APPS.PO_AUTO_HEADER_PROCESS_PVT dependencies on PO_HEADERS_INTERFACE

Line 349: FROM po_headers_interface

345: /* bug 12987412 new award is created ,
346: initially default clm_contract_officer to null*/
347: x_headers.umbrella_program_id, --umbrella program
348: x_headers.fon_ref_id --umbrella program
349: FROM po_headers_interface
350: WHERE interface_header_id = p_interface_header_id
351: ORDER BY interface_header_id;
352:
353: ELSIF po_autocreate_params.g_mode = 'ADD' THEN

Line 640: po_headers_interface PHI

636: x_headers.clm_contract_officer, --bug 12987412
637: x_headers.umbrella_program_id, --umbrella program
638: x_headers.fon_ref_id --umbrella program
639: FROM po_headers_all PH,
640: po_headers_interface PHI
641: WHERE PH.SEGMENT1 = REPLACE(PHI.DOCUMENT_NUM,'-')
642: AND PHI.interface_header_id = p_interface_header_id;
643:
644: END IF ;

Line 701: l_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;

697: -- Derive rate info
698: l_req_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
699: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
700: l_display_rate NUMBER;
701: l_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
702: /* bug 12987412 variables declared to get the employee_id using
703: po_employees_sv.get_employee
704: */
705: x_emp_id NUMBER;

Line 724: ** should already be loaded into the po_headers_interface table.

720: /*
721: ** If we are using automatic numbering, get segment1
722: ** from the po_unique_identifier_control table.
723: ** If we are using manual numbering, segment1
724: ** should already be loaded into the po_headers_interface table.
725: ** The checks to verify that a manual po number is unique
726: ** is done on the client side.
727: */
728: /*

Line 1883: FROM po_headers_interface

1879: /* bug 12987412 new award is created hence use the value from
1880: x_headers.clm_contract_officer */
1881: x_headers.umbrella_program_id, --umbrella program
1882: x_headers.fon_ref_id --umbrella program
1883: FROM po_headers_interface
1884: WHERE interface_header_id = x_headers.intf_header_id;
1885:
1886: END IF; -- g_mode = 'ADD'
1887:

Line 1892: UPDATE po_headers_interface

1888: l_progress := '050';
1889: po_autocreate_params.g_po_header_id := x_headers.po_header_id;
1890:
1891: -- The following is needed during lines processing. (Fetch)
1892: UPDATE po_headers_interface
1893: SET po_header_id = x_headers.po_header_id ,
1894: draft_id = x_headers.draft_id
1895: WHERE interface_header_id = x_headers.intf_header_id;
1896:

Line 1974: FROM po_headers_interface

1970: x_headers.last_updated_by,
1971: x_headers.last_update_login,
1972: x_headers.creation_date,
1973: x_headers.created_by
1974: FROM po_headers_interface
1975: WHERE interface_header_id = x_headers.intf_header_id
1976: AND x_headers.doc_type = 'PA'
1977: AND NVL(x_headers.global_agreement_flag, 'N') = 'Y';
1978: