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_ITEM_CONTEXTS

Line 865: p_tax_unit_id in ff_archive_item_contexts.context%type,

861: procedure archive_balances
862: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
863: p_person_id in per_all_people_f.person_id%type,
864: p_business_group_id in hr_organization_units.business_group_id%type,
865: p_tax_unit_id in ff_archive_item_contexts.context%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;

Line 869: v_date_earned ff_archive_item_contexts.context%type;

865: p_tax_unit_id in ff_archive_item_contexts.context%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;

Line 1566: FROM ff_archive_item_contexts con1

1562: AND org_information1 = g_basis_year)
1563: and ppa.payroll_action_id = paa.payroll_action_id
1564: and paa.assignment_id = l_assignment_id)--ORGLEVELPREVSUMITTEDvalues
1565: AND EXISTS (SELECT 1
1566: FROM ff_archive_item_contexts con1
1567: WHERE con1.archive_item_id = arch.archive_item_id
1568: AND con1.context = p_tax_unit_id
1569: AND con1.sequence_no =2)
1570: AND EXISTS (SELECT 1

Line 1571: FROM ff_archive_item_contexts con2

1567: WHERE con1.archive_item_id = arch.archive_item_id
1568: AND con1.context = p_tax_unit_id
1569: AND con1.sequence_no =2)
1570: AND EXISTS (SELECT 1
1571: FROM ff_archive_item_contexts con2
1572: WHERE con2.archive_item_id = arch.archive_item_id
1573: AND fnd_date.canonical_to_date(con2.context) = fnd_date.canonical_to_date(t_date_earned(i))
1574: AND con2.sequence_no =3);
1575: EXCEPTION

Line 1670: from ff_archive_item_contexts con1

1666: AND org_information1 = g_basis_year)
1667: and ppa.payroll_action_id = paa.payroll_action_id
1668: and paa.assignment_id = l_assignment_id)
1669: and exists (select 1
1670: from ff_archive_item_contexts con1
1671: where con1.archive_item_id = arch.archive_item_id
1672: and con1.context = p_tax_unit_id
1673: and con1.sequence_no =2);
1674:

Line 1727: from ff_archive_item_contexts con1

1723: AND org_information1 = g_basis_year)
1724: and ppa.payroll_action_id = paa.payroll_action_id
1725: and paa.assignment_id = l_assignment_id)
1726: and exists (select 1
1727: from ff_archive_item_contexts con1
1728: where con1.archive_item_id = arch.archive_item_id
1729: and con1.context = p_tax_unit_id
1730: and con1.sequence_no =2);
1731:

Line 1800: from ff_archive_item_contexts con1

1796: AND org_information1 = g_basis_year)
1797: and ppa.payroll_action_id = paa.payroll_action_id
1798: and paa.assignment_id = l_assignment_id)
1799: and exists (select 1
1800: from ff_archive_item_contexts con1
1801: where con1.archive_item_id = arch.archive_item_id
1802: and con1.context = p_tax_unit_id
1803: and con1.sequence_no =2);
1804:

Line 1872: insert into ff_archive_item_contexts

1868: 'AAP' )
1869: returning archive_item_id bulk collect into t_archive_items ;
1870:
1871: forall counter in t_archive_items.first..t_archive_items.last
1872: insert into ff_archive_item_contexts
1873: ( archive_item_id,
1874: sequence_no,
1875: context,
1876: context_id )

Line 1902: insert into ff_archive_item_contexts

1898: returning archive_item_id bulk collect into t_archive_items ;
1899:
1900:
1901: forall counter in t_archive_items.first..t_archive_items.last
1902: insert into ff_archive_item_contexts
1903: ( archive_item_id,
1904: sequence_no,
1905: context,
1906: context_id )

Line 1914: insert into ff_archive_item_contexts

1910: p_assignment_action_id,
1911: l_asac_cont_id );
1912: --
1913: forall counter in t_archive_items.first..t_archive_items.last
1914: insert into ff_archive_item_contexts
1915: ( archive_item_id,
1916: sequence_no,
1917: context,
1918: context_id )

Line 1926: insert into ff_archive_item_contexts

1922: p_tax_unit_id,
1923: l_tax_cont_id );
1924: --
1925: forall counter in t_archive_items.first..t_archive_items.last
1926: insert into ff_archive_item_contexts
1927: ( archive_item_id,
1928: sequence_no,
1929: context,
1930: context_id )

Line 1960: insert into ff_archive_item_contexts

1956:
1957:
1958:
1959: forall counter in t_archive_items_ir8a.first..t_archive_items_ir8a.last
1960: insert into ff_archive_item_contexts
1961: ( archive_item_id,
1962: sequence_no,
1963: context,
1964: context_id )

Line 1972: insert into ff_archive_item_contexts

1968: p_assignment_action_id,
1969: l_asac_cont_id );
1970: --
1971: forall counter in t_archive_items_ir8a.first..t_archive_items_ir8a.last
1972: insert into ff_archive_item_contexts
1973: ( archive_item_id,
1974: sequence_no,
1975: context,
1976: context_id )

Line 2004: insert into ff_archive_item_contexts

2000:
2001:
2002:
2003: forall counter in t_archive_items_ir8s.first..t_archive_items_ir8s.last
2004: insert into ff_archive_item_contexts
2005: ( archive_item_id,
2006: sequence_no,
2007: context,
2008: context_id )

Line 2016: insert into ff_archive_item_contexts

2012: p_assignment_action_id,
2013: l_asac_cont_id );
2014: --
2015: forall counter in t_archive_items_ir8s.first..t_archive_items_ir8s.last
2016: insert into ff_archive_item_contexts
2017: ( archive_item_id,
2018: sequence_no,
2019: context,
2020: context_id )

Line 2049: insert into ff_archive_item_contexts

2045:
2046:
2047:
2048: forall counter in t_archive_items_a8a.first..t_archive_items_a8a.last
2049: insert into ff_archive_item_contexts
2050: ( archive_item_id,
2051: sequence_no,
2052: context,
2053: context_id )

Line 2061: insert into ff_archive_item_contexts

2057: p_assignment_action_id,
2058: l_asac_cont_id );
2059: --
2060: forall counter in t_archive_items_a8a.first..t_archive_items_a8a.last
2061: insert into ff_archive_item_contexts
2062: ( archive_item_id,
2063: sequence_no,
2064: context,
2065: context_id )

Line 2171: insert into ff_archive_item_contexts

2167: returning archive_item_id bulk collect into t_archive_items_orig ;
2168: --
2169:
2170: forall counter in t_archive_items_orig.first..t_archive_items_orig.last
2171: insert into ff_archive_item_contexts
2172: ( archive_item_id,
2173: sequence_no,
2174: context,
2175: context_id )

Line 2216: p_tax_unit_id in ff_archive_item_contexts.context%type,

2212: ---------------------------------------------------------------------------
2213: procedure archive_shares_details
2214: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2215: p_person_id in per_all_people_f.person_id%type,
2216: p_tax_unit_id in ff_archive_item_contexts.context%type,
2217: p_basis_start in date,
2218: p_basis_end in date )
2219: is
2220:

Line 2344: c_tax_unit_id ff_archive_item_contexts.context%type) is

2340: cursor shares_removed
2341: (c_user_entity_id ff_user_entities.user_entity_id%type,
2342: c_assignment_id per_assignment_extra_info.assignment_id%type,
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

Line 2348: ff_archive_item_contexts con2

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
2352: from pay_payroll_actions ppa,

Line 2363: from ff_archive_item_contexts con1

2359: AND org_information1 = g_basis_year)
2360: and ppa.payroll_action_id = paa.payroll_action_id
2361: and paa.assignment_id = c_assignment_id)
2362: and exists (select 1
2363: from ff_archive_item_contexts con1
2364: where con1.archive_item_id = arch.archive_item_id
2365: and con1.context = c_tax_unit_id
2366: and con1.sequence_no =2)
2367: and arch.archive_item_id = con2.archive_item_id

Line 2475: from ff_archive_item_contexts con1

2471: AND org_information1 = g_basis_year)
2472: and ppa.payroll_action_id = paa.payroll_action_id
2473: and paa.assignment_id = l_assignment_id)
2474: and exists (select 1
2475: from ff_archive_item_contexts con1
2476: where con1.archive_item_id = arch.archive_item_id
2477: and con1.context = p_tax_unit_id
2478: and con1.sequence_no =2)
2479: and exists (select 1

Line 2480: from ff_archive_item_contexts con2

2476: where con1.archive_item_id = arch.archive_item_id
2477: and con1.context = p_tax_unit_id
2478: and con1.sequence_no =2)
2479: and exists (select 1
2480: from ff_archive_item_contexts con2
2481: where con2.archive_item_id = arch.archive_item_id
2482: and con2.context = shares_removed_rec.person_extra_info_id
2483: and con2.sequence_no = 3);
2484: exception

Line 2521: from ff_archive_item_contexts con1

2517: and ppa.payroll_action_id = paa.payroll_action_id
2518: and ppa.report_type='SG_IRAS_ARCHIVE'
2519: and paa.assignment_id = l_assignment_id)
2520: and exists (select 1
2521: from ff_archive_item_contexts con1
2522: where con1.archive_item_id = arch.archive_item_id
2523: and con1.context = p_tax_unit_id
2524: and con1.sequence_no =2)
2525: and exists (select 1

Line 2526: from ff_archive_item_contexts con2

2522: where con1.archive_item_id = arch.archive_item_id
2523: and con1.context = p_tax_unit_id
2524: and con1.sequence_no =2)
2525: and exists (select 1
2526: from ff_archive_item_contexts con2
2527: where con2.archive_item_id = arch.archive_item_id
2528: and con2.context = shares_removed_rec.person_extra_info_id
2529: and con2.sequence_no = 3)
2530: order by ue.user_entity_name desc;

Line 2575: from ff_archive_item_contexts con1

2571: AND org_information1 = g_basis_year)
2572: and ppa.payroll_action_id = paa.payroll_action_id
2573: and paa.assignment_id = l_assignment_id)
2574: and exists (select 1
2575: from ff_archive_item_contexts con1
2576: where con1.archive_item_id = arch.archive_item_id
2577: and con1.context = p_tax_unit_id
2578: and con1.sequence_no =2)
2579: and exists (select 1

Line 2580: from ff_archive_item_contexts con2

2576: where con1.archive_item_id = arch.archive_item_id
2577: and con1.context = p_tax_unit_id
2578: and con1.sequence_no =2)
2579: and exists (select 1
2580: from ff_archive_item_contexts con2
2581: where con2.archive_item_id = arch.archive_item_id
2582: and con2.context = share_rec.person_extra_info_id
2583: and con2.sequence_no = 3);
2584: exception

Line 2774: p_tax_unit_id in ff_archive_item_contexts.context%type,

2770: ---------------------------------------------------------------------------
2771: procedure archive_ir8s_c_details
2772: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2773: p_person_id in per_all_people_f.person_id%type,
2774: p_tax_unit_id in ff_archive_item_contexts.context%type,
2775: p_business_group_id in per_assignments_f.business_group_id%type,
2776: p_basis_start in date,
2777: p_basis_end in date) is
2778:

Line 2850: p_tax_unit_id in ff_archive_item_contexts.context%type,

2846: procedure archive_ir8s_c_detail_moas
2847: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2848: p_1_person_id in per_all_people_f.person_id%type,
2849: p_person_id in per_all_people_f.person_id%type,
2850: p_tax_unit_id in ff_archive_item_contexts.context%type,
2851: p_business_group_id in per_assignments_f.business_group_id%type,
2852: p_basis_start in date,
2853: p_basis_end in date) is
2854:

Line 2888: c_tax_unit_id ff_archive_item_contexts.context%type,

2884:
2885:
2886: cursor ir8s_c_details
2887: (c_person_id per_assignments_f.person_id%type,
2888: c_tax_unit_id ff_archive_item_contexts.context%type,
2889: c_business_group_id per_assignments_f.business_group_id%type,
2890: c_basis_start date,
2891: c_basis_end date) is
2892:

Line 2924: c_tax_unit_id ff_archive_item_contexts.context%type) is

2920:
2921: cursor ir8s_c_removed
2922: (c_user_entity_id ff_user_entities.user_entity_id%type,
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

Line 2928: ff_archive_item_contexts con2

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
2932: from pay_payroll_actions ppa,

Line 2943: from ff_archive_item_contexts con1

2939: AND org_information1 = g_basis_year)
2940: and ppa.payroll_action_id = paa.payroll_action_id
2941: and paa.assignment_id = c_assignment_id)
2942: and exists (select 1
2943: from ff_archive_item_contexts con1
2944: where con1.archive_item_id = arch.archive_item_id
2945: and con1.context = c_tax_unit_id
2946: and con1.sequence_no =2)
2947: and arch.archive_item_id = con2.archive_item_id

Line 3012: from ff_archive_item_contexts con1

