DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_SKILLS_PUB dependencies on STANDARD

Line 545: --Standard Start of API SAVEPOINT

541: l_msg_count NUMBER;
542: l_msg_data VARCHAR2(200);
543:
544: BEGIN
545: --Standard Start of API SAVEPOINT
546: SAVEPOINT CREATE_RESOURCE_SKILLS_SP;
547:
548: x_return_status := fnd_api.g_ret_sts_success;
549:

Line 550: --Standard Call to check API compatibility

546: SAVEPOINT CREATE_RESOURCE_SKILLS_SP;
547:
548: x_return_status := fnd_api.g_ret_sts_success;
549:
550: --Standard Call to check API compatibility
551: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
552: THEN
553: RAISE FND_API.G_EXC_ERROR;
554: END IF;

Line 611: --standard commit

607: RAISE fnd_api.g_exc_error;
608: END IF;
609:
610:
611: --standard commit
612: IF fnd_api.to_boolean (p_commit)
613: THEN
614: COMMIT WORK;
615: END IF;

Line 700: --Standard Start of API SAVEPOINT

696: l_msg_count NUMBER;
697: l_msg_data VARCHAR2(200);
698:
699: BEGIN
700: --Standard Start of API SAVEPOINT
701: SAVEPOINT UPDATE_RESOURCE_SKILLS_SP;
702:
703: x_return_status := fnd_api.g_ret_sts_success;
704:

Line 705: --Standard Call to check API compatibility

701: SAVEPOINT UPDATE_RESOURCE_SKILLS_SP;
702:
703: x_return_status := fnd_api.g_ret_sts_success;
704:
705: --Standard Call to check API compatibility
706: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
707: THEN
708: RAISE FND_API.G_EXC_ERROR;
709: END IF;

Line 826: --Standard Start of API SAVEPOINT

822: l_msg_count NUMBER;
823: l_msg_data VARCHAR2(200);
824:
825: BEGIN
826: --Standard Start of API SAVEPOINT
827: SAVEPOINT DELETE_RESOURCE_SKILLS_SP;
828:
829: x_return_status := fnd_api.g_ret_sts_success;
830:

Line 831: --Standard Call to check API compatibility

827: SAVEPOINT DELETE_RESOURCE_SKILLS_SP;
828:
829: x_return_status := fnd_api.g_ret_sts_success;
830:
831: --Standard Call to check API compatibility
832: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
833: THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;

Line 952: --Standard Start of API SAVEPOINT

948: l_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE := p_subcategory;
949:
950: BEGIN
951:
952: --Standard Start of API SAVEPOINT
953: SAVEPOINT CREATE_RESOURCE_SKILLS_SP;
954:
955:
956: l_cascade_option := p_cascade_option;

Line 960: --Standard Call to check API compatibility

956: l_cascade_option := p_cascade_option;
957: x_return_status := fnd_api.g_ret_sts_success;
958: l_product_org_id := p_product_org_id ;
959:
960: --Standard Call to check API compatibility
961: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
962: THEN
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;

Line 1233: --standard commit

1229: END IF;
1230:
1231: END IF; /* End of if (l_subcategory is null) AND (P_CATEGORY_ID is NOT NULL) AND (l_cascade_option = DONT_CASCADE)*/
1232:
1233: --standard commit
1234: IF fnd_api.to_boolean (p_commit)
1235: THEN
1236: COMMIT WORK;
1237: END IF;

Line 1357: --Standard Start of API SAVEPOINT

1353: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE;
1354:
1355: BEGIN
1356:
1357: --Standard Start of API SAVEPOINT
1358: SAVEPOINT UPDATE_RESOURCE_SKILLS_SP;
1359:
1360:
1361: -- Initialize local variable

Line 1367: --Standard Call to check API compatibility

1363: x_return_status := fnd_api.g_ret_sts_success;
1364: l_return_status := fnd_api.g_ret_sts_success;
1365:
1366:
1367: --Standard Call to check API compatibility
1368: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1369: THEN
1370: RAISE FND_API.G_EXC_ERROR;
1371: END IF;

Line 1575: --standard commit

1571: END IF;
1572:
1573: END IF;
1574:
1575: --standard commit
1576: IF fnd_api.to_boolean (p_commit)
1577: THEN
1578: COMMIT WORK;
1579: END IF;