1 PACKAGE AS_SALES_LEAD_OPP_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvslos.pls 120.1 2006/03/25 04:28:45 savadhan noship $ */
3 -- Start of Comments
4 -- Package name : AS_SALES_LEAD_OPP_PVT
5 -- Purpose : Sales Lead and Opportunity
6 -- NOTE :
7 -- History :
8 -- 04/09/2001 FFANG Created.
9 --
10 -- End of Comments
11
12
13 -- *************************
14 -- Validation Procedures
15 -- *************************
16
17 -- API Name: Get_Potential_Opportunity
18
19 PROCEDURE Get_Potential_Opportunity(
20 P_Api_Version_Number IN NUMBER,
21 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
25 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
26 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
27 P_identity_salesforce_id IN NUMBER := NULL,
28 -- FND_API.G_MISS_NUM,
29 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
30 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
31 P_SALES_LEAD_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_rec_type,
32 X_Return_Status OUT NOCOPY VARCHAR2,
33 X_Msg_Count OUT NOCOPY NUMBER,
34 X_Msg_Data OUT NOCOPY VARCHAR2,
35 X_OPPORTUNITY_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE,
36 X_OPP_LINES_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.LINE_TBL_TYPE
37 );
38
39 -- API Name: Copy_Lead_To_Opportunity
40 /* API renamed by Francis on 06/26/2001 from Link_Lead_To_Opportunity to Copy_Lead_To_Opportunity */
41
42 PROCEDURE Copy_Lead_To_Opportunity(
43 P_Api_Version_Number IN NUMBER,
44 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
45 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
46 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
48 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
50 P_identity_salesforce_id IN NUMBER, -- := FND_API.G_MISS_NUM,
51 P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
52 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
53 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
54 P_SALES_LEAD_ID IN NUMBER,
55 P_SALES_LEAD_LINE_TBL IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_TBL_TYPE
56 := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_TBL,
57 P_OPPORTUNITY_ID IN NUMBER,
58 X_Return_Status OUT NOCOPY VARCHAR2,
59 X_Msg_Count OUT NOCOPY NUMBER,
60 X_Msg_Data OUT NOCOPY VARCHAR2
61 );
62
63
64 -- API Name: Link_Lead_To_Opportunity
65 /* API added by Francis on 06/26/2001 */
66
67 PROCEDURE Link_Lead_To_Opportunity(
68 P_Api_Version_Number IN NUMBER,
69 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
70 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
71 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
73 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
74 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
75 P_identity_salesforce_id IN NUMBER, -- := FND_API.G_MISS_NUM,
76 P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
77 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
78 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
79 P_SALES_LEAD_ID IN NUMBER,
80 P_OPPORTUNITY_ID IN NUMBER,
81 X_Return_Status OUT NOCOPY VARCHAR2,
82 X_Msg_Count OUT NOCOPY NUMBER,
83 X_Msg_Data OUT NOCOPY VARCHAR2
84 );
85
86
87 -- API Name: Create_Opportunity_For_Lead
88
89 PROCEDURE Create_Opportunity_For_Lead(
90 P_Api_Version_Number IN NUMBER,
91 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
92 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
93 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
95 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
96 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
97 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
98 P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
99 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
100 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
101 P_SALES_LEAD_ID IN NUMBER,
102 P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
103 X_Return_Status OUT NOCOPY VARCHAR2,
104 X_Msg_Count OUT NOCOPY NUMBER,
105 X_Msg_Data OUT NOCOPY VARCHAR2,
106 X_OPPORTUNITY_ID OUT NOCOPY NUMBER
107 );
108 -- This procedure added for Bug#3613374
109 PROCEDURE CHECK_SALES_STAGE(
110 p_api_version_number IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
112 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
113 p_sales_lead_id IN NUMBER,
114 P_sales_lead_stage_id IN NUMBER,
115 P_sales_lead_methodology_id IN NUMBER,
116 X_sales_stage_id OUT NOCOPY NUMBER,
117 X_sales_methodology_id OUT NOCOPY NUMBER,
118 X_Return_Status OUT NOCOPY VARCHAR2,
119 X_Msg_Count OUT NOCOPY NUMBER,
120 X_Msg_Data OUT NOCOPY VARCHAR2
121 );
122
123 End AS_SALES_LEAD_OPP_PVT;