APPS.POR_CONTRACTOR_NOTIFY dependencies on PO_REQUISITION_HEADERS_ALL

Line 23: L_CONTRACTOR_STATUS PO_REQUISITION_HEADERS_ALL.CONTRACTOR_STATUS%TYPE;

19: IS
20:
21: L_REQ_HEADER_ID Number;
22: L_CONTR_ASSIGN_REQD VARCHAR2(1) := 'N';
23: L_CONTRACTOR_STATUS PO_REQUISITION_HEADERS_ALL.CONTRACTOR_STATUS%TYPE;
24: L_SUPPLIER_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.SUPPLIER_NOTIFIED_FLAG%TYPE;
25:
26: BEGIN
27:

Line 24: L_SUPPLIER_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.SUPPLIER_NOTIFIED_FLAG%TYPE;

20:
21: L_REQ_HEADER_ID Number;
22: L_CONTR_ASSIGN_REQD VARCHAR2(1) := 'N';
23: L_CONTRACTOR_STATUS PO_REQUISITION_HEADERS_ALL.CONTRACTOR_STATUS%TYPE;
24: L_SUPPLIER_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.SUPPLIER_NOTIFIED_FLAG%TYPE;
25:
26: BEGIN
27:
28: L_REQ_HEADER_ID := WF_ENGINE.GETITEMATTRNUMBER

Line 36: FROM PO_REQUISITION_HEADERS_ALL

32:
33: --Query the supplires which need to be notified for this requisition
34: SELECT CONTRACTOR_STATUS, SUPPLIER_NOTIFIED_FLAG
35: INTO L_CONTRACTOR_STATUS, L_SUPPLIER_NOTIFIED_FLAG
36: FROM PO_REQUISITION_HEADERS_ALL
37: WHERE REQUISITION_HEADER_ID = L_REQ_HEADER_ID;
38:
39: IF g_po_wf_debug = 'Y' THEN
40: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

Line 71: L_REQ_HEADER_ID PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;

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;
75: L_JOB_DESCRIPTION PO_REQUISITION_LINES_ALL.ITEM_DESCRIPTION%TYPE;

Line 92: UPDATE PO_REQUISITION_HEADERS_ALL

88: ITEMKEY => ITEMKEY,
89: ANAME => 'DOCUMENT_ID');
90: --To be removed
91: if L_REQ_HEADER_ID is not null then
92: UPDATE PO_REQUISITION_HEADERS_ALL
93: SET SUPPLIER_NOTIFIED_FLAG = 'Y'
94: WHERE REQUISITION_HEADER_ID = L_REQ_HEADER_ID;
95: end if;
96:

Line 116: UPDATE PO_REQUISITION_HEADERS_ALL

112:
113: IF L_REQUISITION_SUPPLIER_ID IS NULL THEN
114:
115: L_SUPPLIER_EXISTS := 'ALL_SUPPLIER_NOTIFIED';
116: UPDATE PO_REQUISITION_HEADERS_ALL
117: SET SUPPLIER_NOTIFIED_FLAG = 'Y'
118: WHERE REQUISITION_HEADER_ID = L_REQ_HEADER_ID;
119:
120: ELSE

Line 127: PO_REQUISITION_HEADERS_ALL PORH

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
130: AND PORL.REQUISITION_HEADER_ID = PORH.REQUISITION_HEADER_ID;
131:

Line 461: L_REQ_HEADER_ID PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;

457: ACTID IN NUMBER,
458: FUNCMODE IN VARCHAR2,
459: RESULTOUT OUT NOCOPY VARCHAR2 )
460: is
461: L_REQ_HEADER_ID PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;
462:
463: BEGIN
464:
465: L_REQ_HEADER_ID := WF_ENGINE.GETITEMATTRNUMBER