APPS.AMS_COPYACTIVITIES_PVT dependencies on AMS_DELIVERABLES_VL

Line 818: l_new_deliv_name ams_deliverables_vl.deliverable_name%TYPE;

814: l_api_version CONSTANT NUMBER := 1.0;
815: l_api_name CONSTANT VARCHAR2(30) := 'copy_deliverable';
816: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
817: l_return_status VARCHAR2(1);
818: l_new_deliv_name ams_deliverables_vl.deliverable_name%TYPE;
819: l_deli_count NUMBER;
820: l_name VARCHAR2(80);
821: l_msg_count NUMBER;
822: l_msg_data VARCHAR2(512);

Line 827: l_deliv_rec ams_deliverables_vl%ROWTYPE;

823: l_new_deliv_id NUMBER;
824: l_deli_rec ams_deliverable_pvt.deliv_rec_type;
825: l_mesg_text VARCHAR2(2000);
826: p_errmsg VARCHAR2(3000);
827: l_deliv_rec ams_deliverables_vl%ROWTYPE;
828: l_errcode VARCHAR2(80);
829: l_errnum NUMBER;
830: l_errmsg VARCHAR2(3000);
831: l_deliv_count NUMBER;

Line 838: FROM ams_deliverables_vl

834:
835: CURSOR c_deliv_name(l_deliv_name IN VARCHAR2)
836: IS
837: SELECT COUNT(*) --deliverable_name
838: FROM ams_deliverables_vl
839: WHERE deliverable_name = l_deliv_name;
840: BEGIN
841: SAVEPOINT copy_deliverables;
842: IF (AMS_DEBUG_HIGH_ON) THEN

Line 887: FROM ams_deliverables_vl

883: l_msg_data := NULL;
884: -- selects the deliverable to copy
885: SELECT *
886: INTO l_deliv_rec
887: FROM ams_deliverables_vl
888: WHERE deliverable_id = p_src_deliv_id;
889: l_deli_rec.object_version_number := 1;
890: l_deli_rec.owner_user_id := fnd_global.user_id;
891: l_deli_rec.status_date := SYSDATE;