[Home] [Help]
29: allee 40.4 17-Apr-1996 Modified l_state(2) -> l_state(10) so that
30: it could handle the Pseudo-State = 'FED'
31: for Federal W2 Reporting;
32: bhoman 40.6 17-APR-1998 Changes made to support SQWL diskette reporting.
33: achauhan 40.7 08-aug-1998 Commented out the insert into ff_archive_item_contexts
34: The table definition of ff_archive_item_contexts has
35: changed and the old archive process does not need to
36: populate this table since there is only one contxt for the routes
37: djoshi 40.8 08-Apr-1999 Verfied for Canonical Complience of Date
30: it could handle the Pseudo-State = 'FED'
31: for Federal W2 Reporting;
32: bhoman 40.6 17-APR-1998 Changes made to support SQWL diskette reporting.
33: achauhan 40.7 08-aug-1998 Commented out the insert into ff_archive_item_contexts
34: The table definition of ff_archive_item_contexts has
35: changed and the old archive process does not need to
36: populate this table since there is only one contxt for the routes
37: djoshi 40.8 08-Apr-1999 Verfied for Canonical Complience of Date
38: mreid 115.5 30-Nov-1999 Added column names to ff_archive_items insert
511: p_item_name VARCHAR2,
512: p_user_entity_id ff_archive_items.user_entity_id%TYPE,
513: p_context1 ff_archive_items.context1%TYPE,
514: p_value ff_archive_items.value%TYPE,
515: p_context2 ff_archive_item_contexts.context%TYPE
516: := NULL) IS
517: --
518: chk ff_archive_items.value%TYPE;
519: --
648: hr_utility.set_location ('arch_store',122);
649: --
650: /* context2 is not supported in the old archive process. So, commenting this insert */
651: IF p_context2 IS NOT NULL THEN
652: -- INSERT INTO ff_archive_item_contexts VALUES
653: -- ( ff_archive_items_s.currval,2,p_context2 );
654: --
655: hr_utility.set_location ('arch_store',123);
656: END IF;
672: --
673: SELECT value
674: INTO chk
675: FROM ff_archive_items ai,
676: ff_archive_item_contexts aic
677: WHERE ai.archive_item_id = aic.archive_item_id AND
678: ai.user_entity_id = p_user_entity_id AND
679: ai.context1 = p_context1 AND
680: aic.sequence_no = 2 AND
967: --==============================================================================
968: -- ARCH_ROLBK
969: --
970: -- rollback an archive - delete rows from ff_archive_items and
971: -- ff_archive_item_contexts that relate to a specified payroll action
972: --==============================================================================
973: PROCEDURE arch_rolbk (p_errmsg OUT nocopy VARCHAR2,
974: p_errcode OUT nocopy NUMBER,
975: p_payroll_action_id NUMBER) IS
978: --
979: --------------------------------------------------------------------------------
980: -- Delete archive items
981: --------------------------------------------------------------------------------
982: DELETE FROM ff_archive_item_contexts ic
983: WHERE EXISTS ( SELECT '1'
984: FROM ff_contexts con,
985: ff_route_context_usages rcu,
986: ff_user_entities ue,