DBA Data[Home] [Help]

PACKAGE: APPS.AS_LINK_LEAD_OPP_PUB

Source


1 PACKAGE AS_LINK_LEAD_OPP_PUB AUTHID CURRENT_USER as
2 /* $Header: asxpllos.pls 115.1 2002/11/15 01:37:07 axavier ship $ */
3 -- Start of Comments
4 -- Package name     : AS_LINK_LEAD_OPP_PUB
5 -- Purpose          : Link/Copy Leads to Opportunity
6 -- NOTE             :
7 -- History          :
8 --     06/25/2002 FFANG  Created.
9 --
10 -- End of Comments
11 
12 -- Default number of records fetch per call
13 G_DEFAULT_NUM_REC_FETCH  NUMBER := 30;
14 
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      := 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,
32     X_Msg_Count                  OUT NOCOPY  NUMBER,
33     X_Msg_Data                   OUT NOCOPY  VARCHAR2,
34     X_OPPORTUNITY_TBL            OUT NOCOPY  AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE,
35     X_OPP_LINES_tbl              OUT NOCOPY  AS_OPPORTUNITY_PUB.LINE_TBL_TYPE
36     );
37 
38 --
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,
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
55                               := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_TBL,
56     P_OPPORTUNITY_ID            IN   NUMBER,
57     X_Return_Status             OUT NOCOPY  VARCHAR2,
58     X_Msg_Count                 OUT NOCOPY  NUMBER,
59     X_Msg_Data                  OUT NOCOPY  VARCHAR2
60     );
61 
62 --
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,
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,
79     X_Return_Status              OUT NOCOPY  VARCHAR2,
80     X_Msg_Count                  OUT NOCOPY  NUMBER,
81     X_Msg_Data                   OUT NOCOPY  VARCHAR2
82     );
83 
84 --
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,
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,
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
105     );
106 
107 
108 End AS_LINK_LEAD_OPP_PUB;