68: -- Parameters:
69: -- IN
70: -- p_api_version_number IN NUMBER Required
71: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
72: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
73: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
74: -- P_CHK_RULES_Rec IN CHK_RULES_Rec_Type Required
75: --
76: -- OUT:
69: -- IN
70: -- p_api_version_number IN NUMBER Required
71: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
72: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
73: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
74: -- P_CHK_RULES_Rec IN CHK_RULES_Rec_Type Required
75: --
76: -- OUT:
77: -- x_return_status OUT VARCHAR2
82: -- End of Comments
83: --
84: PROCEDURE Create_profile_check_rules(
85: P_Api_Version_Number IN NUMBER,
86: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
87: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
88: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
89: P_CHECK_ID IN NUMBER,
90: P_BLOCK_ID IN NUMBER,
83: --
84: PROCEDURE Create_profile_check_rules(
85: P_Api_Version_Number IN NUMBER,
86: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
87: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
88: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
89: P_CHECK_ID IN NUMBER,
90: P_BLOCK_ID IN NUMBER,
91: P_SEQUENCE IN NUMBER,
84: PROCEDURE Create_profile_check_rules(
85: P_Api_Version_Number IN NUMBER,
86: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
87: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
88: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
89: P_CHECK_ID IN NUMBER,
90: P_BLOCK_ID IN NUMBER,
91: P_SEQUENCE IN NUMBER,
92: P_CREATED_BY IN NUMBER,
108: );
109:
110: PROCEDURE Create_profile_check_rules(
111: P_Api_Version_Number IN NUMBER,
112: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
113: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
114: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
115: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
116: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
109:
110: PROCEDURE Create_profile_check_rules(
111: P_Api_Version_Number IN NUMBER,
112: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
113: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
114: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
115: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
116: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
117: X_Return_Status OUT NOCOPY VARCHAR2,
110: PROCEDURE Create_profile_check_rules(
111: P_Api_Version_Number IN NUMBER,
112: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
113: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
114: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
115: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
116: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
117: X_Return_Status OUT NOCOPY VARCHAR2,
118: X_Msg_Count OUT NOCOPY NUMBER,
128: -- Parameters:
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
134: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
135: -- P_CHK_RULES_Rec IN CHK_RULES_Rec_Type Required
136: --
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
134: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
135: -- P_CHK_RULES_Rec IN CHK_RULES_Rec_Type Required
136: --
137: -- OUT:
144: --
145:
146: PROCEDURE Update_profile_check_rules(
147: P_Api_Version_Number IN NUMBER,
148: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
149: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
150: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
151: P_CHECK_ID IN NUMBER,
152: P_BLOCK_ID IN NUMBER,
145:
146: PROCEDURE Update_profile_check_rules(
147: P_Api_Version_Number IN NUMBER,
148: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
149: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
150: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
151: P_CHECK_ID IN NUMBER,
152: P_BLOCK_ID IN NUMBER,
153: P_SEQUENCE IN NUMBER,
146: PROCEDURE Update_profile_check_rules(
147: P_Api_Version_Number IN NUMBER,
148: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
149: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
150: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
151: P_CHECK_ID IN NUMBER,
152: P_BLOCK_ID IN NUMBER,
153: P_SEQUENCE IN NUMBER,
154: P_CREATED_BY IN NUMBER,
170: );
171:
172: PROCEDURE Update_profile_check_rules(
173: P_Api_Version_Number IN NUMBER,
174: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
175: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
176: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
177: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
178: --P_CHECK_ID IN NUMBER,
171:
172: PROCEDURE Update_profile_check_rules(
173: P_Api_Version_Number IN NUMBER,
174: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
175: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
176: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
177: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
178: --P_CHECK_ID IN NUMBER,
179: --P_BLOCK_ID IN NUMBER,
172: PROCEDURE Update_profile_check_rules(
173: P_Api_Version_Number IN NUMBER,
174: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
175: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
176: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
177: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
178: --P_CHECK_ID IN NUMBER,
179: --P_BLOCK_ID IN NUMBER,
180: PX_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
192: -- Parameters:
193: -- IN
194: -- p_api_version_number IN NUMBER Required
195: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
196: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
197: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
198: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
199: -- P_CHK_RULES_Rec IN CHK_RULES_Rec_Type Required
200: --
193: -- IN
194: -- p_api_version_number IN NUMBER Required
195: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
196: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
197: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
198: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
199: -- P_CHK_RULES_Rec IN CHK_RULES_Rec_Type Required
200: --
201: -- OUT:
207: -- End of Comments
208: --
209: PROCEDURE Delete_profile_check_rules(
210: P_Api_Version_Number IN NUMBER,
211: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
212: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
213: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
214: p_Check_id IN NUMBER,
215: p_Sequence IN NUMBER,
208: --
209: PROCEDURE Delete_profile_check_rules(
210: P_Api_Version_Number IN NUMBER,
211: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
212: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
213: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
214: p_Check_id IN NUMBER,
215: p_Sequence IN NUMBER,
216: p_OBJECT_VERSION_NUMBER IN NUMBER,
209: PROCEDURE Delete_profile_check_rules(
210: P_Api_Version_Number IN NUMBER,
211: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
212: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
213: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
214: p_Check_id IN NUMBER,
215: p_Sequence IN NUMBER,
216: p_OBJECT_VERSION_NUMBER IN NUMBER,
217: X_Return_Status OUT NOCOPY VARCHAR2,
225: -- API Name: Validate_profile_check_rules
226:
227: PROCEDURE Validate_profile_check_rules(
228: P_Api_Name IN VARCHAR2,
229: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
230: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
231: P_Validation_mode IN VARCHAR2,
232: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type,
233: --P_BLOCK_ID IN NUMBER,
226:
227: PROCEDURE Validate_profile_check_rules(
228: P_Api_Name IN VARCHAR2,
229: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
230: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
231: P_Validation_mode IN VARCHAR2,
232: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type,
233: --P_BLOCK_ID IN NUMBER,
234: --P_CHECK_ID IN NUMBER,