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_AU_FOREIGN_WORKERS dependencies on PAY_BALANCE_PKG

Line 665: defined_balance_id for use in pay_balance_pkg call

661: Name : get_defined_balances
662: Type : Procedure
663: Access : Public
664: Description : This procedure returns a Balance pl/sql table of the
665: defined_balance_id for use in pay_balance_pkg call
666: Inputs : p_balances_tab - List of Balance names
667: p_dimension_name - Dimension name
668: Outputs : p_def_bal_tab - Defined Balance ID Pl/sql table
669:

Line 675: ,p_def_bal_tab OUT NOCOPY pay_balance_pkg.t_balance_value_tab

671:
672:
673: PROCEDURE get_defined_balances(p_balances_tab IN pay_au_foreign_workers.tab_bal_type
674: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
675: ,p_def_bal_tab OUT NOCOPY pay_balance_pkg.t_balance_value_tab
676: )
677: IS
678:
679: CURSOR csr_get_def_bal

Line 695: l_def_bal_tab pay_balance_pkg.t_balance_value_tab;

691:
692: l_proc_name VARCHAR2(100);
693: l_def_bal_id NUMBER;
694:
695: l_def_bal_tab pay_balance_pkg.t_balance_value_tab;
696:
697: l_no_def_bal EXCEPTION;
698:
699: BEGIN

Line 981: Outputs : Complex Data Type - pay_balance_pkg.t_detailed_bal_out_tab

977: p_fw_type - Foreign Worker Type, Valid Values are,
978: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F
979: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J
980: p_balances_tab - PL/SQL table of Balances for which prorated values should be fetched
981: Outputs : Complex Data Type - pay_balance_pkg.t_detailed_bal_out_tab
982: contains Balance Values
983:
984: */
985:

Line 993: ,p_output_table OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab)

989: ,p_start_date IN DATE
990: ,p_end_date IN DATE
991: ,p_fw_type IN VARCHAR2
992: ,p_balances_tab IN pay_au_foreign_workers.tab_bal_type
993: ,p_output_table OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab)
994: IS
995:
996: TYPE prorate_dat IS RECORD
997: (

Line 1085: l_output_tab pay_balance_pkg.t_detailed_bal_out_tab;

1081: AND paa.action_status = 'C'
1082: AND paa.tax_unit_id = c_tax_unit_id;
1083:
1084:
1085: l_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
1086: l_return_tab pay_balance_pkg.t_detailed_bal_out_tab;
1087: l_contexts_tab pay_balance_pkg.t_context_tab;
1088:
1089: l_proc_name VARCHAR2(100);

Line 1086: l_return_tab pay_balance_pkg.t_detailed_bal_out_tab;

1082: AND paa.tax_unit_id = c_tax_unit_id;
1083:
1084:
1085: l_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
1086: l_return_tab pay_balance_pkg.t_detailed_bal_out_tab;
1087: l_contexts_tab pay_balance_pkg.t_context_tab;
1088:
1089: l_proc_name VARCHAR2(100);
1090: l_prorate_tab prorate_tab;

Line 1087: l_contexts_tab pay_balance_pkg.t_context_tab;

1083:
1084:
1085: l_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
1086: l_return_tab pay_balance_pkg.t_detailed_bal_out_tab;
1087: l_contexts_tab pay_balance_pkg.t_context_tab;
1088:
1089: l_proc_name VARCHAR2(100);
1090: l_prorate_tab prorate_tab;
1091:

Line 1102: l_run_balance_tab pay_balance_pkg.t_balance_value_tab;

1098: l_run_dimension VARCHAR2(20) := '_ASG_LE_RUN';
1099: l_ptd_dimension VARCHAR2(20) := '_ASG_LE_PTD';
1100: l_ytd_dimension VARCHAR2(20) := '_ASG_LE_YTD';
1101:
1102: l_run_balance_tab pay_balance_pkg.t_balance_value_tab;
1103: l_ptd_balance_tab pay_balance_pkg.t_balance_value_tab;
1104: l_ytd_balance_tab pay_balance_pkg.t_balance_value_tab;
1105:
1106: l_fw_days_index NUMBER;

Line 1103: l_ptd_balance_tab pay_balance_pkg.t_balance_value_tab;

1099: l_ptd_dimension VARCHAR2(20) := '_ASG_LE_PTD';
1100: l_ytd_dimension VARCHAR2(20) := '_ASG_LE_YTD';
1101:
1102: l_run_balance_tab pay_balance_pkg.t_balance_value_tab;
1103: l_ptd_balance_tab pay_balance_pkg.t_balance_value_tab;
1104: l_ytd_balance_tab pay_balance_pkg.t_balance_value_tab;
1105:
1106: l_fw_days_index NUMBER;
1107:

Line 1104: l_ytd_balance_tab pay_balance_pkg.t_balance_value_tab;

1100: l_ytd_dimension VARCHAR2(20) := '_ASG_LE_YTD';
1101:
1102: l_run_balance_tab pay_balance_pkg.t_balance_value_tab;
1103: l_ptd_balance_tab pay_balance_pkg.t_balance_value_tab;
1104: l_ytd_balance_tab pay_balance_pkg.t_balance_value_tab;
1105:
1106: l_fw_days_index NUMBER;
1107:
1108: l_le_fw_days NUMBER;

Line 1143: /* Call pay_balance_pkg */

1139: get_defined_balances(p_balances_tab
1140: ,l_ytd_dimension
1141: ,l_ytd_balance_tab);
1142:
1143: /* Call pay_balance_pkg */
1144: l_output_tab.DELETE;
1145: l_return_tab.DELETE;
1146: l_contexts_tab(1).tax_unit_id := p_tax_unit_id ;
1147:

Line 1155: pay_balance_pkg.get_value

1151: ,p_end_date);
1152: FETCH csr_ytd_max_action_id INTO l_max_ass_act_id;
1153: CLOSE csr_ytd_max_action_id;
1154:
1155: pay_balance_pkg.get_value
1156: (p_assignment_action_id => l_max_ass_act_id
1157: ,p_defined_balance_lst => l_ytd_balance_tab
1158: ,p_context_lst => l_contexts_tab
1159: ,p_output_table => l_return_tab);

Line 1286: pay_balance_pkg.get_value

1282:
1283: l_return_tab.DELETE;
1284: l_contexts_tab(1).tax_unit_id := p_tax_unit_id ;
1285:
1286: pay_balance_pkg.get_value
1287: (p_assignment_action_id => l_max_ass_act_id
1288: ,p_defined_balance_lst => l_ptd_balance_tab
1289: ,p_context_lst => l_contexts_tab
1290: ,p_output_table => l_return_tab);