APPS.PAY_US_YEPP_ADD_ACTIONS_PKG dependencies on FF_ARCHIVE_ITEMS

Line 73: ff_archive_items while creating assignment actions.

69: for CURSOR c_get_asg_id.
70: 18-Apr-2006 alikhar 115.12 5120818 Performance fix for cursor c_get_latest_asg.
71: Added Ordered hint.
72: 25-Aug-2006 saurgupt 115.13 3829668 Added the procedure create_archive to insert record into
73: ff_archive_items while creating assignment actions.
74: 29-AUG-2006 sodhingr 115.14 3829668 archive A_ADD_ARCHIVE= Y when an assigment
75: is added to archive
76: ********************************************************************/
77:

Line 453: Description : Creates an entry into ff_archive_items for user_entity A_W2_CORRECTED. This is needed to

449:
450: -- Bug 3829668
451: /******************************************************************
452: Procedure create_archive
453: Description : Creates an entry into ff_archive_items for user_entity A_W2_CORRECTED. This is needed to
454: print/noprint 'CORRECTED' on Online Employee W2.
455: ******************************************************************/
456: PROCEDURE create_archive(cp_asg_action_id in number,
457: cp_gre_id in number)

Line 487: -- Inserting into ff_archive_items

483: close c_get_dbi_id;
484:
485: hr_utility.set_location(gv_package_name || '.create_archive', 20);
486:
487: -- Inserting into ff_archive_items
488:
489: insert into ff_archive_items
490: (ARCHIVE_ITEM_ID,
491: USER_ENTITY_ID,

Line 489: insert into ff_archive_items

485: hr_utility.set_location(gv_package_name || '.create_archive', 20);
486:
487: -- Inserting into ff_archive_items
488:
489: insert into ff_archive_items
490: (ARCHIVE_ITEM_ID,
491: USER_ENTITY_ID,
492: CONTEXT1,
493: VALUE)

Line 495: (ff_archive_items_s.nextval,

491: USER_ENTITY_ID,
492: CONTEXT1,
493: VALUE)
494: values
495: (ff_archive_items_s.nextval,
496: l_user_entity_id,
497: cp_asg_action_id,
498: 'Y');
499:

Line 508: (ff_archive_items_s.currval,

504: SEQUENCE_NO,
505: CONTEXT,
506: CONTEXT_ID)
507: values
508: (ff_archive_items_s.currval,
509: 1,
510: cp_gre_id,
511: l_context_id);
512: hr_utility.set_location(gv_package_name || '.create_archive', 30);

Line 752: /* insert into ff_archive_items */

748: status => 'M' );
749:
750: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 120);
751:
752: /* insert into ff_archive_items */
753: -- Bug 3829668
754: hr_utility.trace('creating ff_archive_items entry');
755: create_archive(lockingactid ,
756: p_gre_id);

Line 754: hr_utility.trace('creating ff_archive_items entry');

750: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 120);
751:
752: /* insert into ff_archive_items */
753: -- Bug 3829668
754: hr_utility.trace('creating ff_archive_items entry');
755: create_archive(lockingactid ,
756: p_gre_id);
757:
758: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 121);