DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_BALANCE_PKG

Line 574: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', g_local_unit_id);

570: l_database_ptd_item_suffix := '_PER_LE_PTD';
571: elsif g_local_unit_id is not null then
572: l_database_ytd_item_suffix := '_PER_LU_YTD';
573: l_database_ptd_item_suffix := '_PER_LU_PTD';
574: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', g_local_unit_id);
575: end if;
576:
577: for i in benefit_person_period.first .. benefit_person_period.last
578: loop

Line 583: pay_balance_pkg.set_context (

579: for m in benefit_type_tab.first .. benefit_type_tab.last
580: loop
581: l_ytd_value := 0;
582: l_period_number := benefit_person_period (i).time_period.last;
583: pay_balance_pkg.set_context (
584: 'ASSIGNMENT_ACTION_ID',
585: benefit_person_period (i).time_period (l_period_number).assignment_action_id
586: );
587:

Line 606: -- pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID', p_assignment_action_id);

602: elsif benefit_type_tab (m) <> 'Lunch Benefit' then
603: for balance_rec in csr_balance (benefit_type_tab (m))
604: loop
605: begin
606: -- pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID', p_assignment_action_id);
607: l_ytd_value :=
608: l_ytd_value
609: + get_balance_value (
610: p_balance_name => balance_rec.balance_name,

Line 648: pay_balance_pkg.set_context (

644: elsif benefit_type_tab (m) not in ('Lunch Benefit', 'Car Benefit') then
645: for balance_rec in csr_balance (benefit_type_tab (m))
646: loop
647: begin
648: pay_balance_pkg.set_context (
649: 'ASSIGNMENT_ACTION_ID',
650: benefit_person_period (i).time_period (j).pay_period_end_date
651: );
652: l_monetary_value :=

Line 1411: pay_balance_pkg.set_context ('DATE_EARNED', fnd_date.date_to_canonical (g_year_last_date));

1407: close get_element_details;
1408: end if;
1409:
1410: /* Set the context for Date Earned as the Effective Date */
1411: pay_balance_pkg.set_context ('DATE_EARNED', fnd_date.date_to_canonical (g_year_last_date));
1412: --
1413: --
1414: /* Set the context forTAX_UNIT_ID as the Legal Employer Id */
1415: pay_balance_pkg.set_context ('TAX_UNIT_ID', g_legal_employer_id);

Line 1415: pay_balance_pkg.set_context ('TAX_UNIT_ID', g_legal_employer_id);

1411: pay_balance_pkg.set_context ('DATE_EARNED', fnd_date.date_to_canonical (g_year_last_date));
1412: --
1413: --
1414: /* Set the context forTAX_UNIT_ID as the Legal Employer Id */
1415: pay_balance_pkg.set_context ('TAX_UNIT_ID', g_legal_employer_id);
1416: pay_balance_pkg.set_context ('SOURCE_TEXT', null);
1417: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID', p_assignment_action_id);
1418: pay_balance_pkg.set_context ('ASSIGNMENT_ID', i.assignment_id);
1419:

Line 1416: pay_balance_pkg.set_context ('SOURCE_TEXT', null);

1412: --
1413: --
1414: /* Set the context forTAX_UNIT_ID as the Legal Employer Id */
1415: pay_balance_pkg.set_context ('TAX_UNIT_ID', g_legal_employer_id);
1416: pay_balance_pkg.set_context ('SOURCE_TEXT', null);
1417: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID', p_assignment_action_id);
1418: pay_balance_pkg.set_context ('ASSIGNMENT_ID', i.assignment_id);
1419:
1420: --

Line 1417: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID', p_assignment_action_id);

1413: --
1414: /* Set the context forTAX_UNIT_ID as the Legal Employer Id */
1415: pay_balance_pkg.set_context ('TAX_UNIT_ID', g_legal_employer_id);
1416: pay_balance_pkg.set_context ('SOURCE_TEXT', null);
1417: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID', p_assignment_action_id);
1418: pay_balance_pkg.set_context ('ASSIGNMENT_ID', i.assignment_id);
1419:
1420: --
1421: --

Line 1418: pay_balance_pkg.set_context ('ASSIGNMENT_ID', i.assignment_id);

1414: /* Set the context forTAX_UNIT_ID as the Legal Employer Id */
1415: pay_balance_pkg.set_context ('TAX_UNIT_ID', g_legal_employer_id);
1416: pay_balance_pkg.set_context ('SOURCE_TEXT', null);
1417: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID', p_assignment_action_id);
1418: pay_balance_pkg.set_context ('ASSIGNMENT_ID', i.assignment_id);
1419:
1420: --
1421: --
1422:

Line 1428: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', g_local_unit_id);

1424: if g_local_unit_id is null then
1425: l_database_item_suffix := '_PER_LE_YTD';
1426: elsif g_local_unit_id is not null then
1427: l_database_item_suffix := '_PER_LU_YTD';
1428: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', g_local_unit_id);
1429: end if;
1430:
1431: /* Get the value for balnace Actual Tax Days */
1432: l_actual_tax_days := get_balance_value (

Line 1528: pay_balance_pkg.set_context ('DATE_EARNED', g_pay_period_end_date);

1524: close csr_payroll_archived;
1525:
1526: if l_payroll_archived_flag = 'N' then
1527: /* Set the context for Date Earned as the Effective Date */
1528: pay_balance_pkg.set_context ('DATE_EARNED', g_pay_period_end_date);
1529: --
1530: --
1531: l_database_item_suffix := null;
1532:

Line 1537: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', g_local_unit_id);

1533: if g_local_unit_id is null then
1534: l_database_item_suffix := '_PER_LE_PTD';
1535: elsif g_local_unit_id is not null then
1536: l_database_item_suffix := '_PER_LU_PTD';
1537: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', g_local_unit_id);
1538: end if;
1539:
1540: l_salary_income := get_balance_value (
1541: p_balance_name => 'Salary Income',

Line 1831: return (pay_balance_pkg.get_value (

1827: --
1828: /* Get the Balance value and return it */
1829: --
1830: --
1831: return (pay_balance_pkg.get_value (
1832: p_defined_balance_id => l_get_defined_balance_id,
1833: p_assignment_id => p_assignment_id,
1834: p_virtual_date => p_bal_date --g_effective_date
1835: )