APPS.PN_CC_SYNC_PKG dependencies on PN_SPACE_ASSIGN_EMP_PKG

Line 17: | pn_space_assign_emp_pkg.update_row

13: |
14: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
15: | pnp_util_func.get_segment_column_name
16: | pnp_util_func.get_location_code
17: | pn_space_assign_emp_pkg.update_row
18: |
19: | ARGUMENTS : IN:
20: | p_as_of_date
21: | p_locn_type

Line 35: | PN_SPACE_ASSIGN_EMP_PKG.Update_Row to pass

31: | 13-NOV-03 Vikas Mehta Created
32: | 26-OCT-05 Hareesha o ATG mandated changes for SQL literals using
33: | dbms_sql.
34: | 04-APR-06 Hareesha o Bug 5119241 Modified call to
35: | PN_SPACE_ASSIGN_EMP_PKG.Update_Row to pass
36: | new CC.
37: | 30-JUN-06 Hareesha o Bug #5262982 Select org_id too in the query
38: | along with all other columns.The new record
39: | created was not being populated with org_id.

Line 386: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := asg_rec;

382: dbms_sql.column_value (l_cursor, 33,asg_rec.ATTRIBUTE15);
383: dbms_sql.column_value (l_cursor, 34,asg_rec.ORG_ID);
384: l_log_context := 'opening cursor ';
385:
386: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := asg_rec;
387:
388:
389: /* Get cost center from HR */
390: IF l_person_id <> asg_rec.person_id THEN

Line 429: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := asg_rec;

425:
426:
427: BEGIN
428:
429: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := asg_rec;
430:
431: /* Check if assignmnet start date is same as as_of_date.
432: We do not need to insert new record but only need to update cost ceneter in this case. */
433:

Line 438: PN_SPACE_ASSIGN_EMP_PKG.Update_Row(

434: IF l_as_of_date = trunc(asg_rec.emp_assign_start_date) THEN
435:
436: /* Call Update_Row in CORRECT mode */
437:
438: PN_SPACE_ASSIGN_EMP_PKG.Update_Row(
439: asg_rec.emp_space_assign_id,
440: asg_rec.attribute1,
441: asg_rec.attribute2,
442: asg_rec.attribute3,

Line 480: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo.source := l_source_id || '_' || asg_rec.emp_space_assign_id ;

476: ELSE
477: /* Need to update current record and insert new record
478: Call Update_Row in UPDATE mode */
479:
480: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo.source := l_source_id || '_' || asg_rec.emp_space_assign_id ;
481:
482: PN_SPACE_ASSIGN_EMP_PKG.Update_Row(
483: asg_rec.emp_space_assign_id,
484: asg_rec.attribute1,

Line 482: PN_SPACE_ASSIGN_EMP_PKG.Update_Row(

478: Call Update_Row in UPDATE mode */
479:
480: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo.source := l_source_id || '_' || asg_rec.emp_space_assign_id ;
481:
482: PN_SPACE_ASSIGN_EMP_PKG.Update_Row(
483: asg_rec.emp_space_assign_id,
484: asg_rec.attribute1,
485: asg_rec.attribute2,
486: asg_rec.attribute3,