APPS.PORCPTWF dependencies on PO_HEADERS

Line 1045: from po_headers

1041: if (x_requester_username is null) or (x_requester_current = FALSE) then
1042:
1043: select agent_id
1044: into x_buyer_id
1045: from po_headers
1046: where po_header_id=x_header_id;
1047:
1048: wf_directory.GetUserName ( p_orig_system => 'PER',
1049: p_orig_system_id => x_buyer_id,

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 1184: FROM PO_HEADERS poh,

1180: INTO x_po_number,
1181: x_supplier_name,
1182: x_buyer_id,
1183: x_note_to_receiver
1184: FROM PO_HEADERS poh,
1185: PO_VENDORS pov
1186: WHERE po_header_id = x_po_header_id
1187: AND poh.vendor_id = pov.vendor_id (+);
1188:

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: