Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12.1.3 : Invalid package HXC_TIMECARD_UTILITIES

edited Nov 7, 2014 11:38AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

Hi,

Invalid package after applying patch

19827234:R12.HXT.B1OFF:19012444:12.1.7.TIME FOR ONE EMP CHARGED TO TK

=========

HXC_TIMECARD_UTILITIES

the error messages are in the package body:

PLS-00307: too many declarations of 'GET_ASSIGNMENT_PERIODS' match this call.

this occurs at line 1935 and line 1940 in the package body.

and also error message

PLS-00323: subprogram or cursor 'GET_ASSIGNMENT_PERIODS' is declared in a package specification and must be defined in the package body

========


package version in database is :


hxctcutil.pkb 120.25.12010000.16 2014/02/10 12:20:07 asrajago ship
hxctcutil.pkh 120.4.12010000.10 2014/06/12 07:31:24 jnerlla ship



Code creating the error

============

Line  
80 FUNCTION get_assignment_periods(
80 SELECT trunc(date_start)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center