DBA Data[Home] [Help]

APPS.AS_SALES_LEADS_PUB dependencies on AS_SALES_LEADS_PUB

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 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 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 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 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 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;