126:
127: BEGIN
128:
129:
130: -- Standard Start OF API savepoint
131: -- ===============================
132: SAVEPOINT Create_Spec;
133:
134: -- Standard call to check for call compatibility
130: -- Standard Start OF API savepoint
131: -- ===============================
132: SAVEPOINT Create_Spec;
133:
134: -- Standard call to check for call compatibility
135: -- =============================================
136: IF NOT FND_API.Compatible_API_CALL
137: (l_api_version , p_api_version , l_api_name , G_PKG_NAME)
138: THEN
359: 'l_key_value', l_spec.spec_name);
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:
363: -- Standard Check of p_commit.
364: -- ==========================
365: IF FND_API.to_boolean(p_commit)
366: THEN
367: COMMIT WORK;
446:
447: BEGIN
448:
449:
450: -- Standard Start OF API savepoint
451: -- ===============================
452: SAVEPOINT Delete_Spec;
453:
454: -- Standard call to check for call compatibility.
450: -- Standard Start OF API savepoint
451: -- ===============================
452: SAVEPOINT Delete_Spec;
453:
454: -- Standard call to check for call compatibility.
455: -- ==============================================
456: IF NOT FND_API.Compatible_API_CALL
457: (l_api_version , p_api_version , l_api_name , G_PKG_NAME)
458: THEN
527: ELSE -- Report one row successfully delete marked
528: x_deleted_rows := 1;
529: END IF;
530:
531: -- Standard Check of p_commit.
532: IF FND_API.to_boolean(p_commit)
533: THEN
534: COMMIT WORK;
535: END IF;
614:
615: BEGIN
616:
617:
618: -- Standard Start OF API savepoint
619: -- ===============================
620: SAVEPOINT Delete_Spec_Tests;
621:
622: -- Standard call to check for call compatibility.
618: -- Standard Start OF API savepoint
619: -- ===============================
620: SAVEPOINT Delete_Spec_Tests;
621:
622: -- Standard call to check for call compatibility.
623: -- ==============================================
624: IF NOT FND_API.Compatible_API_CALL
625: (l_api_version , p_api_version , l_api_name , G_PKG_NAME)
626: THEN
743: x_deleted_rows := i;
744:
745: END LOOP;
746:
747: -- Standard Check of p_commit.
748: IF FND_API.to_boolean(p_commit)
749: THEN
750: COMMIT WORK;
751: END IF;