R12.1.3 : Invalid package HXC_TIMECARD_UTILITIES
Hi,
Invalid package after applying patch
19827234:R12.HXT.B | 1OFF: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)