DBA Data[Home] [Help]

APPS.OE_CREDIT_PUB dependencies on OE_COMMITMENT_PVT

Line 135: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN

131: FROM OE_ORDER_LINES
132: WHERE HEADER_ID = p_header_rec.header_id;
133:
134: -- Get Total Commitments applied to the current order if Commitment Sequencing is "On"
135: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
136:
137: SELECT NVL(SUM(commitment_applied_amount), 0)
138: INTO l_order_commitment
139: FROM OE_PAYMENTS

Line 1381: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN

1377:
1378: END IF; -- orders on hold flag
1379:
1380: -- Check Commitment Total if Commitment Sequencing "On"
1381: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
1382:
1383: OPEN commitment_total;
1384: FETCH commitment_total INTO l_total_commitment;
1385: IF commitment_total%notfound THEN

Line 1566: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN

1562:
1563: END IF; -- check orders on hold
1564:
1565: -- Check Commitment Total if Commitment Sequencing "On"
1566: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
1567:
1568: OPEN site_commitment_total;
1569: FETCH site_commitment_total INTO l_total_commitment;
1570: IF site_commitment_total%notfound THEN

Line 1779: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN

1775: END IF;
1776: */
1777:
1778: -- Get Total Commitments applied to the current order if Commitment Sequencing is "On"
1779: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
1780:
1781: SELECT NVL(SUM(P.commitment_applied_amount), 0)
1782: INTO l_order_commitment
1783: FROM OE_PAYMENTS P, OE_ORDER_LINES L

Line 3034: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN

3030: to_char(l_total_exposure));
3031: END IF; -- l_orders_on_hold_flag
3032:
3033: -- Check Commitment Total if Commitment Sequencing "On"
3034: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
3035:
3036: OPEN commitment_total;
3037: FETCH commitment_total INTO l_total_commitment;
3038: IF commitment_total%notfound THEN

Line 3200: IF OE_Commitment_PVT.do_Commitment_Sequencing THEN

3196:
3197: END IF; -- check orders on hold
3198:
3199: -- Check Commitment Total if Commitment Sequencing "On"
3200: IF OE_Commitment_PVT.do_Commitment_Sequencing THEN
3201:
3202: OPEN site_commitment_total;
3203: FETCH site_commitment_total INTO l_total_commitment;
3204: IF site_commitment_total%notfound THEN