APPS.AS_OPP_HEADER_PVT dependencies on AS_LEADS_ALL

Line 44: -- Add freeze_flag in as_leads_all and do relevant change.

40: -- if it is NULL or G_MISS_CHAR (when creating)
41: -- 2. add parameter p_mode to Set_opp_default_values to
42: -- tell if calling by create or update
43: -- 01-11-01 SOLIN For bug 1554330,
44: -- Add freeze_flag in as_leads_all and do relevant change.
45: -- 03-sep-03 NKAMBLE Validate_DecisionDate procedure added as an enhancement# 3125485
46: -- 12-sep-03 NKAMBLE FOR Bug#3133993, changed VALIDATE_SOURCE_PROMOTION_ID procedure cursor
47: -- c_source_promotion_id_exists
48: -- NOTE :

Line 618: UPDATE AS_LEADS_ALL

614: UPDATE AS_ACCESSES_ALL
615: SET object_version_number = nvl(object_version_number,0) + 1, OWNER_FLAG = 'Y'
616: WHERE ACCESS_ID = p_access_id;
617:
618: UPDATE AS_LEADS_ALL
619: SET object_version_number = nvl(object_version_number,0) + 1, owner_salesforce_id = acr.salesforce_id,
620: owner_sales_group_id = acr.sales_group_id
621: WHERE lead_id = acr.lead_id;
622:

Line 1434: FROM AS_LEADS_ALL

1430: WIN_PROBABILITY, nvl(TOTAL_REVENUE_OPP_FORECAST_AMT, 0), STATUS,
1431: SALES_STAGE_ID, DECISION_DATE, LEAD_NUMBER, FREEZE_FLAG,
1432: sales_methodology_id, sales_stage_id, customer_id, address_id,
1433: owner_salesforce_id, owner_sales_group_id
1434: FROM AS_LEADS_ALL
1435: WHERE LEAD_ID = c_LEAD_ID
1436: For Update NOWAIT;
1437:
1438: cursor c_close_reason(p_lead_id NUMBER) IS

Line 1440: from as_leads_all

1436: For Update NOWAIT;
1437:
1438: cursor c_close_reason(p_lead_id NUMBER) IS
1439: select close_reason
1440: from as_leads_all
1441: where lead_id = p_lead_id;
1442:
1443: cursor close_competitor_exist(p_lead_id NUMBER) IS
1444: select 'Y'

Line 1445: from as_leads_all

1441: where lead_id = p_lead_id;
1442:
1443: cursor close_competitor_exist(p_lead_id NUMBER) IS
1444: select 'Y'
1445: from as_leads_all
1446: where lead_id = p_lead_id
1447: and close_competitor_id is not null;
1448:
1449: cursor comp_required ( p_status_profile VARCHAR2, p_lead_id NUMBER) IS

Line 1451: from as_leads_all ld,

1447: and close_competitor_id is not null;
1448:
1449: cursor comp_required ( p_status_profile VARCHAR2, p_lead_id NUMBER) IS
1450: select 'Y'
1451: from as_leads_all ld,
1452: as_statuses_b st
1453: where ld.status = st.status_code
1454: and ld.lead_id = p_lead_id
1455: and (( p_status_profile = 'BOTH' and

Line 1465: CURSOR c_sales_credit_amount (p_lead_id as_leads_all.lead_id%type) IS

1461: select employee_person_id
1462: from as_salesforce_v
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:

Line 2084: From as_leads_all lead, as_statuses_vl status

2080: Select lead.win_probability, status.win_loss_indicator,
2081: status.forecast_rollup_flag
2082: Into l_win_probability, l_win_loss_indicator,
2083: l_forecast_rollup_flag
2084: From as_leads_all lead, as_statuses_vl status
2085: Where lead_id = l_Header_rec.LEAD_ID
2086: And lead.status = status.status_code(+);
2087:
2088: IF AS_OPP_SALES_CREDIT_PVT.Apply_Forecast_Defaults(

Line 2116: UPDATE AS_LEADS_ALL

2112: l_tot_rev_opp_forecast_amt := nvl(l_tot_rev_opp_forecast_amt,0) + nvl(l_opp_forecast_amount,0);
2113: END IF;
2114: END LOOP;
2115: -- The following update added for ASNB
2116: UPDATE AS_LEADS_ALL
2117: SET TOTAL_REVENUE_OPP_FORECAST_AMT = nvl(l_tot_rev_opp_forecast_amt,0)
2118: WHERE lead_id = l_Header_rec.lead_id;
2119: ELSIF nvl(l_tot_rev_opp_forecast_amt, 0) <> FND_API.G_MISS_NUM THEN
2120: l_update_count := 0;

Line 2147: UPDATE AS_LEADS_ALL

2143: IF l_update_count = 0 THEN
2144: l_tot_rev_opp_forecast_amt := NULL;
2145: END IF;
2146:
2147: UPDATE AS_LEADS_ALL
2148: SET TOTAL_REVENUE_OPP_FORECAST_AMT = l_tot_rev_opp_forecast_amt
2149: WHERE lead_id = l_Header_rec.lead_id;
2150: END IF;
2151:

Line 4040: FROM as_leads_all

4036: )
4037: IS
4038: CURSOR C_ORIGINAL_LEAD_ID_Exists (c_ORIGINAL_LEAD_ID VARCHAR2) IS
4039: SELECT 'X'
4040: FROM as_leads_all
4041: WHERE lead_id = c_original_lead_id;
4042:
4043: l_val VARCHAR2(1);
4044: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Validate_ORIGINAL_LEAD_ID';

Line 4062: -- METHODOLOGY_CODE should exist in as_leads_all

4058:
4059: IF (p_ORIGINAL_LEAD_ID is NOT NULL) and
4060: (p_ORIGINAL_LEAD_ID <> FND_API.G_MISS_NUM)
4061: THEN
4062: -- METHODOLOGY_CODE should exist in as_leads_all
4063: OPEN C_ORIGINAL_LEAD_ID_Exists (p_ORIGINAL_LEAD_ID);
4064: FETCH C_ORIGINAL_LEAD_ID_Exists into l_val;
4065:
4066: IF C_ORIGINAL_LEAD_ID_Exists%NOTFOUND THEN