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,
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,
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 := FND_API.G_MISS_NUM,
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 := FND_API.G_MISS_NUM,
28: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
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 := FND_API.G_MISS_NUM,
28: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
29: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
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 := FND_API.G_MISS_NUM,
28: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
29: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
30: P_SALES_LEAD_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_rec_type,
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 := FND_API.G_MISS_NUM,
28: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
29: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
30: P_SALES_LEAD_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_rec_type,
31: X_Return_Status OUT NOCOPY VARCHAR2,
39: -- API Name: Copy_Lead_To_Opportunity
40: --
41: PROCEDURE Copy_Lead_To_Opportunity(
42: P_Api_Version_Number IN NUMBER,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: --
41: PROCEDURE Copy_Lead_To_Opportunity(
42: P_Api_Version_Number IN NUMBER,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
41: PROCEDURE Copy_Lead_To_Opportunity(
42: P_Api_Version_Number IN NUMBER,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
49: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
42: P_Api_Version_Number IN NUMBER,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
49: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
50: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
49: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
50: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
51: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
49: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
50: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
51: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
52: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
49: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
50: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
51: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
52: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
53: P_SALES_LEAD_ID IN NUMBER,
46: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
49: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
50: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
51: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
52: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
53: P_SALES_LEAD_ID IN NUMBER,
54: P_SALES_LEAD_LINE_TBL IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_TBL_TYPE
63: -- API Name: Link_Lead_To_Opportunity
64: --
65: PROCEDURE Link_Lead_To_Opportunity(
66: P_Api_Version_Number IN NUMBER,
67: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
68: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: --
65: PROCEDURE Link_Lead_To_Opportunity(
66: P_Api_Version_Number IN NUMBER,
67: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
68: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
65: PROCEDURE Link_Lead_To_Opportunity(
66: P_Api_Version_Number IN NUMBER,
67: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
68: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
73: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
66: P_Api_Version_Number IN NUMBER,
67: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
68: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
73: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
74: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
67: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
68: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
73: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
74: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
75: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
68: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
73: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
74: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
75: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
76: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
73: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
74: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
75: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
76: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
77: P_SALES_LEAD_ID IN NUMBER,
70: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
73: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
74: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
75: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
76: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
77: P_SALES_LEAD_ID IN NUMBER,
78: P_OPPORTUNITY_ID IN NUMBER,
85: -- API Name: Create_Opportunity_For_Lead
86: --
87: PROCEDURE Create_Opportunity_For_Lead(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
90: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: --
87: PROCEDURE Create_Opportunity_For_Lead(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
90: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
87: PROCEDURE Create_Opportunity_For_Lead(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
90: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
95: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
90: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
95: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
96: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
89: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
90: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
95: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
96: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
97: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
90: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
95: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
96: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
97: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
98: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
95: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
96: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
97: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
98: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
99: P_SALES_LEAD_ID IN NUMBER,
92: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
95: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
96: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
97: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
98: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
99: P_SALES_LEAD_ID IN NUMBER,
100: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
97: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
98: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
99: P_SALES_LEAD_ID IN NUMBER,
100: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: X_Return_Status OUT NOCOPY VARCHAR2,
102: X_Msg_Count OUT NOCOPY NUMBER,
103: X_Msg_Data OUT NOCOPY VARCHAR2,
104: X_OPPORTUNITY_ID OUT NOCOPY NUMBER