[Home] [Help]
288: A_SS_EE_WAGE rate to archive the data
289: related to bug 983094 and 101435
290: 01-sep-1999 achauhan 40.33 While archiving the employer data
291: add the context of pay_payroll_actions
292: to ff_archive_item_contexts.
293: 11-aug-1999 achauhan 40.32 Added the call to
294: eoy_archive_gre_data in the
295: eoy_range_cursor procedure. This is
296: being done to handle the situation
1586: select rowid,fai.value into l_rowid_found,l_old_value
1587: from ff_archive_items fai
1588: where user_entity_id = p_user_entity_id(j)
1589: and context1 = p_context1
1590: and exists (select 'x' from ff_archive_item_contexts faic
1591: where fai.archive_item_id = faic.archive_item_id
1592: and faic.context_id = l_tax_context_id
1593: and faic.context = l_tuid );
1594: exception when no_data_found then
1671: l_new_value := p_value(j);
1672:
1673: for i in p_sequence.first .. p_sequence.last
1674: loop
1675: insert into ff_archive_item_contexts
1676: (ARCHIVE_ITEM_ID,
1677: SEQUENCE_NO,
1678: CONTEXT,
1679: CONTEXT_ID)
1703: select rowid,fai.value into l_rowid_found,l_old_value
1704: from ff_archive_items fai
1705: where user_entity_id = p_user_entity_id(j)
1706: and context1 = p_context1
1707: and exists (select 'x' from ff_archive_item_contexts faic
1708: where fai.archive_item_id = faic.archive_item_id
1709: and faic.context_id = l_tax_context_id
1710: and faic.context = l_tuid )
1711: and exists (select 'x' from ff_archive_item_contexts faic
1707: and exists (select 'x' from ff_archive_item_contexts faic
1708: where fai.archive_item_id = faic.archive_item_id
1709: and faic.context_id = l_tax_context_id
1710: and faic.context = l_tuid )
1711: and exists (select 'x' from ff_archive_item_contexts faic
1712: where fai.archive_item_id = faic.archive_item_id
1713: and faic.context_id = l_jursd_context_id
1714: and faic.context = l_jd );
1715: exception when no_data_found then
1761: l_new_value := p_value(j);
1762:
1763: for i in p_sequence.first .. p_sequence.last
1764: loop
1765: insert into ff_archive_item_contexts
1766: (ARCHIVE_ITEM_ID,
1767: SEQUENCE_NO,
1768: CONTEXT,
1769: CONTEXT_ID)
1810: l_step := 10;
1811:
1812: for i in p_sequence.first .. p_sequence.last
1813: loop
1814: insert into ff_archive_item_contexts
1815: (ARCHIVE_ITEM_ID,
1816: SEQUENCE_NO,
1817: CONTEXT,
1818: CONTEXT_ID)
2909:
2910:
2911: hr_utility.trace('l_archive_itemid '||l_archive_itemid);
2912:
2913: delete from ff_archive_item_contexts
2914: where archive_item_id = l_archive_itemid;
2915:
2916: delete from ff_archive_items
2917: where archive_item_id = l_archive_itemid;
3446: l_count := l_count + 1;
3447: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3448: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
3449:
3450: /* Insert rows into ff_archive_items and ff_archive_item_contexts
3451: for the city, county and state */
3452:
3453: l_step := 17;
3454: