APPS.PO_RCOTOLERANCE_PVT dependencies on PO_CHANGE_REQUESTS

Line 21: * Effects: Get revised line quantity from po_req_distributions and po_change_requests.

17: * Requisition Header Id
18: * Requisition Line Id
19: * Change Request Group Id
20: * Modifies: None.
21: * Effects: Get revised line quantity from po_req_distributions and po_change_requests.
22: * Returns:
23: * Revised line quantity
24: * If there is an exception returns 0
25: */

Line 58: * Effects: Return updated distribution qty from po_change_requests if any

54: * Requires: Requisition Header Id
55: * Change Request Group Id
56: * Requisition Line Id
57: * Modifies: None.
58: * Effects: Return updated distribution qty from po_change_requests if any
59: * Else Return the req_line_quantity from po_req_distributions
60: * If line was cancelled return 0
61: * Returns:
62: * Revised distribution quantity

Line 78: FROM po_change_requests

74: l_qty_changed NUMBER := 0;
75: BEGIN
76: SELECT COUNT(* )
77: INTO l_qty_changed
78: FROM po_change_requests
79: WHERE document_distribution_id = p_req_dist_id
80: AND document_line_id = p_req_line_id
81: AND document_header_id = p_req_id
82: AND request_status = 'SYSTEMSAVE'

Line 88: FROM po_change_requests

84:
85: IF (l_qty_changed > 0) THEN
86: SELECT new_quantity
87: INTO l_new_qty
88: FROM po_change_requests
89: WHERE document_distribution_id = p_req_dist_id
90: AND document_line_id = p_req_line_id
91: AND document_header_id = p_req_id
92: AND request_status = 'SYSTEMSAVE';

Line 580: FROM po_change_requests

576: SELECT 'N'
577: INTO l_return_val
578: FROM dual
579: WHERE EXISTS (SELECT 'N'
580: FROM po_change_requests
581: WHERE change_request_group_id = p_reqgrp_id
582: AND action_type = 'MODIFICATION'
583: AND request_status = 'SYSTEMSAVE'
584: AND request_level = 'LINE'

Line 605: FROM po_change_requests

601: SELECT 'N'
602: INTO l_return_val
603: FROM dual
604: WHERE EXISTS (SELECT 'N'
605: FROM po_change_requests
606: WHERE change_request_group_id = p_reqgrp_id
607: AND action_type = 'MODIFICATION'
608: AND request_status = 'SYSTEMSAVE'
609: AND request_level = 'LINE'

Line 653: FROM PO_CHANGE_REQUESTS PCR,

649: INTO l_return_val
650: FROM dual
651: WHERE EXISTS (SELECT 'N' FROM (
652: SELECT PRL.UNIT_PRICE AS UNIT_PRICE, PRL.QUANTITY AS QUANTITY,PCR.NEW_QUANTITY AS NEW_QUANTITY
653: FROM PO_CHANGE_REQUESTS PCR,
654: PO_REQUISITION_LINES_ALL PRL
655: WHERE PCR.CHANGE_REQUEST_GROUP_ID = p_reqgrp_id
656: AND PCR.ACTION_TYPE = 'MODIFICATION'
657: AND PCR.REQUEST_STATUS NOT IN ('ACCEPTED',

Line 681: FROM po_change_requests pcr,

677: SELECT 'N'
678: INTO l_return_val
679: FROM dual
680: WHERE EXISTS (SELECT 'N'
681: FROM po_change_requests pcr,
682: po_change_requests pcr1,
683: po_requisition_lines_all prl,
684: po_req_distributions_all prd
685: WHERE prd.requisition_line_id = prl.requisition_line_id

Line 682: po_change_requests pcr1,

678: INTO l_return_val
679: FROM dual
680: WHERE EXISTS (SELECT 'N'
681: FROM po_change_requests pcr,
682: po_change_requests pcr1,
683: po_requisition_lines_all prl,
684: po_req_distributions_all prd
685: WHERE prd.requisition_line_id = prl.requisition_line_id
686: AND pcr.change_request_group_id = p_reqgrp_id

Line 749: FROM po_change_requests pcr,

745: l_tolerances_tbl(tol_reqtotal_ind).max_decrement,
746: l_tolerances_tbl(tol_reqtotal_amt_ind).max_increment,
747: l_tolerances_tbl(tol_reqtotal_amt_ind).max_decrement)
748: INTO l_return_val
749: FROM po_change_requests pcr,
750: po_change_requests pcr1,
751: po_requisition_lines_all prl,
752: po_req_distributions_all prd
753: WHERE prl.requisition_line_id = prd.requisition_line_id

Line 750: po_change_requests pcr1,

746: l_tolerances_tbl(tol_reqtotal_amt_ind).max_increment,
747: l_tolerances_tbl(tol_reqtotal_amt_ind).max_decrement)
748: INTO l_return_val
749: FROM po_change_requests pcr,
750: po_change_requests pcr1,
751: po_requisition_lines_all prl,
752: po_req_distributions_all prd
753: WHERE prl.requisition_line_id = prd.requisition_line_id
754: AND pcr.change_request_group_id (+ ) = p_reqgrp_id

Line 850: po_change_requests pcr

846: requisition_header_id
847: INTO l_org_id,
848: l_reqheader_id
849: FROM po_requisition_headers prh,
850: po_change_requests pcr
851: WHERE pcr.change_request_group_id = p_chreqgrp_id
852: AND pcr.document_header_id = prh.requisition_header_id
853: AND ROWNUM = 1;
854:

Line 869: UPDATE po_change_requests

865: || x_appr_status);
866: END IF;
867:
868:
869: UPDATE po_change_requests
870: SET approval_required_flag = x_appr_status
871: WHERE change_request_group_id = p_chreqgrp_id;
872: END set_approval_required_flag;
873: END po_rcotolerance_pvt;