DBA Data[Home] [Help]

APPS.PA_CI_TYPE_USAGE_PUB dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

2: /* $Header: PACITUPB.pls 120.1 2005/08/19 16:18:47 mwasowic noship $ */
3:
4: PROCEDURE create_ci_type_usage (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_project_type IN VARCHAR2 := NULL,

Line 7: p_commit IN VARCHAR2 := FND_API.g_false,

3:
4: PROCEDURE create_ci_type_usage (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_project_type IN VARCHAR2 := NULL,
11: p_project_type_id IN NUMBER := NULL,

Line 8: p_validate_only IN VARCHAR2 := FND_API.g_true,

4: PROCEDURE create_ci_type_usage (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_project_type IN VARCHAR2 := NULL,
11: p_project_type_id IN NUMBER := NULL,
12: p_ci_type_name IN VARCHAR2 := NULL,

Line 9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_project_type IN VARCHAR2 := NULL,
11: p_project_type_id IN NUMBER := NULL,
12: p_ci_type_name IN VARCHAR2 := NULL,
13: p_ci_type_id IN NUMBER := NULL,

Line 29: IF p_commit = FND_API.G_TRUE THEN

25: l_ci_type_id NUMBER := p_ci_type_id;
26: BEGIN
27: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PUB.CREATE_CI_TYPE_USAGE');
28:
29: IF p_commit = FND_API.G_TRUE THEN
30: SAVEPOINT create_ci_type_usage;
31: END IF;
32:
33: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 33: IF p_init_msg_list = FND_API.G_TRUE THEN

29: IF p_commit = FND_API.G_TRUE THEN
30: SAVEPOINT create_ci_type_usage;
31: END IF;
32:
33: IF p_init_msg_list = FND_API.G_TRUE THEN
34: fnd_msg_pub.initialize;
35: END IF;
36:
37: x_return_status := 'S';

Line 77: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

73: END IF;
74:
75: END IF;
76:
77: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
78: pa_ci_type_usage_pvt.create_ci_type_usage (
79: p_init_msg_list => 'F',
80: p_commit => 'F',
81: p_validate_only => 'F',

Line 94: IF p_commit = fnd_api.g_true THEN

90: x_msg_count => x_msg_count,
91: x_msg_data => x_msg_data);
92: END IF;
93:
94: IF p_commit = fnd_api.g_true THEN
95: IF x_return_status = 'S' THEN
96: COMMIT;
97: ELSE
98: ROLLBACK TO create_ci_type_usage;

Line 109: IF p_commit = fnd_api.g_true THEN

105: pa_debug.reset_err_stack;
106:
107: EXCEPTION
108: WHEN OTHERS THEN
109: IF p_commit = fnd_api.g_true THEN
110: ROLLBACK TO create_ci_type_usage;
111: END IF;
112:
113: x_return_status := 'U';

Line 124: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

120: END create_ci_type_usage;
121:
122: PROCEDURE update_ci_type_usage (
123: p_api_version IN NUMBER := 1.0,
124: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
125: p_commit IN VARCHAR2 := FND_API.g_false,
126: p_validate_only IN VARCHAR2 := FND_API.g_true,
127: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
128: p_ci_type_usage_id IN NUMBER,

Line 125: p_commit IN VARCHAR2 := FND_API.g_false,

121:
122: PROCEDURE update_ci_type_usage (
123: p_api_version IN NUMBER := 1.0,
124: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
125: p_commit IN VARCHAR2 := FND_API.g_false,
126: p_validate_only IN VARCHAR2 := FND_API.g_true,
127: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
128: p_ci_type_usage_id IN NUMBER,
129: p_project_type IN VARCHAR2 := NULL,

Line 126: p_validate_only IN VARCHAR2 := FND_API.g_true,

122: PROCEDURE update_ci_type_usage (
123: p_api_version IN NUMBER := 1.0,
124: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
125: p_commit IN VARCHAR2 := FND_API.g_false,
126: p_validate_only IN VARCHAR2 := FND_API.g_true,
127: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
128: p_ci_type_usage_id IN NUMBER,
129: p_project_type IN VARCHAR2 := NULL,
130: p_project_type_id IN NUMBER := NULL,

Line 127: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

123: p_api_version IN NUMBER := 1.0,
124: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
125: p_commit IN VARCHAR2 := FND_API.g_false,
126: p_validate_only IN VARCHAR2 := FND_API.g_true,
127: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
128: p_ci_type_usage_id IN NUMBER,
129: p_project_type IN VARCHAR2 := NULL,
130: p_project_type_id IN NUMBER := NULL,
131: p_ci_type_name IN VARCHAR2 := NULL,

Line 147: IF p_commit = FND_API.G_TRUE THEN

143: l_ci_type_id NUMBER := p_ci_type_id;
144: BEGIN
145: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PUB.UPDATE_CI_TYPE_USAGE');
146:
147: IF p_commit = FND_API.G_TRUE THEN
148: SAVEPOINT update_ci_type_usage;
149: END IF;
150:
151: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 151: IF p_init_msg_list = FND_API.G_TRUE THEN

147: IF p_commit = FND_API.G_TRUE THEN
148: SAVEPOINT update_ci_type_usage;
149: END IF;
150:
151: IF p_init_msg_list = FND_API.G_TRUE THEN
152: fnd_msg_pub.initialize;
153: END IF;
154:
155: x_return_status := 'S';

Line 195: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

191: END IF;
192:
193: END IF;
194:
195: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
196: pa_ci_type_usage_pvt.update_ci_type_usage (
197: p_init_msg_list => 'F',
198: p_commit => 'F',
199: p_validate_only => 'F',

Line 212: IF p_commit = fnd_api.g_true THEN

208: x_msg_count => x_msg_count,
209: x_msg_data => x_msg_data);
210: END IF;
211:
212: IF p_commit = fnd_api.g_true THEN
213: IF x_return_status = 'S' THEN
214: COMMIT;
215: ELSE
216: ROLLBACK TO update_ci_type_usage;

Line 227: IF p_commit = fnd_api.g_true THEN

223: pa_debug.reset_err_stack;
224:
225: EXCEPTION
226: WHEN OTHERS THEN
227: IF p_commit = fnd_api.g_true THEN
228: ROLLBACK TO update_ci_type_usage;
229: END IF;
230:
231: x_return_status := 'U';

Line 242: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

238: END update_ci_type_usage;
239:
240: PROCEDURE delete_ci_type_usage (
241: p_api_version IN NUMBER := 1.0,
242: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
243: p_commit IN VARCHAR2 := FND_API.g_false,
244: p_validate_only IN VARCHAR2 := FND_API.g_true,
245: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
246: p_ci_type_usage_id IN NUMBER,

Line 243: p_commit IN VARCHAR2 := FND_API.g_false,

239:
240: PROCEDURE delete_ci_type_usage (
241: p_api_version IN NUMBER := 1.0,
242: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
243: p_commit IN VARCHAR2 := FND_API.g_false,
244: p_validate_only IN VARCHAR2 := FND_API.g_true,
245: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
246: p_ci_type_usage_id IN NUMBER,
247: p_project_type IN VARCHAR2 := NULL,

Line 244: p_validate_only IN VARCHAR2 := FND_API.g_true,

240: PROCEDURE delete_ci_type_usage (
241: p_api_version IN NUMBER := 1.0,
242: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
243: p_commit IN VARCHAR2 := FND_API.g_false,
244: p_validate_only IN VARCHAR2 := FND_API.g_true,
245: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
246: p_ci_type_usage_id IN NUMBER,
247: p_project_type IN VARCHAR2 := NULL,
248: p_project_type_id IN NUMBER := NULL,

Line 245: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

241: p_api_version IN NUMBER := 1.0,
242: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
243: p_commit IN VARCHAR2 := FND_API.g_false,
244: p_validate_only IN VARCHAR2 := FND_API.g_true,
245: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
246: p_ci_type_usage_id IN NUMBER,
247: p_project_type IN VARCHAR2 := NULL,
248: p_project_type_id IN NUMBER := NULL,
249: p_ci_type_name IN VARCHAR2 := NULL,

Line 262: IF p_commit = FND_API.G_TRUE THEN

258: l_ci_type_id NUMBER := p_ci_type_id;
259: BEGIN
260: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PUB.DELETE_CI_TYPE_USAGE');
261:
262: IF p_commit = FND_API.G_TRUE THEN
263: SAVEPOINT delete_ci_type_usage;
264: END IF;
265:
266: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 266: IF p_init_msg_list = FND_API.G_TRUE THEN

262: IF p_commit = FND_API.G_TRUE THEN
263: SAVEPOINT delete_ci_type_usage;
264: END IF;
265:
266: IF p_init_msg_list = FND_API.G_TRUE THEN
267: fnd_msg_pub.initialize;
268: END IF;
269:
270: x_return_status := 'S';

Line 311: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

307: END IF;
308:
309: END IF;
310:
311: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
312: pa_ci_type_usage_pvt.delete_ci_type_usage (
313: p_init_msg_list => 'F',
314: p_commit => 'F',
315: p_validate_only => 'F',

Line 325: IF p_commit = fnd_api.g_true THEN

321: x_msg_count => x_msg_count,
322: x_msg_data => x_msg_data);
323: END IF;
324:
325: IF p_commit = fnd_api.g_true THEN
326: IF x_return_status = 'S' THEN
327: COMMIT;
328: ELSE
329: ROLLBACK TO delete_ci_type_usage;

Line 340: IF p_commit = fnd_api.g_true THEN

336: pa_debug.reset_err_stack;
337:
338: EXCEPTION
339: WHEN OTHERS THEN
340: IF p_commit = fnd_api.g_true THEN
341: ROLLBACK TO delete_ci_type_usage;
342: END IF;
343:
344: x_return_status := 'U';