DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on PO_HEADERS_ALL

Line 1131: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;

1127: --
1128: x_po_number VARCHAR2(20):= NULL;
1129: x_supplier_name PO_VENDORS.VENDOR_NAME%TYPE := NULL;
1130: x_exp_receipt_date DATE;
1131: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;
1132: x_buyer_id NUMBER := 0;
1133:
1134: -- line info
1135: --

Line 1326: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;

1322: -- Header info
1323: x_so_number VARCHAR2(20):= NULL;
1324: x_so_header_id NUMBER;
1325: x_exp_receipt_date DATE;
1326: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;
1327:
1328: -- line info
1329: x_line_disp NUMBER := 0;
1330: x_total_lines NUMBER := 0;

Line 2175: from po_headers_all

2171: where rownum < 2;
2172:
2173: cursor getorgid is
2174: select org_id
2175: from po_headers_all
2176: where po_header_id = x_header_id;
2177:
2178: cursor getorgid_int is
2179: select org_id

Line 3058: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;

3054: x_number VARCHAR2(20):= NULL;
3055: x_supplier_name PO_VENDORS.VENDOR_NAME%TYPE := NULL;
3056: x_due_date DATE;
3057: x_buyer_name WF_USERS.DISPLAY_NAME%TYPE := NULL;
3058: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;
3059: x_disp_count NUMBER := 0;
3060: x_confirm_rcpt_inst VARCHAR2(2000);
3061: x_is_int_req VARCHAR2(1);
3062: