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_SG_IRAS_AMEND_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 18: g_moa_369_date ff_archive_items.value%type;

14: g_setup_action_id pay_payroll_actions.payroll_action_id%type;
15: g_report_type varchar2(30);
16:
17: g_previous_person_id per_all_people_f.person_id%type;
18: g_moa_369_date ff_archive_items.value%type;
19: -- Added for bug 5435088 org cursor only need to run once
20: g_name_of_bank ff_archive_items.value%type;
21: g_org_run char(1);
22: g_org_a8a_run char(1);

Line 20: g_name_of_bank ff_archive_items.value%type;

16:
17: g_previous_person_id per_all_people_f.person_id%type;
18: g_moa_369_date ff_archive_items.value%type;
19: -- Added for bug 5435088 org cursor only need to run once
20: g_name_of_bank ff_archive_items.value%type;
21: g_org_run char(1);
22: g_org_a8a_run char(1);
23: g_iras_method char(1); /* Bug 7415444 , Original or Amendment*/
24: l_counter number;

Line 870: v_balance_value ff_archive_items.value%type;

866: p_basis_year in varchar2 )
867: is
868: v_run_ass_action_id pay_assignment_actions.assignment_action_id%type;
869: v_date_earned ff_archive_item_contexts.context%type;
870: v_balance_value ff_archive_items.value%type;
871: v_archive_item_id ff_archive_items.archive_item_id%type;
872: v_object_version_number ff_archive_items.object_version_number%type;
873: v_some_warning boolean;
874: --------------------------------------------------------------------------------------

Line 871: v_archive_item_id ff_archive_items.archive_item_id%type;

867: is
868: v_run_ass_action_id pay_assignment_actions.assignment_action_id%type;
869: v_date_earned ff_archive_item_contexts.context%type;
870: v_balance_value ff_archive_items.value%type;
871: v_archive_item_id ff_archive_items.archive_item_id%type;
872: v_object_version_number ff_archive_items.object_version_number%type;
873: v_some_warning boolean;
874: --------------------------------------------------------------------------------------
875: --Bug#3933332 Moved the records from package header as these pl/sql table is

Line 872: v_object_version_number ff_archive_items.object_version_number%type;

868: v_run_ass_action_id pay_assignment_actions.assignment_action_id%type;
869: v_date_earned ff_archive_item_contexts.context%type;
870: v_balance_value ff_archive_items.value%type;
871: v_archive_item_id ff_archive_items.archive_item_id%type;
872: v_object_version_number ff_archive_items.object_version_number%type;
873: v_some_warning boolean;
874: --------------------------------------------------------------------------------------
875: --Bug#3933332 Moved the records from package header as these pl/sql table is
876: -- specific to procedure archive_balances()

Line 878: type t_archive_items_tab is table of ff_archive_items.archive_item_id%TYPE index by binary_integer;

874: --------------------------------------------------------------------------------------
875: --Bug#3933332 Moved the records from package header as these pl/sql table is
876: -- specific to procedure archive_balances()
877: --------------------------------------------------------------------------------------
878: type t_archive_items_tab is table of ff_archive_items.archive_item_id%TYPE index by binary_integer;
879: t_archive_items t_archive_items_tab;
880: t_archive_items_orig t_archive_items_tab;
881: t_archive_items_a8a t_archive_items_tab;
882: t_archive_items_ir8a t_archive_items_tab;

Line 886: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;

882: t_archive_items_ir8a t_archive_items_tab;
883: t_archive_items_ir8s t_archive_items_tab;
884: t_old_value t_archive_items_tab;
885: --
886: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
887: t_archive_value t_archive_value_tab;
888: t_orig_value t_archive_value_tab;
889: t_flag t_archive_value_tab;
890: t_archive_value_a8a t_archive_value_tab;

Line 894: type t_amend_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;

890: t_archive_value_a8a t_archive_value_tab;
891: t_archive_value_ir8a t_archive_value_tab;
892: t_archive_value_ir8s t_archive_value_tab;
893:
894: type t_amend_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
895: t_amend_value t_amend_value_tab;
896: t_amend_value_a8a t_amend_value_tab;
897: t_amend_value_ir8a t_amend_value_tab;
898: t_amend_value_ir8s t_amend_value_tab;

