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_national_identifier per_all_people_f.national_identifier%type;
23: g_legal_entity_name hr_organization_information.org_information1%type;

Line 381: from ff_archive_items fai,

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

Line 387: l_value ff_archive_items.value%type;

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

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

Line 1070: v_archive_item_id ff_archive_items.archive_item_id%type;

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

Line 1071: v_object_version_number ff_archive_items.object_version_number%type;

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

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

1073: --------------------------------------------------------------------------------------
1074: --Bug#3933332 Moved the records from package header as these pl/sql table is
1075: -- specific to procedure archive_balances()
1076: --------------------------------------------------------------------------------------
1077: type t_archive_items_tab is table of ff_archive_items.archive_item_id%TYPE index by binary_integer;
1078: t_archive_items t_archive_items_tab;
1079: --
1080: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
1081: t_archive_value t_archive_value_tab;

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

1076: --------------------------------------------------------------------------------------
1077: type t_archive_items_tab is table of ff_archive_items.archive_item_id%TYPE index by binary_integer;
1078: t_archive_items t_archive_items_tab;
1079: --
1080: type t_archive_value_tab is table of ff_archive_items.value%TYPE index by binary_integer;
1081: t_archive_value t_archive_value_tab;
1082: --
1083: type t_date_earned_tab is table of varchar2(30) index by binary_integer;
1084: t_date_earned t_date_earned_tab;

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

1590: l_pmon_counter := false;
1591: end if;
1592: end loop;
1593: ------------------------------------------------------------------------------------------------
1594: -- Bug: 3260855 Bulk Insert into ff_archive_items for month balances
1595: ------------------------------------------------------------------------------------------------
1596: select context_id
1597: into l_asac_cont_id
1598: from ff_contexts

Line 1612: insert into ff_archive_items

1608: from ff_contexts
1609: where context_name = 'DATE_EARNED' ;
1610: --
1611: forall counter in 1..t_user_entity_id.count
1612: insert into ff_archive_items
1613: ( archive_item_id,
1614: user_entity_id,
1615: context1,
1616: value,

Line 1619: ( ff_archive_items_s.nextval,

1615: context1,
1616: value,
1617: archive_type )
1618: values
1619: ( ff_archive_items_s.nextval,
1620: t_user_entity_id(counter),
1621: p_assignment_action_id,
1622: t_archive_value(counter),
1623: 'AAP' )

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

1689: end loop;
1690: --
1691: end if;
1692: ------------------------------------------------------------------------------------------------
1693: -- Bug: 3260855 - Bulk Insert into ff_archive_items for ytd balances
1694: ------------------------------------------------------------------------------------------------
1695: forall counter in 1..t_user_entity_id.count
1696: insert into ff_archive_items
1697: ( archive_item_id,

Line 1696: insert into ff_archive_items

1692: ------------------------------------------------------------------------------------------------
1693: -- Bug: 3260855 - Bulk Insert into ff_archive_items for ytd balances
1694: ------------------------------------------------------------------------------------------------
1695: forall counter in 1..t_user_entity_id.count
1696: insert into ff_archive_items
1697: ( archive_item_id,
1698: user_entity_id,
1699: context1,
1700: value,

Line 1703: ( ff_archive_items_s.nextval,

1699: context1,
1700: value,
1701: archive_type )
1702: values
1703: ( ff_archive_items_s.nextval,
1704: t_user_entity_id(counter),
1705: p_assignment_action_id,
1706: t_archive_value(counter),
1707: 'AAP' )

Line 1762: v_date_from ff_archive_items.value%type;

1758: p_run_ass_action_id in pay_assignment_actions.assignment_action_id%type,
1759: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type )
1760: is
1761: --
1762: v_date_from ff_archive_items.value%type;
1763: v_date_to ff_archive_items.value%type;
1764: v_no_of_times number;
1765: v_date_from_old ff_archive_items.value%type;
1766: v_date_to_old ff_archive_items.value%type;

Line 1763: v_date_to ff_archive_items.value%type;

1759: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type )
1760: is
1761: --
1762: v_date_from ff_archive_items.value%type;
1763: v_date_to ff_archive_items.value%type;
1764: v_no_of_times number;
1765: v_date_from_old ff_archive_items.value%type;
1766: v_date_to_old ff_archive_items.value%type;
1767: v_no_of_times_old number;

Line 1765: v_date_from_old ff_archive_items.value%type;

1761: --
1762: v_date_from ff_archive_items.value%type;
1763: v_date_to ff_archive_items.value%type;
1764: v_no_of_times number;
1765: v_date_from_old ff_archive_items.value%type;
1766: v_date_to_old ff_archive_items.value%type;
1767: v_no_of_times_old number;
1768: v_no_of_times_411 number;
1769: v_no_of_times_413 number;

Line 1766: v_date_to_old ff_archive_items.value%type;

1762: v_date_from ff_archive_items.value%type;
1763: v_date_to ff_archive_items.value%type;
1764: v_no_of_times number;
1765: v_date_from_old ff_archive_items.value%type;
1766: v_date_to_old ff_archive_items.value%type;
1767: v_no_of_times_old number;
1768: v_no_of_times_411 number;
1769: v_no_of_times_413 number;
1770: v_265_indicator varchar2(1);

Line 1771: v_moa_410_date ff_archive_items.value%type;

1767: v_no_of_times_old number;
1768: v_no_of_times_411 number;
1769: v_no_of_times_413 number;
1770: v_265_indicator varchar2(1);
1771: v_moa_410_date ff_archive_items.value%type;
1772: v_moa_411_date ff_archive_items.value%type;
1773: v_moa_413_date ff_archive_items.value%type;
1774: l_terminated varchar2(1);
1775: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;

Line 1772: v_moa_411_date ff_archive_items.value%type;

1768: v_no_of_times_411 number;
1769: v_no_of_times_413 number;
1770: v_265_indicator varchar2(1);
1771: v_moa_410_date ff_archive_items.value%type;
1772: v_moa_411_date ff_archive_items.value%type;
1773: v_moa_413_date ff_archive_items.value%type;
1774: l_terminated varchar2(1);
1775: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;
1776: l_new_ass_id per_all_assignments_f.assignment_id%TYPE;

Line 1773: v_moa_413_date ff_archive_items.value%type;

1769: v_no_of_times_413 number;
1770: v_265_indicator varchar2(1);
1771: v_moa_410_date ff_archive_items.value%type;
1772: v_moa_411_date ff_archive_items.value%type;
1773: v_moa_413_date ff_archive_items.value%type;
1774: l_terminated varchar2(1);
1775: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;
1776: l_new_ass_id per_all_assignments_f.assignment_id%TYPE;
1777: l_run_ass_action_id pay_assignment_actions.assignment_action_id%TYPE;

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

1843: procedure get_balance_dates ( p_asg_action_id in pay_assignment_actions.assignment_action_id%type,
1844: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
1845: p_balance_name in pay_balance_types.balance_name%type,
1846: p_business_group_id in hr_organization_units.business_group_id%type,
1847: p_date_from out nocopy ff_archive_items.value%type,
1848: p_date_to out nocopy ff_archive_items.value%type,
1849: p_no_of_times out nocopy number )
1850: is
1851: c_def_balance_id pay_defined_balances.defined_balance_id%type;

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

1844: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
1845: p_balance_name in pay_balance_types.balance_name%type,
1846: p_business_group_id in hr_organization_units.business_group_id%type,
1847: p_date_from out nocopy ff_archive_items.value%type,
1848: p_date_to out nocopy ff_archive_items.value%type,
1849: p_no_of_times out nocopy number )
1850: is
1851: c_def_balance_id pay_defined_balances.defined_balance_id%type;
1852: c_run_balance_status pay_balance_validation.run_balance_status%type ;

