DBA Data[Home] [Help]

APPS.INV_DIAG_RCV_IPROC dependencies on INV_DIAG_RCV_IPROC_COMMON

Line 240: INV_DIAG_RCV_IPROC_COMMON.build_req_all_sql(l_operating_id,l_req_number,l_line_num,l_receipt_num,l_org_id,po_sql);

236: l_receipt_num IS NOT NULL AND
237: l_org_id IS NOT NULL AND
238: l_skip_rest = 'N' THEN
239:
240: INV_DIAG_RCV_IPROC_COMMON.build_req_all_sql(l_operating_id,l_req_number,l_line_num,l_receipt_num,l_org_id,po_sql);
241: l_skip_rest := 'Y';
242: END if;
243:
244: IF l_req_number IS NOT NULL AND

Line 248: INV_DIAG_RCV_IPROC_COMMON.build_req_sql(l_operating_id,l_req_number,l_line_num,po_sql);

244: IF l_req_number IS NOT NULL AND
245: l_operating_id IS NOT NULL AND
246: l_skip_rest = 'N' THEN
247:
248: INV_DIAG_RCV_IPROC_COMMON.build_req_sql(l_operating_id,l_req_number,l_line_num,po_sql);
249: l_skip_rest := 'Y';
250: END if;
251:
252: IF l_receipt_num IS NOT NULL AND

Line 256: INV_DIAG_RCV_IPROC_COMMON.build_req_rcv_sql(l_receipt_num,l_org_id,po_sql);

252: IF l_receipt_num IS NOT NULL AND
253: l_org_id IS NOT NULL AND
254: l_skip_rest = 'N' THEN
255:
256: INV_DIAG_RCV_IPROC_COMMON.build_req_rcv_sql(l_receipt_num,l_org_id,po_sql);
257: l_skip_rest := 'Y';
258: END if;
259:
260: -- Call the procedure to get the lookup codes