DBA Data[Home] [Help]

APPS.PAY_MAGTAPE_EXTRACT dependencies on PAY_BALANCE_PKG

Line 213: pay_balance_pkg.set_context ('JURISDICTION_CODE',jurisdiction_code);

209: INTO jurisdiction_code
210: FROM pay_state_rules sr
211: WHERE sr.state_code = l_state;
212: --
213: pay_balance_pkg.set_context ('JURISDICTION_CODE',jurisdiction_code);
214: END IF;
215: --
216: hr_utility.set_location ('arch_initialise',6);
217: --------------------------------------------------------------------------------

Line 758: pay_balance_pkg.set_context ('TAX_UNIT_ID',employer_row.tax_unit_id);

754: --
755: --------------------------------------------------------------------------------
756: -- Set contexts
757: --------------------------------------------------------------------------------
758: pay_balance_pkg.set_context ('TAX_UNIT_ID',employer_row.tax_unit_id);
759: --
760: hr_utility.set_location ('arch_employer_loop',12);
761: --------------------------------------------------------------------------------
762: -- Loop through employer db items

Line 770: result := pay_balance_pkg.run_db_item (l_employer_dbis.item_name(i),

766: --
767: --------------------------------------------------------------------------------
768: -- Execute user exit
769: --------------------------------------------------------------------------------
770: result := pay_balance_pkg.run_db_item (l_employer_dbis.item_name(i),
771: l_business_group_id,
772: l_legislation_code);
773: --
774: --------------------------------------------------------------------------------

Line 851: pay_balance_pkg.set_context ('ASSIGNMENT_ID',employee_row.assignment_id);

847: --
848: --------------------------------------------------------------------------------
849: -- Setup contexts
850: --------------------------------------------------------------------------------
851: pay_balance_pkg.set_context ('ASSIGNMENT_ID',employee_row.assignment_id);
852: pay_balance_pkg.set_context ('DATE_EARNED',
853: fnd_date.date_to_canonical(employee_row.date_earned));
854: pay_balance_pkg.set_context ('TAX_UNIT_ID',employee_row.tax_unit_id);
855: --

Line 852: pay_balance_pkg.set_context ('DATE_EARNED',

848: --------------------------------------------------------------------------------
849: -- Setup contexts
850: --------------------------------------------------------------------------------
851: pay_balance_pkg.set_context ('ASSIGNMENT_ID',employee_row.assignment_id);
852: pay_balance_pkg.set_context ('DATE_EARNED',
853: fnd_date.date_to_canonical(employee_row.date_earned));
854: pay_balance_pkg.set_context ('TAX_UNIT_ID',employee_row.tax_unit_id);
855: --
856: IF l_effective_date > employee_row.date_earned THEN

Line 854: pay_balance_pkg.set_context ('TAX_UNIT_ID',employee_row.tax_unit_id);

850: --------------------------------------------------------------------------------
851: pay_balance_pkg.set_context ('ASSIGNMENT_ID',employee_row.assignment_id);
852: pay_balance_pkg.set_context ('DATE_EARNED',
853: fnd_date.date_to_canonical(employee_row.date_earned));
854: pay_balance_pkg.set_context ('TAX_UNIT_ID',employee_row.tax_unit_id);
855: --
856: IF l_effective_date > employee_row.date_earned THEN
857: SELECT MAX(assignment_action_id)
858: INTO aaid

Line 863: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',aaid);

859: FROM pay_assignment_actions
860: WHERE tax_unit_id = employee_row.tax_unit_id AND
861: assignment_id = employee_row.assignment_id;
862: --
863: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',aaid);
864: ELSE
865: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',
866: employee_row.assignment_action_id);
867: END IF;

Line 865: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',

861: assignment_id = employee_row.assignment_id;
862: --
863: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',aaid);
864: ELSE
865: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',
866: employee_row.assignment_action_id);
867: END IF;
868: --
869: hr_utility.set_location ('arch_employee_loop',12);

Line 877: result := pay_balance_pkg.get_value (l_balance_dbis.balance_id(i),

873: FOR i IN 1..l_balance_dbis.sz LOOP
874: --
875: hr_utility.set_location ('arch_employee_loop',121);
876: --
877: result := pay_balance_pkg.get_value (l_balance_dbis.balance_id(i),
878: employee_row.assignment_action_id);
879: --
880: hr_utility.trace ('** Balance Loop ** ' ||
881: l_balance_dbis.item_name(i) || ' = ' || result);

Line 902: result := pay_balance_pkg.run_db_item (l_assignment_dbis.item_name(i),

898: --
899: --------------------------------------------------------------------------------
900: -- Execute user exit
901: --------------------------------------------------------------------------------
902: result := pay_balance_pkg.run_db_item (l_assignment_dbis.item_name(i),
903: l_business_group_id,
904: l_legislation_code);
905: --
906: --------------------------------------------------------------------------------