DBA Data[Home] [Help]

APPS.PAY_BATCH_BALANCE_ADJ_PKG dependencies on PAY_BATCH_BALANCE_ADJ_PKG

Line 1: PACKAGE BODY PAY_BATCH_BALANCE_ADJ_PKG AS

1: PACKAGE BODY PAY_BATCH_BALANCE_ADJ_PKG AS
2: /* $Header: pybbautl.pkb 120.9 2006/05/26 11:17:28 jabubaka noship $ */
3:
4: g_package constant varchar2(33) := ' PAY_BATCH_BALANCE_ADJ_PKG.';
5:

Line 4: g_package constant varchar2(33) := ' PAY_BATCH_BALANCE_ADJ_PKG.';

1: PACKAGE BODY PAY_BATCH_BALANCE_ADJ_PKG AS
2: /* $Header: pybbautl.pkb 120.9 2006/05/26 11:17:28 jabubaka noship $ */
3:
4: g_package constant varchar2(33) := ' PAY_BATCH_BALANCE_ADJ_PKG.';
5:
6: type varchar240_table is table of varchar2(240)
7: index by binary_integer;
8: --

Line 31: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.SUBMIT_CONC_REQUEST';

27: --
28: l_request_id number := 0;
29: l_pac_id pay_payroll_actions.payroll_action_id%TYPE;
30: l_batch_status pay_balance_batch_headers.batch_status%TYPE := null;
31: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.SUBMIT_CONC_REQUEST';
32: --
33: begin
34: --
35: hr_utility.set_location('Entering ' || l_proc, 5);

Line 97: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.BATCH_OVERALL_STATUS';

93: unprocessed_groups_exist boolean := FALSE;
94: transferred_groups_exist boolean := FALSE;
95: header_transferred boolean := FALSE;
96: header_processing boolean := FALSE;
97: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.BATCH_OVERALL_STATUS';
98: --
99: cursor csr_status is
100: select pay_batch_balance_adj_pkg.batch_group_overall_status
101: (pabg.batch_id, pabg.batch_group_id) status

Line 100: select pay_batch_balance_adj_pkg.batch_group_overall_status

96: header_processing boolean := FALSE;
97: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.BATCH_OVERALL_STATUS';
98: --
99: cursor csr_status is
100: select pay_batch_balance_adj_pkg.batch_group_overall_status
101: (pabg.batch_id, pabg.batch_group_id) status
102: from pay_adjust_batch_groups pabg
103: where pabg.batch_id = p_batch_id
104: union

Line 204: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.BATCH_GROUP_OVERALL_STATUS';

200: ( p_batch_id in number,
201: p_batch_group_id in number )
202: return varchar2 is
203: --
204: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.BATCH_GROUP_OVERALL_STATUS';
205: --
206: valid_lines_exist boolean := FALSE;
207: error_lines_exist boolean := FALSE;
208: unprocessed_lines_exist boolean := FALSE;

Line 317: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.PURGE';

313: ( p_batch_id in number,
314: p_batch_group_id in number)
315: is
316: --
317: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.PURGE';
318: --
319: cursor csr_batch_lines is
320: select pabl.batch_line_id
321: from pay_adjust_batch_lines pabl

Line 429: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.CHECK_OPERATION_ALLOWED';

425: ( p_batch_status in varchar2 ,
426: p_process_mode in varchar2 )
427: return boolean is
428: --
429: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.CHECK_OPERATION_ALLOWED';
430: --
431: begin
432: --
433: hr_utility.set_location('Entering: '||l_proc, 5);

Line 462: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.ROLLBACK_BATCH';

458: p_batch_group_id in number )
459: is
460: --
461: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
462: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.ROLLBACK_BATCH';
463:
464: l_message_source_id_tbl hr_entry.number_table;
465: l_message_source_type_tbl hr_entry.varchar2_table;
466: l_message_level_tbl hr_entry.varchar2_table;

Line 1109: l_proc varchar2(72) := 'pay_batch_balance_adj_pkg.run_process';

1105: p_batch_id in number,
1106: p_batch_group_id in number
1107: ) is
1108: --
1109: l_proc varchar2(72) := 'pay_batch_balance_adj_pkg.run_process';
1110: l_batch_status pay_balance_batch_headers.batch_status%type;
1111: --
1112: begin
1113: --

Line 1136: pay_batch_balance_adj_pkg.rollback_batch

1132: if p_batch_operation = 'ROLLBACK' then
1133:
1134: hr_utility.set_location(l_proc,30);
1135:
1136: pay_batch_balance_adj_pkg.rollback_batch
1137: ( p_batch_id => p_batch_id,
1138: p_batch_group_id => p_batch_group_id );
1139: hr_utility.set_location(l_proc,40);
1140:

Line 1145: pay_batch_balance_adj_pkg.purge

1141: elsif p_batch_operation = 'PURGE' then
1142:
1143: hr_utility.set_location(l_proc,50);
1144:
1145: pay_batch_balance_adj_pkg.purge
1146: ( p_batch_id => p_batch_id,
1147: p_batch_group_id => p_batch_group_id );
1148:
1149: hr_utility.set_location(l_proc,60);

Line 1155: pay_batch_balance_adj_pkg.validate_batch

1151: elsif p_batch_operation = 'VALIDATE' then
1152:
1153: hr_utility.set_location(l_proc,70);
1154:
1155: pay_batch_balance_adj_pkg.validate_batch
1156: ( p_batch_id => p_batch_id,
1157: p_batch_group_id => p_batch_group_id );
1158: hr_utility.set_location(l_proc,80);
1159:

Line 1164: pay_batch_balance_adj_pkg.transfer_batch

1160: elsif p_batch_operation = 'TRANSFER' then
1161:
1162: hr_utility.set_location(l_proc,90);
1163:
1164: pay_batch_balance_adj_pkg.transfer_batch
1165: ( p_batch_id => p_batch_id,
1166: p_batch_group_id => p_batch_group_id );
1167: hr_utility.set_location(l_proc,100);
1168: end if;

Line 1187: END PAY_BATCH_BALANCE_ADJ_PKG;

1183: raise;
1184: --
1185: end run_process;
1186: --
1187: END PAY_BATCH_BALANCE_ADJ_PKG;