APPS.AS_OPP_LINE_PVT dependencies on AS_SALES_CREDITS

Line 33: FROM as_sales_credits

29: WHERE lead_id = p_lead_id;
30: -- Cursor added for ASNB
31: CURSOR C_renue_opp_forst_tot IS
32: SELECT nvl(sum(OPP_FORECAST_AMOUNT),0) credit_total
33: FROM as_sales_credits
34: WHERE lead_id = p_lead_id
35: AND credit_type_id = FND_PROFILE.VALUE('AS_FORECAST_CREDIT_TYPE_ID');
36:
37: l_line_total NUMBER;

Line 102: Update as_sales_credits

98: IF l_opp_worst_forecast_amount IS NOT NULL OR
99: l_opp_forecast_amount IS NOT NULL OR
100: l_opp_best_forecast_amount IS NOT NULL
101: THEN
102: Update as_sales_credits
103: Set opp_worst_forecast_amount = nvl(l_opp_worst_forecast_amount,
104: opp_worst_forecast_amount),
105: opp_forecast_amount = nvl(l_opp_forecast_amount,
106: opp_forecast_amount),

Line 142: FROM as_sales_credits

138: SELECT sales_credit_id,
139: credit_amount,
140: credit_percent,
141: credit_type_id
142: FROM as_sales_credits
143: WHERE lead_line_id = c_lead_line_id;
144:
145: l_credit_percent NUMBER;
146: l_credit_amount NUMBER;

Line 207: UPDATE as_sales_credits

203: l_opp_best_forecast_amount := p_opp_best_forecast_amount;
204: END IF;
205: END IF;
206:
207: UPDATE as_sales_credits
208: SET object_version_number = nvl(object_version_number,0) + 1, credit_percent = l_credit_percent,
209: credit_amount = l_credit_amount,
210: last_update_date = SYSDATE,
211: last_updated_by = FND_GLOBAL.USER_ID,

Line 252: UPDATE as_sales_credits

248: END IF;
249: END IF;
250:
251:
252: UPDATE as_sales_credits
253: SET object_version_number = nvl(object_version_number,0) + 1, credit_percent = l_credit_percent,
254: credit_amount = l_credit_amount,
255: last_update_date = SYSDATE,
256: last_updated_by = FND_GLOBAL.USER_ID,

Line 1998: from as_sales_credits

1994: IS
1995:
1996: CURSOR C_sales_credits(c_lead_line_id NUMBER) IS
1997: SELECT sales_credit_id
1998: from as_sales_credits
1999: WHERE lead_line_id = c_lead_line_id;
2000:
2001: CURSOR C_decision_factors(c_lead_line_id NUMBER) IS
2002: SELECT lead_decision_factor_id

Line 2197: AS_SALES_CREDITS_PKG.Delete_Row(

2193:
2194: -- Delete sales credits under this line
2195:
2196: FOR sc_c IN C_sales_credits(l_Line_rec.LEAD_LINE_ID) LOOP
2197: AS_SALES_CREDITS_PKG.Delete_Row(
2198: p_SALES_CREDIT_ID => sc_c.sales_credit_id );
2199: END LOOP;
2200:
2201: FOR df_c IN C_decision_factors(l_Line_rec.LEAD_LINE_ID) LOOP