APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_RCOTOLERANCE_PVT

Line 10419: ((PO_RCOTOLERANCE_PVT.changes_within_tol(

10415: AND pcr1.initiator(+) = 'REQUESTER'
10416: AND pcr1.new_price(+) IS NOT NULL
10417: GROUP BY pcr.document_line_location_id
10418: HAVING
10419: ((PO_RCOTOLERANCE_PVT.changes_within_tol(
10420: sum(decode(pl.matching_basis, 'AMOUNT', pod.amount_ordered, pl.unit_price * (pod.quantity_ordered-nvl(pod.quantity_cancelled,0)))),
10421: sum(decode(pl.matching_basis, 'AMOUNT', nvl(pcr.new_amount, pod.amount_ordered), nvl(pcr.new_quantity,pod.quantity_ordered)*nvl(pcr1.new_price, pl.unit_price))),
10422: p_tolerances_tab(TOL_SHIPAMT_IND).max_increment,
10423: p_tolerances_tab(TOL_SHIPAMT_IND).max_decrement,

Line 10427: (PO_RCOTOLERANCE_PVT.change_within_tol_percent(

10423: p_tolerances_tab(TOL_SHIPAMT_IND).max_decrement,
10424: p_tolerances_tab(TOL_SHIPAMT_AMT_IND).max_increment,
10425: p_tolerances_tab(TOL_SHIPAMT_AMT_IND).max_decrement) = 'N')
10426: OR
10427: (PO_RCOTOLERANCE_PVT.change_within_tol_percent(
10428: sum(pod.quantity_ordered-nvl(pod.quantity_cancelled,0)),
10429: sum(nvl(pcr.new_quantity, pod.quantity_ordered-nvl(pod.quantity_cancelled, 0))),
10430: p_tolerances_tab(TOL_SHIPQTY_IND).max_increment,
10431: p_tolerances_tab(TOL_SHIPQTY_IND).max_decrement) = 'N')));

Line 10504: PO_RCOTOLERANCE_PVT.change_within_tol_date(

10500: AND action_type='MODIFICATION'
10501: AND request_status not in ('ACCEPTED', 'REJECTED')
10502: AND request_level='SHIPMENT'
10503: AND
10504: PO_RCOTOLERANCE_PVT.change_within_tol_date(
10505: old_need_by_date,
10506: new_need_by_date,
10507: p_tolerances_tab(TOL_NEEDBY_IND).max_increment,
10508: p_tolerances_tab(TOL_NEEDBY_IND).max_decrement) = 'N');

Line 10535: (PO_RCOTOLERANCE_PVT.change_within_tol_date(

10531: AND action_type='MODIFICATION'
10532: AND request_status not in ('ACCEPTED', 'REJECTED')
10533: AND request_level='LINE'
10534: AND (
10535: (PO_RCOTOLERANCE_PVT.change_within_tol_date(
10536: old_start_date,
10537: new_start_date,
10538: p_tolerances_tab(TOL_STARTDATE_IND).max_increment,
10539: p_tolerances_tab(TOL_STARTDATE_IND).max_decrement) = 'N')

Line 10541: (PO_RCOTOLERANCE_PVT.change_within_tol_date(

10537: new_start_date,
10538: p_tolerances_tab(TOL_STARTDATE_IND).max_increment,
10539: p_tolerances_tab(TOL_STARTDATE_IND).max_decrement) = 'N')
10540: OR
10541: (PO_RCOTOLERANCE_PVT.change_within_tol_date(
10542: old_expiration_date,
10543: new_expiration_date,
10544: p_tolerances_tab(TOL_ENDDATE_IND).max_increment,
10545: p_tolerances_tab(TOL_ENDDATE_IND).max_decrement) = 'N')

Line 10547: (PO_RCOTOLERANCE_PVT.change_within_tol_percent(

10543: new_expiration_date,
10544: p_tolerances_tab(TOL_ENDDATE_IND).max_increment,
10545: p_tolerances_tab(TOL_ENDDATE_IND).max_decrement) = 'N')
10546: OR
10547: (PO_RCOTOLERANCE_PVT.change_within_tol_percent(
10548: old_price,
10549: new_price,
10550: p_tolerances_tab(TOL_UNITPRICE_IND).max_increment,
10551: p_tolerances_tab(TOL_UNITPRICE_IND).max_decrement) = 'N'))

Line 10598: l_return_val := PO_RCOTOLERANCE_PVT.changes_within_tol(

10594: end if;
10595: l_progress:= '006';
10596:
10597:
10598: l_return_val := PO_RCOTOLERANCE_PVT.changes_within_tol(
10599: l_old_amount,
10600: l_new_amount,
10601: p_tolerances_tab(TOL_LINEAMT_IND).max_increment,
10602: p_tolerances_tab(TOL_LINEAMT_IND).max_decrement,

Line 10664: SELECT PO_RCOTOLERANCE_PVT.changes_within_tol(

10660: where change_request_group_id = p_pochggrp_id;
10661:
10662: if ( l_document_type = 'PO' ) then
10663:
10664: SELECT PO_RCOTOLERANCE_PVT.changes_within_tol(
10665: sum(decode(pl.matching_basis,
10666: 'AMOUNT',
10667: pod.amount_ordered,
10668: pl.unit_price * (pod.quantity_ordered-nvl(pod.quantity_cancelled,0)))),

Line 10734: l_return_val:= PO_RCOTOLERANCE_PVT.changes_within_tol(

10730: AND pcr.document_line_location_id =pll.line_location_id (+)
10731: AND pcr.request_level<>'DISTRIBUTION'
10732: AND pcr.initiator(+) = 'REQUESTER';
10733:
10734: l_return_val:= PO_RCOTOLERANCE_PVT.changes_within_tol(
10735: l_old_amount_release,
10736: l_new_amount_release,
10737: p_tolerances_tab(TOL_POTOTAL_IND).max_increment,
10738: p_tolerances_tab(TOL_POTOTAL_IND).max_decrement,