eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 199: into ff_archive_items instead of

195: process.
196: Changes for 1099 Magnetic rules
197: to be included in Emp REarch.
198: 06-SEP-2002 asasthan 115.55 Employer Rearch was inserting rows
199: into ff_archive_items instead of
200: updating values. l_old_value made
201: null instead of 'Null'.
202: Also added more contexts for
203: Employer Rearch process to

Line 256: 09-NOV-2001 jgoswami 115.33 Added archive_type to ff_archive_items

252: 04-DEC-2001 jgoswami 115.35 Added Data related to Puerto Rico
253: A_MARITAL_STATUS,
254: A_CON_NATIONAL_IDENTIFIER
255: 30-NOV-2001 jgoswami 115.34 added dbdrv command
256: 09-NOV-2001 jgoswami 115.33 Added archive_type to ff_archive_items
257: insert for Payroll Action level.
258: 15-OCT-2001 jgoswami 115.32 Added cursor c_get_latest_asg in
259: eoy_action_creation and eoy_archive_data
260: for improving performance and removed the

Line 1840: l_archive_type ff_archive_items.archive_type%type;

1836: l_jursd_context_id number := 0;
1837: l_jd varchar2(11) := null;
1838: l_tuid number := 0;
1839: l_rowid_found varchar2(240);
1840: l_archive_type ff_archive_items.archive_type%type;
1841: l_rearch boolean :=FALSE;
1842: l_fed_state_value varchar2(240);
1843: l_old_value varchar2(240):= null;
1844: l_new_value varchar2(240):= null;

Line 1891: from ff_archive_items fai

1887: for j in p_user_entity_id.first .. p_user_entity_id.last
1888: loop
1889: begin
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

Line 1913: update ff_archive_items

1909: )) THEN
1910:
1911: BEGIN
1912: hr_utility.trace('B4 update of value ');
1913: update ff_archive_items
1914: set value = p_value(j)
1915: where rowid = l_rowid_found;
1916:
1917: EXCEPTION WHEN OTHERS THEN

Line 1943: update ff_archive_items

1939: AND p_value(j) is not NULL
1940: AND (not l_rearch) ) THEN
1941:
1942: BEGIN
1943: update ff_archive_items
1944: set value = p_value(j)
1945: where rowid = l_rowid_found;
1946: EXCEPTION WHEN OTHERS THEN
1947: hr_utility.trace('In others error for update -210 ');

Line 1960: insert into ff_archive_items

1956:
1957: ELSE /* Archive row does not exist */
1958:
1959: hr_utility.trace('No rowid found ');
1960: insert into ff_archive_items
1961: (ARCHIVE_ITEM_ID,
1962: USER_ENTITY_ID,
1963: CONTEXT1,
1964: VALUE,

Line 1967: (ff_archive_items_s.nextval,

1963: CONTEXT1,
1964: VALUE,
1965: ARCHIVE_TYPE)
1966: values
1967: (ff_archive_items_s.nextval,
1968: p_user_entity_id(j),
1969: p_context1,
1970: p_value(j),
1971: l_archive_type);

Line 1985: (ff_archive_items_s.currval,

1981: SEQUENCE_NO,
1982: CONTEXT,
1983: CONTEXT_ID)
1984: values
1985: (ff_archive_items_s.currval,
1986: p_sequence(i),
1987: p_context(i),
1988: p_context_id(i));
1989: end loop;

Line 2008: from ff_archive_items fai

2004: for j in p_user_entity_id.first .. p_user_entity_id.last
2005: loop
2006: begin
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

Line 2029: update ff_archive_items fai

2025: if l_rowid_found is not null then
2026:
2027: if l_old_value is null then
2028:
2029: update ff_archive_items fai
2030: set value = p_value(j)
2031: where rowid = l_rowid_found;
2032: l_new_value := p_value(j);
2033:

Line 2038: update ff_archive_items fai

2034: else
2035:
2036: if l_rearch then
2037:
2038: update ff_archive_items fai
2039: set value = p_value(j)
2040: where rowid = l_rowid_found;
2041:
2042: l_new_value := p_value(j);

Line 2050: insert into ff_archive_items

2046: end if;
2047:
2048:
2049: else
2050: insert into ff_archive_items
2051: (ARCHIVE_ITEM_ID,
2052: USER_ENTITY_ID,
2053: CONTEXT1,
2054: VALUE,

Line 2057: (ff_archive_items_s.nextval,

2053: CONTEXT1,
2054: VALUE,
2055: ARCHIVE_TYPE)
2056: values
2057: (ff_archive_items_s.nextval,
2058: p_user_entity_id(j),
2059: p_context1,
2060: p_value(j),
2061: l_archive_type);

Line 2075: (ff_archive_items_s.currval,

2071: SEQUENCE_NO,
2072: CONTEXT,
2073: CONTEXT_ID)
2074: values
2075: (ff_archive_items_s.currval,
2076: p_sequence(i),
2077: p_context(i),
2078: p_context_id(i));
2079: end loop;

Line 2103: insert into ff_archive_items

2099: l_step := 9;
2100:
2101: for j in p_user_entity_id.first .. p_user_entity_id.last
2102: loop
2103: insert into ff_archive_items
2104: (ARCHIVE_ITEM_ID,
2105: USER_ENTITY_ID,
2106: CONTEXT1,
2107: VALUE)

Line 2109: (ff_archive_items_s.nextval,

2105: USER_ENTITY_ID,
2106: CONTEXT1,
2107: VALUE)
2108: values
2109: (ff_archive_items_s.nextval,
2110: p_user_entity_id(j),
2111: p_context1,
2112: p_value(j));
2113:

Line 2124: (ff_archive_items_s.currval,

2120: SEQUENCE_NO,
2121: CONTEXT,
2122: CONTEXT_ID)
2123: values
2124: (ff_archive_items_s.currval,
2125: p_sequence(i),
2126: p_context(i),
2127: p_context_id(i));
2128: end loop;

Line 3077: from ff_archive_items fai

3073: cursor c_chk_payroll_action is
3074: select 'Y'
3075: from dual
3076: where exists (select null
3077: from ff_archive_items fai
3078: where fai.context1 = p_payroll_action_id);
3079: begin
3080:
3081: hr_utility.trace('chk_gre_archive - checking g_archive_flag');

Line 3421: from ff_archive_items fai,

3417: p_archive_name IN VARCHAR2) IS
3418:
3419: CURSOR c_get_ff_arch IS
3420: select fai.archive_item_id
3421: from ff_archive_items fai,
3422: ff_user_entities fue
3423: where context1 =p_context
3424: and fai.user_entity_id = fue.user_entity_id
3425: and user_entity_name = p_archive_name ;

Line 3443: delete from ff_archive_items

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;
3445:
3446: END;
3447:

Line 3590: l_archive_item_id ff_archive_items.archive_item_id%type;

3586: l_chk_city_sd_archive varchar2(1);
3587: l_true varchar2(1);
3588: l_marital_status per_people_f.marital_status%type;
3589: l_con_national_identifier per_people_f.national_identifier%type;
3590: l_archive_item_id ff_archive_items.archive_item_id%type;
3591: l_object_version_number number(9);
3592: l_some_warning boolean;
3593: lv_value ff_archive_items.value%type := null;
3594: l_taxable_amount_unknown varchar(150) := null;

Line 3593: lv_value ff_archive_items.value%type := null;

3589: l_con_national_identifier per_people_f.national_identifier%type;
3590: l_archive_item_id ff_archive_items.archive_item_id%type;
3591: l_object_version_number number(9);
3592: l_some_warning boolean;
3593: lv_value ff_archive_items.value%type := null;
3594: l_taxable_amount_unknown varchar(150) := null;
3595: l_total_distributions varchar(150) := null;
3596: l_ee_distribution_percent varchar(150) := null;
3597: l_total_distribution_percent varchar(150) := null;

Line 4082: /* Insert rows into ff_archive_items and ff_archive_item_contexts

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: