DBA Data[Home] [Help]

APPS.PV_PROCESS_RULE_PVT dependencies on FND_API

Line 22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

18: -- Pre-Req :
19: -- Parameters:
20: -- IN
21: -- p_api_version_number IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
26: --

Line 23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

19: -- Parameters:
20: -- IN
21: -- p_api_version_number IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
26: --
27: -- OUT:

Line 24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

20: -- IN
21: -- p_api_version_number IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
26: --
27: -- OUT:
28: -- x_return_status OUT VARCHAR2

Line 40: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

36: --
37:
38: PROCEDURE Create_process_rule(
39: P_Api_Version_Number IN NUMBER,
40: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: P_Identity_Resource_Id IN NUMBER,
44: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE

Line 41: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

37:
38: PROCEDURE Create_process_rule(
39: P_Api_Version_Number IN NUMBER,
40: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: P_Identity_Resource_Id IN NUMBER,
44: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
45: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,

Line 42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

38: PROCEDURE Create_process_rule(
39: P_Api_Version_Number IN NUMBER,
40: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: P_Identity_Resource_Id IN NUMBER,
44: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
45: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
46: X_PROCESS_RULE_ID OUT NOCOPY NUMBER,

Line 61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

57: -- Pre-Req :
58: -- Parameters:
59: -- IN
60: -- p_api_version_number IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_identity_resource_id IN NUMBER Optional Default = NULL
65: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required

Line 62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

58: -- Parameters:
59: -- IN
60: -- p_api_version_number IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_identity_resource_id IN NUMBER Optional Default = NULL
65: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
66: --

Line 63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

59: -- IN
60: -- p_api_version_number IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_identity_resource_id IN NUMBER Optional Default = NULL
65: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
66: --
67: -- OUT:

Line 80: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

76: --
77: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
78: PROCEDURE Update_process_rule(
79: P_Api_Version_Number IN NUMBER,
80: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
81: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: P_Identity_Resource_Id IN NUMBER,
84: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,

Line 81: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

77: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
78: PROCEDURE Update_process_rule(
79: P_Api_Version_Number IN NUMBER,
80: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
81: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: P_Identity_Resource_Id IN NUMBER,
84: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
85: X_Return_Status OUT NOCOPY VARCHAR2,

Line 82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

78: PROCEDURE Update_process_rule(
79: P_Api_Version_Number IN NUMBER,
80: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
81: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: P_Identity_Resource_Id IN NUMBER,
84: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
85: X_Return_Status OUT NOCOPY VARCHAR2,
86: X_Msg_Count OUT NOCOPY NUMBER,

Line 99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

95: -- Pre-Req :
96: -- Parameters:
97: -- IN
98: -- p_api_version_number IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
102: -- p_identity_resource_id IN NUMBER Optional Default = NULL
103: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required

Line 100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

96: -- Parameters:
97: -- IN
98: -- p_api_version_number IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
102: -- p_identity_resource_id IN NUMBER Optional Default = NULL
103: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
104: --

Line 101: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

97: -- IN
98: -- p_api_version_number IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
102: -- p_identity_resource_id IN NUMBER Optional Default = NULL
103: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
104: --
105: -- OUT:

Line 119: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

115: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
116: -- The Master delete procedure may not be needed depends on different business requirements.
117: PROCEDURE Delete_process_rule(
118: P_Api_Version_Number IN NUMBER,
119: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
120: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: P_Identity_Resource_Id IN NUMBER,
123: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,

Line 120: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

116: -- The Master delete procedure may not be needed depends on different business requirements.
117: PROCEDURE Delete_process_rule(
118: P_Api_Version_Number IN NUMBER,
119: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
120: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: P_Identity_Resource_Id IN NUMBER,
123: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
124: X_Return_Status OUT NOCOPY VARCHAR2,

Line 121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

117: PROCEDURE Delete_process_rule(
118: P_Api_Version_Number IN NUMBER,
119: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
120: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: P_Identity_Resource_Id IN NUMBER,
123: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
124: X_Return_Status OUT NOCOPY VARCHAR2,
125: X_Msg_Count OUT NOCOPY NUMBER,

Line 138: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

134: -- Pre-Req :
135: -- Parameters:
136: -- IN
137: -- p_api_version_number IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
139: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
142: --

Line 139: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

135: -- Parameters:
136: -- IN
137: -- p_api_version_number IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
139: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
142: --
143: -- OUT:

Line 140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

136: -- IN
137: -- p_api_version_number IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
139: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
142: --
143: -- OUT:
144: -- x_return_status OUT VARCHAR2

Line 156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

152: --
153:
154: PROCEDURE Copy_process_rule(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_Identity_Resource_Id IN NUMBER,
160: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE

Line 157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

153:
154: PROCEDURE Copy_process_rule(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_Identity_Resource_Id IN NUMBER,
160: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
161: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,

Line 158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

154: PROCEDURE Copy_process_rule(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_Identity_Resource_Id IN NUMBER,
160: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
161: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
162: X_PROCESS_RULE_ID OUT NOCOPY NUMBER,

Line 182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

178: --
179: -- End of Comments
180:
181: PROCEDURE Validate_PROCESS_RULE_ID (
182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183: P_Validation_mode IN VARCHAR2,
184: P_PROCESS_RULE_ID IN NUMBER,
185: X_Return_Status OUT NOCOPY VARCHAR2,
186: X_Msg_Count OUT NOCOPY NUMBER,

Line 203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

199: --
200: -- End of Comments
201:
202: PROCEDURE Validate_OWNER_RESOURCE_ID (
203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204: P_Validation_mode IN VARCHAR2,
205: P_OWNER_RESOURCE_ID IN NUMBER,
206: X_Return_Status OUT NOCOPY VARCHAR2,
207: X_Msg_Count OUT NOCOPY NUMBER,

Line 224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

220: --
221: -- End of Comments
222:
223: PROCEDURE Validate_CURRENCY_CODE (
224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225: P_Validation_mode IN VARCHAR2,
226: P_CURRENCY_CODE IN VARCHAR2,
227: X_Return_Status OUT NOCOPY VARCHAR2,
228: X_Msg_Count OUT NOCOPY NUMBER,

Line 245: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

241: -- 2. We can also validate table instead of record. There will be an option for user to choose.
242: -- End of Comments
243:
244: PROCEDURE Validate_RANK (
245: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
246: P_Validation_mode IN VARCHAR2,
247: P_Parent_Rule_ID IN NUMBER,
248: P_Child_Rule_ID IN NUMBER,
249: P_RANK IN NUMBER,

Line 264: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

260: --
261: -- End of Comments
262:
263: PROCEDURE Validate_enddate(
264: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
265: P_Validation_mode IN VARCHAR2,
266: P_START_DATE IN DATE,
267: P_END_DATE IN DATE,
268: X_Return_Status OUT NOCOPY VARCHAR2,

Line 274: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

270: X_Msg_Data OUT NOCOPY VARCHAR2
271: );
272:
273: PROCEDURE Validate_startdate(
274: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
275: P_Validation_mode IN VARCHAR2,
276: P_Parent_Rule_ID IN NUMBER,
277: P_START_DATE IN DATE,
278: X_Return_Status OUT NOCOPY VARCHAR2,

Line 284: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

280: X_Msg_Data OUT NOCOPY VARCHAR2
281: );
282:
283: PROCEDURE Validate_status(
284: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
285: P_Validation_mode IN VARCHAR2,
286: P_Parent_Rule_ID IN NUMBER,
287: P_STATUS IN VARCHAR2,
288: X_Return_Status OUT NOCOPY VARCHAR2,

Line 306: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

302: --
303: -- End of Comments
304:
305: PROCEDURE Validate_process_rule(
306: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
307: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: P_Validation_mode IN VARCHAR2,
309: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
310: X_Return_Status OUT NOCOPY VARCHAR2,

Line 307: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

303: -- End of Comments
304:
305: PROCEDURE Validate_process_rule(
306: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
307: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: P_Validation_mode IN VARCHAR2,
309: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
310: X_Return_Status OUT NOCOPY VARCHAR2,
311: X_Msg_Count OUT NOCOPY NUMBER,