eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AUTO_HEADER_PROCESS_PVT dependencies on PO_HEADERS

Line 11: g_terms_id PO_HEADERS.terms_id%TYPE;

7: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
8: -- Derive and validate Vendor related attributes
9: g_vendor_ship_to_loc_id NUMBER;
10: g_vendor_bill_to_loc_id NUMBER;
11: g_terms_id PO_HEADERS.terms_id%TYPE;
12: g_fob PO_HEADERS.fob_lookup_code%TYPE;
13: g_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
14: g_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
15: g_vs_terms_id PO_HEADERS.terms_id%TYPE;

Line 12: g_fob PO_HEADERS.fob_lookup_code%TYPE;

8: -- Derive and validate Vendor related attributes
9: g_vendor_ship_to_loc_id NUMBER;
10: g_vendor_bill_to_loc_id NUMBER;
11: g_terms_id PO_HEADERS.terms_id%TYPE;
12: g_fob PO_HEADERS.fob_lookup_code%TYPE;
13: g_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
14: g_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
15: g_vs_terms_id PO_HEADERS.terms_id%TYPE;
16: g_vs_fob PO_HEADERS.fob_lookup_code%TYPE;

Line 13: g_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;

9: g_vendor_ship_to_loc_id NUMBER;
10: g_vendor_bill_to_loc_id NUMBER;
11: g_terms_id PO_HEADERS.terms_id%TYPE;
12: g_fob PO_HEADERS.fob_lookup_code%TYPE;
13: g_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
14: g_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
15: g_vs_terms_id PO_HEADERS.terms_id%TYPE;
16: g_vs_fob PO_HEADERS.fob_lookup_code%TYPE;
17: g_vs_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;

Line 14: g_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;

10: g_vendor_bill_to_loc_id NUMBER;
11: g_terms_id PO_HEADERS.terms_id%TYPE;
12: g_fob PO_HEADERS.fob_lookup_code%TYPE;
13: g_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
14: g_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
15: g_vs_terms_id PO_HEADERS.terms_id%TYPE;
16: g_vs_fob PO_HEADERS.fob_lookup_code%TYPE;
17: g_vs_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
18: g_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;

Line 15: g_vs_terms_id PO_HEADERS.terms_id%TYPE;

11: g_terms_id PO_HEADERS.terms_id%TYPE;
12: g_fob PO_HEADERS.fob_lookup_code%TYPE;
13: g_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
14: g_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
15: g_vs_terms_id PO_HEADERS.terms_id%TYPE;
16: g_vs_fob PO_HEADERS.fob_lookup_code%TYPE;
17: g_vs_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
18: g_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
19:

Line 16: g_vs_fob PO_HEADERS.fob_lookup_code%TYPE;

12: g_fob PO_HEADERS.fob_lookup_code%TYPE;
13: g_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
14: g_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
15: g_vs_terms_id PO_HEADERS.terms_id%TYPE;
16: g_vs_fob PO_HEADERS.fob_lookup_code%TYPE;
17: g_vs_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
18: g_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
19:
20: /* -------------------------------------------------------

Line 17: g_vs_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;

13: g_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
14: g_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
15: g_vs_terms_id PO_HEADERS.terms_id%TYPE;
16: g_vs_fob PO_HEADERS.fob_lookup_code%TYPE;
17: g_vs_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
18: g_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
19:
20: /* -------------------------------------------------------
21: ---------------- PRIVATE PROCEDURES -------------------

Line 18: g_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;

14: g_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
15: g_vs_terms_id PO_HEADERS.terms_id%TYPE;
16: g_vs_fob PO_HEADERS.fob_lookup_code%TYPE;
17: g_vs_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
18: g_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
19:
20: /* -------------------------------------------------------
21: ---------------- PRIVATE PROCEDURES -------------------
22: ------------------------------------------------------- */

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 639: FROM po_headers_all PH,

635: x_headers.clm_external_idv,
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:

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 738: FROM po_headers_all ph

734: l_progress := '010';
735:
736: SELECT ph.po_header_id
737: INTO x_headers.po_header_id
738: FROM po_headers_all ph
739: WHERE ph.type_lookup_code = PO_AUTOCREATE_PARAMS.g_document_subtype
740: AND ph.segment1 = REPLACE(x_headers.document_num,'-')
741: AND NVL(org_id, -99) = NVL(PO_AUTOCREATE_PARAMS.g_purchasing_ou_id, -99);
742:

Line 747: SELECT po_headers_s.nextval INTO x_headers.po_header_id FROM sys.dual;

