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_ITEMS

Line 17: g_moa_369_date ff_archive_items.value%type;

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

Line 19: g_name_of_bank ff_archive_items.value%type;

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

Line 384: from ff_archive_items fai,

380: is
381: cursor csr_get_value( p_user_entity_name varchar2,
382: p_assignment_action_id number ) is
383: select fai.value
384: from ff_archive_items fai,
385: ff_user_entities fue
386: where fai.context1 = p_assignment_action_id
387: and fai.user_entity_id = fue.user_entity_id
388: and fue.user_entity_name = p_user_entity_name;

Line 390: l_value ff_archive_items.value%type;

386: where fai.context1 = p_assignment_action_id
387: and fai.user_entity_id = fue.user_entity_id
388: and fue.user_entity_name = p_user_entity_name;
389: --
390: l_value ff_archive_items.value%type;
391: e_no_value_found exception;
392: begin
393: open csr_get_value ( p_user_entity_name,
394: p_assignment_action_id );

Line 1080: v_balance_value ff_archive_items.value%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;
1084: --------------------------------------------------------------------------------------

Line 1081: v_archive_item_id ff_archive_items.archive_item_id%type;

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;
1084: --------------------------------------------------------------------------------------
1085: --Bug#3933332 Moved the records from package header as these pl/sql table is

Line 1082: v_object_version_number ff_archive_items.object_version_number%type;

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;
1084: --------------------------------------------------------------------------------------
1085: --Bug#3933332 Moved the records from package header as these pl/sql table is
1086: -- specific to procedure archive_balances()

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

1084: --------------------------------------------------------------------------------------
1085: --Bug#3933332 Moved the records from package header as these pl/sql table is
1086: -- specific to procedure archive_balances()
1087: --------------------------------------------------------------------------------------
1088: type t_archive_items_tab is table of ff_archive_items.archive_item_id%TYPE index by binary_integer;
1089: t_archive_items t_archive_items_tab;
1090: --
1091: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
1092: t_archive_value t_archive_value_tab;

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

1087: --------------------------------------------------------------------------------------
1088: type t_archive_items_tab is table of ff_archive_items.archive_item_id%TYPE index by binary_integer;
1089: t_archive_items t_archive_items_tab;
1090: --
1091: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
1092: t_archive_value t_archive_value_tab;
1093: --
1094: type t_date_earned_tab is table of varchar2(30) index by binary_integer;
1095: t_date_earned t_date_earned_tab;

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

1601: l_pmon_counter := false;
1602: end if;
1603: end loop;
1604: ------------------------------------------------------------------------------------------------
1605: -- Bug: 3260855 Bulk Insert into ff_archive_items for month balances
1606: ------------------------------------------------------------------------------------------------
1607: select context_id
1608: into l_asac_cont_id
1609: from ff_contexts

Line 1623: insert into ff_archive_items

