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_LEADS_PVT dependencies on AS_SALES_LEADS

Line 1: PACKAGE BODY AS_SALES_LEADS_PVT as

1: PACKAGE BODY AS_SALES_LEADS_PVT as
2: /* $Header: asxvslmb.pls 120.1 2006/03/25 04:27:46 savadhan noship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEADS_PVT
5: -- Purpose : Sales Leads Management

Line 4: -- Package name : AS_SALES_LEADS_PVT

1: PACKAGE BODY AS_SALES_LEADS_PVT as
2: /* $Header: asxvslmb.pls 120.1 2006/03/25 04:27:46 savadhan noship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEADS_PVT
5: -- Purpose : Sales Leads Management
6: -- NOTE :
7: -- History :
8: -- 06/05/2000 FFANG Created.

Line 10: -- 08/30/2000 FFANG Add assign_to_salesforce_id to AS_SALES_LEADS

6: -- NOTE :
7: -- History :
8: -- 06/05/2000 FFANG Created.
9: -- 06/06/2000 FFANG ModIFied according data schema changes.
10: -- 08/30/2000 FFANG Add assign_to_salesforce_id to AS_SALES_LEADS
11: -- 08/31/2000 FFANG Add assign_to_salesforce_id to AS_SALES_LEADS_LOG
12: -- 09/20/2000 FFANG For bug 1406777, add different logics to
13: -- validate_sales_lead_id when calling from create or
14: -- update

Line 11: -- 08/31/2000 FFANG Add assign_to_salesforce_id to AS_SALES_LEADS_LOG

7: -- History :
8: -- 06/05/2000 FFANG Created.
9: -- 06/06/2000 FFANG ModIFied according data schema changes.
10: -- 08/30/2000 FFANG Add assign_to_salesforce_id to AS_SALES_LEADS
11: -- 08/31/2000 FFANG Add assign_to_salesforce_id to AS_SALES_LEADS_LOG
12: -- 09/20/2000 FFANG For bug 1406777, add different logics to
13: -- validate_sales_lead_id when calling from create or
14: -- update
15: -- 09/20/2000 FFANG For bug 1406761, add different logics to

Line 107: -- Set as_sales_leads_log.manual_rank_flag:

103: -- 12/17/2002 SOLIN Populate column lead_rank_ind:
104: -- 'U': lead is upgraded.
105: -- 'D': lead is downgraded.
106: -- 'N': none of above.
107: -- Set as_sales_leads_log.manual_rank_flag:
108: -- 'Y': user manually sets rank
109: -- 'N': rating engine sets rank
110: -- null: rank is not updated
111: -- 11/08/2004 BMUTHUKR Modified validate_status_close_reason procedure to fix bug 3931489.

Line 116: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEADS_PVT';

112: --
113: -- END of Comments
114:
115:
116: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEADS_PVT';
117: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxvslmb.pls';
118:
119:
120: -- ffang 092000 for bug 1400244

Line 129: px_SALES_LEAD_rec IN OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

125: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
126:
127: PROCEDURE Set_default_values (
128: p_mode IN VARCHAR2,
129: px_SALES_LEAD_rec IN OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
130: )
131: IS
132: BEGIN
133:

Line 337: FROM as_sales_leads

333: )
334: IS
335: CURSOR C_Sales_Lead_Id_Exists (X_Sales_Lead_Id NUMBER) IS
336: SELECT 'X'
337: FROM as_sales_leads
338: WHERE sales_lead_id = X_Sales_Lead_Id;
339:
340: l_val VARCHAR2(1);
341:

Line 834: FROM as_sales_leads

830: WHERE sales_lead_id = X_Sales_Lead_Id;
831:
832: Cursor C_GET_STATUS_CODE (c_sales_lead_id NUMBER) IS
833: SELECT status_code
834: FROM as_sales_leads
835: WHERE sales_lead_id = c_sales_lead_id;
836:
837:
838: l_val VARCHAR2(1);

Line 2599: FROM as_sales_leads

2595: )
2596: IS
2597: CURSOR C_Header_Amount (X_Sales_Lead_ID NUMBER) IS
2598: SELECT budget_amount
2599: FROM as_sales_leads
2600: where sales_lead_id = X_Sales_Lead_ID;
2601:
2602: CURSOR C_Lines_Amounts (X_Sales_Lead_ID NUMBER) IS
2603: SELECT sum (budget_amount)

Line 2654: P_SALES_LEAD_Rec IN OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,

2650: PROCEDURE Validate_sales_lead(
2651: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2652: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2653: P_Validation_mode IN VARCHAR2,
2654: P_SALES_LEAD_Rec IN OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,
2655: P_Referral_Type IN VARCHAR2,
2656: P_Referred_By IN NUMBER,
2657: X_Return_Status OUT NOCOPY VARCHAR2,
2658: X_Msg_Count OUT NOCOPY NUMBER,

Line 3213: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

3209: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
3210: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
3211: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3212: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3213: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type

Line 3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,

3210: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
3211: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3212: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3213: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,

Line 3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type

3211: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3212: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3213: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
3219: X_SALES_LEAD_ID OUT NOCOPY NUMBER,

Line 3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,

3212: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3213: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
3219: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
3220: X_SALES_LEAD_LINE_OUT_Tbl OUT

Line 3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type

3213: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
3219: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
3220: X_SALES_LEAD_LINE_OUT_Tbl OUT
3221: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_type,

Line 3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,

3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
3219: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
3220: X_SALES_LEAD_LINE_OUT_Tbl OUT
3221: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_type,
3222: X_SALES_LEAD_CNT_OUT_Tbl OUT

Line 3221: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_type,

3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
3219: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
3220: X_SALES_LEAD_LINE_OUT_Tbl OUT
3221: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_type,
3222: X_SALES_LEAD_CNT_OUT_Tbl OUT
3223: AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
3224: X_Return_Status OUT NOCOPY VARCHAR2,
3225: X_Msg_Count OUT NOCOPY NUMBER,

Line 3223: AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,

3219: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
3220: X_SALES_LEAD_LINE_OUT_Tbl OUT
3221: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_type,
3222: X_SALES_LEAD_CNT_OUT_Tbl OUT
3223: AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
3224: X_Return_Status OUT NOCOPY VARCHAR2,
3225: X_Msg_Count OUT NOCOPY NUMBER,
3226: X_Msg_Data OUT NOCOPY VARCHAR2
3227: )

Line 3242: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

3238: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
3239: l_SALES_LEAD_ID NUMBER;
3240: l_sales_lead_line_id NUMBER;
3241: l_lead_contact_id NUMBER;
3242: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3243: := p_sales_lead_rec;
3244: p_sales_lead_line_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type;
3245: p_sales_lead_contact_rec AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type;
3246: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type;

Line 3244: p_sales_lead_line_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type;

3240: l_sales_lead_line_id NUMBER;
3241: l_lead_contact_id NUMBER;
3242: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3243: := p_sales_lead_rec;
3244: p_sales_lead_line_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type;
3245: p_sales_lead_contact_rec AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type;
3246: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type;
3247: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
3248: l_Sales_Lead_Log_ID NUMBER;

Line 3245: p_sales_lead_contact_rec AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type;

3241: l_lead_contact_id NUMBER;
3242: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3243: := p_sales_lead_rec;
3244: p_sales_lead_line_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type;
3245: p_sales_lead_contact_rec AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type;
3246: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type;
3247: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
3248: l_Sales_Lead_Log_ID NUMBER;
3249: l_access_id NUMBER;

Line 3317: FROM hz_parties hzp, as_sales_leads sl

3313: -- 11.5.10 ckapoor Lead Name changes for Rivendell
3314:
3315: CURSOR C_get_primary_contact_name(X_sales_lead_id NUMBER) IS
3316: SELECT hzp.party_name
3317: FROM hz_parties hzp, as_sales_leads sl
3318: WHERE hzp.party_id = sl.primary_cnt_person_party_id
3319: and sl.sales_lead_id = X_sales_lead_id;
3320: -- this works since contacts API would have already updated the
3321: -- primary contacts party id information in as_sales_leads.

Line 3321: -- primary contacts party id information in as_sales_leads.

3317: FROM hz_parties hzp, as_sales_leads sl
3318: WHERE hzp.party_id = sl.primary_cnt_person_party_id
3319: and sl.sales_lead_id = X_sales_lead_id;
3320: -- this works since contacts API would have already updated the
3321: -- primary contacts party id information in as_sales_leads.
3322:
3323:
3324: CURSOR C_get_customer_name (X_party_id NUMBER) IS
3325: SELECT party_name

Line 3519: AS_SALES_LEADS_PUB.Get_Access_Profiles(

3515: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3516: 'Calling Get_Access_Profiles');
3517: END IF;
3518:
3519: AS_SALES_LEADS_PUB.Get_Access_Profiles(
3520: p_profile_tbl => p_sales_lead_profile_tbl,
3521: x_access_profile_rec => l_access_profile_rec);
3522:
3523: IF (AS_DEBUG_LOW_ON) THEN

Line 3761: AS_SALES_LEADS_PKG.Sales_Lead_Insert_Row(

3757:
3758: -- Invoke table handler(Sales_Lead_Insert_Row)
3759: x_SALES_LEAD_ID := l_SALES_LEAD_rec.SALES_LEAD_ID;
3760:
3761: AS_SALES_LEADS_PKG.Sales_Lead_Insert_Row(
3762: px_SALES_LEAD_ID => x_SALES_LEAD_ID,
3763: p_LAST_UPDATE_DATE => SYSDATE,
3764: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3765: p_CREATION_DATE => SYSDATE,

Line 3903: 'Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');

3899: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3900: 'xSalesLeadID is '||l_sales_lead_id);
3901:
3902: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3903: 'Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');
3904: END IF;
3905:
3906: -- Call API to create log entry
3907:

Line 3908: AS_SALES_LEADS_LOG_PKG.Insert_Row(

3904: END IF;
3905:
3906: -- Call API to create log entry
3907:
3908: AS_SALES_LEADS_LOG_PKG.Insert_Row(
3909: px_log_id => l_sales_lead_log_id ,
3910: p_sales_lead_id => l_sales_lead_id,
3911: p_created_by => fnd_global.user_id,
3912: p_creation_date => sysdate,

Line 3943: AS_SALES_LEADS_LOG_PKG.Insert_Row(

3939: if ( l_SALES_LEAD_rec.REFERRAL_TYPE is not null and l_sales_lead_rec.REFERRAL_TYPE <> FND_API.G_MISS_CHAR) then
3940:
3941: l_sales_lead_log_id := null;
3942:
3943: AS_SALES_LEADS_LOG_PKG.Insert_Row(
3944: px_log_id => l_sales_lead_log_id ,
3945: p_sales_lead_id => l_sales_lead_id,
3946: p_created_by => fnd_global.user_id,
3947: p_creation_date => sysdate,

Line 4221: update as_sales_leads set description = l_default_lead_name where sales_lead_id =

4217: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4218: 'CK:def name:'||l_default_lead_name);
4219: END IF;
4220:
4221: update as_sales_leads set description = l_default_lead_name where sales_lead_id =
4222: l_SALES_LEAD_ID;
4223:
4224: end if ;
4225:

Line 4300: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,

4296: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
4297: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
4298: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4299: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4300: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,
4301: -- P_Calling_From_WF_Flag IN VARCHAR2 := 'N',
4302: X_Return_Status OUT NOCOPY VARCHAR2,
4303: X_Msg_Count OUT NOCOPY NUMBER,
4304: X_Msg_Data OUT NOCOPY VARCHAR2

Line 4373: From AS_SALES_LEADS

4369: referral_status,
4370: accept_flag,
4371: decision_timeframe_code,
4372: creation_date
4373: From AS_SALES_LEADS
4374: Where SALES_LEAD_ID = p_Sales_Lead_ID
4375: For Update NOWAIT;
4376: -- Denorm fix 2928041
4377:

Line 4397: -- FROM AS_SALES_LEADS SL, HZ_CONTACT_POINTS HZ

4393: -- added for auto qualification of sales_lead
4394: -- changing query
4395: --CURSOR C_PHONE_ID_Exists(c_sales_lead_id NUMBER) IS
4396: -- SELECT hz.contact_point_id
4397: -- FROM AS_SALES_LEADS SL, HZ_CONTACT_POINTS HZ
4398: -- WHERE hz.owner_table_id = sl.customer_id
4399: -- AND hz.owner_table_name = 'HZ_PARTIES'
4400: -- AND hz.contact_point_type = 'PHONE'
4401: -- AND hz.primary_flag = 'Y'

Line 4415: -- FROM as_sales_leads

4411: FROM AS_SALES_LEAD_CONTACTS
4412: WHERE sales_lead_id = c_sales_lead_id ;
4413: -- Cursor C_Get_Keep_Flag (c_sales_lead_id NUMBER) IS
4414: -- SELECT keep_flag
4415: -- FROM as_sales_leads
4416: -- WHERE sales_lead_id = c_sales_lead_id;
4417:
4418: -- ffang 121100, for bug 1504040, auto-qualification has nothing to do with
4419: -- keep_flag but previous status_code

Line 4422: FROM as_sales_leads

4418: -- ffang 121100, for bug 1504040, auto-qualification has nothing to do with
4419: -- keep_flag but previous status_code
4420: Cursor C_GET_STATUS_CODE (c_sales_lead_id NUMBER) IS
4421: SELECT status_code
4422: FROM as_sales_leads
4423: WHERE sales_lead_id = c_sales_lead_id;
4424:
4425: CURSOR c_get_person_id(x_resource_id NUMBER) IS
4426: SELECT source_id

Line 4464: FROM as_sales_leads_log

4460: where decision_timeframe_code = X_DECISION_TIMEFRAME_CODE and enabled_flag = 'Y';
4461:
4462: CURSOR C_get_last_system_rank (c_sales_lead_id NUMBER) IS
4463: SELECT lead_rank_id
4464: FROM as_sales_leads_log
4465: WHERE sales_lead_id = c_sales_lead_id
4466: AND manual_rank_flag = 'N'
4467: ORDER BY log_id DESC;
4468:

Line 4510: l_tar_SALES_LEAD_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

4506: l_api_name CONSTANT VARCHAR2(30) := 'Update_sales_lead';
4507: l_api_version_number CONSTANT NUMBER := 2.0;
4508: -- Local Variables
4509: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
4510: l_tar_SALES_LEAD_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
4511: := P_SALES_LEAD_Rec;
4512: l_rowid ROWID;
4513: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type;
4514: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

Line 4762: AS_SALES_LEADS_PUB.Get_Access_Profiles(

4758: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4759: 'Calling Get_Access_Profiles');
4760: END IF;
4761:
4762: AS_SALES_LEADS_PUB.Get_Access_Profiles(
4763: p_profile_tbl => p_sales_lead_profile_tbl,
4764: x_access_profile_rec => l_access_profile_rec);
4765:
4766:

Line 5137: -- Moving code here, since we need common code for logging into as_sales_leads (status_open_flag

5133: END If;
5134: END IF;
5135: --Ends changes for bug 3675566
5136:
5137: -- Moving code here, since we need common code for logging into as_sales_leads (status_open_flag
5138: -- and lead_rank_score)
5139:
5140: --Denorm fix 04/30/03 ckapoor
5141: --Get the open status flag for both old status and new status

Line 5213: 'Just before AS_SALES_LEADS_PKG.Sales_Lead_Update_Row');

5209: IF (AS_DEBUG_LOW_ON) THEN
5210:
5211:
5212: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5213: 'Just before AS_SALES_LEADS_PKG.Sales_Lead_Update_Row');
5214:
5215:
5216: END IF;
5217:

Line 5291: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(

5287: END IF;
5288: -- SOLIN, end
5289:
5290: -- Invoke table handler(Sales_Lead_Update_Row)
5291: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5292: p_SALES_LEAD_ID => l_tar_SALES_LEAD_rec.SALES_LEAD_ID,
5293: p_LAST_UPDATE_DATE => SYSDATE,
5294: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5295: p_CREATION_DATE => l_tar_SALES_LEAD_rec.CREATION_DATE,

Line 5457: 'Just after AS_SALES_LEADS_PKG.Sales_Lead_Update_Row');

5453:
5454:
5455:
5456: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5457: 'Just after AS_SALES_LEADS_PKG.Sales_Lead_Update_Row');
5458:
5459: END IF;
5460:
5461:

Line 5533: 'Just after AS_SALES_LEADS_PKG.Sales_Lead_Update_Row');

5529: ELSE
5530: IF (AS_DEBUG_LOW_ON) THEN
5531:
5532: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5533: 'Just after AS_SALES_LEADS_PKG.Sales_Lead_Update_Row');
5534: END IF;
5535:
5536:
5537: if (l_tar_sales_lead_rec.status_code = FND_API.G_MISS_CHAR) then

Line 5586: 'Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');

5582: -- Debug Message
5583: IF (AS_DEBUG_LOW_ON) THEN
5584:
5585: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5586: 'Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');
5587: END IF;
5588:
5589: -- Call API to create log entry
5590: AS_SALES_LEADS_LOG_PKG.Insert_Row(

Line 5590: AS_SALES_LEADS_LOG_PKG.Insert_Row(

5586: 'Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');
5587: END IF;
5588:
5589: -- Call API to create log entry
5590: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5591: px_log_id => l_sales_lead_log_id ,
5592: p_sales_lead_id => l_tar_sales_lead_rec.sales_lead_id,
5593: p_created_by => fnd_global.user_id,
5594: p_creation_date => sysdate,

Line 5633: 'Not Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');

5629: -- Debug Message
5630: IF (AS_DEBUG_LOW_ON) THEN
5631:
5632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5633: 'Not Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');
5634: END IF;
5635:
5636: */
5637: END IF;

