DBA Data[Home] [Help]

APPS.PV_PROCESS_RULES_PUB dependencies on FND_API

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

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

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

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:

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

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

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

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,

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

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.

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

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,

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

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

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

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

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

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

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

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,

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

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,

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

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,

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

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

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

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

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

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:

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

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,

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

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,

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

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,

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

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

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

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:

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

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

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

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,

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

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.

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

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,