APPS.PO_CORE_S3 dependencies on PO_HEADERS_ALL

Line 213: l_umb_prog_id PO_HEADERS_ALL.UMBRELLA_PROGRAM_ID%TYPE;

209: IS
210: --
211: -- This function would return Umbrella Program id for the document header id passed.
212: --
213: l_umb_prog_id PO_HEADERS_ALL.UMBRELLA_PROGRAM_ID%TYPE;
214: l_progress VARCHAR2(3) := NULL;
215: BEGIN
216:
217: SELECT umbrella_program_id

Line 219: FROM po_headers_all pha

215: BEGIN
216:
217: SELECT umbrella_program_id
218: INTO l_umb_prog_id
219: FROM po_headers_all pha
220: WHERE pha.po_header_id = p_doc_header_id;
221:
222: l_progress := '010';
223:

Line 298: PROCEDURE generate_update_payment_seq (p_po_header_id IN PO_HEADERS_ALL.PO_HEADER_ID%TYPE,

294: END ADD_PERIOD;
295: --
296:
297: -- Paymnet Instruction
298: PROCEDURE generate_update_payment_seq (p_po_header_id IN PO_HEADERS_ALL.PO_HEADER_ID%TYPE,
299: p_line_id IN NUMBER DEFAULT NULL,
300: p_payment_instr_code IN PO_HEADERS_ALL.CLM_PAYMENT_INSTR_CODE%TYPE)
301: IS
302: l_key number;

Line 300: p_payment_instr_code IN PO_HEADERS_ALL.CLM_PAYMENT_INSTR_CODE%TYPE)

296:
297: -- Paymnet Instruction
298: PROCEDURE generate_update_payment_seq (p_po_header_id IN PO_HEADERS_ALL.PO_HEADER_ID%TYPE,
299: p_line_id IN NUMBER DEFAULT NULL,
300: p_payment_instr_code IN PO_HEADERS_ALL.CLM_PAYMENT_INSTR_CODE%TYPE)
301: IS
302: l_key number;
303: BEGIN
304: -- pick a new key for temp table

Line 472: PROCEDURE generate_payment_sequence (p_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE)

468:
469: END generate_update_payment_seq;
470:
471:
472: PROCEDURE generate_payment_sequence (p_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE)
473: IS
474: l_payment_instr_code PO_HEADERS_ALL.CLM_PAYMENT_INSTR_CODE%TYPE;
475: l_payment_instr_code_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
476: l_po_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 474: l_payment_instr_code PO_HEADERS_ALL.CLM_PAYMENT_INSTR_CODE%TYPE;

470:
471:
472: PROCEDURE generate_payment_sequence (p_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE)
473: IS
474: l_payment_instr_code PO_HEADERS_ALL.CLM_PAYMENT_INSTR_CODE%TYPE;
475: l_payment_instr_code_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
476: l_po_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
477: honour_at_line_level BOOLEAN;
478: l_org_id NUMBER;

Line 484: FROM po_headers_all

480: BEGIN
481: honour_at_line_level := FALSE;
482: SELECT clm_payment_instr_code, org_id
483: INTO l_payment_instr_code, l_org_id
484: FROM po_headers_all
485: WHERE po_header_id = p_po_header_id;
486: --Get FV install
487: IF fv_install.enabled(l_org_id) THEN
488: fv_enabled_flag :='Y';