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 1312: FROM ams_deliverables_vl

1308: AND default_flag = 'Y';
1309:
1310: CURSOR c_orig_stat_rec(p_deliverable_id IN NUMBER) IS
1311: SELECT user_status_id, status_code
1312: FROM ams_deliverables_vl
1313: WHERE deliverable_id = p_deliverable_id;
1314:
1315: l_orig_stat_rec c_orig_stat_rec%ROWTYPE;
1316: /*

Line 1326: FROM ams_deliverables_vl;

1322: WHERE segment1 = p_inv_item_num;
1323:
1324: CURSOR c_pricelist_header_id IS
1325: SELECT distinct(pricelist_header_id)
1326: FROM ams_deliverables_vl;
1327: */
1328: CURSOR c_jtf_item_id (p_deliv_id IN NUMBER) IS
1329: SELECT jtf_amv_item_id
1330: FROM ams_deliverables_vl

Line 1330: FROM ams_deliverables_vl

1326: FROM ams_deliverables_vl;
1327: */
1328: CURSOR c_jtf_item_id (p_deliv_id IN NUMBER) IS
1329: SELECT jtf_amv_item_id
1330: FROM ams_deliverables_vl
1331: WHERE deliverable_id = p_deliv_id;
1332:
1333: CURSOR c_jtf_att_count (p_deliv_id IN NUMBER) IS
1334: SELECT count(1)

Line 2478: FROM ams_deliverables_vl

2474:
2475: cursor c_check_uniq ( del_nm IN VARCHAR2, del_ver IN VARCHAR2 )
2476: IS
2477: SELECT 'N'
2478: FROM ams_deliverables_vl
2479: WHERE deliverable_name = del_nm
2480: AND version = del_ver;
2481:
2482:

Line 2486: FROM ams_deliverables_vl

2482:
2483: cursor c_check_uniq_u ( del_nm IN VARCHAR2, del_ver IN VARCHAR2 , del_id IN NUMBER )
2484: IS
2485: SELECT 'N'
2486: FROM ams_deliverables_vl
2487: WHERE deliverable_name = del_nm
2488: AND version = del_ver
2489: AND deliverable_id <> del_id;
2490:

Line 2506: 'ams_deliverables_vl',

2502: IF p_validation_mode = JTF_PLSQL_API.g_create
2503: AND p_deliv_rec.deliverable_id IS NOT NULL
2504: THEN
2505: IF AMS_Utility_PVT.check_uniqueness(
2506: 'ams_deliverables_vl',
2507: 'deliverable_id = ' || p_deliv_rec.deliverable_id
2508: ) = FND_API.g_false
2509: THEN
2510: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 2587: -- 'ams_deliverables_vl',

2583: -- '''AND version = ' || p_deliv_rec.version
2584: -- );
2585: --ELSE
2586: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2587: -- 'ams_deliverables_vl',
2588: -- 'deliverable_name = ''' || p_deliv_rec.deliverable_name ||
2589: -- ''' AND deliverable_id <> ' || p_deliv_rec.deliverable_id
2590: -- );
2591: --END IF;

Line 3654: FROM ams_deliverables_vl

3650: IS
3651:
3652: CURSOR c_deliv IS
3653: SELECT *
3654: FROM ams_deliverables_vl
3655: WHERE deliverable_id = p_deliv_rec.deliverable_id;
3656:
3657: l_deliv_rec c_deliv%ROWTYPE;
3658: