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 168: into ff_archive_items instead of

164: process.
165: Changes for 1099 Magnetic rules
166: to be included in Emp REarch.
167: 06-SEP-2002 asasthan 115.55 Employer Rearch was inserting rows
168: into ff_archive_items instead of
169: updating values. l_old_value made
170: null instead of 'Null'.
171: Also added more contexts for
172: Employer Rearch process to

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

221: 04-DEC-2001 jgoswami 115.35 Added Data related to Puerto Rico
222: A_MARITAL_STATUS,
223: A_CON_NATIONAL_IDENTIFIER
224: 30-NOV-2001 jgoswami 115.34 added dbdrv command
225: 09-NOV-2001 jgoswami 115.33 Added archive_type to ff_archive_items
226: insert for Payroll Action level.
227: 15-OCT-2001 jgoswami 115.32 Added cursor c_get_latest_asg in
228: eoy_action_creation and eoy_archive_data
229: for improving performance and removed the

Line 1536: l_archive_type ff_archive_items.archive_type%type;

1532: l_jursd_context_id number := 0;
1533: l_jd varchar2(11) := null;
1534: l_tuid number := 0;
1535: l_rowid_found varchar2(240);
1536: l_archive_type ff_archive_items.archive_type%type;
1537: l_rearch boolean :=FALSE;
1538: l_fed_state_value varchar2(240);
1539: l_old_value varchar2(240):= null;
1540: l_new_value varchar2(240):= null;

Line 1587: from ff_archive_items fai

1583: for j in p_user_entity_id.first .. p_user_entity_id.last
1584: loop
1585: begin
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

Line 1609: update ff_archive_items

1605: )) THEN
1606:
1607: BEGIN
1608: hr_utility.trace('B4 update of value ');
1609: update ff_archive_items
1610: set value = p_value(j)
1611: where rowid = l_rowid_found;
1612:
1613: EXCEPTION WHEN OTHERS THEN

Line 1639: update ff_archive_items

1635: AND p_value(j) is not NULL
1636: AND (not l_rearch) ) THEN
1637:
1638: BEGIN
1639: update ff_archive_items
1640: set value = p_value(j)
1641: where rowid = l_rowid_found;
1642: EXCEPTION WHEN OTHERS THEN
1643: hr_utility.trace('In others error for update -210 ');

Line 1656: insert into ff_archive_items

