APPS.AS_OPP_HEADER_PVT dependencies on AS_SALES_CREDITS

Line 1466: From as_sales_credits

1462: where salesforce_id = c_salesforce_id;
1463:
1464: CURSOR c_sales_credit_amount (p_lead_id as_leads_all.lead_id%type) IS
1465: Select sales_credit_id, credit_type_id,credit_amount
1466: From as_sales_credits
1467: Where lead_id = p_lead_id;
1468:
1469: CURSOR c_get_status_flags (p_status_code VARCHAR2) IS
1470: Select status.win_loss_indicator,

Line 2103: Update as_sales_credits

2099: l_win_probability, l_win_loss_indicator, l_forecast_rollup_flag,
2100: curr_rec_sc_amt.credit_amount, 'ON-UPDATE',
2101: l_opp_worst_forecast_amount, l_opp_forecast_amount,
2102: l_opp_best_forecast_amount);
2103: Update as_sales_credits
2104: Set object_version_number = nvl(object_version_number, 0) + 1,
2105: opp_worst_forecast_amount = l_opp_worst_forecast_amount,
2106: opp_forecast_amount = l_opp_forecast_amount,
2107: opp_best_forecast_amount = l_opp_best_forecast_amount

Line 2123: Select count(*) into l_count from as_sales_credits

2119: l_update_count := 0;
2120: -- Trickle down supplied TOTAL_REVENUE_OPP_FORECAST_AMT to
2121: -- sales credits/lines
2122: IF l_old_tot_rev_opp_forecast_amt = 0 THEN
2123: Select count(*) into l_count from as_sales_credits
2124: where lead_id = l_Header_rec.LEAD_ID and
2125: credit_type_id = l_forecast_credit_type_id;
2126: IF l_count > 0 THEN -- Equally distribute
2127: l_opp_forecast_amount := nvl(l_tot_rev_opp_forecast_amt, 0)/l_count;

Line 2128: Update as_sales_credits set opp_forecast_amount = l_opp_forecast_amount

2124: where lead_id = l_Header_rec.LEAD_ID and
2125: credit_type_id = l_forecast_credit_type_id;
2126: IF l_count > 0 THEN -- Equally distribute
2127: l_opp_forecast_amount := nvl(l_tot_rev_opp_forecast_amt, 0)/l_count;
2128: Update as_sales_credits set opp_forecast_amount = l_opp_forecast_amount
2129: where lead_id = l_Header_rec.LEAD_ID AND
2130: credit_type_id = l_forecast_credit_type_id;
2131: l_update_count := SQL%ROWCOUNT;
2132: END IF;

Line 2134: Update as_sales_credits

2130: credit_type_id = l_forecast_credit_type_id;
2131: l_update_count := SQL%ROWCOUNT;
2132: END IF;
2133: ELSE
2134: Update as_sales_credits
2135: Set opp_forecast_amount =
2136: nvl(l_tot_rev_opp_forecast_amt, 0) * (nvl(opp_forecast_amount, 0)/l_old_tot_rev_opp_forecast_amt)
2137: where lead_id = l_Header_rec.LEAD_ID AND
2138: credit_type_id = l_forecast_credit_type_id;