5:
6: PROCEDURE Insert_Row
7: (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_msg_count OUT NOCOPY NUMBER,
6: PROCEDURE Insert_Row
7: (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_msg_count OUT NOCOPY NUMBER,
14: p_msg_data OUT NOCOPY VARCHAR2,
7: (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_msg_count OUT NOCOPY NUMBER,
14: p_msg_data OUT NOCOPY VARCHAR2,
15: --
39:
40: PROCEDURE Lock_Row
41: (
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: p_return_status OUT NOCOPY VARCHAR2,
47: p_msg_count OUT NOCOPY NUMBER,
40: PROCEDURE Lock_Row
41: (
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: p_return_status OUT NOCOPY VARCHAR2,
47: p_msg_count OUT NOCOPY NUMBER,
48: p_msg_data OUT NOCOPY VARCHAR2,
41: (
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: p_return_status OUT NOCOPY VARCHAR2,
47: p_msg_count OUT NOCOPY NUMBER,
48: p_msg_data OUT NOCOPY VARCHAR2,
49: --
73:
74: PROCEDURE Update_Row
75: (
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE,
79: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80: p_return_status OUT NOCOPY VARCHAR2,
81: p_msg_count OUT NOCOPY NUMBER,
74: PROCEDURE Update_Row
75: (
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE,
79: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80: p_return_status OUT NOCOPY VARCHAR2,
81: p_msg_count OUT NOCOPY NUMBER,
82: p_msg_data OUT NOCOPY VARCHAR2,
75: (
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE,
79: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80: p_return_status OUT NOCOPY VARCHAR2,
81: p_msg_count OUT NOCOPY NUMBER,
82: p_msg_data OUT NOCOPY VARCHAR2,
83: --
106:
107: PROCEDURE Delete_Row
108: (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: p_return_status OUT NOCOPY VARCHAR2,
114: p_msg_count OUT NOCOPY NUMBER,
107: PROCEDURE Delete_Row
108: (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: p_return_status OUT NOCOPY VARCHAR2,
114: p_msg_count OUT NOCOPY NUMBER,
115: p_msg_data OUT NOCOPY VARCHAR2,
108: (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: p_return_status OUT NOCOPY VARCHAR2,
114: p_msg_count OUT NOCOPY NUMBER,
115: p_msg_data OUT NOCOPY VARCHAR2,
116: --
119:
120: PROCEDURE Rules_Insert_Row
121: (
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
124: p_commit IN VARCHAR2 := FND_API.G_FALSE,
125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126: p_return_status OUT NOCOPY VARCHAR2,
127: p_msg_count OUT NOCOPY NUMBER,
120: PROCEDURE Rules_Insert_Row
121: (
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
124: p_commit IN VARCHAR2 := FND_API.G_FALSE,
125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126: p_return_status OUT NOCOPY VARCHAR2,
127: p_msg_count OUT NOCOPY NUMBER,
128: p_msg_data OUT NOCOPY VARCHAR2,
121: (
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
124: p_commit IN VARCHAR2 := FND_API.G_FALSE,
125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126: p_return_status OUT NOCOPY VARCHAR2,
127: p_msg_count OUT NOCOPY NUMBER,
128: p_msg_data OUT NOCOPY VARCHAR2,
129: --
137:
138: PROCEDURE Rules_Delete_Row
139: (
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144: p_return_status OUT NOCOPY VARCHAR2,
145: p_msg_count OUT NOCOPY NUMBER,
138: PROCEDURE Rules_Delete_Row
139: (
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144: p_return_status OUT NOCOPY VARCHAR2,
145: p_msg_count OUT NOCOPY NUMBER,
146: p_msg_data OUT NOCOPY VARCHAR2,
139: (
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144: p_return_status OUT NOCOPY VARCHAR2,
145: p_msg_count OUT NOCOPY NUMBER,
146: p_msg_data OUT NOCOPY VARCHAR2,
147: --
150:
151: PROCEDURE Distribution_Insert_Row
152: (
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_return_status OUT NOCOPY VARCHAR2,
158: p_msg_count OUT NOCOPY NUMBER,
151: PROCEDURE Distribution_Insert_Row
152: (
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_return_status OUT NOCOPY VARCHAR2,
158: p_msg_count OUT NOCOPY NUMBER,
159: p_msg_data OUT NOCOPY VARCHAR2,
152: (
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_return_status OUT NOCOPY VARCHAR2,
158: p_msg_count OUT NOCOPY NUMBER,
159: p_msg_data OUT NOCOPY VARCHAR2,
160: --
173:
174: PROCEDURE Check_Unique
175: (
176: p_api_version 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_return_status OUT NOCOPY VARCHAR2,
181: p_msg_count OUT NOCOPY NUMBER,
174: PROCEDURE Check_Unique
175: (
176: p_api_version 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_return_status OUT NOCOPY VARCHAR2,
181: p_msg_count OUT NOCOPY NUMBER,
182: p_msg_data OUT NOCOPY VARCHAR2,
175: (
176: p_api_version 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_return_status OUT NOCOPY VARCHAR2,
181: p_msg_count OUT NOCOPY NUMBER,
182: p_msg_data OUT NOCOPY VARCHAR2,
183: --
188: --
189: PROCEDURE Copy_Rule
190: (
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195: p_return_status OUT NOCOPY VARCHAR2,
196: p_msg_count OUT NOCOPY NUMBER,
189: PROCEDURE Copy_Rule
190: (
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195: p_return_status OUT NOCOPY VARCHAR2,
196: p_msg_count OUT NOCOPY NUMBER,
197: p_msg_data OUT NOCOPY VARCHAR2,
190: (
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195: p_return_status OUT NOCOPY VARCHAR2,
196: p_msg_count OUT NOCOPY NUMBER,
197: p_msg_data OUT NOCOPY VARCHAR2,
198: --