APPS.PO_APPROVAL_ACTION dependencies on PO_REQUISITION_LINES

Line 231: UPDATE PO_REQUISITION_LINES_ALL PORL

227: pragma AUTONOMOUS_TRANSACTION;
228:
229: begin
230:
231: UPDATE PO_REQUISITION_LINES_ALL PORL
232: SET PORL.last_update_date = sysdate,
233: PORL.last_updated_by = p_user_id,
234: PORL.last_update_login = p_last_update_login,
235: PORL.rate =

Line 319: AND NOT EXISTS (SELECT 'Lines Exist' FROM PO_REQUISITION_LINES

315: into l_error_occur
316: FROM
317: PO_REQUISITION_HEADERS PRH
318: WHERE PRH.requisition_header_id = l_document_id
319: AND NOT EXISTS (SELECT 'Lines Exist' FROM PO_REQUISITION_LINES
320: PRL WHERE PRL.requisition_header_id = PRH.requisition_header_id
321: AND nvl(PRL.cancel_flag,'N') = 'N');
322:
323: EXCEPTION

Line 351: PO_REQUISITION_LINES PRL

347:
348: SELECT 'Y'
349: INTO l_error_occur
350: FROM
351: PO_REQUISITION_LINES PRL
352: WHERE PRL.requisition_header_id = l_document_id
353: AND nvl(PRL.cancel_flag,'N') = 'N'
354: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED'
355: AND nvl(PRL.modified_by_agent_flag,'N') = 'N'

Line 376: PO_REQUISITION_LINES PRL

372: SELECT
373: l_online_report_id, l_last_update_login, l_user_id, sysdate,
374: l_user_id,sysdate,PRL.line_num,0,0,l_sequence, 'Line #' || PRL.line_num ||' ' || l_msg_text
375: FROM
376: PO_REQUISITION_LINES PRL
377: WHERE PRL.requisition_header_id = l_document_id
378: AND nvl(PRL.cancel_flag,'N') = 'N'
379: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED'
380: AND nvl(PRL.modified_by_agent_flag,'N') = 'N'

Line 396: PO_REQ_DISTRIBUTIONS PRD,PO_REQUISITION_LINES PRL

392: /* Commented the following sql in bug 5864807
393: SELECT 'Y'
394: INTO l_error_occur
395: FROM
396: PO_REQ_DISTRIBUTIONS PRD,PO_REQUISITION_LINES PRL
397: WHERE
398: PRL.requisition_line_id = PRD.requisition_line_id AND
399: PRL.requisition_header_id = l_document_id AND
400: nvl(PRL.cancel_flag,'N') = 'N'

Line 414: PO_REQUISITION_LINES PRL

410: -- Added the following sql for bug 5864807
411: SELECT 'Y'
412: INTO l_error_occur
413: FROM
414: PO_REQUISITION_LINES PRL
415: WHERE
416: PRL.requisition_header_id = l_document_id AND
417: nvl(PRL.cancel_flag,'N') = 'N'
418: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED' AND

Line 447: PO_REQ_DISTRIBUTIONS PRD,PO_REQUISITION_LINES PRL

443: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,
444: 'Line #' || PRL.line_num ||' Quantity '|| to_char (PRL.quantity) || ' ' ||
445: l_msg_text || ' ' || to_char(sum(PRD.req_line_quantity))
446: FROM
447: PO_REQ_DISTRIBUTIONS PRD,PO_REQUISITION_LINES PRL
448: WHERE
449: PRL.requisition_line_id = PRD.requisition_line_id AND
450: PRL.requisition_header_id = l_document_id AND
451: nvl(PRL.cancel_flag,'N') = 'N'

Line 475: FROM PO_REQUISITION_LINES PRL

471: shipment_num, distribution_num, sequence, text_line) SELECT
472: l_online_report_id,l_last_update_login,l_last_user_id, sysdate,
473: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,
474: 'Line #' ||PRL.line_num||' '|| l_msg_text
475: FROM PO_REQUISITION_LINES PRL
476: WHERE PRL.requisition_header_id = l_document_id
477: AND PRL.source_type_code = 'INVENTORY' AND nvl(PRL.cancel_flag,'N')
478: = 'N' AND nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND
479: 1 < (select count(PRD.requisition_line_id) FROM PO_REQ_DISTRIBUTIONS

Line 495: FROM PO_REQUISITION_LINES PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,

491: SELECT
492: l_online_report_id,l_last_update_login,l_user_id, sysdate,
493: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,
494: 'Line #' ||PRL.line_num||' '||l_msg_text
495: FROM PO_REQUISITION_LINES PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
496: GL_SETS_OF_BOOKS SOB
497: WHERE PRL.requisition_header_id = l_document_id AND
498: nvl(PRL.cancel_flag, 'N') = 'N' AND nvl(PRL.closed_code, 'OPEN') <>
499: 'FINALLY CLOSED' AND SOB.set_of_books_id = FSP.set_of_books_id AND

Line 542: , PO_REQUISITION_LINES PRL

538: , 'Line #'||PRL.line_num||' Distribution '||PRD.distribution_num||' '||l_msg_text
539: FROM
540: FINANCIALS_SYSTEM_PARAMETERS FSP
541: , PO_REQ_DISTRIBUTIONS PRD
542: , PO_REQUISITION_LINES PRL
543: , PO_REQUISITION_HEADERS_ALL PRH
544: WHERE PRD.requisition_line_id = PRL.requisition_line_id
545: AND PRL.requisition_header_id = PRH.requisition_header_id
546: AND PRL.requisition_header_id = l_document_id