APPS.POR_CANCEL_NOTIF_PVT dependencies on PO_REQUISITION_LINES

Line 98: l_contractor_status po_requisition_lines.contractor_status%type;

94:
95: l_progress varchar2(200);
96: l_supplier_notified_flag po_requisition_headers.supplier_notified_flag%type;
97: l_req_line_id NUMBER;
98: l_contractor_status po_requisition_lines.contractor_status%type;
99: l_api_name varchar2(50) := 'IS_ANY_SUPPLIER_NOTIFIED';
100: BEGIN
101:
102: l_progress := 'POR_CANCEL_NOTIFICATION_PVT.Is_any_supplier_notified: 01';

Line 125: po_requisition_lines_all prl

121: select nvl(prh.supplier_notified_flag, 'N'), prl.contractor_status
122: into l_supplier_notified_flag, l_contractor_status
123: from
124: po_requisition_headers_all prh,
125: po_requisition_lines_all prl
126: where
127: prh.requisition_header_id = prl.requisition_header_id and
128: requisition_line_id = l_req_line_id;
129:

Line 209: l_contact_info PO_REQUISITION_LINES.CONTACT_INFORMATION%TYPE;

205:
206: l_progress varchar2(200);
207: l_req_line_id NUMBER;
208: l_job_name po_job_associations_tl.JOB_DESCRIPTION%TYPE;
209: l_contact_info PO_REQUISITION_LINES.CONTACT_INFORMATION%TYPE;
210: l_start_date DATE;
211: l_req_info VARCHAR2(100) := '';
212: l_cont_status PO_REQUISITION_LINES.CONTRACTOR_STATUS%TYPE;
213: l_api_name varchar2(50) := 'SET_NOTIFICATION_ATTRIBUTES';

Line 212: l_cont_status PO_REQUISITION_LINES.CONTRACTOR_STATUS%TYPE;

208: l_job_name po_job_associations_tl.JOB_DESCRIPTION%TYPE;
209: l_contact_info PO_REQUISITION_LINES.CONTACT_INFORMATION%TYPE;
210: l_start_date DATE;
211: l_req_info VARCHAR2(100) := '';
212: l_cont_status PO_REQUISITION_LINES.CONTRACTOR_STATUS%TYPE;
213: l_api_name varchar2(50) := 'SET_NOTIFICATION_ATTRIBUTES';
214: BEGIN
215:
216: l_progress := 'POR_CANCEL_NOTIFICATION_PVT.set_notification_attributes: 01';

Line 246: po_requisition_lines_all prl,

242: prl.assignment_start_date, prh.segment1 || ' / ' || to_char(prl.line_num)
243: INTO l_job_name, l_contact_info, l_start_date, l_req_info
244: FROM
245: po_requisition_headers_all prh,
246: po_requisition_lines_all prl,
247: po_job_associations pja
248: WHERE prl.requisition_line_id = l_req_line_id AND
249: prl.job_id = pja.job_id AND
250: prh.requisition_header_id = prl.requisition_header_id;

Line 324: l_cont_status po_requisition_lines.CONTRACTOR_STATUS%type;

320:
321: l_progress varchar2(200);
322: l_api_name varchar2(50) := 'SET_SUPPLIER';
323: l_req_line_id NUMBER := 0;
324: l_cont_status po_requisition_lines.CONTRACTOR_STATUS%type;
325: l_requisition_supplier_id NUMBER := 0;
326: l_performer WF_USER_ROLES.ROLE_NAME%TYPE;
327: l_supplier_exists VARCHAR2(50);
328:

Line 409: FROM po_requisition_lines

405: ELSIF (l_cont_status = 'ASSIGNED') THEN -- only one supplier
406:
407: SELECT max(vendor_id)
408: INTO l_requisition_supplier_id
409: FROM po_requisition_lines
410: WHERE
411: requisition_line_id = l_req_line_id AND
412: nvl(supplier_notified_for_cancel, 'N')='N';
413:

Line 465: * Updates SUPPLIER_NOTIFIED_FOR_CANCEL flag in po_requisition_lines *

461: END set_supplier;
462:
463:
464: /*==========================================================================*
465: * Updates SUPPLIER_NOTIFIED_FOR_CANCEL flag in po_requisition_lines *
466: *==========================================================================*/
467: PROCEDURE post_notification_process(itemtype in varchar2,
468: itemkey in varchar2,
469: actid in number,

Line 477: l_cont_status po_requisition_lines.contractor_status%type;

473:
474: l_progress varchar2(200);
475: l_req_line_id NUMBER := 0;
476: l_supplier_id NUMBER := 0;
477: l_cont_status po_requisition_lines.contractor_status%type;
478: l_api_name varchar2(50) := 'POST_NOTIFICATION_PROCESS';
479:
480: BEGIN
481:

Line 501: UPDATE po_requisition_lines_all

497: aname => 'REQ_LINE_ID');
498:
499: l_progress := 'POR_CANCEL_NOTIFICATION_PVT.post_notification_process: 02';
500:
501: UPDATE po_requisition_lines_all
502: SET supplier_notified_for_cancel ='Y'
503: WHERE requisition_line_id = l_req_line_id;
504:
505: l_cont_status := wf_engine.GetItemAttrText (itemtype => itemtype,