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 1399: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN

1395:
1396: END IF; -- orders on hold flag
1397:
1398: -- Check Commitment Total if Commitment Sequencing "On"
1399: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
1400:
1401: OPEN commitment_total;
1402: FETCH commitment_total INTO l_total_commitment;
1403: IF commitment_total%notfound THEN

Line 1584: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN

1580:
1581: END IF; -- check orders on hold
1582:
1583: -- Check Commitment Total if Commitment Sequencing "On"
1584: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
1585:
1586: OPEN site_commitment_total;
1587: FETCH site_commitment_total INTO l_total_commitment;
1588: IF site_commitment_total%notfound THEN

Line 1797: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN

1793: END IF;
1794: */
1795:
1796: -- Get Total Commitments applied to the current order if Commitment Sequencing is "On"
1797: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
1798:
1799: SELECT NVL(SUM(P.commitment_applied_amount), 0)
1800: INTO l_order_commitment
1801: FROM OE_PAYMENTS P, OE_ORDER_LINES L

Line 3070: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN

3066: to_char(l_total_exposure));
3067: END IF; -- l_orders_on_hold_flag
3068:
3069: -- Check Commitment Total if Commitment Sequencing "On"
3070: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
3071:
3072: OPEN commitment_total;
3073: FETCH commitment_total INTO l_total_commitment;
3074: IF commitment_total%notfound THEN

Line 3236: IF OE_Commitment_PVT.do_Commitment_Sequencing THEN

3232:
3233: END IF; -- check orders on hold
3234:
3235: -- Check Commitment Total if Commitment Sequencing "On"
3236: IF OE_Commitment_PVT.do_Commitment_Sequencing THEN
3237:
3238: OPEN site_commitment_total;
3239: FETCH site_commitment_total INTO l_total_commitment;
3240: IF site_commitment_total%notfound THEN