APPS.AMS_DELIVERABLE_PVT dependencies on AMS_DELIVERABLES_VL

Line 236: FROM ams_deliverables_vl

232: FROM DUAL;
233:
234: CURSOR c_deliv_count(deliv_id IN NUMBER) IS
235: SELECT COUNT(*)
236: FROM ams_deliverables_vl
237: WHERE deliverable_id = deliv_id;
238:
239: CURSOR c_status_code(status_id IN NUMBER) IS
240: SELECT system_status_code

Line 1299: FROM ams_deliverables_vl

1295: AND default_flag = 'Y';
1296:
1297: CURSOR c_orig_stat_rec(p_deliverable_id IN NUMBER) IS
1298: SELECT user_status_id, status_code
1299: FROM ams_deliverables_vl
1300: WHERE deliverable_id = p_deliverable_id;
1301:
1302: l_orig_stat_rec c_orig_stat_rec%ROWTYPE;
1303: /*

Line 1313: FROM ams_deliverables_vl;

1309: WHERE segment1 = p_inv_item_num;
1310:
1311: CURSOR c_pricelist_header_id IS
1312: SELECT distinct(pricelist_header_id)
1313: FROM ams_deliverables_vl;
1314: */
1315: CURSOR c_jtf_item_id (p_deliv_id IN NUMBER) IS
1316: SELECT jtf_amv_item_id
1317: FROM ams_deliverables_vl

Line 1317: FROM ams_deliverables_vl

1313: FROM ams_deliverables_vl;
1314: */
1315: CURSOR c_jtf_item_id (p_deliv_id IN NUMBER) IS
1316: SELECT jtf_amv_item_id
1317: FROM ams_deliverables_vl
1318: WHERE deliverable_id = p_deliv_id;
1319:
1320: CURSOR c_jtf_att_count (p_deliv_id IN NUMBER) IS
1321: SELECT count(1)

Line 2465: FROM ams_deliverables_vl

2461:
2462: cursor c_check_uniq ( del_nm IN VARCHAR2, del_ver IN VARCHAR2 )
2463: IS
2464: SELECT 'N'
2465: FROM ams_deliverables_vl
2466: WHERE deliverable_name = del_nm
2467: AND version = del_ver;
2468:
2469:

Line 2473: FROM ams_deliverables_vl

2469:
2470: cursor c_check_uniq_u ( del_nm IN VARCHAR2, del_ver IN VARCHAR2 , del_id IN NUMBER )
2471: IS
2472: SELECT 'N'
2473: FROM ams_deliverables_vl
2474: WHERE deliverable_name = del_nm
2475: AND version = del_ver
2476: AND deliverable_id <> del_id;
2477:

Line 2493: 'ams_deliverables_vl',

2489: IF p_validation_mode = JTF_PLSQL_API.g_create
2490: AND p_deliv_rec.deliverable_id IS NOT NULL
2491: THEN
2492: IF AMS_Utility_PVT.check_uniqueness(
2493: 'ams_deliverables_vl',
2494: 'deliverable_id = ' || p_deliv_rec.deliverable_id
2495: ) = FND_API.g_false
2496: THEN
2497: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 2574: -- 'ams_deliverables_vl',

2570: -- '''AND version = ' || p_deliv_rec.version
2571: -- );
2572: --ELSE
2573: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2574: -- 'ams_deliverables_vl',
2575: -- 'deliverable_name = ''' || p_deliv_rec.deliverable_name ||
2576: -- ''' AND deliverable_id <> ' || p_deliv_rec.deliverable_id
2577: -- );
2578: --END IF;

Line 3641: FROM ams_deliverables_vl

3637: IS
3638:
3639: CURSOR c_deliv IS
3640: SELECT *
3641: FROM ams_deliverables_vl
3642: WHERE deliverable_id = p_deliv_rec.deliverable_id;
3643:
3644: l_deliv_rec c_deliv%ROWTYPE;
3645: