APPS.PO_INTERFACE_S dependencies on PO_HEADERS_S

Line 561: x_document_number po_headers.segment1%type;

557: x_number_lines IN OUT NOCOPY number,
558: p_document_creation_method IN VARCHAR2, --
559: p_orig_org_id IN NUMBER DEFAULT NULL --
560: ) IS
561: x_document_number po_headers.segment1%type;
562: x_errorcode number;
563: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
564: l_api_name VARCHAR2(30) := 'create_documents(wrapper1)'; --< Bug 3210331 >
565: BEGIN

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

1231:
1232: X_line_found varchar2(1) := 'N';
1233: x_release_num number;
1234:
1235: x_document_num po_headers.segment1%type:=null; -- Bug 1093645
1236:
1237: l_api_name CONSTANT VARCHAR2(30) := 'create_po';
1238:
1239: x_org_id number;

Line 1241: x_valid_ship_to po_headers.ship_to_location_id%TYPE;

1237: l_api_name CONSTANT VARCHAR2(30) := 'create_po';
1238:
1239: x_org_id number;
1240: /*bug # 2997337 */
1241: x_valid_ship_to po_headers.ship_to_location_id%TYPE;
1242: x_valid_bill_to po_headers.bill_to_location_id%TYPE;
1243: x_is_valid VARCHAR(1) := 'N';
1244: /*bug # 2997337 */
1245:

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

7388: PROCEDURE create_rfq(x_interface_header_id IN number,
7389: x_document_id IN OUT NOCOPY number) IS
7390:
7391: x_quotation_class_code varchar2(25);
7392: x_document_num po_headers.segment1%type:=null; -- Bug 1093645
7393:
7394: l_api_name CONSTANT VARCHAR2(30) := 'create_documents';
7395:
7396: --

Line 7635: UPDATE po_headers set segment1=x_document_num

7631: p_message => 'new po num = ' || x_document_num);
7632: END IF;
7633:
7634: l_progress := '130';
7635: UPDATE po_headers set segment1=x_document_num
7636: where po_header_id=x_document_id;
7637:
7638: END IF;
7639: END IF;

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

8613: )
8614: IS
8615:
8616: x_po_header_id number := null;
8617: x_document_num po_headers.segment1%type:=null;
8618: x_min_interface_line_id number:= null;
8619: x_order_type_lookup_code varchar2(25) := null;
8620: x_quotation_class_code varchar2(25) := null;
8621: x_count_dist number;

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

8628: x_vendor_product_num varchar2(240) := null;
8629: x_purchasing_uom varchar2(240) := null;
8630: x_pay_on_code varchar2(25) := null;
8631: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
8632: x_old_document_num po_headers.segment1%type:=null; -- Bug 700513, lpo, 07/15/98
8633:
8634: x_employee_id number;
8635: x_employee_name varchar2(240);
8636: x_requestor_location_id number;

Line 8835: SELECT po_headers_s.nextval

8831: p_token => l_progress,
8832: p_message => 'In std/planned/rfq');
8833: END IF;
8834:
8835: SELECT po_headers_s.nextval
8836: INTO x_po_header_id
8837: FROM sys.dual;
8838:
8839: