APPS.POR_CONTRACTOR_NOTIFY dependencies on PO_REQUISITION_LINES_ALL

Line 74: L_START_DATE PO_REQUISITION_LINES_ALL.ASSIGNMENT_START_DATE%TYPE;

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;
76: L_COMPANY_NAME varchar2(100);
77: L_REQ_NUM_LINE_NUM varchar2(100);
78: L_STATUS varchar2(1);

Line 75: L_JOB_DESCRIPTION PO_REQUISITION_LINES_ALL.ITEM_DESCRIPTION%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;
76: L_COMPANY_NAME varchar2(100);
77: L_REQ_NUM_LINE_NUM varchar2(100);
78: L_STATUS varchar2(1);
79: L_EXP_MSG varchar2(100);

Line 80: L_REQUISITION_LINE_ID PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;

76: L_COMPANY_NAME varchar2(100);
77: L_REQ_NUM_LINE_NUM varchar2(100);
78: L_STATUS varchar2(1);
79: L_EXP_MSG varchar2(100);
80: L_REQUISITION_LINE_ID PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
81: L_LINE_NUM PO_REQUISITION_LINES_ALL.LINE_NUM%TYPE;
82: L_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;
83:
84: BEGIN

Line 81: L_LINE_NUM PO_REQUISITION_LINES_ALL.LINE_NUM%TYPE;

77: L_REQ_NUM_LINE_NUM varchar2(100);
78: L_STATUS varchar2(1);
79: L_EXP_MSG varchar2(100);
80: L_REQUISITION_LINE_ID PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
81: L_LINE_NUM PO_REQUISITION_LINES_ALL.LINE_NUM%TYPE;
82: L_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;
83:
84: BEGIN
85:

Line 103: PO_REQUISITION_LINES_ALL PORL

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;
107:

Line 126: PO_REQUISITION_LINES_ALL PORL,

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

Line 217: PO_REQUISITION_LINES_ALL PORL,

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
221: AND PLS.VENDOR_ID = POV.VENDOR_ID;

Line 453: DESCRIPTION: Sets the REQS_IN_POOL flag in the po_requisition_lines_all table to 'Y'

449: END GET_ADHOC_EMAIL_ROLE;
450:
451: /*===========================================================================
452: PROCEDURE NAME: SET_REQSINPOOL_FLAG
453: DESCRIPTION: Sets the REQS_IN_POOL flag in the po_requisition_lines_all table to 'Y'
454: ===========================================================================*/
455:
456: PROCEDURE SET_REQSINPOOL_FLAG (ITEMTYPE IN VARCHAR2,
457: ITEMKEY IN VARCHAR2,

Line 472: UPDATE PO_REQUISITION_LINES_ALL

468: ITEMKEY => ITEMKEY,
469: ANAME => 'DOCUMENT_ID');
470:
471: IF L_REQ_HEADER_ID is not null then
472: UPDATE PO_REQUISITION_LINES_ALL
473: SET REQS_IN_POOL_FLAG = 'Y'
474: WHERE REQUISITION_HEADER_ID = L_REQ_HEADER_ID
475: AND NVL(CONTRACTOR_REQUISITION_FLAG, 'N') = 'Y';
476: END IF;