[Home] [Help]
PACKAGE: APPS.AS_SALES_LEAD_LINES_PVT
Source
1 PACKAGE AS_SALES_LEAD_LINES_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvslls.pls 115.6 2004/03/29 23:01:32 chchandr ship $ */
3 -- Start of Comments
4 -- Package name : AS_SALES_LEAD_LINES_PVT
5 -- Purpose : Sales Leads Lines
6 -- NOTE :
7 -- History :
8 -- 03/29/2001 FFANG Created.
9 --
10 -- End of Comments
11
12
13 -- *************************
14 -- Validation Procedures
15 -- *************************
16
17 -- Item level validation procedures
18
19 /*
20 PROCEDURE Validate_INTEREST_TYPE_ID (
21 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22 P_Validation_mode IN VARCHAR2,
23 P_INTEREST_TYPE_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_PRIM_INT_CODE_ID (
30 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
31 P_Validation_mode IN VARCHAR2,
32 P_INTEREST_TYPE_ID IN NUMBER,
33 P_PRIMARY_INTEREST_CODE_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_SEC_INT_CODE_ID (
40 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41 P_Validation_mode IN VARCHAR2,
42 P_INTEREST_TYPE_ID IN NUMBER,
43 P_PRIMARY_INTEREST_CODE_ID IN NUMBER,
44 P_SECONDARY_INTEREST_CODE_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
51 PROCEDURE Validate_INV_ORG_ID (
52 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
53 P_Validation_mode IN VARCHAR2,
54 P_INVENTORY_ITEM_ID IN NUMBER,
55 P_ORGANIZATION_ID IN NUMBER,
56 X_Return_Status OUT NOCOPY VARCHAR2,
57 X_Msg_Count OUT NOCOPY NUMBER,
58 X_Msg_Data OUT NOCOPY VARCHAR2
59 );
60
61 PROCEDURE Validate_UOM_CODE (
62 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
63 P_Validation_mode IN VARCHAR2,
64 P_UOM_CODE IN VARCHAR2,
65 X_Return_Status OUT NOCOPY VARCHAR2,
66 X_Msg_Count OUT NOCOPY NUMBER,
67 X_Msg_Data OUT NOCOPY VARCHAR2
68 );
69
70
71
72
73 PROCEDURE Validate_Category_ID (
74 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
75 P_Validation_mode IN VARCHAR2,
76 P_Category_ID IN NUMBER,
77 X_Return_Status OUT NOCOPY VARCHAR2,
78 X_Msg_Count OUT NOCOPY NUMBER,
79 X_Msg_Data OUT NOCOPY VARCHAR2
80 );
81
82
83 PROCEDURE Validate_Category_Set_ID (
84 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
85 P_Validation_mode IN VARCHAR2,
86 P_Category_Set_ID IN NUMBER,
87 X_Return_Status OUT NOCOPY VARCHAR2,
88 X_Msg_Count OUT NOCOPY NUMBER,
89 X_Msg_Data OUT NOCOPY VARCHAR2
90 );
91
92
93
94 -- Record level validation procedures
95
96 PROCEDURE Validate_Intrst_Type_Sec_CODE (
97 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
98 P_Validation_mode IN VARCHAR2,
99 P_INTEREST_TYPE_ID IN NUMBER,
100 P_PRIMARY_INTEREST_CODE_ID IN NUMBER,
101 P_SECONDARY_INTEREST_CODE_ID IN NUMBER,
102 X_Return_Status OUT NOCOPY VARCHAR2,
103 X_Msg_Count OUT NOCOPY NUMBER,
104 X_Msg_Data OUT NOCOPY VARCHAR2
105 );
106
107 PROCEDURE Validate_INVENT_INTRST(
108 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
109 P_Validation_mode IN VARCHAR2,
110 P_INTEREST_TYPE_ID IN NUMBER,
111 P_INVENTORY_ITEM_ID IN NUMBER,
112 X_Return_Status OUT NOCOPY VARCHAR2,
113 X_Msg_Count OUT NOCOPY NUMBER,
114 X_Msg_Data OUT NOCOPY VARCHAR2
115 );
116
117
118 -- Inter-record level validation
119 /*
120 PROCEDURE Validate_Budget_Amounts(
121 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
122 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123 P_Validation_mode IN VARCHAR2,
124 P_SALES_LEAD_ID IN NUMBER,
125 X_Return_Status OUT NOCOPY VARCHAR2,
126 X_Msg_Count OUT NOCOPY NUMBER,
127 X_Msg_Data OUT NOCOPY VARCHAR2
128 );
129 */
130
131 -- validation procedures
132
133 PROCEDURE Validate_sales_lead_line(
134 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
135 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136 P_Validation_mode IN VARCHAR2,
137 P_SALES_LEAD_LINE_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type,
138 X_Return_Status OUT NOCOPY VARCHAR2,
139 X_Msg_Count OUT NOCOPY NUMBER,
140 X_Msg_Data OUT NOCOPY VARCHAR2
141 );
142
143
144
145 -- ************************
146 -- Sales Lead Line APIs
147 -- ************************
148
149 -- API Name: Create_sales_lead_lines
150
151 PROCEDURE Create_sales_lead_lines(
152 P_Api_Version_Number IN NUMBER,
153 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
154 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
155 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
157 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
158 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
159 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
160 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
161 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
162 P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_Type
163 := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
164 P_SALES_LEAD_ID IN NUMBER,
165 X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY
166 AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
167 X_Return_Status OUT NOCOPY VARCHAR2,
168 X_Msg_Count OUT NOCOPY NUMBER,
169 X_Msg_Data OUT NOCOPY VARCHAR2
170 );
171
172
173 -- API Name: Update_sales_lead_lines
174
175 PROCEDURE Update_sales_lead_lines(
176 P_Api_Version_Number IN NUMBER,
177 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
178 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
179 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
181 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
182 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
183 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
184 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
185 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
186 P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_Type,
187 X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY
188 AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
189 X_Return_Status OUT NOCOPY VARCHAR2,
190 X_Msg_Count OUT NOCOPY NUMBER,
191 X_Msg_Data OUT NOCOPY VARCHAR2
192 );
193
194
195 -- API Name: Delete_sales_lead_lines
196
197 PROCEDURE Delete_sales_lead_lines(
198 P_Api_Version_Number IN NUMBER,
199 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
203 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
204 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
205 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
206 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
207 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
208 P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_Type,
209 X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY
210 AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
211 X_Return_Status OUT NOCOPY VARCHAR2,
212 X_Msg_Count OUT NOCOPY NUMBER,
213 X_Msg_Data OUT NOCOPY VARCHAR2
214 );
215
216
217 End AS_SALES_LEAD_LINES_PVT;