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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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
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,
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,
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,
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,
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
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,
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,
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
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,
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,
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,
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
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,
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,
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