[Home] [Help]
319: A_SS_EE_WAGE rate to archive the data
320: related to bug 983094 and 101435
321: 01-sep-1999 achauhan 40.33 While archiving the employer data
322: add the context of pay_payroll_actions
323: to ff_archive_item_contexts.
324: 11-aug-1999 achauhan 40.32 Added the call to
325: eoy_archive_gre_data in the
326: eoy_range_cursor procedure. This is
327: being done to handle the situation
1890: select rowid,fai.value into l_rowid_found,l_old_value
1891: from ff_archive_items fai
1892: where user_entity_id = p_user_entity_id(j)
1893: and context1 = p_context1
1894: and exists (select 'x' from ff_archive_item_contexts faic
1895: where fai.archive_item_id = faic.archive_item_id
1896: and faic.context_id = l_tax_context_id
1897: and faic.context = l_tuid );
1898: exception when no_data_found then
1975: l_new_value := p_value(j);
1976:
1977: for i in p_sequence.first .. p_sequence.last
1978: loop
1979: insert into ff_archive_item_contexts
1980: (ARCHIVE_ITEM_ID,
1981: SEQUENCE_NO,
1982: CONTEXT,
1983: CONTEXT_ID)
2007: select rowid,fai.value into l_rowid_found,l_old_value
2008: from ff_archive_items fai
2009: where user_entity_id = p_user_entity_id(j)
2010: and context1 = p_context1
2011: and exists (select 'x' from ff_archive_item_contexts faic
2012: where fai.archive_item_id = faic.archive_item_id
2013: and faic.context_id = l_tax_context_id
2014: and faic.context = l_tuid )
2015: and exists (select 'x' from ff_archive_item_contexts faic
2011: and exists (select 'x' from ff_archive_item_contexts faic
2012: where fai.archive_item_id = faic.archive_item_id
2013: and faic.context_id = l_tax_context_id
2014: and faic.context = l_tuid )
2015: and exists (select 'x' from ff_archive_item_contexts faic
2016: where fai.archive_item_id = faic.archive_item_id
2017: and faic.context_id = l_jursd_context_id
2018: and faic.context = l_jd );
2019: exception when no_data_found then
2065: l_new_value := p_value(j);
2066:
2067: for i in p_sequence.first .. p_sequence.last
2068: loop
2069: insert into ff_archive_item_contexts
2070: (ARCHIVE_ITEM_ID,
2071: SEQUENCE_NO,
2072: CONTEXT,
2073: CONTEXT_ID)
2114: l_step := 10;
2115:
2116: for i in p_sequence.first .. p_sequence.last
2117: loop
2118: insert into ff_archive_item_contexts
2119: (ARCHIVE_ITEM_ID,
2120: SEQUENCE_NO,
2121: CONTEXT,
2122: CONTEXT_ID)
3436:
3437:
3438: hr_utility.trace('l_archive_itemid '||l_archive_itemid);
3439:
3440: delete from ff_archive_item_contexts
3441: where archive_item_id = l_archive_itemid;
3442:
3443: delete from ff_archive_items
3444: where archive_item_id = l_archive_itemid;
4078: l_count := l_count + 1;
4079: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
4080: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
4081:
4082: /* Insert rows into ff_archive_items and ff_archive_item_contexts
4083: for the city, county and state */
4084:
4085: l_step := 17;
4086: