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_ARCHIVE dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 1064: p_tax_unit_id in ff_archive_item_contexts.context%type,

1060: procedure archive_balances
1061: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1062: p_person_id in per_all_people_f.person_id%type,
1063: p_business_group_id in hr_organization_units.business_group_id%type,
1064: p_tax_unit_id in ff_archive_item_contexts.context%type,
1065: p_basis_year in varchar2 )
1066: is
1067: v_run_ass_action_id pay_assignment_actions.assignment_action_id%type;
1068: v_date_earned ff_archive_item_contexts.context%type;

Line 1068: v_date_earned ff_archive_item_contexts.context%type;

1064: p_tax_unit_id in ff_archive_item_contexts.context%type,
1065: p_basis_year in varchar2 )
1066: is
1067: v_run_ass_action_id pay_assignment_actions.assignment_action_id%type;
1068: v_date_earned ff_archive_item_contexts.context%type;
1069: v_balance_value ff_archive_items.value%type;
1070: v_archive_item_id ff_archive_items.archive_item_id%type;
1071: v_object_version_number ff_archive_items.object_version_number%type;
1072: v_some_warning boolean;

Line 1627: insert into ff_archive_item_contexts

1623: 'AAP' )
1624: returning archive_item_id bulk collect into t_archive_items ;
1625: --
1626: forall counter in t_archive_items.first..t_archive_items.last
1627: insert into ff_archive_item_contexts
1628: ( archive_item_id,
1629: sequence_no,
1630: context,
1631: context_id )

Line 1639: insert into ff_archive_item_contexts

1635: p_assignment_action_id,
1636: l_asac_cont_id );
1637: --
1638: forall counter in t_archive_items.first..t_archive_items.last
1639: insert into ff_archive_item_contexts
1640: ( archive_item_id,
1641: sequence_no,
1642: context,
1643: context_id )

Line 1651: insert into ff_archive_item_contexts

1647: p_tax_unit_id,
1648: l_tax_cont_id );
1649: --
1650: forall counter in t_archive_items.first..t_archive_items.last
1651: insert into ff_archive_item_contexts
1652: ( archive_item_id,
1653: sequence_no,
1654: context,
1655: context_id )

Line 1711: insert into ff_archive_item_contexts

1707: 'AAP' )
1708: returning archive_item_id bulk collect into t_archive_items ;
1709: --
1710: forall counter in t_archive_items.first..t_archive_items.last
1711: insert into ff_archive_item_contexts
1712: ( archive_item_id,
1713: sequence_no,
1714: context,
1715: context_id )

Line 1723: insert into ff_archive_item_contexts

1719: p_assignment_action_id,
1720: l_asac_cont_id );
1721: --
1722: forall counter in t_archive_items.first..t_archive_items.last
1723: insert into ff_archive_item_contexts
1724: ( archive_item_id,
1725: sequence_no,
1726: context,
1727: context_id )

Line 3841: p_tax_unit_id in ff_archive_item_contexts.context%type,

3837: ---------------------------------------------------------------------------
3838: procedure archive_shares_details
3839: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3840: p_person_id in per_all_people_f.person_id%type,
3841: p_tax_unit_id in ff_archive_item_contexts.context%type,
3842: p_basis_start in date,
3843: p_basis_end in date )
3844: is
3845: --

Line 3978: p_tax_unit_id in ff_archive_item_contexts.context%type,

3974: ---------------------------------------------------------------------------
3975: procedure archive_ir8s_c_details
3976: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3977: p_person_id in per_all_people_f.person_id%type,
3978: p_tax_unit_id in ff_archive_item_contexts.context%type,
3979: p_business_group_id in per_assignments_f.business_group_id%type,
3980: p_basis_start in date,
3981: p_basis_end in date) is
3982:

Line 3993: c_tax_unit_id ff_archive_item_contexts.context%type,