Line 5651: AS_SALES_LEADS_LOG_PKG.Insert_Row(

5647: then
5648:
5649: l_sales_lead_log_id := null;
5650:
5651: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5652: px_log_id => l_sales_lead_log_id ,
5653: p_sales_lead_id => l_tar_sales_lead_rec.sales_lead_id,
5654: p_created_by => fnd_global.user_id,
5655: p_creation_date => sysdate,

Line 6383: -- since we are re-using code from denorming for as_sales_leads, if l_new_lead_rank_score

6379:
6380:
6381: -- if new rank is null, we want to fix the score since old might have been non null.
6382: -- if new rank is g_miss , means anyways the rank is not changing so score is not changing.
6383: -- since we are re-using code from denorming for as_sales_leads, if l_new_lead_rank_score
6384: -- is g_miss then dont update as_accesses_all, basically simulate table handler
6385:
6386: if ( l_new_lead_rank_score <> FND_API.G_MISS_NUM ) THEN
6387: -- update the as_accesses_all.lead_rank_score if the rank has been changed i.e not g_miss

Line 6481: P_Sales_lead_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

6477: /*
6478: This function is decomissioned
6479: -- function determines whether the Sales_Lead Is Qualified Or NOT.
6480: FUNCTION IS_LEAD_QUALIFIED(
6481: P_Sales_lead_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
6482: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
6483: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
6484: p_contact_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
6485: ) RETURN VARCHAR

Line 6482: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,

6478: This function is decomissioned
6479: -- function determines whether the Sales_Lead Is Qualified Or NOT.
6480: FUNCTION IS_LEAD_QUALIFIED(
6481: P_Sales_lead_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
6482: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
6483: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
6484: p_contact_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
6485: ) RETURN VARCHAR
6486: IS

Line 6666: -- change this to make sure contact role from as_sales_leads_contacts table is used

6662: return l_isQualified;
6663: end if;
6664: end if;
6665:
6666: -- change this to make sure contact role from as_sales_leads_contacts table is used
6667: if l_contact_role_req = 'Y' then
6668: if (p_contact_role_code is null) or
6669: (p_contact_role_code = FND_API.G_MISS_CHAR) then
6670: IF (AS_DEBUG_LOW_ON) THEN

Line 6723: END AS_SALES_LEADS_PVT;

6719:
6720:
6721: */
6722:
6723: END AS_SALES_LEADS_PVT;