1652:
1653: ELSE /* Archive row does not exist */
1654:
1655: hr_utility.trace('No rowid found ');
1656: insert into ff_archive_items
1657: (ARCHIVE_ITEM_ID,
1658: USER_ENTITY_ID,
1659: CONTEXT1,
1660: VALUE,

Line 1663: (ff_archive_items_s.nextval,

1659: CONTEXT1,
1660: VALUE,
1661: ARCHIVE_TYPE)
1662: values
1663: (ff_archive_items_s.nextval,
1664: p_user_entity_id(j),
1665: p_context1,
1666: p_value(j),
1667: l_archive_type);

Line 1681: (ff_archive_items_s.currval,

1677: SEQUENCE_NO,
1678: CONTEXT,
1679: CONTEXT_ID)
1680: values
1681: (ff_archive_items_s.currval,
1682: p_sequence(i),
1683: p_context(i),
1684: p_context_id(i));
1685: end loop;

Line 1704: from ff_archive_items fai

1700: for j in p_user_entity_id.first .. p_user_entity_id.last
1701: loop
1702: begin
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

Line 1725: update ff_archive_items fai

1721: if l_rowid_found is not null then
1722:
1723: if l_old_value is null then
1724:
1725: update ff_archive_items fai
1726: set value = p_value(j)
1727: where rowid = l_rowid_found;
1728: l_new_value := p_value(j);
1729:

Line 1734: update ff_archive_items fai

1730: else
1731:
1732: if l_rearch then
1733:
1734: update ff_archive_items fai
1735: set value = p_value(j)
1736: where rowid = l_rowid_found;
1737:
1738: l_new_value := p_value(j);

Line 1746: insert into ff_archive_items

1742: end if;
1743:
1744:
1745: else
1746: insert into ff_archive_items
1747: (ARCHIVE_ITEM_ID,
1748: USER_ENTITY_ID,
1749: CONTEXT1,
1750: VALUE,

Line 1753: (ff_archive_items_s.nextval,

1749: CONTEXT1,
1750: VALUE,
1751: ARCHIVE_TYPE)
1752: values
1753: (ff_archive_items_s.nextval,
1754: p_user_entity_id(j),
1755: p_context1,
1756: p_value(j),
1757: l_archive_type);

Line 1771: (ff_archive_items_s.currval,

1767: SEQUENCE_NO,
1768: CONTEXT,
1769: CONTEXT_ID)
1770: values
1771: (ff_archive_items_s.currval,
1772: p_sequence(i),
1773: p_context(i),
1774: p_context_id(i));
1775: end loop;

Line 1799: insert into ff_archive_items

1795: l_step := 9;
1796:
1797: for j in p_user_entity_id.first .. p_user_entity_id.last
1798: loop
1799: insert into ff_archive_items
1800: (ARCHIVE_ITEM_ID,
1801: USER_ENTITY_ID,
1802: CONTEXT1,
1803: VALUE)

Line 1805: (ff_archive_items_s.nextval,

1801: USER_ENTITY_ID,
1802: CONTEXT1,
1803: VALUE)
1804: values
1805: (ff_archive_items_s.nextval,
1806: p_user_entity_id(j),
1807: p_context1,
1808: p_value(j));
1809:

Line 1820: (ff_archive_items_s.currval,

1816: SEQUENCE_NO,
1817: CONTEXT,
1818: CONTEXT_ID)
1819: values
1820: (ff_archive_items_s.currval,
1821: p_sequence(i),
1822: p_context(i),
1823: p_context_id(i));
1824: end loop;

Line 2567: from ff_archive_items fai

2563: cursor c_chk_payroll_action is
2564: select 'Y'
2565: from dual
2566: where exists (select null
2567: from ff_archive_items fai
2568: where fai.context1 = p_payroll_action_id);
2569: begin
2570:
2571: hr_utility.trace('chk_gre_archive - checking g_archive_flag');

Line 2894: from ff_archive_items fai,

2890: p_archive_name IN VARCHAR2) IS
2891:
2892: CURSOR c_get_ff_arch IS
2893: select fai.archive_item_id
2894: from ff_archive_items fai,
2895: ff_user_entities fue
2896: where context1 =p_context
2897: and fai.user_entity_id = fue.user_entity_id
2898: and user_entity_name = p_archive_name ;

Line 2916: delete from ff_archive_items

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;
2918:
2919: END;
2920:

Line 3018: l_archive_item_id ff_archive_items.archive_item_id%type;

3014: l_chk_city_sd_archive varchar2(1);
3015: l_true varchar2(1);
3016: l_marital_status per_people_f.marital_status%type;
3017: l_con_national_identifier per_people_f.national_identifier%type;
3018: l_archive_item_id ff_archive_items.archive_item_id%type;
3019: l_object_version_number number(9);
3020: l_some_warning boolean;
3021: lv_value ff_archive_items.value%type := null;
3022: l_taxable_amount_unknown varchar(150) := null;

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

3017: l_con_national_identifier per_people_f.national_identifier%type;
3018: l_archive_item_id ff_archive_items.archive_item_id%type;
3019: l_object_version_number number(9);
3020: l_some_warning boolean;
3021: lv_value ff_archive_items.value%type := null;
3022: l_taxable_amount_unknown varchar(150) := null;
3023: l_total_distributions varchar(150) := null;
3024: l_ee_distribution_percent varchar(150) := null;
3025: l_total_distribution_percent varchar(150) := null;

Line 3450: /* Insert rows into ff_archive_items and ff_archive_item_contexts

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: