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 577: FROM po_change_requests

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

Line 602: FROM po_change_requests

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

Line 650: FROM PO_CHANGE_REQUESTS PCR,

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

Line 678: FROM po_change_requests pcr,

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

Line 679: po_change_requests pcr1,

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

Line 746: FROM po_change_requests pcr,

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

Line 747: po_change_requests pcr1,

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

Line 847: po_change_requests pcr

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

Line 866: UPDATE po_change_requests

862: || x_appr_status);
863: END IF;
864:
865:
866: UPDATE po_change_requests
867: SET approval_required_flag = x_appr_status
868: WHERE change_request_group_id = p_chreqgrp_id;
869: END set_approval_required_flag;
870: END po_rcotolerance_pvt;