DBA Data[Home] [Help]

APPS.CSF_REQUESTS_PVT dependencies on STANDARD

Line 32: -- Standard start of API savepoint

28: l_api_version CONSTANT NUMBER := 1.0;
29:
30: l_request_task_id NUMBER;
31: BEGIN
32: -- Standard start of API savepoint
33: SAVEPOINT createschedulerrequest;
34:
35: -- Standard call to check for call compatibility
36: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 35: -- Standard call to check for call compatibility

31: BEGIN
32: -- Standard start of API savepoint
33: SAVEPOINT createschedulerrequest;
34:
35: -- Standard call to check for call compatibility
36: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
37: RAISE fnd_api.g_exc_unexpected_error;
38: END IF;
39:

Line 116: -- Standard check of p_commit

112: , p_request_task_id => l_request_task_id
113: , p_resource_tbl => p_resource_tbl
114: );
115:
116: -- Standard check of p_commit
117: IF fnd_api.to_boolean(p_commit) THEN
118: COMMIT WORK;
119: END IF;
120: EXCEPTION

Line 151: -- Standard start of API savepoint

147: ) IS
148: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_RESULTS';
149: l_api_version CONSTANT NUMBER := 1.0;
150: BEGIN
151: -- Standard start of API savepoint
152: SAVEPOINT createresourceresults;
153:
154: -- Standard call to check for call compatibility
155: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 154: -- Standard call to check for call compatibility

150: BEGIN
151: -- Standard start of API savepoint
152: SAVEPOINT createresourceresults;
153:
154: -- Standard call to check for call compatibility
155: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
156: RAISE fnd_api.g_exc_unexpected_error;
157: END IF;
158:

Line 257: -- Standard start of API savepoint

253: AND so.COST(+) = p_spares_cost;
254:
255: l_resource_rec c_resource%ROWTYPE;
256: BEGIN
257: -- Standard start of API savepoint
258: SAVEPOINT createplanoption;
259:
260: -- Standard call to check for call compatibility
261: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 260: -- Standard call to check for call compatibility

256: BEGIN
257: -- Standard start of API savepoint
258: SAVEPOINT createplanoption;
259:
260: -- Standard call to check for call compatibility
261: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
262: RAISE fnd_api.g_exc_unexpected_error;
263: END IF;
264:

Line 325: -- Standard check of p_commit

321:
322: -- output plan option id
323: x_plan_option_id := l_resource_rec.plan_option_id;
324:
325: -- Standard check of p_commit
326: IF fnd_api.to_boolean(p_commit) THEN
327: COMMIT WORK;
328: END IF;
329: EXCEPTION

Line 367: -- Standard start of API savepoint

363: ) IS
364: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PLAN_OPTION_TASK';
365: l_api_version CONSTANT NUMBER := 1.0;
366: BEGIN
367: -- Standard start of API savepoint
368: SAVEPOINT createplanoptiontask;
369:
370: -- Standard call to check for call compatibility
371: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 370: -- Standard call to check for call compatibility

366: BEGIN
367: -- Standard start of API savepoint
368: SAVEPOINT createplanoptiontask;
369:
370: -- Standard call to check for call compatibility
371: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
372: RAISE fnd_api.g_exc_unexpected_error;
373: END IF;
374:

Line 407: -- Standard check of p_commit

403: , p_trip_id
404: , 1
405: );
406:
407: -- Standard check of p_commit
408: IF fnd_api.to_boolean(p_commit) THEN
409: COMMIT WORK;
410: END IF;
411: EXCEPTION

Line 455: -- Standard start of API savepoint

451: AND ROWNUM = 1; -- there should be one task per request
452:
453: l_rec c_message%ROWTYPE;
454: BEGIN
455: -- Standard start of API savepoint
456: SAVEPOINT createmessage;
457:
458: -- Standard call to check for call compatibility
459: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 458: -- Standard call to check for call compatibility

454: BEGIN
455: -- Standard start of API savepoint
456: SAVEPOINT createmessage;
457:
458: -- Standard call to check for call compatibility
459: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;
462:

Line 497: -- Standard check of p_commit

493: );
494:
495: x_message_id := l_rec.message_id;
496:
497: -- Standard check of p_commit
498: IF fnd_api.to_boolean(p_commit) THEN
499: COMMIT WORK;
500: END IF;
501:

Line 536: -- Standard start of API savepoint

532: ) IS
533: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_MESSAGE_TOKEN';
534: l_api_version CONSTANT NUMBER := 1.0;
535: BEGIN
536: -- Standard start of API savepoint
537: SAVEPOINT createmessagetoken;
538:
539: -- Standard call to check for call compatibility
540: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 539: -- Standard call to check for call compatibility

535: BEGIN
536: -- Standard start of API savepoint
537: SAVEPOINT createmessagetoken;
538:
539: -- Standard call to check for call compatibility
540: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
541: RAISE fnd_api.g_exc_unexpected_error;
542: END IF;
543:

Line 568: -- Standard check of p_commit

564: , SUBSTR(p_value, 1, 4000)
565: , 1
566: );
567:
568: -- Standard check of p_commit
569: IF fnd_api.to_boolean(p_commit) THEN
570: COMMIT WORK;
571: END IF;
572: EXCEPTION

Line 638: -- Standard start of API savepoint

634: l_resource_rec c_resource%ROWTYPE;
635:
636: j PLS_INTEGER;
637: BEGIN
638: -- Standard start of API savepoint
639: SAVEPOINT createplanoptions;
640:
641: -- Standard call to check for call compatibility
642: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 641: -- Standard call to check for call compatibility

637: BEGIN
638: -- Standard start of API savepoint
639: SAVEPOINT createplanoptions;
640:
641: -- Standard call to check for call compatibility
642: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
643: RAISE fnd_api.g_exc_unexpected_error;
644: END IF;
645:

Line 712: -- Standard check of p_commit

708: x_plan_option_id_tbl(j) := l_resource_rec.plan_option_id;
709: j := p_resource_id_tbl.NEXT(j);
710: END LOOP;
711: END IF;
712: -- Standard check of p_commit
713: IF fnd_api.to_boolean(p_commit) THEN
714: COMMIT WORK;
715: END IF;
716: EXCEPTION

Line 754: -- Standard start of API savepoint

750:
751: l_index PLS_INTEGER;
752: l_child_request_id NUMBER;
753: BEGIN
754: -- Standard start of API savepoint
755: SAVEPOINT create_opttrips_request;
756:
757: -- Standard call to check for call compatibility
758: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 757: -- Standard call to check for call compatibility

753: BEGIN
754: -- Standard start of API savepoint
755: SAVEPOINT create_opttrips_request;
756:
757: -- Standard call to check for call compatibility
758: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
759: RAISE fnd_api.g_exc_unexpected_error;
760: END IF;
761:

Line 834: -- Standard check of p_commit

830: , x_request_id => l_child_request_id
831: );
832: END IF;
833:
834: -- Standard check of p_commit
835: IF fnd_api.to_boolean(p_commit) THEN
836: COMMIT WORK;
837: END IF;
838: EXCEPTION