743: ELSIF (PO_AUTOCREATE_PARAMS.g_mode='NEW') THEN
744:
745: l_progress := '020';
746:
747: SELECT po_headers_s.nextval INTO x_headers.po_header_id FROM sys.dual;
748:
749: IF (PO_AUTOCREATE_PARAMS.g_sys.user_defined_po_num_code='AUTOMATIC') AND (PO_AUTOCREATE_PARAMS.g_document_type IN ('PO','PA')) THEN
750:
751: --< Bug 14314684 Create Workflow project >

Line 1025: x_valid_ship_to po_headers.ship_to_location_id%TYPE;

1021: IS
1022:
1023: l_progress VARCHAR2(3) := '000';
1024: l_api_name CONSTANT VARCHAR2(30) := 'validate_header';
1025: x_valid_ship_to po_headers.ship_to_location_id%TYPE;
1026: x_valid_bill_to po_headers.bill_to_location_id%TYPE;
1027: x_is_valid VARCHAR(1) := 'N';
1028:
1029: BEGIN

Line 1026: x_valid_bill_to po_headers.bill_to_location_id%TYPE;

1022:
1023: l_progress VARCHAR2(3) := '000';
1024: l_api_name CONSTANT VARCHAR2(30) := 'validate_header';
1025: x_valid_ship_to po_headers.ship_to_location_id%TYPE;
1026: x_valid_bill_to po_headers.bill_to_location_id%TYPE;
1027: x_is_valid VARCHAR(1) := 'N';
1028:
1029: BEGIN
1030:

Line 1188: DESC: Insert/update header records into po_headers_draft_all table.

1184: END validate_header;
1185:
1186: /* ============================================================================
1187: NAME: merge_to_headers_draft
1188: DESC: Insert/update header records into po_headers_draft_all table.
1189: ARGS: IN OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type
1190: NOTE: if NEW DOCUMENT
1191: 1. Create a draft record
1192: 2. Create headers_draft record

Line 1243: -- Update the PO Headers Draft

1239: last_update_login = x_headers.last_update_login
1240: WHERE draft_id = x_headers.draft_id;
1241:
1242: l_progress := '021';
1243: -- Update the PO Headers Draft
1244: UPDATE po_headers_draft_all
1245: SET last_update_date = x_headers.last_update_date,
1246: last_updated_by = x_headers.last_updated_by,
1247: last_update_login = x_headers.last_update_login

Line 1244: UPDATE po_headers_draft_all

1240: WHERE draft_id = x_headers.draft_id;
1241:
1242: l_progress := '021';
1243: -- Update the PO Headers Draft
1244: UPDATE po_headers_draft_all
1245: SET last_update_date = x_headers.last_update_date,
1246: last_updated_by = x_headers.last_updated_by,
1247: last_update_login = x_headers.last_update_login
1248: WHERE draft_id = x_headers.draft_id;

Line 1318: -- Insert esisting records from PO into po_headers_draft_all

1314: x_headers.clm_contract_officer --Bug13547051
1315: );
1316:
1317: l_progress := '040';
1318: -- Insert esisting records from PO into po_headers_draft_all
1319: INSERT
1320: INTO po_headers_draft_all
1321: (
1322: draft_id,

Line 1320: INTO po_headers_draft_all

1316:
1317: l_progress := '040';
1318: -- Insert esisting records from PO into po_headers_draft_all
1319: INSERT
1320: INTO po_headers_draft_all
1321: (
1322: draft_id,
1323: org_id,
1324: delete_flag,

Line 1563: FROM po_headers_all

1559: supplier_notif_method, --Bug13547051 In add to mode the communication should be copied from the base award.
1560: fax, --Bug13547051
1561: email_address, --Bug13547051
1562: clm_effective_date --Bug13547051
1563: FROM po_headers_all
1564: WHERE po_header_id = x_headers.po_header_id;
1565:
1566: l_progress := '050';
1567: UPDATE po_headers_draft_all

Line 1567: UPDATE po_headers_draft_all

1563: FROM po_headers_all
1564: WHERE po_header_id = x_headers.po_header_id;
1565:
1566: l_progress := '050';
1567: UPDATE po_headers_draft_all
1568: SET last_update_date = x_headers.last_update_date,
1569: last_updated_by = x_headers.last_updated_by,
1570: authorization_status = NULL,
1571: last_update_login = x_headers.last_update_login

Line 1625: -- Insert new documents attribute values into po_headers_draft_all

1621: x_headers.request_id
1622: );
1623:
1624: l_progress := '040';
1625: -- Insert new documents attribute values into po_headers_draft_all
1626: INSERT
1627: INTO po_headers_draft_all
1628: (
1629: draft_id,

Line 1627: INTO po_headers_draft_all

1623:
1624: l_progress := '040';
1625: -- Insert new documents attribute values into po_headers_draft_all
1626: INSERT
1627: INTO po_headers_draft_all
1628: (
1629: draft_id,
1630: org_id,
1631: delete_flag,

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: