APPS.POR_CONTRACTOR_NOTIFY dependencies on PO_REQUISITION_SUPPLIERS

Line 70: L_REQUISITION_SUPPLIER_ID PO_REQUISITION_SUPPLIERS.REQUISITION_SUPPLIER_ID%TYPE;

66: FUNCMODE IN VARCHAR2,
67: RESULTOUT OUT NOCOPY VARCHAR2 )
68: IS
69:
70: L_REQUISITION_SUPPLIER_ID PO_REQUISITION_SUPPLIERS.REQUISITION_SUPPLIER_ID%TYPE;
71: L_REQ_HEADER_ID PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;
72: L_SUPPLIER_EXISTS VARCHAR2(50);
73: L_NOTIFIER WF_USER_ROLES.ROLE_NAME%TYPE;
74: L_START_DATE PO_REQUISITION_LINES_ALL.ASSIGNMENT_START_DATE%TYPE;

Line 102: FROM PO_REQUISITION_SUPPLIERS PLS,

98: BEGIN
99:
100: SELECT MAX(PLS.REQUISITION_SUPPLIER_ID)
101: INTO L_REQUISITION_SUPPLIER_ID
102: FROM PO_REQUISITION_SUPPLIERS PLS,
103: PO_REQUISITION_LINES_ALL PORL
104: WHERE NVL(PLS.SUPPLIER_NOTIFIED_FLAG,'N') = 'N'
105: AND PORL.REQUISITION_LINE_ID = PLS.REQUISITION_LINE_ID
106: AND PORL.REQUISITION_HEADER_ID = L_REQ_HEADER_ID;

Line 125: FROM PO_REQUISITION_SUPPLIERS PLS,

121:
122: SELECT PORL.ASSIGNMENT_START_DATE,
123: PORL.ITEM_DESCRIPTION, PORH.SEGMENT1 || ' / ' || PORL.LINE_NUM, PORL.REQUISITION_LINE_ID
124: INTO L_START_DATE, L_JOB_DESCRIPTION, L_REQ_NUM_LINE_NUM, L_REQUISITION_LINE_ID
125: FROM PO_REQUISITION_SUPPLIERS PLS,
126: PO_REQUISITION_LINES_ALL PORL,
127: PO_REQUISITION_HEADERS_ALL PORH
128: WHERE PORL.REQUISITION_LINE_ID = PLS.REQUISITION_LINE_ID
129: AND PLS.REQUISITION_SUPPLIER_ID = L_REQUISITION_SUPPLIER_ID

Line 216: FROM PO_REQUISITION_SUPPLIERS PLS,

212: END IF;
213:
214: SELECT PORL.LINE_NUM, POV.VENDOR_NAME
215: INTO L_LINE_NUM, L_VENDOR_NAME
216: FROM PO_REQUISITION_SUPPLIERS PLS,
217: PO_REQUISITION_LINES_ALL PORL,
218: PO_VENDORS POV
219: WHERE PORL.REQUISITION_LINE_ID = PLS.REQUISITION_LINE_ID
220: AND PLS.REQUISITION_SUPPLIER_ID = L_REQUISITION_SUPPLIER_ID

Line 280: UPDATE PO_REQUISITION_SUPPLIERS

276: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
277: g_module_prefix || 'UPDATE_NOTIFY_SUPPLIER' || 'L_REQUISITION_SUPPLIER_ID : ' || L_REQUISITION_SUPPLIER_ID);
278: end if;
279:
280: UPDATE PO_REQUISITION_SUPPLIERS
281: SET SUPPLIER_NOTIFIED_FLAG = 'Y', SUPPLIER_NOTIFIED_DATE = SYSDATE
282: WHERE REQUISITION_SUPPLIER_ID = L_REQUISITION_SUPPLIER_ID;
283:
284: RETURN;

Line 327: FROM PO_REQUISITION_SUPPLIERS PRS, PO_VENDOR_SITES_ALL PVS

323: IF (L_REQ_SUPPLIER_ID IS NOT NULL) THEN
324:
325: SELECT PRS.VENDOR_SITE_ID, PRS.VENDOR_CONTACT_ID, PVS.VENDOR_SITE_CODE, PVS.LANGUAGE
326: INTO L_VENDOR_SITE_ID, L_VENDOR_CONTACT_ID, L_VENDOR_SITE_CODE, L_VENDOR_SITE_LANG
327: FROM PO_REQUISITION_SUPPLIERS PRS, PO_VENDOR_SITES_ALL PVS
328: WHERE PRS.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
329: AND PRS.REQUISITION_SUPPLIER_ID = L_REQ_SUPPLIER_ID;
330:
331: ELSIF (L_REQ_LINE_ID IS NOT NULL) THEN