3989: person_id_rec person_id_tab;
3990:
3991: cursor ir8s_c_invalid_records
3992: (c_person_id per_all_people_f.person_id%type,
3993: c_tax_unit_id ff_archive_item_contexts.context%type,
3994: c_business_group_id per_assignments_f.business_group_id%type,
3995: c_basis_start date,
3996: c_basis_end date) is
3997:

Line 4105: p_tax_unit_id in ff_archive_item_contexts.context%type,

4101: procedure archive_ir8s_c_detail_moas
4102: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4103: p_1_person_id in per_all_people_f.person_id%type,
4104: p_person_id in per_all_people_f.person_id%type,
4105: p_tax_unit_id in ff_archive_item_contexts.context%type,
4106: p_business_group_id in per_assignments_f.business_group_id%type,
4107: p_basis_start in date,
4108: p_basis_end in date) is
4109:

Line 4112: c_tax_unit_id ff_archive_item_contexts.context%type,

4108: p_basis_end in date) is
4109:
4110: cursor ir8s_c_details
4111: (c_person_id per_assignments_f.person_id%type,
4112: c_tax_unit_id ff_archive_item_contexts.context%type,
4113: c_business_group_id per_assignments_f.business_group_id%type,
4114: c_basis_start date,
4115: c_basis_end date) is
4116:

Line 4258: p_context_value2 in ff_archive_item_contexts.context%type )

4254: procedure archive_item_2
4255: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4256: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4257: p_archive_value in ff_archive_items.value%type,
4258: p_context_value2 in ff_archive_item_contexts.context%type )
4259: is
4260: --
4261: v_user_entity_id ff_user_entities.user_entity_id%type;
4262: v_archive_item_id ff_archive_items.archive_item_id%type;

Line 4312: p_context_value2 in ff_archive_item_contexts.context%type,

4308: procedure archive_item_3
4309: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4310: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4311: p_archive_value in ff_archive_items.value%type,
4312: p_context_value2 in ff_archive_item_contexts.context%type,
4313: p_context_value3 in ff_archive_item_contexts.context%type )
4314: is
4315: --
4316: v_user_entity_id ff_user_entities.user_entity_id%type;

Line 4313: p_context_value3 in ff_archive_item_contexts.context%type )

4309: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4310: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4311: p_archive_value in ff_archive_items.value%type,
4312: p_context_value2 in ff_archive_item_contexts.context%type,
4313: p_context_value3 in ff_archive_item_contexts.context%type )
4314: is
4315: --
4316: v_user_entity_id ff_user_entities.user_entity_id%type;
4317: v_archive_item_id ff_archive_items.archive_item_id%type;

Line 4494: , p_tax_unit_id in ff_archive_item_contexts.context%type

4490: -------------------------------------------------------------------------
4491:
4492: function pri_if_latest
4493: ( p_person_id in per_all_people_f.person_id%type
4494: , p_tax_unit_id in ff_archive_item_contexts.context%type
4495: , p_basis_start in date
4496: , p_basis_end in date) return boolean
4497: is
4498: v_dummy varchar2(1);

Line 4557: , p_tax_unit_id in ff_archive_item_contexts.context%type

4553: -------------------------------------------------------------------------
4554:
4555: function pri_LE_if_latest
4556: ( p_person_id in per_all_people_f.person_id%type
4557: , p_tax_unit_id in ff_archive_item_contexts.context%type
4558: , p_basis_start in date
4559: , p_basis_end in date) return number
4560: is
4561: v_assignment_id number(10);

Line 4626: , p_tax_unit_id in ff_archive_item_contexts.context%type

4622: -------------------------------------------------------------------------
4623:
4624: function id_LE_if_latest
4625: ( p_person_id in per_all_people_f.person_id%type
4626: , p_tax_unit_id in ff_archive_item_contexts.context%type
4627: , p_basis_start in date
4628: , p_basis_end in date) return number
4629: is
4630: v_assignment_id number(10);