APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_RCOTOLERANCE_PVT

Line 10809: ((PO_RCOTOLERANCE_PVT.changes_within_tol(

10805: AND pcr1.initiator(+) = 'REQUESTER'
10806: AND pcr1.new_price(+) IS NOT NULL
10807: GROUP BY pcr.document_line_location_id
10808: HAVING
10809: ((PO_RCOTOLERANCE_PVT.changes_within_tol(
10810: sum(decode(pl.matching_basis, 'AMOUNT', pod.amount_ordered, pl.unit_price * (pod.quantity_ordered-nvl(pod.quantity_cancelled,0)))),
10811: 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))),
10812: p_tolerances_tab(TOL_SHIPAMT_IND).max_increment,
10813: p_tolerances_tab(TOL_SHIPAMT_IND).max_decrement,

Line 10817: (PO_RCOTOLERANCE_PVT.change_within_tol_percent(

10813: p_tolerances_tab(TOL_SHIPAMT_IND).max_decrement,
10814: p_tolerances_tab(TOL_SHIPAMT_AMT_IND).max_increment,
10815: p_tolerances_tab(TOL_SHIPAMT_AMT_IND).max_decrement) = 'N')
10816: OR
10817: (PO_RCOTOLERANCE_PVT.change_within_tol_percent(
10818: sum(pod.quantity_ordered-nvl(pod.quantity_cancelled,0)),
10819: sum(nvl(pcr.new_quantity, pod.quantity_ordered-nvl(pod.quantity_cancelled, 0))),
10820: p_tolerances_tab(TOL_SHIPQTY_IND).max_increment,
10821: p_tolerances_tab(TOL_SHIPQTY_IND).max_decrement) = 'N')));

Line 10894: PO_RCOTOLERANCE_PVT.change_within_tol_date(

10890: AND action_type='MODIFICATION'
10891: AND request_status not in ('ACCEPTED', 'REJECTED')
10892: AND request_level='SHIPMENT'
10893: AND
10894: PO_RCOTOLERANCE_PVT.change_within_tol_date(
10895: old_need_by_date,
10896: new_need_by_date,
10897: p_tolerances_tab(TOL_NEEDBY_IND).max_increment,
10898: p_tolerances_tab(TOL_NEEDBY_IND).max_decrement) = 'N');

Line 10925: (PO_RCOTOLERANCE_PVT.change_within_tol_date(

10921: AND action_type='MODIFICATION'
10922: AND request_status not in ('ACCEPTED', 'REJECTED')
10923: AND request_level='LINE'
10924: AND (
10925: (PO_RCOTOLERANCE_PVT.change_within_tol_date(
10926: old_start_date,
10927: new_start_date,
10928: p_tolerances_tab(TOL_STARTDATE_IND).max_increment,
10929: p_tolerances_tab(TOL_STARTDATE_IND).max_decrement) = 'N')

Line 10931: (PO_RCOTOLERANCE_PVT.change_within_tol_date(

10927: new_start_date,
10928: p_tolerances_tab(TOL_STARTDATE_IND).max_increment,
10929: p_tolerances_tab(TOL_STARTDATE_IND).max_decrement) = 'N')
10930: OR
10931: (PO_RCOTOLERANCE_PVT.change_within_tol_date(
10932: old_expiration_date,
10933: new_expiration_date,
10934: p_tolerances_tab(TOL_ENDDATE_IND).max_increment,
10935: p_tolerances_tab(TOL_ENDDATE_IND).max_decrement) = 'N')

Line 10937: (PO_RCOTOLERANCE_PVT.change_within_tol_percent(

10933: new_expiration_date,
10934: p_tolerances_tab(TOL_ENDDATE_IND).max_increment,
10935: p_tolerances_tab(TOL_ENDDATE_IND).max_decrement) = 'N')
10936: OR
10937: (PO_RCOTOLERANCE_PVT.change_within_tol_percent(
10938: old_price,
10939: new_price,
10940: p_tolerances_tab(TOL_UNITPRICE_IND).max_increment,
10941: p_tolerances_tab(TOL_UNITPRICE_IND).max_decrement) = 'N'))

Line 10988: l_return_val := PO_RCOTOLERANCE_PVT.changes_within_tol(

10984: end if;
10985: l_progress:= '006';
10986:
10987:
10988: l_return_val := PO_RCOTOLERANCE_PVT.changes_within_tol(
10989: l_old_amount,
10990: l_new_amount,
10991: p_tolerances_tab(TOL_LINEAMT_IND).max_increment,
10992: p_tolerances_tab(TOL_LINEAMT_IND).max_decrement,

Line 11054: SELECT PO_RCOTOLERANCE_PVT.changes_within_tol(

11050: where change_request_group_id = p_pochggrp_id;
11051:
11052: if ( l_document_type = 'PO' ) then
11053:
11054: SELECT PO_RCOTOLERANCE_PVT.changes_within_tol(
11055: sum(decode(pl.matching_basis,
11056: 'AMOUNT',
11057: pod.amount_ordered,
11058: pl.unit_price * (pod.quantity_ordered-nvl(pod.quantity_cancelled,0)))),

Line 11124: l_return_val:= PO_RCOTOLERANCE_PVT.changes_within_tol(

11120: AND pcr.document_line_location_id =pll.line_location_id (+)
11121: AND pcr.request_level<>'DISTRIBUTION'
11122: AND pcr.initiator(+) = 'REQUESTER';
11123:
11124: l_return_val:= PO_RCOTOLERANCE_PVT.changes_within_tol(
11125: l_old_amount_release,
11126: l_new_amount_release,
11127: p_tolerances_tab(TOL_POTOTAL_IND).max_increment,
11128: p_tolerances_tab(TOL_POTOTAL_IND).max_decrement,