APPS.AS_OPP_HEADER_PVT dependencies on AS_SALES_CREDITS

Line 1467: From as_sales_credits

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

Line 2104: Update as_sales_credits

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

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

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

Line 2129: Update as_sales_credits set opp_forecast_amount = l_opp_forecast_amount

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

Line 2135: Update as_sales_credits

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