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 1075: p_tax_unit_id in ff_archive_item_contexts.context%type,

1071: procedure archive_balances
1072: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1073: p_person_id in per_all_people_f.person_id%type,
1074: p_business_group_id in hr_organization_units.business_group_id%type,
1075: p_tax_unit_id in ff_archive_item_contexts.context%type,
1076: p_basis_year in varchar2 )
1077: is
1078: v_run_ass_action_id pay_assignment_actions.assignment_action_id%type;
1079: v_date_earned ff_archive_item_contexts.context%type;

Line 1079: v_date_earned ff_archive_item_contexts.context%type;

1075: p_tax_unit_id in ff_archive_item_contexts.context%type,
1076: p_basis_year in varchar2 )
1077: is
1078: v_run_ass_action_id pay_assignment_actions.assignment_action_id%type;
1079: v_date_earned ff_archive_item_contexts.context%type;
1080: v_balance_value ff_archive_items.value%type;
1081: v_archive_item_id ff_archive_items.archive_item_id%type;
1082: v_object_version_number ff_archive_items.object_version_number%type;
1083: v_some_warning boolean;

Line 1638: insert into ff_archive_item_contexts

1634: 'AAP' )
1635: returning archive_item_id bulk collect into t_archive_items ;
1636: --
1637: forall counter in t_archive_items.first..t_archive_items.last
1638: insert into ff_archive_item_contexts
1639: ( archive_item_id,
1640: sequence_no,
1641: context,
1642: context_id )

Line 1650: insert into ff_archive_item_contexts

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

Line 1662: insert into ff_archive_item_contexts

1658: p_tax_unit_id,
1659: l_tax_cont_id );
1660: --
1661: forall counter in t_archive_items.first..t_archive_items.last
1662: insert into ff_archive_item_contexts
1663: ( archive_item_id,
1664: sequence_no,
1665: context,
1666: context_id )

Line 1722: insert into ff_archive_item_contexts

1718: 'AAP' )
1719: returning archive_item_id bulk collect into t_archive_items ;
1720: --
1721: forall counter in t_archive_items.first..t_archive_items.last
1722: insert into ff_archive_item_contexts
1723: ( archive_item_id,
1724: sequence_no,
1725: context,
1726: context_id )

Line 1734: insert into ff_archive_item_contexts

1730: p_assignment_action_id,
1731: l_asac_cont_id );
1732: --
1733: forall counter in t_archive_items.first..t_archive_items.last
1734: insert into ff_archive_item_contexts
1735: ( archive_item_id,
1736: sequence_no,
1737: context,
1738: context_id )

Line 3971: p_tax_unit_id in ff_archive_item_contexts.context%type,

3967: ---------------------------------------------------------------------------
3968: procedure archive_shares_details
3969: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3970: p_person_id in per_all_people_f.person_id%type,
3971: p_tax_unit_id in ff_archive_item_contexts.context%type,
3972: p_basis_start in date,
3973: p_basis_end in date )
3974: is
3975: --

Line 4238: p_tax_unit_id in ff_archive_item_contexts.context%type,

4234: ---------------------------------------------------------------------------
4235: procedure archive_ir8s_c_details
4236: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4237: p_person_id in per_all_people_f.person_id%type,
4238: p_tax_unit_id in ff_archive_item_contexts.context%type,
4239: p_business_group_id in per_assignments_f.business_group_id%type,
4240: p_basis_start in date,
4241: p_basis_end in date) is
4242:

Line 4253: c_tax_unit_id ff_archive_item_contexts.context%type,

4249: person_id_rec person_id_tab;
4250:
4251: cursor ir8s_c_invalid_records
4252: (c_person_id per_all_people_f.person_id%type,
4253: c_tax_unit_id ff_archive_item_contexts.context%type,
4254: c_business_group_id per_assignments_f.business_group_id%type,
4255: c_basis_start date,
4256: c_basis_end date) is
4257:

Line 4365: p_tax_unit_id in ff_archive_item_contexts.context%type,

4361: procedure archive_ir8s_c_detail_moas
4362: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4363: p_1_person_id in per_all_people_f.person_id%type,
4364: p_person_id in per_all_people_f.person_id%type,
4365: p_tax_unit_id in ff_archive_item_contexts.context%type,
4366: p_business_group_id in per_assignments_f.business_group_id%type,
4367: p_basis_start in date,
4368: p_basis_end in date) is
4369:

Line 4372: c_tax_unit_id ff_archive_item_contexts.context%type,

4368: p_basis_end in date) is
4369:
4370: cursor ir8s_c_details
4371: (c_person_id per_assignments_f.person_id%type,
4372: c_tax_unit_id ff_archive_item_contexts.context%type,
4373: c_business_group_id per_assignments_f.business_group_id%type,
4374: c_basis_start date,
4375: c_basis_end date) is
4376:

Line 4518: p_context_value2 in ff_archive_item_contexts.context%type )

4514: procedure archive_item_2
4515: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4516: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4517: p_archive_value in ff_archive_items.value%type,
4518: p_context_value2 in ff_archive_item_contexts.context%type )
4519: is
4520: --
4521: v_user_entity_id ff_user_entities.user_entity_id%type;
4522: v_archive_item_id ff_archive_items.archive_item_id%type;

Line 4572: p_context_value2 in ff_archive_item_contexts.context%type,

4568: procedure archive_item_3
4569: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4570: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4571: p_archive_value in ff_archive_items.value%type,
4572: p_context_value2 in ff_archive_item_contexts.context%type,
4573: p_context_value3 in ff_archive_item_contexts.context%type )
4574: is
4575: --
4576: v_user_entity_id ff_user_entities.user_entity_id%type;

Line 4573: p_context_value3 in ff_archive_item_contexts.context%type )

4569: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4570: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4571: p_archive_value in ff_archive_items.value%type,
4572: p_context_value2 in ff_archive_item_contexts.context%type,
4573: p_context_value3 in ff_archive_item_contexts.context%type )
4574: is
4575: --
4576: v_user_entity_id ff_user_entities.user_entity_id%type;
4577: v_archive_item_id ff_archive_items.archive_item_id%type;

Line 4754: , p_tax_unit_id in ff_archive_item_contexts.context%type

4750: -------------------------------------------------------------------------
4751:
4752: function pri_if_latest
4753: ( p_person_id in per_all_people_f.person_id%type
4754: , p_tax_unit_id in ff_archive_item_contexts.context%type
4755: , p_basis_start in date
4756: , p_basis_end in date) return boolean
4757: is
4758: v_dummy varchar2(1);

Line 4817: , p_tax_unit_id in ff_archive_item_contexts.context%type

4813: -------------------------------------------------------------------------
4814:
4815: function pri_LE_if_latest
4816: ( p_person_id in per_all_people_f.person_id%type
4817: , p_tax_unit_id in ff_archive_item_contexts.context%type
4818: , p_basis_start in date
4819: , p_basis_end in date) return number
4820: is
4821: v_assignment_id number(10);

Line 4886: , p_tax_unit_id in ff_archive_item_contexts.context%type

4882: -------------------------------------------------------------------------
4883:
4884: function id_LE_if_latest
4885: ( p_person_id in per_all_people_f.person_id%type
4886: , p_tax_unit_id in ff_archive_item_contexts.context%type
4887: , p_basis_start in date
4888: , p_basis_end in date) return number
4889: is
4890: v_assignment_id number(10);