eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on AS_SALES_LEADS

Line 264: X_Assign_Id_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.Assign_Id_Tbl_Type

260: P_Sales_Lead_Id IN NUMBER,
261: X_Return_Status OUT NOCOPY VARCHAR2,
262: X_Msg_Count OUT NOCOPY NUMBER,
263: X_Msg_Data OUT NOCOPY VARCHAR2,
264: X_Assign_Id_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.Assign_Id_Tbl_Type
265: )
266: IS
267: -- bug 1530383
268: -- solin. Change the cursor for party with site, party without site.

Line 271: FROM AS_SALES_LEADS SL

267: -- bug 1530383
268: -- solin. Change the cursor for party with site, party without site.
269: CURSOR C_Get_Address_Id(c_sales_lead_id NUMBER) IS
270: SELECT SL.ADDRESS_ID
271: FROM AS_SALES_LEADS SL
272: WHERE SL.SALES_LEAD_ID = c_sales_lead_id;
273:
274: -- Bug 3035251
275: -- Add UPPER for all VARCHAR2 qualifiers

Line 299: FROM AS_SALES_LEADS SL,

295: UPPER(SL.CURRENCY_CODE),
296: TRUNC(SL.CREATION_DATE),
297: SL.SOURCE_PROMOTION_ID,
298: TO_NUMBER(NULL)
299: FROM AS_SALES_LEADS SL,
300: HZ_CONTACT_POINTS PHONE,
301: HZ_LOCATIONS ADDR,
302: HZ_PARTY_SITES SITE,
303: HZ_PARTIES PARTY

Line 341: FROM AS_SALES_LEADS SL,

337: UPPER(SL.CURRENCY_CODE),
338: TRUNC(SL.CREATION_DATE),
339: SL.SOURCE_PROMOTION_ID,
340: NULL
341: FROM AS_SALES_LEADS SL,
342: HZ_CONTACT_POINTS PHONE,
343: HZ_PARTIES PARTY
344: WHERE SL.SALES_LEAD_ID = X_Sales_Lead_Id
345: AND SL.CUSTOMER_ID = PARTY.PARTY_ID

Line 880: FROM AS_SALES_LEADS SL

876: SL.ASSIGN_TO_SALESFORCE_ID,
877: SL.ASSIGN_SALES_GROUP_ID,
878: SL.REFERRAL_TYPE,
879: SL.REFERRED_BY
880: FROM AS_SALES_LEADS SL
881: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id;
882:
883: CURSOR C_Validate_Partner_User(c_resource_id NUMBER) IS
884: SELECT 'Y'

Line 944: FROM AS_SALES_LEADS SL,

940: ORGP.CURR_FY_POTENTIAL_REVENUE,
941: UPPER(ORGP.PREF_FUNCTIONAL_CURRENCY),
942: UPPER(PARTY.DUNS_NUMBER_C),
943: UPPER(SL.CHANNEL_CODE)
944: FROM AS_SALES_LEADS SL,
945: HZ_CONTACT_POINTS PHONE,
946: HZ_LOCATIONS ADDR,
947: HZ_PARTY_SITES SITE,
948: HZ_PARTIES PARTY,

Line 996: FROM AS_SALES_LEADS SL,

992: ORGP.CURR_FY_POTENTIAL_REVENUE,
993: UPPER(ORGP.PREF_FUNCTIONAL_CURRENCY),
994: UPPER(PARTY.DUNS_NUMBER_C),
995: UPPER(SL.CHANNEL_CODE)
996: FROM AS_SALES_LEADS SL,
997: HZ_CONTACT_POINTS PHONE,
998: HZ_PARTIES PARTY,
999: HZ_ORGANIZATION_PROFILES ORGP
1000: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id

Line 2033: FROM AS_SALES_LEADS SL

2029: SL.ADDRESS_ID,
2030: SL.ASSIGN_TO_SALESFORCE_ID,
2031: SL.ASSIGN_SALES_GROUP_ID,
2032: SL.REJECT_REASON_CODE
2033: FROM AS_SALES_LEADS SL
2034: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id;
2035:
2036: -- Bug 3035251
2037: -- Add UPPER for all VARCHAR2 qualifiers

Line 2068: FROM AS_SALES_LEADS SL,

2064: ORGP.CURR_FY_POTENTIAL_REVENUE,
2065: UPPER(ORGP.PREF_FUNCTIONAL_CURRENCY),
2066: UPPER(PARTY.DUNS_NUMBER_C),
2067: UPPER(SL.CHANNEL_CODE)
2068: FROM AS_SALES_LEADS SL,
2069: HZ_CONTACT_POINTS PHONE,
2070: HZ_LOCATIONS ADDR,
2071: HZ_PARTY_SITES SITE,
2072: HZ_PARTIES PARTY,

Line 2120: FROM AS_SALES_LEADS SL,

2116: ORGP.CURR_FY_POTENTIAL_REVENUE,
2117: UPPER(ORGP.PREF_FUNCTIONAL_CURRENCY),
2118: UPPER(PARTY.DUNS_NUMBER_C),
2119: UPPER(SL.CHANNEL_CODE)
2120: FROM AS_SALES_LEADS SL,
2121: HZ_CONTACT_POINTS PHONE,
2122: HZ_PARTIES PARTY,
2123: HZ_ORGANIZATION_PROFILES ORGP
2124: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id

Line 3238: FROM AS_SALES_LEADS lead

3234: Amount_Enabled VARCHAR2(1);
3235:
3236: CURSOR c0(C_Sales_Lead_Id NUMBER) IS
3237: SELECT Customer_Id, Address_Id
3238: FROM AS_SALES_LEADS lead
3239: WHERE lead.sales_lead_Id = C_Sales_Lead_Id;
3240:
3241: -- Bug 3091085, SOLIN(Bug 3087354 for 11.5.8)
3242: -- Use JTF_QUAL_USGS_ALL, instead of JTF_QUAL_USGS(with security policies)

Line 3863: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

3859: -- Get lead_rank_score and lead creation_date
3860: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
3861: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
3862: NVL(rk.min_score, 0), sl.creation_date
3863: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
3864: WHERE sl.sales_lead_id = c_sales_lead_id
3865: AND sl.status_code = sta.status_code
3866: AND sl.lead_rank_id = rk.rank_id(+);
3867: BEGIN

Line 4164: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

4160: -- Get lead_rank_score and lead creation_date
4161: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
4162: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
4163: NVL(rk.min_score, 0), sl.creation_date
4164: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
4165: WHERE sl.sales_lead_id = c_sales_lead_id
4166: AND sl.status_code = sta.status_code
4167: AND sl.lead_rank_id = rk.rank_id(+);
4168:

Line 4290: | AS_SALES_LEADS_LOG, AS_SALES_LEADS, AS_ACCESSES_ALL will be updated.

4286: | NOTES
4287: | This procedure will get resource_id from the profile
4288: | AS_DEFAULT_RESOURCE_ID. If this profile is not set, it will get
4289: | current user's resource_id. Once resource_id is gotten
4290: | AS_SALES_LEADS_LOG, AS_SALES_LEADS, AS_ACCESSES_ALL will be updated.
4291: |
4292: | HISTORY
4293: | 12/05/01 SOLIN Created
4294: *-------------------------------------------------------------------------*/

Line 4371: FROM as_sales_leads

4367:
4368: CURSOR c_sales_lead(c_sales_lead_id NUMBER) IS
4369: SELECT customer_id, address_id, reject_reason_code,
4370: lead_rank_id, qualified_flag, NVL(accept_flag, 'N'), status_code
4371: FROM as_sales_leads
4372: WHERE Sales_lead_id = c_sales_lead_id;
4373:
4374: -- Get whether status is open or not for the lead
4375: -- Get lead_rank_score and lead creation_date

Line 4379: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

4375: -- Get lead_rank_score and lead creation_date
4376: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
4377: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
4378: NVL(rk.min_score, 0), sl.creation_date
4379: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
4380: WHERE sl.sales_lead_id = c_sales_lead_id
4381: AND sl.status_code = sta.status_code
4382: AND sl.lead_rank_id = rk.rank_id(+);
4383:

Line 4484: AS_SALES_LEADS_LOG_PKG.Insert_Row(

4480: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4481: -- 'Lead Status on Routing:'|| l_routing_status); END IF;
4482:
4483: -- Call API to create log entry
4484: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4485: px_log_id => l_sales_lead_log_id ,
4486: p_sales_lead_id => p_sales_lead_id,
4487: p_created_by => fnd_global.user_id,
4488: p_creation_date => SYSDATE,

Line 4507: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(

4503: p_category => NULL);
4504:
4505: -- Call table handler directly, not calling Update_Sales_Lead,
4506: -- in case current user doesn't have update privilege.
4507: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
4508: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4509: p_LAST_UPDATE_DATE => SYSDATE,
4510: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4511: p_CREATION_DATE => FND_API.G_MISS_DATE,

Line 4698: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;

4694: x_return_status OUT NOCOPY VARCHAR2,
4695: x_msg_count OUT NOCOPY NUMBER,
4696: x_msg_data OUT NOCOPY VARCHAR2)
4697: IS
4698: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;
4699:
4700: l_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4701: l_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4702: l_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;

Line 4764: FROM as_sales_leads

4760:
4761: CURSOR c_sales_lead(c_sales_lead_id NUMBER) IS
4762: SELECT customer_id, address_id, reject_reason_code,
4763: lead_rank_id, qualified_flag, NVL(accept_flag, 'N'), status_code
4764: FROM as_sales_leads
4765: WHERE Sales_lead_id = c_sales_lead_id;
4766:
4767: -- Get whether status is open or not for the lead
4768: -- Get lead_rank_score and lead creation_date

Line 4772: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

4768: -- Get lead_rank_score and lead creation_date
4769: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
4770: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
4771: NVL(rk.min_score, 0), sl.creation_date
4772: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
4773: WHERE sl.sales_lead_id = c_sales_lead_id
4774: AND sl.status_code = sta.status_code
4775: AND sl.lead_rank_id = rk.rank_id(+);
4776: BEGIN

Line 4809: -- Customer return owner, update AS_SALES_LEADS_LOG and

4805: -- code modified for bug12766399
4806: Set_Default_Lead_Owner(p_sales_lead_id, p_salesgroup_id,
4807: p_request_id,p_resource_id, x_return_status, x_msg_count, x_msg_data);
4808: ELSE
4809: -- Customer return owner, update AS_SALES_LEADS_LOG and
4810: -- AS_ACCESSES_ALL, AS_SALES_LEADS
4811: IF (AS_DEBUG_LOW_ON) THEN
4812: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4813: 'res id in upd=' || l_Resource_Id);

Line 4810: -- AS_ACCESSES_ALL, AS_SALES_LEADS

