92: contract_number,
93: contract_number || ' - ' || contract_number_modifier)
94: contract_number_print -- used to form the
95: -- comments in the PO Header
96: -- ,po_headers_s.NEXTVAL po_header_id
97: FROM okc_k_headers_b
98: WHERE id = b_chr_id;
99:
100:
1285: my_debug('1040: Batch id = ' || p_batch_id, 2);
1286:
1287: -- Select the PO Header id so that it can be populated in related
1288: -- objects and can be logged
1289: SELECT po_headers_s.nextval
1290: INTO l_po_header_id
1291: FROM dual;
1292:
1293: my_debug('1060: po_header_id : ' || l_po_header_id,2);