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 1433: FROM AS_LEADS_ALL

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

Line 1439: from as_leads_all

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

Line 1444: from as_leads_all

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

Line 1450: from as_leads_all ld,

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

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

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

Line 2083: From as_leads_all lead, as_statuses_vl status

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

Line 2115: UPDATE AS_LEADS_ALL

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

Line 2146: UPDATE AS_LEADS_ALL

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

Line 4039: FROM as_leads_all

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

Line 4061: -- METHODOLOGY_CODE should exist in as_leads_all

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