3008: AND org_information1 = g_basis_year)
3009: and ppa.payroll_action_id = paa.payroll_action_id
3010: and paa.assignment_id = l_assignment_id)
3011: and exists (select 1
3012: from ff_archive_item_contexts con1
3013: where con1.archive_item_id = arch.archive_item_id
3014: and con1.context = p_tax_unit_id
3015: and con1.sequence_no =2)
3016: and exists (select 1

Line 3017: from ff_archive_item_contexts con2

3013: where con1.archive_item_id = arch.archive_item_id
3014: and con1.context = p_tax_unit_id
3015: and con1.sequence_no =2)
3016: and exists (select 1
3017: from ff_archive_item_contexts con2
3018: where con2.archive_item_id = arch.archive_item_id
3019: and con2.context = ir8s_c_removed_rec.assignment_extra_info_id
3020: and con2.sequence_no = 3);
3021: exception

Line 3068: from ff_archive_item_contexts con1

3064: and ppa.payroll_action_id = paa.payroll_action_id
3065: and ppa.report_type='SG_IRAS_ARCHIVE'
3066: and paa.assignment_id = l_assignment_id)
3067: and exists (select 1
3068: from ff_archive_item_contexts con1
3069: where con1.archive_item_id = arch.archive_item_id
3070: and con1.context = p_tax_unit_id
3071: and con1.sequence_no =2)
3072: and exists (select 1

Line 3073: from ff_archive_item_contexts con2

3069: where con1.archive_item_id = arch.archive_item_id
3070: and con1.context = p_tax_unit_id
3071: and con1.sequence_no =2)
3072: and exists (select 1
3073: from ff_archive_item_contexts con2
3074: where con2.archive_item_id = arch.archive_item_id
3075: and con2.context = ir8s_c_removed_rec.assignment_extra_info_id
3076: and con2.sequence_no = 3)
3077: order by ue.user_entity_name desc;

Line 3146: from ff_archive_item_contexts con1

3142: AND org_information1 = g_basis_year)
3143: and ppa.payroll_action_id = paa.payroll_action_id
3144: and paa.assignment_id = l_assignment_id)
3145: and exists (select 1
3146: from ff_archive_item_contexts con1
3147: where con1.archive_item_id = arch.archive_item_id
3148: and con1.context = p_tax_unit_id
3149: and con1.sequence_no =2)
3150: and exists (select 1

Line 3151: from ff_archive_item_contexts con2

3147: where con1.archive_item_id = arch.archive_item_id
3148: and con1.context = p_tax_unit_id
3149: and con1.sequence_no =2)
3150: and exists (select 1
3151: from ff_archive_item_contexts con2
3152: where con2.archive_item_id = arch.archive_item_id
3153: and con2.context = ir8s_c_rec.assignment_extra_info_id
3154: and con2.sequence_no = 3);
3155: exception

Line 3287: p_context_value2 in ff_archive_item_contexts.context%type )

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;
3291: v_archive_item_id ff_archive_items.archive_item_id%type;

Line 3341: p_context_value2 in ff_archive_item_contexts.context%type,

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: --
3345: v_user_entity_id ff_user_entities.user_entity_id%type;

Line 3342: p_context_value3 in ff_archive_item_contexts.context%type )

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: --
3345: v_user_entity_id ff_user_entities.user_entity_id%type;
3346: v_archive_item_id ff_archive_items.archive_item_id%type;

Line 3511: , p_tax_unit_id in ff_archive_item_contexts.context%type

3507: -------------------------------------------------------------------------
3508:
3509: function pri_if_latest
3510: ( p_person_id in per_all_people_f.person_id%type
3511: , p_tax_unit_id in ff_archive_item_contexts.context%type
3512: , p_basis_start in date
3513: , p_basis_end in date) return boolean
3514: is
3515: v_dummy varchar2(1);

Line 3574: , p_tax_unit_id in ff_archive_item_contexts.context%type

3570: -------------------------------------------------------------------------
3571:
3572: function pri_LE_if_latest
3573: ( p_person_id in per_all_people_f.person_id%type
3574: , p_tax_unit_id in ff_archive_item_contexts.context%type
3575: , p_basis_start in date
3576: , p_basis_end in date) return number
3577: is
3578: v_assignment_id number(10);

Line 3643: , p_tax_unit_id in ff_archive_item_contexts.context%type

3639: -------------------------------------------------------------------------
3640:
3641: function id_LE_if_latest
3642: ( p_person_id in per_all_people_f.person_id%type
3643: , p_tax_unit_id in ff_archive_item_contexts.context%type
3644: , p_basis_start in date
3645: , p_basis_end in date) return number
3646: is
3647: v_assignment_id number(10);