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

Line 1: PACKAGE BODY AS_SALES_LEADS_PUB as

1: PACKAGE BODY AS_SALES_LEADS_PUB as
2: /* $Header: asxpslmb.pls 115.68 2003/11/17 19:41:45 chchandr ship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEADS_PUB
5: -- Purpose : Sales Leads Management

Line 4: -- Package name : AS_SALES_LEADS_PUB

1: PACKAGE BODY AS_SALES_LEADS_PUB as
2: /* $Header: asxpslmb.pls 115.68 2003/11/17 19:41:45 chchandr ship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEADS_PUB
5: -- Purpose : Sales Leads Management
6: -- NOTE :
7: -- History :
8: -- 06/05/2000 FFANG Created.

Line 52: -- as_sales_leads_log.

48: -- in route_lead_to_marketing.
49: -- 04/23/2003 SOLIN Bug 2921021
50: -- Route_Lead_To_Marketing should log lead_rank_id,
51: -- assign_sales_group_id, qualified_flag in
52: -- as_sales_leads_log.
53: -- 04/24/2003 SOLIN Bug 2923708
54: -- Route_Lead_To_Marketing should set accept_flag to 'N'
55: -- if owner is changed.
56: -- 06/16/2003 SOLIN Bug 3007246

Line 64: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEADS_PUB';

60: -- Use type JTF_NUMBER_TABLE, instead of NUMBER_TABLE
61: --
62: -- End of Comments
63:
64: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEADS_PUB';
65: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxpslmb.pls';
66: G_CREATE NUMBER :=2;
67: G_UPDATE NUMBER :=1;
68:

Line 154: AS_SALES_LEADS_PVT.Create_sales_lead(

150: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
151: 'PUB: Call PVT.Create_sales_lead');
152: END IF;
153:
154: AS_SALES_LEADS_PVT.Create_sales_lead(
155: P_Api_Version_Number => 2.0,
156: P_Init_Msg_List => FND_API.G_FALSE,
157: P_Commit => FND_API.G_FALSE,
158: P_Validation_Level => P_Validation_Level,

Line 319: AS_SALES_LEADS_PVT.Update_sales_lead(

315: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
316: 'PUB: Calling PVT.Update_sales_lead');
317:
318: END IF;
319: AS_SALES_LEADS_PVT.Update_sales_lead(
320: P_Api_Version_Number => 2.0,
321: P_Init_Msg_List => FND_API.G_FALSE,
322: P_Commit => FND_API.G_FALSE, -- p_commit,
323: P_Validation_Level => P_Validation_Level,

Line 1725: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

1721: )
1722: IS
1723: l_api_name CONSTANT VARCHAR2(30) := 'Link_Lead_To_Opportunity';
1724: l_api_version_number CONSTANT NUMBER := 2.0;
1725: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
1726: DEFAULT AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;
1727: CURSOR C_Get_Sales_Lead (X_Sales_Lead_Id NUMBER) IS
1728: SELECT sales_lead_id
1729: ,last_update_date

Line 1726: DEFAULT AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;

1722: IS
1723: l_api_name CONSTANT VARCHAR2(30) := 'Link_Lead_To_Opportunity';
1724: l_api_version_number CONSTANT NUMBER := 2.0;
1725: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
1726: DEFAULT AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;
1727: CURSOR C_Get_Sales_Lead (X_Sales_Lead_Id NUMBER) IS
1728: SELECT sales_lead_id
1729: ,last_update_date
1730: ,last_updated_by

Line 1823: FROM as_sales_leads

1819: ,LEAD_RANK_IND
1820: ,LEAD_ENGINE_RUN_DATE
1821: ,CURRENT_REROUTES
1822:
1823: FROM as_sales_leads
1824: WHERE sales_lead_id = X_Sales_Lead_Id;
1825:
1826: BEGIN
1827: -- Standard Start of API savepoint

Line 2505: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

2501: )
2502: IS
2503: l_api_name CONSTANT VARCHAR2(30) := 'Create_Opp_For_Lead';
2504: l_api_version_number CONSTANT NUMBER := 2.0;
2505: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
2506: DEFAULT AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;
2507: CURSOR C_Get_Sales_Lead (X_Sales_Lead_Id NUMBER) IS
2508: SELECT sales_lead_id
2509: ,last_update_date

Line 2506: DEFAULT AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;

2502: IS
2503: l_api_name CONSTANT VARCHAR2(30) := 'Create_Opp_For_Lead';
2504: l_api_version_number CONSTANT NUMBER := 2.0;
2505: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
2506: DEFAULT AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;
2507: CURSOR C_Get_Sales_Lead (X_Sales_Lead_Id NUMBER) IS
2508: SELECT sales_lead_id
2509: ,last_update_date
2510: ,last_updated_by

Line 2607: FROM as_sales_leads

2603:
2604:
2605:
2606:
2607: FROM as_sales_leads
2608: WHERE sales_lead_id = X_Sales_Lead_Id;
2609: BEGIN
2610: -- Standard Start of API savepoint
2611: SAVEPOINT CREATE_OPP_FOR_LEAD_PUB;

Line 4111: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;

4107: l_api_version_number CONSTANT NUMBER := 2.0;
4108: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type := AS_ACCESS_PUB.G_MISS_SALES_TEAM_REC;
4109: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4110: l_sales_lead_profile_tbl AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL;
4111: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;
4112:
4113: l_assign_sales_group_id NUMBER;
4114: l_assign_to_person_id NUMBER;
4115: l_assign_to_salesforce_id NUMBER;

Line 4126: l_status_code as_sales_leads.status_code%type;

4122: l_group_id NUMBER;
4123: l_last_update_date DATE;
4124: l_sales_lead_log_id NUMBER;
4125:
4126: l_status_code as_sales_leads.status_code%type;
4127: l_reject_reason_code as_sales_leads.reject_reason_code%type;
4128: l_qualified_flag VARCHAR2(1);
4129: l_lead_rank_id NUMBER;
4130:

Line 4127: l_reject_reason_code as_sales_leads.reject_reason_code%type;

4123: l_last_update_date DATE;
4124: l_sales_lead_log_id NUMBER;
4125:
4126: l_status_code as_sales_leads.status_code%type;
4127: l_reject_reason_code as_sales_leads.reject_reason_code%type;
4128: l_qualified_flag VARCHAR2(1);
4129: l_lead_rank_id NUMBER;
4130:
4131: -- Bug 2822580, SOLIN, 03/07/2003

Line 4152: FROM AS_SALES_LEADS asl

4148: -- bugfix# 2770000
4149: /*
4150: CURSOR get_sales_lead_owner (c_sales_lead_id NUMBER) IS
4151: SELECT asl.ASSIGN_TO_SALESFORCE_ID
4152: FROM AS_SALES_LEADS asl
4153: WHERE asl.sales_lead_id = c_sales_lead_id;
4154: */
4155:
4156: CURSOR get_person_id_csr (c_resource_id NUMBER) IS

Line 4165: FROM AS_SALES_LEADS asl

4161: CURSOR get_sales_lead_csr (c_sales_lead_id NUMBER) IS
4162: SELECT asl.customer_id, asl.address_id, asl.status_code,
4163: asl.reject_reason_code, asl.assign_to_salesforce_id,
4164: asl.qualified_flag, asl.lead_rank_id
4165: FROM AS_SALES_LEADS asl
4166: WHERE asl.sales_lead_id = c_sales_lead_id;
4167:
4168: CURSOR c_get_group_id (c_resource_id NUMBER, c_rs_group_member VARCHAR2,
4169: c_sales VARCHAR2, c_telesales VARCHAR2,

Line 4466: AS_SALES_LEADS_LOG_PKG.Insert_Row(

4462: END IF;
4463:
4464: -- Call API to create log entry
4465:
4466: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4467: px_log_id => l_sales_lead_log_id ,
4468: p_sales_lead_id => p_sales_lead_id,
4469: p_created_by => fnd_global.user_id,
4470: p_creation_date => SYSDATE,

Line 4489: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(

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

Line 4775: WHEN AS_SALES_LEADS_PUB.Filter_Exception THEN

4771: END IF;
4772:
4773: EXCEPTION
4774:
4775: WHEN AS_SALES_LEADS_PUB.Filter_Exception THEN
4776: RAISE AS_SALES_LEADS_PUB.Filter_Exception;
4777:
4778: WHEN FND_API.G_EXC_ERROR THEN
4779: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 4776: RAISE AS_SALES_LEADS_PUB.Filter_Exception;

4772:
4773: EXCEPTION
4774:
4775: WHEN AS_SALES_LEADS_PUB.Filter_Exception THEN
4776: RAISE AS_SALES_LEADS_PUB.Filter_Exception;
4777:
4778: WHEN FND_API.G_EXC_ERROR THEN
4779: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4780: P_API_NAME => L_API_NAME

Line 4962: End AS_SALES_LEADS_PUB;

4958:
4959: End Lead_Process_After_Update;
4960:
4961:
4962: End AS_SALES_LEADS_PUB;