APPS.OKC_UDA_TEMPLATES_UTIL dependencies on OKC_UDA_DELIVERABLE_USAGES

Line 1336: INSERT INTO OKC_UDA_DELIVERABLE_USAGES (DEL_USAGE_ID

1332:
1333: l_user_id := fnd_global.user_id();
1334:
1335: --Copy Deliverable Usages
1336: INSERT INTO OKC_UDA_DELIVERABLE_USAGES (DEL_USAGE_ID
1337: ,UDA_TEMPLATE_ID
1338: ,DEL_TYPE_CODE
1339: ,ATTR_GROUP_ID
1340: ,CREATED_BY

Line 1359: FROM OKC_UDA_DELIVERABLE_USAGES

1355: ,sysdate
1356: ,LAST_UPDATE_LOGIN
1357: ,OBJECT_VERSION_NUMBER
1358: ,SEQUENCE_NUM
1359: FROM OKC_UDA_DELIVERABLE_USAGES
1360: WHERE UDA_TEMPLATE_ID = p_src_uda_temp_id;
1361:
1362: OPEN c_attr_grp_details;
1363: FETCH c_attr_grp_details INTO l_object_id;

Line 1568: DELETE FROM OKC_UDA_DELIVERABLE_USAGES

1564: -- Standard Start of API savepoint
1565: SAVEPOINT del_temp_details_PVT;
1566:
1567: --Delete Deliverable details
1568: DELETE FROM OKC_UDA_DELIVERABLE_USAGES
1569: WHERE uda_template_id = p_uda_temp_id;
1570:
1571: --EGO requires template Id in varchar
1572: l_uda_temp_id := p_uda_temp_id || '';