APPS.PO_INTERFACE_S dependencies on PO_HEADERS_S

Line 556: x_document_number po_headers.segment1%type;

552: p_document_creation_method IN VARCHAR2, --
553: p_orig_org_id IN NUMBER DEFAULT NULL, --
554: p_group_shipments IN VARCHAR2 DEFAULT NULL --
555: ) IS
556: x_document_number po_headers.segment1%type;
557: x_errorcode number;
558: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
559: l_api_name VARCHAR2(30) := 'create_documents(wrapper1)'; --< Bug 3210331 >
560: BEGIN

Line 1428: x_document_num po_headers.segment1%type:=null; -- Bug 1093645

1424:
1425: X_line_found varchar2(1) := 'N';
1426: x_release_num number;
1427:
1428: x_document_num po_headers.segment1%type:=null; -- Bug 1093645
1429:
1430: l_api_name CONSTANT VARCHAR2(30) := 'create_po';
1431:
1432: x_org_id number;

Line 1434: x_valid_ship_to po_headers.ship_to_location_id%TYPE;

1430: l_api_name CONSTANT VARCHAR2(30) := 'create_po';
1431:
1432: x_org_id number;
1433: /*bug # 2997337 */
1434: x_valid_ship_to po_headers.ship_to_location_id%TYPE;
1435: x_valid_bill_to po_headers.bill_to_location_id%TYPE;
1436: x_is_valid VARCHAR(1) := 'N';
1437: /*bug # 2997337 */
1438:

Line 7987: x_document_num po_headers.segment1%type:=null; -- Bug 1093645

7983: PROCEDURE create_rfq(x_interface_header_id IN number,
7984: x_document_id IN OUT NOCOPY number) IS
7985:
7986: x_quotation_class_code varchar2(25);
7987: x_document_num po_headers.segment1%type:=null; -- Bug 1093645
7988:
7989: l_api_name CONSTANT VARCHAR2(30) := 'create_documents';
7990:
7991: --

Line 8236: UPDATE po_headers set segment1=x_document_num,

8232: p_message => 'new po num = ' || x_document_num);
8233: END IF;
8234:
8235: l_progress := '130';
8236: UPDATE po_headers set segment1=x_document_num,
8237: clm_document_number =x_document_num
8238: where po_header_id=x_document_id;
8239:
8240: END IF;

Line 9235: x_document_num po_headers.segment1%type:=null;

9231: )
9232: IS
9233:
9234: x_po_header_id number := null;
9235: x_document_num po_headers.segment1%type:=null;
9236: x_min_interface_line_id number:= null;
9237: x_order_type_lookup_code varchar2(25) := null;
9238: x_quotation_class_code varchar2(25) := null;
9239: x_count_dist number;

Line 9250: x_old_document_num po_headers.segment1%type:=null; -- Bug 700513, lpo, 07/15/98

9246: x_vendor_product_num varchar2(240) := null;
9247: x_purchasing_uom varchar2(240) := null;
9248: x_pay_on_code varchar2(25) := null;
9249: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
9250: x_old_document_num po_headers.segment1%type:=null; -- Bug 700513, lpo, 07/15/98
9251:
9252: x_employee_id number;
9253: x_employee_name varchar2(240);
9254: x_requestor_location_id number;

Line 9453: SELECT po_headers_s.nextval

9449: p_token => l_progress,
9450: p_message => 'In std/planned/rfq');
9451: END IF;
9452:
9453: SELECT po_headers_s.nextval
9454: INTO x_po_header_id
9455: FROM sys.dual;
9456:
9457: