DBA Data[Home] [Help]

APPS.PN_CC_SYNC_PKG dependencies on PN_CC_SYNC_PKG

Line 1: PACKAGE BODY PN_CC_SYNC_PKG AS

1: PACKAGE BODY PN_CC_SYNC_PKG AS
2: -- $Header: PNCCSYNB.pls 120.5 2007/08/10 05:49:06 hrodda ship $
3:
4: /*===========================================================================+
5: | PROCEDURE

Line 65: l_desc VARCHAR2(100) := 'pn_cc_sync_pkg.cc_sync_with_hr';

61: l_count_success NUMBER := 0;
62: l_count_failure NUMBER := 0;
63: l_commit_count NUMBER := 0;
64: l_log_context VARCHAR2(2000);
65: l_desc VARCHAR2(100) := 'pn_cc_sync_pkg.cc_sync_with_hr';
66: l_as_of_date DATE;
67: l_cost_center VARCHAR2(30) := NULL;
68: l_person_id pn_space_assign_emp.person_id%TYPE := 0 ;
69: l_column_name VARCHAR2(30) := NULL;

Line 391: pn_cc_sync_pkg.get_cc_as_of_date(asg_rec.person_id, l_column_name, fnd_date.canonical_to_date(p_as_of_date), l_emp_name, l_cost_center);

387:
388:
389: /* Get cost center from HR */
390: IF l_person_id <> asg_rec.person_id THEN
391: pn_cc_sync_pkg.get_cc_as_of_date(asg_rec.person_id, l_column_name, fnd_date.canonical_to_date(p_as_of_date), l_emp_name, l_cost_center);
392:
393: /* Get employee name if any issues with finding cost center */
394: IF l_emp_name IS NULL THEN
395: OPEN get_emp_name(asg_rec.person_id, l_as_of_date);

Line 722: | (called by pn_cc_sync_pkg.cc_sync_with_hr)

718: |
719: |
720: | NOTES : Currently being used in concurrent program
721: | 'Cost Center Synchronization with HR'
722: | (called by pn_cc_sync_pkg.cc_sync_with_hr)
723: |
724: | MODIFICATION HISTORY
725: |
726: | 13-NOV-03 Vikas Mehta Created

Line 835: END PN_CC_SYNC_PKG;

831:
832: ------------------------------
833: -- End of Package
834: ------------------------------
835: END PN_CC_SYNC_PKG;