16: -- Pre-Req :
17: -- Parameters:
18: -- IN
19: -- p_api_version_number IN NUMBER Required
20: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
21: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
22: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
23: -- P_RULES_Rec IN RULES_REC_TYPE Required
24: --
17: -- Parameters:
18: -- IN
19: -- p_api_version_number IN NUMBER Required
20: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
21: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
22: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
23: -- P_RULES_Rec IN RULES_REC_TYPE Required
24: --
25: -- OUT:
18: -- IN
19: -- p_api_version_number IN NUMBER Required
20: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
21: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
22: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
23: -- P_RULES_Rec IN RULES_REC_TYPE Required
24: --
25: -- OUT:
26: -- x_return_status OUT VARCHAR2
33: -- End of Comments
34: --
35: PROCEDURE Create_process_rules(
36: P_Api_Version_Number IN NUMBER,
37: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
38: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: P_Identity_Resource_Id IN NUMBER,
41: P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
34: --
35: PROCEDURE Create_process_rules(
36: P_Api_Version_Number IN NUMBER,
37: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
38: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: P_Identity_Resource_Id IN NUMBER,
41: P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
42: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
35: PROCEDURE Create_process_rules(
36: P_Api_Version_Number IN NUMBER,
37: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
38: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: P_Identity_Resource_Id IN NUMBER,
41: P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
42: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
43: X_process_rule_id OUT NOCOPY NUMBER,
54: -- Pre-Req :
55: -- Parameters:
56: -- IN
57: -- p_api_version_number IN NUMBER Required
58: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
59: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
60: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
61: -- P_Identity_Resource_Id IN NUMBER Optional Default = NULL
62: -- P_RULES_Rec IN RULES_REC_TYPE Required
55: -- Parameters:
56: -- IN
57: -- p_api_version_number IN NUMBER Required
58: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
59: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
60: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
61: -- P_Identity_Resource_Id IN NUMBER Optional Default = NULL
62: -- P_RULES_Rec IN RULES_REC_TYPE Required
63: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
56: -- IN
57: -- p_api_version_number IN NUMBER Required
58: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
59: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
60: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
61: -- P_Identity_Resource_Id IN NUMBER Optional Default = NULL
62: -- P_RULES_Rec IN RULES_REC_TYPE Required
63: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
64: --
74: --
75: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
76: PROCEDURE Update_process_rules(
77: P_Api_Version_Number IN NUMBER,
78: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
79: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: P_Identity_Resource_Id IN NUMBER,
82: P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
75: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
76: PROCEDURE Update_process_rules(
77: P_Api_Version_Number IN NUMBER,
78: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
79: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: P_Identity_Resource_Id IN NUMBER,
82: P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
83: X_Return_Status OUT NOCOPY VARCHAR2,
76: PROCEDURE Update_process_rules(
77: P_Api_Version_Number IN NUMBER,
78: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
79: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: P_Identity_Resource_Id IN NUMBER,
82: P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
83: X_Return_Status OUT NOCOPY VARCHAR2,
84: X_Msg_Count OUT NOCOPY NUMBER,
93: -- Pre-Req :
94: -- Parameters:
95: -- IN
96: -- p_api_version_number IN NUMBER Required
97: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
98: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
100: -- P_Identity_Resource_Id IN NUMBER Optional Default = NULL
101: -- P_RULES_Rec IN RULES_REC_TYPE Required
94: -- Parameters:
95: -- IN
96: -- p_api_version_number IN NUMBER Required
97: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
98: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
100: -- P_Identity_Resource_Id IN NUMBER Optional Default = NULL
101: -- P_RULES_Rec IN RULES_REC_TYPE Required
102: --
95: -- IN
96: -- p_api_version_number IN NUMBER Required
97: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
98: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
100: -- P_Identity_Resource_Id IN NUMBER Optional Default = NULL
101: -- P_RULES_Rec IN RULES_REC_TYPE Required
102: --
103: -- OUT:
113: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
114: -- The Master delete procedure may not be needed depends on different business requirements.
115: PROCEDURE Delete_process_rules(
116: P_Api_Version_Number IN NUMBER,
117: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
118: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: P_Identity_Resource_Id IN NUMBER,
121: P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
114: -- The Master delete procedure may not be needed depends on different business requirements.
115: PROCEDURE Delete_process_rules(
116: P_Api_Version_Number IN NUMBER,
117: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
118: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: P_Identity_Resource_Id IN NUMBER,
121: P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
122: X_Return_Status OUT NOCOPY VARCHAR2,
115: PROCEDURE Delete_process_rules(
116: P_Api_Version_Number IN NUMBER,
117: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
118: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: P_Identity_Resource_Id IN NUMBER,
121: P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
122: X_Return_Status OUT NOCOPY VARCHAR2,
123: X_Msg_Count OUT NOCOPY NUMBER,
132: -- Pre-Req :
133: -- Parameters:
134: -- IN
135: -- p_api_version_number IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
139: -- P_RULES_Rec IN RULES_REC_TYPE Required
140: --
133: -- Parameters:
134: -- IN
135: -- p_api_version_number IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
139: -- P_RULES_Rec IN RULES_REC_TYPE Required
140: --
141: -- OUT:
134: -- IN
135: -- p_api_version_number IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
139: -- P_RULES_Rec IN RULES_REC_TYPE Required
140: --
141: -- OUT:
142: -- x_return_status OUT VARCHAR2
149: -- End of Comments
150: --
151: PROCEDURE Copy_process_rules(
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_Identity_Resource_Id IN NUMBER,
157: P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
150: --
151: PROCEDURE Copy_process_rules(
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_Identity_Resource_Id IN NUMBER,
157: P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
158: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
151: PROCEDURE Copy_process_rules(
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_Identity_Resource_Id IN NUMBER,
157: P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
158: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
159: X_process_rule_id OUT NOCOPY NUMBER,