APPS.PAY_BATCH_BALANCE_ADJ_PKG dependencies on PAY_BALANCE_BATCH_HEADERS

Line 30: l_batch_status pay_balance_batch_headers.batch_status%TYPE := null;

26: ) return number is
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: --

Line 106: from pay_balance_batch_headers

102: from pay_adjust_batch_groups pabg
103: where pabg.batch_id = p_batch_id
104: union
105: select batch_status status
106: from pay_balance_batch_headers
107: where batch_id = p_batch_id
108: union
109: select 'Y' status
110: from pay_balance_batch_headers bth

Line 110: from pay_balance_batch_headers bth

106: from pay_balance_batch_headers
107: where batch_id = p_batch_id
108: union
109: select 'Y' status
110: from pay_balance_batch_headers bth
111: where bth.batch_id = p_batch_id
112: and bth.batch_status = 'T'
113: order by 1 desc;
114: --

Line 404: from pay_balance_batch_headers

400: -- Delete the batch header
401: --
402:
403: delete
404: from pay_balance_batch_headers
405: where batch_id = p_batch_id;
406:
407: end if;
408:

Line 634: p_batch_name pay_balance_batch_headers.batch_name%type;

630: l_message_text_tbl varchar240_table;
631: l_count binary_integer := 0;
632: l_error_text pay_message_lines.line_text%type;
633: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
634: p_batch_name pay_balance_batch_headers.batch_name%type;
635:
636: --
637:
638: --

Line 665: update pay_balance_batch_headers

661: and batch_id = p_batch_id;
662: --
663: begin
664:
665: update pay_balance_batch_headers
666: set batch_status = 'P'
667: where batch_id = p_batch_id;
668:
669: select batch_name into p_batch_name

Line 670: from pay_balance_batch_headers

666: set batch_status = 'P'
667: where batch_id = p_batch_id;
668:
669: select batch_name into p_batch_name
670: from pay_balance_batch_headers
671: where batch_id = p_batch_id;
672:
673: commit;
674:

Line 1035: update pay_balance_batch_headers

1031: fetch batch_grp_stts into status_E;
1032: close batch_grp_stts;
1033:
1034: if (status_T = 1) then
1035: update pay_balance_batch_headers
1036: set batch_status = 'T'
1037: where batch_id = p_batch_id;
1038: elsif ((status_T = 0) and (status_E = 1)) then
1039: update pay_balance_batch_headers

Line 1039: update pay_balance_batch_headers

1035: update pay_balance_batch_headers
1036: set batch_status = 'T'
1037: where batch_id = p_batch_id;
1038: elsif ((status_T = 0) and (status_E = 1)) then
1039: update pay_balance_batch_headers
1040: set batch_status = 'E'
1041: where batch_id = p_batch_id;
1042: elsif ((status_T = 0) and (status_E = 0)) then
1043: update pay_balance_batch_headers

Line 1043: update pay_balance_batch_headers

1039: update pay_balance_batch_headers
1040: set batch_status = 'E'
1041: where batch_id = p_batch_id;
1042: elsif ((status_T = 0) and (status_E = 0)) then
1043: update pay_balance_batch_headers
1044: set batch_status = 'V'
1045: where batch_id = p_batch_id;
1046: end if;
1047: end validate_and_transfer; -- end of procedure

Line 1110: l_batch_status pay_balance_batch_headers.batch_status%type;

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: --
1114: hr_utility.set_location('Entering ' || l_proc, 10);