1619: from ff_contexts
1620: where context_name = 'DATE_EARNED' ;
1621: --
1622: forall counter in 1..t_user_entity_id.count
1623: insert into ff_archive_items
1624: ( archive_item_id,
1625: user_entity_id,
1626: context1,
1627: value,

Line 1630: ( ff_archive_items_s.nextval,

1626: context1,
1627: value,
1628: archive_type )
1629: values
1630: ( ff_archive_items_s.nextval,
1631: t_user_entity_id(counter),
1632: p_assignment_action_id,
1633: t_archive_value(counter),
1634: 'AAP' )

Line 1704: -- Bug: 3260855 - Bulk Insert into ff_archive_items for ytd balances

1700: end loop;
1701: --
1702: end if;
1703: ------------------------------------------------------------------------------------------------
1704: -- Bug: 3260855 - Bulk Insert into ff_archive_items for ytd balances
1705: ------------------------------------------------------------------------------------------------
1706: forall counter in 1..t_user_entity_id.count
1707: insert into ff_archive_items
1708: ( archive_item_id,

Line 1707: insert into ff_archive_items

1703: ------------------------------------------------------------------------------------------------
1704: -- Bug: 3260855 - Bulk Insert into ff_archive_items for ytd balances
1705: ------------------------------------------------------------------------------------------------
1706: forall counter in 1..t_user_entity_id.count
1707: insert into ff_archive_items
1708: ( archive_item_id,
1709: user_entity_id,
1710: context1,
1711: value,

Line 1714: ( ff_archive_items_s.nextval,

1710: context1,
1711: value,
1712: archive_type )
1713: values
1714: ( ff_archive_items_s.nextval,
1715: t_user_entity_id(counter),
1716: p_assignment_action_id,
1717: t_archive_value(counter),
1718: 'AAP' )

Line 1773: v_date_from ff_archive_items.value%type;

1769: p_run_ass_action_id in pay_assignment_actions.assignment_action_id%type,
1770: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type )
1771: is
1772: --
1773: v_date_from ff_archive_items.value%type;
1774: v_date_to ff_archive_items.value%type;
1775: v_no_of_times number;
1776: v_date_from_old ff_archive_items.value%type;
1777: v_date_to_old ff_archive_items.value%type;

Line 1774: v_date_to ff_archive_items.value%type;

1770: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type )
1771: is
1772: --
1773: v_date_from ff_archive_items.value%type;
1774: v_date_to ff_archive_items.value%type;
1775: v_no_of_times number;
1776: v_date_from_old ff_archive_items.value%type;
1777: v_date_to_old ff_archive_items.value%type;
1778: v_no_of_times_old number;

Line 1776: v_date_from_old ff_archive_items.value%type;

1772: --
1773: v_date_from ff_archive_items.value%type;
1774: v_date_to ff_archive_items.value%type;
1775: v_no_of_times number;
1776: v_date_from_old ff_archive_items.value%type;
1777: v_date_to_old ff_archive_items.value%type;
1778: v_no_of_times_old number;
1779: v_no_of_times_411 number;
1780: v_no_of_times_413 number;

Line 1777: v_date_to_old ff_archive_items.value%type;

1773: v_date_from ff_archive_items.value%type;
1774: v_date_to ff_archive_items.value%type;
1775: v_no_of_times number;
1776: v_date_from_old ff_archive_items.value%type;
1777: v_date_to_old ff_archive_items.value%type;
1778: v_no_of_times_old number;
1779: v_no_of_times_411 number;
1780: v_no_of_times_413 number;
1781: v_265_indicator varchar2(1);

Line 1782: v_moa_410_date ff_archive_items.value%type;

1778: v_no_of_times_old number;
1779: v_no_of_times_411 number;
1780: v_no_of_times_413 number;
1781: v_265_indicator varchar2(1);
1782: v_moa_410_date ff_archive_items.value%type;
1783: v_moa_411_date ff_archive_items.value%type;
1784: v_moa_413_date ff_archive_items.value%type;
1785: l_terminated varchar2(1);
1786: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;

Line 1783: v_moa_411_date ff_archive_items.value%type;

1779: v_no_of_times_411 number;
1780: v_no_of_times_413 number;
1781: v_265_indicator varchar2(1);
1782: v_moa_410_date ff_archive_items.value%type;
1783: v_moa_411_date ff_archive_items.value%type;
1784: v_moa_413_date ff_archive_items.value%type;
1785: l_terminated varchar2(1);
1786: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;
1787: l_new_ass_id per_all_assignments_f.assignment_id%TYPE;

Line 1784: v_moa_413_date ff_archive_items.value%type;

1780: v_no_of_times_413 number;
1781: v_265_indicator varchar2(1);
1782: v_moa_410_date ff_archive_items.value%type;
1783: v_moa_411_date ff_archive_items.value%type;
1784: v_moa_413_date ff_archive_items.value%type;
1785: l_terminated varchar2(1);
1786: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;
1787: l_new_ass_id per_all_assignments_f.assignment_id%TYPE;
1788: l_run_ass_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 1858: p_date_from out nocopy ff_archive_items.value%type,

1854: procedure get_balance_dates ( p_asg_action_id in pay_assignment_actions.assignment_action_id%type,
1855: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
1856: p_balance_name in pay_balance_types.balance_name%type,
1857: p_business_group_id in hr_organization_units.business_group_id%type,
1858: p_date_from out nocopy ff_archive_items.value%type,
1859: p_date_to out nocopy ff_archive_items.value%type,
1860: p_no_of_times out nocopy number )
1861: is
1862: c_def_balance_id pay_defined_balances.defined_balance_id%type;

Line 1859: p_date_to out nocopy ff_archive_items.value%type,

1855: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
1856: p_balance_name in pay_balance_types.balance_name%type,
1857: p_business_group_id in hr_organization_units.business_group_id%type,
1858: p_date_from out nocopy ff_archive_items.value%type,
1859: p_date_to out nocopy ff_archive_items.value%type,
1860: p_no_of_times out nocopy number )
1861: is
1862: c_def_balance_id pay_defined_balances.defined_balance_id%type;
1863: c_run_balance_status pay_balance_validation.run_balance_status%type ;

