APPS.PO_SERVICES_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 192: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;

188: -------------------------------------------------------------------------------
189: FUNCTION get_contractor_status ( p_req_line_id IN NUMBER )
190: RETURN VARCHAR2
191: IS
192: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;
193: BEGIN
194:
195: SELECT contractor_status
196: INTO l_contractor_status

Line 197: FROM po_requisition_lines_all

193: BEGIN
194:
195: SELECT contractor_status
196: INTO l_contractor_status
197: FROM po_requisition_lines_all
198: WHERE requisition_line_id = p_req_line_id;
199:
200: return (l_contractor_status);
201:

Line 246: FROM po_requisition_lines_all

242: SELECT requisition_line_id
243: , line_num
244: INTO x_expense_line_id
245: , x_expense_line_num
246: FROM po_requisition_lines_all
247: WHERE labor_req_line_id = p_parent_line_id;
248:
249: EXCEPTION
250:

Line 292: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;

288: p_req_line_id IN NUMBER
289: )
290: RETURN VARCHAR2
291: IS
292: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;
293:
294: BEGIN
295:
296: SELECT job_long_description

Line 298: FROM po_requisition_lines_all

294: BEGIN
295:
296: SELECT job_long_description
297: INTO l_job_long_description
298: FROM po_requisition_lines_all
299: WHERE requisition_line_id = p_req_line_id;
300:
301: return (l_job_long_description);
302:

Line 399: FROM po_requisition_lines_all PRL1 -- Expense Line

395: SELECT PRL2.requisition_line_id
396: , PRL2.line_num
397: INTO x_parent_line_id
398: , x_parent_line_num
399: FROM po_requisition_lines_all PRL1 -- Expense Line
400: , po_requisition_lines_all PRL2 -- Parent Line
401: WHERE p_expense_line_id = PRL1.requisition_line_id
402: AND PRL1.labor_req_line_id = PRL2.requisition_line_id;
403:

Line 400: , po_requisition_lines_all PRL2 -- Parent Line

396: , PRL2.line_num
397: INTO x_parent_line_id
398: , x_parent_line_num
399: FROM po_requisition_lines_all PRL1 -- Expense Line
400: , po_requisition_lines_all PRL2 -- Parent Line
401: WHERE p_expense_line_id = PRL1.requisition_line_id
402: AND PRL1.labor_req_line_id = PRL2.requisition_line_id;
403:
404: EXCEPTION

Line 447: l_labor_req_line_id PO_REQUISITION_LINES_ALL.labor_req_line_id%TYPE;

443: p_req_line_id IN NUMBER
444: )
445: RETURN BOOLEAN
446: IS
447: l_labor_req_line_id PO_REQUISITION_LINES_ALL.labor_req_line_id%TYPE;
448:
449: BEGIN
450:
451: SELECT labor_req_line_id

Line 453: FROM po_requisition_lines_all

449: BEGIN
450:
451: SELECT labor_req_line_id
452: INTO l_labor_req_line_id
453: FROM po_requisition_lines_all
454: WHERE requisition_line_id = p_req_line_id;
455:
456: IF ( l_labor_req_line_id IS NOT NULL )
457: THEN