4806: Set_Default_Lead_Owner(p_sales_lead_id, p_salesgroup_id,
4807: p_request_id,p_resource_id, x_return_status, x_msg_count, x_msg_data);
4808: ELSE
4809: -- Customer return owner, update AS_SALES_LEADS_LOG and
4810: -- AS_ACCESSES_ALL, AS_SALES_LEADS
4811: IF (AS_DEBUG_LOW_ON) THEN
4812: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4813: 'res id in upd=' || l_Resource_Id);
4814: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 4827: AS_SALES_LEADS_LOG_PKG.Insert_Row(

4823:
4824: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
4825:
4826: -- Call API to create log entry
4827: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4828: px_log_id => l_sales_lead_log_id ,
4829: p_sales_lead_id => p_sales_lead_id,
4830: p_created_by => fnd_global.user_id,
4831: p_creation_date => SYSDATE,

Line 4850: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(

4846: p_category => NULL);
4847:
4848: -- Call table handler directly, not calling Update_Sales_Lead,
4849: -- in case current user doesn't have update privilege.
4850: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
4851: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4852: p_LAST_UPDATE_DATE => SYSDATE,
4853: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4854: p_CREATION_DATE => FND_API.G_MISS_DATE,

Line 5034: FROM as_sales_leads

5030:
5031: CURSOR c_sales_lead(c_sales_lead_id NUMBER) IS
5032: SELECT customer_id, address_id, reject_reason_code,
5033: lead_rank_id, qualified_flag, status_code
5034: FROM as_sales_leads
5035: WHERE sales_lead_id = c_sales_lead_id;
5036:
5037: -- A resource may not be in any group. Besides, jtf_rs_group_members
5038: -- may not have person_id for all resources. Therefore, get person_id

Line 5073: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

5069: -- Get lead_rank_score and lead creation_date
5070: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
5071: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
5072: NVL(rk.min_score, 0), sl.creation_date
5073: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
5074: WHERE sl.sales_lead_id = c_sales_lead_id
5075: AND sl.status_code = sta.status_code
5076: AND sl.lead_rank_id = rk.rank_id(+);
5077:

Line 5164: AS_SALES_LEADS_LOG_PKG.Insert_Row(

5160:
5161: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5162:
5163: -- Call API to create log entry
5164: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5165: px_log_id => l_sales_lead_log_id ,
5166: p_sales_lead_id => p_sales_lead_id,
5167: p_created_by => fnd_global.user_id,
5168: p_creation_date => SYSDATE,

Line 5187: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(

5183: p_category => NULL);
5184:
5185: -- Call table handler directly, not calling Update_Sales_Lead,
5186: -- in case current user doesn't have update privilege.
5187: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5188: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5189: p_LAST_UPDATE_DATE => SYSDATE,
5190: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5191: p_CREATION_DATE => FND_API.G_MISS_DATE,

Line 5304: -- Otherwise, owner's freeze_flag is the same as as_sales_leads.accept_flag

5300: WHERE sales_lead_id = p_sales_lead_id;
5301: END IF;
5302:
5303: -- If referral_type IS NOT NULL, owner has freeze_flag = 'Y' always.
5304: -- Otherwise, owner's freeze_flag is the same as as_sales_leads.accept_flag
5305: IF l_access_exist_flag = 'Y'
5306: THEN
5307: UPDATE as_accesses_all
5308: SET team_leader_flag = 'Y',

Line 5530: FROM AS_SALES_LEADS_LOG LOG

5526: WHERE ACC.SALES_LEAD_ID = c_sales_lead_id
5527: AND ACC.CREATED_BY_TAP_FLAG = 'Y'
5528: AND NOT EXISTS (
5529: SELECT 1
5530: FROM AS_SALES_LEADS_LOG LOG
5531: WHERE LOG.SALES_LEAD_ID = c_sales_lead_id
5532: AND LOG.ASSIGN_TO_SALESFORCE_ID = ACC.SALESFORCE_ID
5533: AND (LOG.ASSIGN_SALES_GROUP_ID = ACC.SALES_GROUP_ID
5534: OR LOG.ASSIGN_SALES_GROUP_ID IS NULL AND ACC.SALES_GROUP_ID IS NULL))

Line 5649: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;

5645: IS
5646: l_rs_id NUMBER := null;
5647:
5648: l_call_user_hook BOOLEAN;
5649: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;
5650: l_org_owner_id_tbl NUMBER_TABLE;
5651: l_i NUMBER;
5652:
5653: l_resource_id NUMBER;

Line 5683: FROM AS_SALES_LEADS

5679: REF_COMM_LTR_STATUS, REF_ORDER_NUMBER, REF_ORDER_AMT,
5680: REF_COMM_AMT, LEAD_DATE, SOURCE_SYSTEM, COUNTRY,
5681: TOTAL_AMOUNT, EXPIRATION_DATE, LEAD_ENGINE_RUN_DATE, LEAD_RANK_IND,
5682: CURRENT_REROUTES
5683: FROM AS_SALES_LEADS
5684: WHERE SALES_LEAD_ID = c_sales_lead_id;
5685:
5686: CURSOR c_get_resource_avail(c_sales_lead_id NUMBER) IS
5687: SELECT 'Y'

Line 5930: FROM as_sales_leads

5926:
5927: CURSOR c_sales_lead(c_sales_lead_id NUMBER) IS
5928: SELECT customer_id, address_id, reject_reason_code,
5929: lead_rank_id, qualified_flag, status_code
5930: FROM as_sales_leads
5931: WHERE Sales_lead_id = c_sales_lead_id;
5932:
5933: -- Get whether status is open or not for the lead
5934: -- Get lead_rank_score and lead creation_date

Line 5938: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

5934: -- Get lead_rank_score and lead creation_date
5935: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
5936: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
5937: NVL(rk.min_score, 0), sl.creation_date
5938: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
5939: WHERE sl.sales_lead_id = c_sales_lead_id
5940: AND sl.status_code = sta.status_code
5941: AND sl.lead_rank_id = rk.rank_id(+);
5942: BEGIN

Line 5962: AS_SALES_LEADS_LOG_PKG.Insert_Row(

5958:
5959: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5960:
5961: -- Call API to create log entry
5962: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5963: px_log_id => l_sales_lead_log_id ,
5964: p_sales_lead_id => p_sales_lead_id,
5965: p_created_by => fnd_global.user_id,
5966: p_creation_date => SYSDATE,

Line 5985: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(

5981: p_category => NULL);
5982:
5983: -- Call table handler directly, not calling Update_Sales_Lead,
5984: -- in case current user doesn't have update privilege.
5985: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5986: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5987: p_LAST_UPDATE_DATE => SYSDATE,
5988: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5989: p_CREATION_DATE => FND_API.G_MISS_DATE,

Line 6160: FROM as_sales_leads

6156: x_msg_data OUT NOCOPY VARCHAR2)
6157: IS
6158: CURSOR C_Get_Lead_Info(c_sales_lead_id NUMBER) IS
6159: SELECT referral_type
6160: FROM as_sales_leads
6161: WHERE sales_lead_id = c_sales_lead_id;
6162:
6163: l_resource_id NUMBER;
6164: l_group_id NUMBER;