Line 4466: p_archive_value in ff_archive_items.value%type )

4462: ---------------------------------------------------------------------------
4463: procedure archive_item
4464: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4465: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4466: p_archive_value in ff_archive_items.value%type )
4467: is
4468: --
4469: v_user_entity_id ff_user_entities.user_entity_id%type;
4470: v_archive_item_id ff_archive_items.archive_item_id%type;

Line 4470: v_archive_item_id ff_archive_items.archive_item_id%type;

4466: p_archive_value in ff_archive_items.value%type )
4467: is
4468: --
4469: v_user_entity_id ff_user_entities.user_entity_id%type;
4470: v_archive_item_id ff_archive_items.archive_item_id%type;
4471: v_object_version_number ff_archive_items.object_version_number%type;
4472: v_some_warning boolean;
4473: ---------------------------------------------------------------------------
4474: -- Cursor User_Entity_ID

Line 4471: v_object_version_number ff_archive_items.object_version_number%type;

4467: is
4468: --
4469: v_user_entity_id ff_user_entities.user_entity_id%type;
4470: v_archive_item_id ff_archive_items.archive_item_id%type;
4471: v_object_version_number ff_archive_items.object_version_number%type;
4472: v_some_warning boolean;
4473: ---------------------------------------------------------------------------
4474: -- Cursor User_Entity_ID
4475: ---------------------------------------------------------------------------

Line 4517: p_archive_value in ff_archive_items.value%type,

4513: -----------------------------------------------------------------------------
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;

Line 4522: v_archive_item_id ff_archive_items.archive_item_id%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;
4523: v_object_version_number ff_archive_items.object_version_number%type;
4524: v_some_warning boolean;
4525: ---------------------------------------------------------------------------
4526: -- Cursor User_Entity_ID

Line 4523: v_object_version_number ff_archive_items.object_version_number%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;
4523: v_object_version_number ff_archive_items.object_version_number%type;
4524: v_some_warning boolean;
4525: ---------------------------------------------------------------------------
4526: -- Cursor User_Entity_ID
4527: ---------------------------------------------------------------------------

Line 4571: p_archive_value in ff_archive_items.value%type,

4567: -----------------------------------------------------------------------------
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: --

Line 4577: v_archive_item_id ff_archive_items.archive_item_id%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;
4578: v_object_version_number ff_archive_items.object_version_number%type;
4579: v_some_warning boolean;
4580: ---------------------------------------------------------------------------
4581: -- Cursor User_Entity_ID

Line 4578: v_object_version_number ff_archive_items.object_version_number%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;
4578: v_object_version_number ff_archive_items.object_version_number%type;
4579: v_some_warning boolean;
4580: ---------------------------------------------------------------------------
4581: -- Cursor User_Entity_ID
4582: ---------------------------------------------------------------------------