[Home] [Help]
PACKAGE: APPS.AS_SALES_LEAD_CONTACTS_PVT
Source
1 PACKAGE AS_SALES_LEAD_CONTACTS_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvslcs.pls 115.4 2002/11/22 07:53:52 ckapoor ship $ */
3 -- Start of Comments
4 -- Package name : AS_SALES_LEAD_CONTACTS_PVT
5 -- Purpose : Sales Lead Contacts
6 -- NOTE :
7 -- History :
8 -- 04/09/2001 FFANG Created.
9 --
10 -- End of Comments
11
12
13 -- *************************
14 -- Validation Procedures
15 -- *************************
16
17 -- Item level validation procedures
18
19 PROCEDURE Validate_CONTACT_ID (
20 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21 P_Validation_mode IN VARCHAR2,
22 P_CUSTOMER_ID IN NUMBER,
23 P_CONTACT_ID IN NUMBER,
24 X_Return_Status OUT NOCOPY VARCHAR2,
25 X_Msg_Count OUT NOCOPY NUMBER,
26 X_Msg_Data OUT NOCOPY VARCHAR2
27 );
28
29 PROCEDURE Validate_CONTACT_PARTY_ID (
30 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
31 P_Validation_mode IN VARCHAR2,
32 P_CUSTOMER_ID IN NUMBER,
33 P_CONTACT_PARTY_ID IN NUMBER,
34 X_Return_Status OUT NOCOPY VARCHAR2,
35 X_Msg_Count OUT NOCOPY NUMBER,
36 X_Msg_Data OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE Validate_PHONE_ID (
40 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41 P_Validation_mode IN VARCHAR2,
42 P_CONTACT_ID IN NUMBER,
43 P_CONTACT_PARTY_ID IN NUMBER,
44 P_PHONE_ID IN NUMBER,
45 X_Return_Status OUT NOCOPY VARCHAR2,
46 X_Msg_Count OUT NOCOPY NUMBER,
47 X_Msg_Data OUT NOCOPY VARCHAR2
48 );
49
50 PROCEDURE Validate_CONTACT_ROLE_CODE (
51 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
52 P_Validation_mode IN VARCHAR2,
53 P_CONTACT_ROLE_CODE IN VARCHAR2,
54 X_Return_Status OUT NOCOPY VARCHAR2,
55 X_Msg_Count OUT NOCOPY NUMBER,
56 X_Msg_Data OUT NOCOPY VARCHAR2
57 );
58
59 -- Record level validation procedures
60
61
62 -- Inter-record level validation
63
64
65 -- validation procedures
66
67 PROCEDURE Validate_sales_lead_contact(
68 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
69 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70 P_Validation_mode IN VARCHAR2,
71 P_SALES_LEAD_CONTACT_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type,
72 X_Return_Status OUT NOCOPY VARCHAR2,
73 X_Msg_Count OUT NOCOPY NUMBER,
74 X_Msg_Data OUT NOCOPY VARCHAR2
75 );
76
77
78 -- ***************************
79 -- Sales Lead Contact APIs
80 -- ***************************
81
82 -- API Name: Create_sales_lead_contacts
83
84 PROCEDURE Create_sales_lead_contacts(
85 P_Api_Version_Number IN NUMBER,
86 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
87 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
88 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
90 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
92 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
93 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
94 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
95 P_SALES_LEAD_CONTACT_Tbl IN
96 AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
97 := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
98 p_SALES_LEAD_ID IN NUMBER,
99 X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY
100 AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
101 X_Return_Status OUT NOCOPY VARCHAR2,
102 X_Msg_Count OUT NOCOPY NUMBER,
103 X_Msg_Data OUT NOCOPY VARCHAR2
104 );
105
106
107 -- API Name: Update_sales_lead_contacts
108
109 PROCEDURE Update_sales_lead_contacts(
110 P_Api_Version_Number IN NUMBER,
111 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
112 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
113 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
117 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
118 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
119 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
120 P_SALES_LEAD_CONTACT_Tbl IN
121 AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type,
122 X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY
123 AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
124 X_Return_Status OUT NOCOPY VARCHAR2,
125 X_Msg_Count OUT NOCOPY NUMBER,
126 X_Msg_Data OUT NOCOPY VARCHAR2
127 );
128
129
130 -- API Name: Delete_sales_lead_contacts
131
132 PROCEDURE Delete_sales_lead_contacts(
133 P_Api_Version_Number IN NUMBER,
134 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
135 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
136 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
139 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
140 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
141 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
142 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
143 P_SALES_LEAD_CONTACT_Tbl IN
144 AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type,
145 X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY
146 AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
147 X_Return_Status OUT NOCOPY VARCHAR2,
148 X_Msg_Count OUT NOCOPY NUMBER,
149 X_Msg_Data OUT NOCOPY VARCHAR2
150 );
151
152
153 -- API Name: Check_primary_contact
154
155 PROCEDURE Check_primary_contact (
156 P_Api_Version_Number IN NUMBER,
157 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
161 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
162 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
163 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
164 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
165 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
166 P_SALES_LEAD_ID IN NUMBER,
167 X_Return_Status OUT NOCOPY VARCHAR2,
168 X_Msg_Count OUT NOCOPY NUMBER,
169 X_Msg_Data OUT NOCOPY VARCHAR2
170 );
171
172 End AS_SALES_LEAD_CONTACTS_PVT;