Line 1514: -- Bug: 3260855 Bulk Insert into ff_archive_items for month balances

1510: end loop;
1511:
1512: hr_utility.set_location('pysgiraa: archive_balances ',15);
1513: ------------------------------------------------------------------------------------------------
1514: -- Bug: 3260855 Bulk Insert into ff_archive_items for month balances
1515: ------------------------------------------------------------------------------------------------
1516: select context_id
1517: into l_asac_cont_id
1518: from ff_contexts

Line 1553: FROM ff_archive_items arch

1549:
1550: l_temp_value :='';
1551: SELECT nvl(sum(value),0)
1552: INTO l_temp_value
1553: FROM ff_archive_items arch
1554: WHERE arch.user_entity_id = t_user_entity_id(i)
1555: AND arch.context1 IN( select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
1556: from pay_payroll_actions ppa,
1557: pay_assignment_actions paa

Line 1657: from ff_archive_items arch

1653: begin
1654: l_temp_value :='';
1655: select sum(value)
1656: into l_temp_value
1657: from ff_archive_items arch
1658: where arch.user_entity_id = t_user_entity_id_ir8a(counter)
1659: and arch.context1 IN( select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
1660: from pay_payroll_actions ppa,
1661: pay_assignment_actions paa

Line 1714: from ff_archive_items arch

1710: begin
1711: l_temp_value :='';
1712: select sum(value)
1713: into l_temp_value
1714: from ff_archive_items arch
1715: where arch.user_entity_id = t_user_entity_id_ir8s(counter)
1716: and arch.context1 IN( select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
1717: from pay_payroll_actions ppa,
1718: pay_assignment_actions paa

Line 1786: from ff_archive_items arch

1782: begin
1783: l_temp_value :='';
1784: select sum(value)
1785: into l_temp_value
1786: from ff_archive_items arch
1787: where arch.user_entity_id = t_user_entity_id_a8a(i)
1788: and arch.context1 IN( select paa.assignment_action_id
1789: -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
1790: from pay_payroll_actions ppa,

Line 1857: insert into ff_archive_items

1853: t_flag(3) := g_amend_ir8a_flag;
1854: t_flag(4) := g_amend_ir8s_flag;
1855:
1856: forall counter in 1..t_amend_ue_id.count
1857: insert into ff_archive_items
1858: ( archive_item_id,
1859: user_entity_id,
1860: context1,
1861: value,

Line 1864: ( ff_archive_items_s.nextval,

1860: context1,
1861: value,
1862: archive_type )
1863: values
1864: ( ff_archive_items_s.nextval,
1865: t_amend_ue_id(counter),
1866: p_assignment_action_id,
1867: t_flag(counter),
1868: 'AAP' )

Line 1886: insert into ff_archive_items

1882:
1883:
1884: t_archive_items.delete;
1885: forall counter in 1..t_user_entity_id.count
1886: insert into ff_archive_items
1887: ( archive_item_id,
1888: user_entity_id,
1889: context1,
1890: value,

Line 1893: ( ff_archive_items_s.nextval,

1889: context1,
1890: value,
1891: archive_type )
1892: values
1893: ( ff_archive_items_s.nextval,
1894: t_user_entity_id(counter),
1895: p_assignment_action_id,
1896: t_archive_value(counter) - t_amend_value(counter) ,-- T_AMEND-VALUE,
1897: 'AAP' )

Line 1942: insert into ff_archive_items

1938:
1939: hr_utility.set_location('pysgiraa: archive_balances ',130);
1940:
1941: forall counter in 1..t_user_entity_id_ir8a.count
1942: insert into ff_archive_items
1943: ( archive_item_id,
1944: user_entity_id,
1945: context1,
1946: value,

Line 1949: ( ff_archive_items_s.nextval,

1945: context1,
1946: value,
1947: archive_type )
1948: values
1949: ( ff_archive_items_s.nextval,
1950: t_user_entity_id_ir8a(counter),
1951: p_assignment_action_id,
1952: t_archive_value_ir8a(counter) - t_amend_value_ir8a(counter),
1953: 'AAP' )

Line 1986: insert into ff_archive_items

1982: t_archive_items_ir8a.delete;
1983:
1984: hr_utility.set_location('pysgiraa: archive_balances ',140);
1985: forall counter in 1..t_user_entity_id_ir8s.count
1986: insert into ff_archive_items
1987: ( archive_item_id,
1988: user_entity_id,
1989: context1,
1990: value,

Line 1993: ( ff_archive_items_s.nextval,

1989: context1,
1990: value,
1991: archive_type )
1992: values
1993: ( ff_archive_items_s.nextval,
1994: t_user_entity_id_ir8s(counter),
1995: p_assignment_action_id,
1996: t_archive_value_ir8s(counter) - t_amend_value_ir8s(counter) ,
1997: 'AAP' )

Line 2031: insert into ff_archive_items

2027:
2028: hr_utility.set_location('pysgiraa: archive_balances ',150);
2029:
2030: forall counter in 1..t_user_entity_id_a8a.count
2031: insert into ff_archive_items
2032: ( archive_item_id,
2033: user_entity_id,
2034: context1,
2035: value,

Line 2038: ( ff_archive_items_s.nextval,

2034: context1,
2035: value,
2036: archive_type )
2037: values
2038: ( ff_archive_items_s.nextval,
2039: t_user_entity_id_a8a(counter),
2040: p_assignment_action_id,
2041: t_archive_value_a8a(counter) - t_amend_value_a8a(counter) ,
2042: 'AAP' )

Line 2077: ff_archive_items arch

2073:
2074: select arch.value,ue.user_entity_id
2075: bulk collect into t_orig_value,t_orig_user_entity_id
2076: from ff_user_entities ue ,
2077: ff_archive_items arch
2078: where ue.user_entity_name in ('X_PER_NATIONAL_IDENTIFIER',
2079: 'X_PER_SEX',
2080: 'X_PER_DATE_OF_BIRTH',
2081: 'X_PER_ADR_TYPE',

Line 2155: insert into ff_archive_items

2151: hr_utility.set_location('pysgiraa: archive_balances ',170);
2152: if t_orig_user_entity_id.count >0 then
2153:
2154: forall counter in 1..t_orig_user_entity_id.count
2155: insert into ff_archive_items
2156: ( archive_item_id,
2157: user_entity_id,
2158: context1,
2159: value,

Line 2162: ( ff_archive_items_s.nextval,

2158: context1,
2159: value,
2160: archive_type )
2161: values
2162: ( ff_archive_items_s.nextval,
2163: t_orig_user_entity_id(counter),
2164: p_assignment_action_id,
2165: t_orig_value(counter),
2166: 'AAP' )

Line 2221: type t_archive_items_tab is table of ff_archive_items.archive_item_id%TYPE index by binary_integer;

2217: p_basis_start in date,
2218: p_basis_end in date )
2219: is
2220:
2221: type t_archive_items_tab is table of ff_archive_items.archive_item_id%TYPE index by binary_integer;
2222: t_archive_items_a8b t_archive_items_tab;
2223:
2224: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
2225: t_archive_value_a8b t_archive_value_tab;

Line 2224: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;

2220:
2221: type t_archive_items_tab is table of ff_archive_items.archive_item_id%TYPE index by binary_integer;
2222: t_archive_items_a8b t_archive_items_tab;
2223:
2224: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
2225: t_archive_value_a8b t_archive_value_tab;
2226:
2227: type t_amend_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
2228: t_amend_value_a8b t_amend_value_tab;

Line 2227: type t_amend_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;

2223:
2224: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
2225: t_archive_value_a8b t_archive_value_tab;
2226:
2227: type t_amend_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
2228: t_amend_value_a8b t_amend_value_tab;
2229:
2230: type t_user_entity_tab is table of ff_user_entities.user_entity_id%TYPE index by binary_integer;
2231: t_user_entity_id_a8b t_user_entity_tab;

Line 2347: from ff_archive_items arch,

2343: c_person_id per_people_f.person_id%type,
2344: c_tax_unit_id ff_archive_item_contexts.context%type) is
2345:
2346: select distinct con2.context person_extra_info_id
2347: from ff_archive_items arch,
2348: ff_archive_item_contexts con2
2349: where arch.user_entity_id = c_user_entity_id
2350: and arch.context1 IN(
2351: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4

Line 2411: ff_archive_items arch

2407:
2408: select arch.value
2409: into v_er_incorp_date
2410: from ff_user_entities ue ,
2411: ff_archive_items arch
2412: where ue.user_entity_name = 'X_SG_LEGAL_ENTITY_SG_A8B_INCORP_DATE'
2413: and ue.user_entity_id = arch.user_entity_id
2414: AND ARCH.CONTEXT1 in ( select paa.assignment_action_id
2415: -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4

Line 2460: from ff_archive_items arch

2456: begin
2457: l_temp_value :=' ';
2458: select sum(value)
2459: into l_temp_value
2460: from ff_archive_items arch
2461: where arch.user_entity_id = t_user_entity_id_a8b(1)
2462: and arch.context1 IN(
2463: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
2464: from pay_payroll_actions ppa,

Line 2495: ff_archive_items arch

2491:
2492: select arch.value
2493: bulk collect into t_amend_value_a8b
2494: from ff_user_entities ue ,
2495: ff_archive_items arch
2496: where ue.user_entity_name in ('X_A8B_COMPANY'
2497: ,'X_A8B_RCB'
2498: ,'X_A8B_COMPANY_TYPE'
2499: ,'X_A8B_OPTION'

Line 2560: from ff_archive_items arch

2556: begin
2557: l_temp_value := null;
2558: select sum(value)
2559: into l_temp_value
2560: from ff_archive_items arch
2561: where arch.user_entity_id = t_user_entity_id_a8b(1)
2562: and arch.context1 IN(
2563: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
2564: from pay_payroll_actions ppa,

Line 2856: type t_archive_items_tab is table of ff_archive_items.archive_item_id%TYPE index by binary_integer;

2852: p_basis_start in date,
2853: p_basis_end in date) is
2854:
2855:
2856: type t_archive_items_tab is table of ff_archive_items.archive_item_id%TYPE index by binary_integer;
2857: t_archive_items_ir8s_c t_archive_items_tab;
2858:
2859: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
2860: t_archive_value_ir8s_c t_archive_value_tab;

Line 2859: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;

2855:
2856: type t_archive_items_tab is table of ff_archive_items.archive_item_id%TYPE index by binary_integer;
2857: t_archive_items_ir8s_c t_archive_items_tab;
2858:
2859: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
2860: t_archive_value_ir8s_c t_archive_value_tab;
2861:
2862: type t_amend_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
2863: t_amend_value_ir8s_c t_amend_value_tab;

Line 2862: type t_amend_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;

2858:
2859: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
2860: t_archive_value_ir8s_c t_archive_value_tab;
2861:
2862: type t_amend_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
2863: t_amend_value_ir8s_c t_amend_value_tab;
2864: t_amend_value_ir8s_c1 t_amend_value_tab;
2865:
2866: type t_user_entity_tab is table of ff_user_entities.user_entity_id%TYPE index by binary_integer;

Line 2927: from ff_archive_items arch,

2923: c_assignment_id per_assignment_extra_info.assignment_id%type,
2924: c_tax_unit_id ff_archive_item_contexts.context%type) is
2925:
2926: select distinct con2.context assignment_extra_info_id
2927: from ff_archive_items arch,
2928: ff_archive_item_contexts con2
2929: where arch.user_entity_id = c_user_entity_id
2930: and arch.context1 IN(
2931: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4

Line 2997: from ff_archive_items arch

2993: begin
2994: l_temp_value := ' ';
2995: select sum(value)
2996: into l_temp_value
2997: from ff_archive_items arch
2998: where arch.user_entity_id = t_user_entity_id_ir8s_c(counter)
2999: and arch.context1 IN(
3000: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
3001: from pay_payroll_actions ppa,

Line 3048: ff_archive_items arch

3044:
3045: select arch.value
3046: bulk collect into t_amend_value_ir8s_c1
3047: from ff_user_entities ue ,
3048: ff_archive_items arch
3049: where ue.user_entity_name in ('X_DTM502'
3050: ,'X_DTM503'
3051: ,'X_DTM504'
3052: ,'X_DTM505'

Line 3131: from ff_archive_items arch

3127: begin
3128: l_temp_value := ' ';
3129: select sum(value)
3130: into l_temp_value
3131: from ff_archive_items arch
3132: where arch.user_entity_id = t_user_entity_id_ir8s_c(counter)
3133: and arch.context1 IN(
3134: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
3135: from pay_payroll_actions ppa,

Line 3235: p_archive_value in ff_archive_items.value%type )

3231: ---------------------------------------------------------------------------
3232: procedure archive_item
3233: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
3234: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3235: p_archive_value in ff_archive_items.value%type )
3236: is
3237: --
3238: v_user_entity_id ff_user_entities.user_entity_id%type;
3239: v_archive_item_id ff_archive_items.archive_item_id%type;

Line 3239: v_archive_item_id ff_archive_items.archive_item_id%type;

3235: p_archive_value in ff_archive_items.value%type )
3236: is
3237: --
3238: v_user_entity_id ff_user_entities.user_entity_id%type;
3239: v_archive_item_id ff_archive_items.archive_item_id%type;
3240: v_object_version_number ff_archive_items.object_version_number%type;
3241: v_some_warning boolean;
3242: ---------------------------------------------------------------------------
3243: -- Cursor User_Entity_ID

Line 3240: v_object_version_number ff_archive_items.object_version_number%type;

3236: is
3237: --
3238: v_user_entity_id ff_user_entities.user_entity_id%type;
3239: v_archive_item_id ff_archive_items.archive_item_id%type;
3240: v_object_version_number ff_archive_items.object_version_number%type;
3241: v_some_warning boolean;
3242: ---------------------------------------------------------------------------
3243: -- Cursor User_Entity_ID
3244: ---------------------------------------------------------------------------

Line 3286: p_archive_value in ff_archive_items.value%type,

3282: -----------------------------------------------------------------------------
3283: procedure archive_item_2
3284: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
3285: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3286: p_archive_value in ff_archive_items.value%type,
3287: p_context_value2 in ff_archive_item_contexts.context%type )
3288: is
3289: --
3290: v_user_entity_id ff_user_entities.user_entity_id%type;

Line 3291: v_archive_item_id ff_archive_items.archive_item_id%type;

3287: p_context_value2 in ff_archive_item_contexts.context%type )
3288: is
3289: --
3290: v_user_entity_id ff_user_entities.user_entity_id%type;
3291: v_archive_item_id ff_archive_items.archive_item_id%type;
3292: v_object_version_number ff_archive_items.object_version_number%type;
3293: v_some_warning boolean;
3294: ---------------------------------------------------------------------------
3295: -- Cursor User_Entity_ID

Line 3292: v_object_version_number ff_archive_items.object_version_number%type;

3288: is
3289: --
3290: v_user_entity_id ff_user_entities.user_entity_id%type;
3291: v_archive_item_id ff_archive_items.archive_item_id%type;
3292: v_object_version_number ff_archive_items.object_version_number%type;
3293: v_some_warning boolean;
3294: ---------------------------------------------------------------------------
3295: -- Cursor User_Entity_ID
3296: ---------------------------------------------------------------------------

Line 3340: p_archive_value in ff_archive_items.value%type,

3336: -----------------------------------------------------------------------------
3337: procedure archive_item_3
3338: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
3339: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3340: p_archive_value in ff_archive_items.value%type,
3341: p_context_value2 in ff_archive_item_contexts.context%type,
3342: p_context_value3 in ff_archive_item_contexts.context%type )
3343: is
3344: --

Line 3346: v_archive_item_id ff_archive_items.archive_item_id%type;

3342: p_context_value3 in ff_archive_item_contexts.context%type )
3343: is
3344: --
3345: v_user_entity_id ff_user_entities.user_entity_id%type;
3346: v_archive_item_id ff_archive_items.archive_item_id%type;
3347: v_object_version_number ff_archive_items.object_version_number%type;
3348: v_some_warning boolean;
3349: ---------------------------------------------------------------------------
3350: -- Cursor User_Entity_ID

Line 3347: v_object_version_number ff_archive_items.object_version_number%type;

3343: is
3344: --
3345: v_user_entity_id ff_user_entities.user_entity_id%type;
3346: v_archive_item_id ff_archive_items.archive_item_id%type;
3347: v_object_version_number ff_archive_items.object_version_number%type;
3348: v_some_warning boolean;
3349: ---------------------------------------------------------------------------
3350: -- Cursor User_Entity_ID
3351: ---------------------------------------------------------------------------