Line 4206: p_archive_value in ff_archive_items.value%type )

4202: ---------------------------------------------------------------------------
4203: procedure archive_item
4204: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4205: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4206: p_archive_value in ff_archive_items.value%type )
4207: is
4208: --
4209: v_user_entity_id ff_user_entities.user_entity_id%type;
4210: v_archive_item_id ff_archive_items.archive_item_id%type;

Line 4210: v_archive_item_id ff_archive_items.archive_item_id%type;

4206: p_archive_value in ff_archive_items.value%type )
4207: is
4208: --
4209: v_user_entity_id ff_user_entities.user_entity_id%type;
4210: v_archive_item_id ff_archive_items.archive_item_id%type;
4211: v_object_version_number ff_archive_items.object_version_number%type;
4212: v_some_warning boolean;
4213: ---------------------------------------------------------------------------
4214: -- Cursor User_Entity_ID

Line 4211: v_object_version_number ff_archive_items.object_version_number%type;

4207: is
4208: --
4209: v_user_entity_id ff_user_entities.user_entity_id%type;
4210: v_archive_item_id ff_archive_items.archive_item_id%type;
4211: v_object_version_number ff_archive_items.object_version_number%type;
4212: v_some_warning boolean;
4213: ---------------------------------------------------------------------------
4214: -- Cursor User_Entity_ID
4215: ---------------------------------------------------------------------------

Line 4257: p_archive_value in ff_archive_items.value%type,

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

Line 4262: v_archive_item_id ff_archive_items.archive_item_id%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;
4263: v_object_version_number ff_archive_items.object_version_number%type;
4264: v_some_warning boolean;
4265: ---------------------------------------------------------------------------
4266: -- Cursor User_Entity_ID

Line 4263: v_object_version_number ff_archive_items.object_version_number%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;
4263: v_object_version_number ff_archive_items.object_version_number%type;
4264: v_some_warning boolean;
4265: ---------------------------------------------------------------------------
4266: -- Cursor User_Entity_ID
4267: ---------------------------------------------------------------------------

Line 4311: p_archive_value in ff_archive_items.value%type,

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

Line 4317: v_archive_item_id ff_archive_items.archive_item_id%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;
4318: v_object_version_number ff_archive_items.object_version_number%type;
4319: v_some_warning boolean;
4320: ---------------------------------------------------------------------------
4321: -- Cursor User_Entity_ID

Line 4318: v_object_version_number ff_archive_items.object_version_number%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;
4318: v_object_version_number ff_archive_items.object_version_number%type;
4319: v_some_warning boolean;
4320: ---------------------------------------------------------------------------
4321: -- Cursor User_Entity_ID
4322: ---------------------------------------------------------------------------