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 263: X_Assign_Id_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.Assign_Id_Tbl_Type

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

Line 270: FROM AS_SALES_LEADS SL

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

Line 298: FROM AS_SALES_LEADS SL,

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

Line 340: FROM AS_SALES_LEADS SL,

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

Line 879: FROM AS_SALES_LEADS SL

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

Line 943: FROM AS_SALES_LEADS SL,

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

Line 995: FROM AS_SALES_LEADS SL,

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

Line 2032: FROM AS_SALES_LEADS SL

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

Line 2067: FROM AS_SALES_LEADS SL,

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

Line 2119: FROM AS_SALES_LEADS SL,

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

Line 3237: FROM AS_SALES_LEADS lead

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

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

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

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

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

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

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

Line 4368: FROM as_sales_leads

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

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

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

Line 4462: AS_SALES_LEADS_LOG_PKG.Insert_Row(

4458: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4459: -- 'Lead Status on Routing:'|| l_routing_status); END IF;
4460:
4461: -- Call API to create log entry
4462: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4463: px_log_id => l_sales_lead_log_id ,
4464: p_sales_lead_id => p_sales_lead_id,
4465: p_created_by => fnd_global.user_id,
4466: p_creation_date => SYSDATE,

Line 4485: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(

4481: p_category => NULL);
4482:
4483: -- Call table handler directly, not calling Update_Sales_Lead,
4484: -- in case current user doesn't have update privilege.
4485: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
4486: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4487: p_LAST_UPDATE_DATE => SYSDATE,
4488: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4489: p_CREATION_DATE => FND_API.G_MISS_DATE,

Line 4675: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;

4671: x_return_status OUT NOCOPY VARCHAR2,
4672: x_msg_count OUT NOCOPY NUMBER,
4673: x_msg_data OUT NOCOPY VARCHAR2)
4674: IS
4675: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;
4676:
4677: l_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4678: l_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4679: l_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;

Line 4741: FROM as_sales_leads

4737:
4738: CURSOR c_sales_lead(c_sales_lead_id NUMBER) IS
4739: SELECT customer_id, address_id, reject_reason_code,
4740: lead_rank_id, qualified_flag, NVL(accept_flag, 'N'), status_code
4741: FROM as_sales_leads
4742: WHERE Sales_lead_id = c_sales_lead_id;
4743:
4744: -- Get whether status is open or not for the lead
4745: -- Get lead_rank_score and lead creation_date

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

4745: -- Get lead_rank_score and lead creation_date
4746: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
4747: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
4748: NVL(rk.min_score, 0), sl.creation_date
4749: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
4750: WHERE sl.sales_lead_id = c_sales_lead_id
4751: AND sl.status_code = sta.status_code
4752: AND sl.lead_rank_id = rk.rank_id(+);
4753: BEGIN

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

4781: -- user decides to use default resource.
4782: Set_Default_Lead_Owner(p_sales_lead_id, p_salesgroup_id,
4783: p_request_id, x_return_status, x_msg_count, x_msg_data);
4784: ELSE
4785: -- Customer return owner, update AS_SALES_LEADS_LOG and
4786: -- AS_ACCESSES_ALL, AS_SALES_LEADS
4787: IF (AS_DEBUG_LOW_ON) THEN
4788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4789: 'res id in upd=' || l_Resource_Id);

Line 4786: -- AS_ACCESSES_ALL, AS_SALES_LEADS

4782: Set_Default_Lead_Owner(p_sales_lead_id, p_salesgroup_id,
4783: p_request_id, x_return_status, x_msg_count, x_msg_data);
4784: ELSE
4785: -- Customer return owner, update AS_SALES_LEADS_LOG and
4786: -- AS_ACCESSES_ALL, AS_SALES_LEADS
4787: IF (AS_DEBUG_LOW_ON) THEN
4788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4789: 'res id in upd=' || l_Resource_Id);
4790: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 4803: AS_SALES_LEADS_LOG_PKG.Insert_Row(

4799:
4800: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
4801:
4802: -- Call API to create log entry
4803: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4804: px_log_id => l_sales_lead_log_id ,
4805: p_sales_lead_id => p_sales_lead_id,
4806: p_created_by => fnd_global.user_id,
4807: p_creation_date => SYSDATE,

Line 4826: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(

4822: p_category => NULL);
4823:
4824: -- Call table handler directly, not calling Update_Sales_Lead,
4825: -- in case current user doesn't have update privilege.
4826: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
4827: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4828: p_LAST_UPDATE_DATE => SYSDATE,
4829: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4830: p_CREATION_DATE => FND_API.G_MISS_DATE,

Line 5010: FROM as_sales_leads

5006:
5007: CURSOR c_sales_lead(c_sales_lead_id NUMBER) IS
5008: SELECT customer_id, address_id, reject_reason_code,
5009: lead_rank_id, qualified_flag, status_code
5010: FROM as_sales_leads
5011: WHERE sales_lead_id = c_sales_lead_id;
5012:
5013: -- A resource may not be in any group. Besides, jtf_rs_group_members
5014: -- may not have person_id for all resources. Therefore, get person_id

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

5045: -- Get lead_rank_score and lead creation_date
5046: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
5047: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
5048: NVL(rk.min_score, 0), sl.creation_date
5049: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
5050: WHERE sl.sales_lead_id = c_sales_lead_id
5051: AND sl.status_code = sta.status_code
5052: AND sl.lead_rank_id = rk.rank_id(+);
5053:

Line 5140: AS_SALES_LEADS_LOG_PKG.Insert_Row(

5136:
5137: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5138:
5139: -- Call API to create log entry
5140: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5141: px_log_id => l_sales_lead_log_id ,
5142: p_sales_lead_id => p_sales_lead_id,
5143: p_created_by => fnd_global.user_id,
5144: p_creation_date => SYSDATE,

Line 5163: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(

5159: p_category => NULL);
5160:
5161: -- Call table handler directly, not calling Update_Sales_Lead,
5162: -- in case current user doesn't have update privilege.
5163: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5164: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5165: p_LAST_UPDATE_DATE => SYSDATE,
5166: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5167: p_CREATION_DATE => FND_API.G_MISS_DATE,

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

5276: WHERE sales_lead_id = p_sales_lead_id;
5277: END IF;
5278:
5279: -- If referral_type IS NOT NULL, owner has freeze_flag = 'Y' always.
5280: -- Otherwise, owner's freeze_flag is the same as as_sales_leads.accept_flag
5281: IF l_access_exist_flag = 'Y'
5282: THEN
5283: UPDATE as_accesses_all
5284: SET team_leader_flag = 'Y',

Line 5506: FROM AS_SALES_LEADS_LOG LOG

5502: WHERE ACC.SALES_LEAD_ID = c_sales_lead_id
5503: AND ACC.CREATED_BY_TAP_FLAG = 'Y'
5504: AND NOT EXISTS (
5505: SELECT 1
5506: FROM AS_SALES_LEADS_LOG LOG
5507: WHERE LOG.SALES_LEAD_ID = c_sales_lead_id
5508: AND LOG.ASSIGN_TO_SALESFORCE_ID = ACC.SALESFORCE_ID
5509: AND (LOG.ASSIGN_SALES_GROUP_ID = ACC.SALES_GROUP_ID
5510: OR LOG.ASSIGN_SALES_GROUP_ID IS NULL AND ACC.SALES_GROUP_ID IS NULL))

Line 5625: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;

5621: IS
5622: l_rs_id NUMBER := null;
5623:
5624: l_call_user_hook BOOLEAN;
5625: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;
5626: l_org_owner_id_tbl NUMBER_TABLE;
5627: l_i NUMBER;
5628:
5629: l_resource_id NUMBER;

Line 5659: FROM AS_SALES_LEADS

5655: REF_COMM_LTR_STATUS, REF_ORDER_NUMBER, REF_ORDER_AMT,
5656: REF_COMM_AMT, LEAD_DATE, SOURCE_SYSTEM, COUNTRY,
5657: TOTAL_AMOUNT, EXPIRATION_DATE, LEAD_ENGINE_RUN_DATE, LEAD_RANK_IND,
5658: CURRENT_REROUTES
5659: FROM AS_SALES_LEADS
5660: WHERE SALES_LEAD_ID = c_sales_lead_id;
5661:
5662: CURSOR c_get_resource_avail(c_sales_lead_id NUMBER) IS
5663: SELECT 'Y'

Line 5906: FROM as_sales_leads

5902:
5903: CURSOR c_sales_lead(c_sales_lead_id NUMBER) IS
5904: SELECT customer_id, address_id, reject_reason_code,
5905: lead_rank_id, qualified_flag, status_code
5906: FROM as_sales_leads
5907: WHERE Sales_lead_id = c_sales_lead_id;
5908:
5909: -- Get whether status is open or not for the lead
5910: -- Get lead_rank_score and lead creation_date

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

5910: -- Get lead_rank_score and lead creation_date
5911: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
5912: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
5913: NVL(rk.min_score, 0), sl.creation_date
5914: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
5915: WHERE sl.sales_lead_id = c_sales_lead_id
5916: AND sl.status_code = sta.status_code
5917: AND sl.lead_rank_id = rk.rank_id(+);
5918: BEGIN

Line 5938: AS_SALES_LEADS_LOG_PKG.Insert_Row(

5934:
5935: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5936:
5937: -- Call API to create log entry
5938: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5939: px_log_id => l_sales_lead_log_id ,
5940: p_sales_lead_id => p_sales_lead_id,
5941: p_created_by => fnd_global.user_id,
5942: p_creation_date => SYSDATE,

Line 5961: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(

5957: p_category => NULL);
5958:
5959: -- Call table handler directly, not calling Update_Sales_Lead,
5960: -- in case current user doesn't have update privilege.
5961: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5962: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5963: p_LAST_UPDATE_DATE => SYSDATE,
5964: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5965: p_CREATION_DATE => FND_API.G_MISS_DATE,

Line 6135: FROM as_sales_leads

6131: x_msg_data OUT NOCOPY VARCHAR2)
6132: IS
6133: CURSOR C_Get_Lead_Info(c_sales_lead_id NUMBER) IS
6134: SELECT referral_type
6135: FROM as_sales_leads
6136: WHERE sales_lead_id = c_sales_lead_id;
6137:
6138: l_resource_id NUMBER;
6139: l_group_id NUMBER;