APPS.AMS_DELIVERABLE_PVT dependencies on AMS_DELIVERABLES_ALL_B

Line 231: SELECT ams_deliverables_all_b_s.NEXTVAL

227: l_setup_id NUMBER;
228: l_task_planned_start_date DATE := SYSDATE;
229:
230: CURSOR c_deliv_seq IS
231: SELECT ams_deliverables_all_b_s.NEXTVAL
232: FROM DUAL;
233:
234: CURSOR c_deliv_count(deliv_id IN NUMBER) IS
235: SELECT COUNT(*)

Line 412: INSERT INTO ams_deliverables_all_b(

408:
409:
410:
411:
412: INSERT INTO ams_deliverables_all_b(
413: deliverable_id,
414: last_update_date,
415: last_updated_by,
416: creation_date,

Line 1001: DELETE FROM ams_deliverables_all_b

997: IF (AMS_DEBUG_HIGH_ON) THEN
998: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
999: END IF;
1000:
1001: DELETE FROM ams_deliverables_all_b
1002: WHERE deliverable_id = p_deliv_id
1003: AND object_version_number = p_object_version;
1004:
1005: IF (SQL%NOTFOUND) THEN

Line 1109: FROM ams_deliverables_all_b

1105: l_deliv_id NUMBER;
1106:
1107: CURSOR c_deliv_b IS
1108: SELECT deliverable_id
1109: FROM ams_deliverables_all_b
1110: WHERE deliverable_id = p_deliv_id
1111: AND object_version_number = p_object_version
1112: FOR UPDATE OF deliverable_id NOWAIT;
1113:

Line 1368: from ams_deliverables_all_b where deliverable_id = delv_id;

1364:
1365:
1366: CURSOR c_get_ob_ver_num(delv_id IN NUMBER) IS
1367: SELECT object_version_number
1368: from ams_deliverables_all_b where deliverable_id = delv_id;
1369:
1370: l_dummy NUMBER;
1371: l_pending_budget_stat VARCHAR2(50);
1372: l_pending_budget_stat_id NUMBER;

Line 1380: FROM ams_deliverables_all_b

1376:
1377: CURSOR get_owner_id(deliv_id IN NUMBER)
1378: IS
1379: SELECT owner_user_id
1380: FROM ams_deliverables_all_b
1381: WHERE deliverable_id = deliv_id;
1382:
1383: l_owner_user_id NUMBER;
1384:

Line 1397: FROM ams_deliverables_all_b

1393:
1394: CURSOR get_detl(deliv_id IN NUMBER)
1395: IS
1396: SELECT kit_flag, inventory_flag,non_inv_quantity_on_hand
1397: FROM ams_deliverables_all_b
1398: WHERE deliverable_id = deliv_id;
1399:
1400: l_kit_flag VARCHAR2(1) ;
1401: l_inventory_flag VARCHAR2(1);

Line 1848: UPDATE ams_deliverables_all_b

1844: IF (AMS_DEBUG_HIGH_ON) THEN
1845: ams_utility_pvt.debug_message (l_full_name || ' - status_code: ' || l_deliv_rec.status_code);
1846: END IF;
1847:
1848: UPDATE ams_deliverables_all_b
1849: SET last_update_date = SYSDATE,
1850: last_updated_by = FND_GLOBAL.user_id,
1851: last_update_login = FND_GLOBAL.conc_login_id,
1852: object_version_number = l_deliv_rec.object_version_number + 1,

Line 2850: FROM ams_deliverables_all_b

2846: ,inventory_flag
2847: ,non_inv_quantity_on_hand
2848: ,kit_flag
2849: ,status_code
2850: FROM ams_deliverables_all_b
2851: WHERE deliverable_id = delivId;
2852:
2853:
2854: l_api_name VARCHAR2(30) := 'check_deliv_flag_items';

Line 4387: FROM ams_deliverables_all_b

4383: CURSOR c_get_period_dets(deliv_id IN NUMBER)
4384: IS SELECT start_period_name
4385: ,end_period_name
4386: ,deliverable_calendar
4387: FROM ams_deliverables_all_b
4388: WHERE deliverable_id = deliv_id;
4389:
4390: l_get_period_cur c_get_period_Dets%ROWTYPE;
4391: l_deliverable_calendar VARCHAR2(15) := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');

Line 4438: FROM ams_deliverables_all_b

4434:
4435: CURSOR c_owner_id(deliv_id IN NUMBER)
4436: IS
4437: SELECT owner_user_id
4438: FROM ams_deliverables_all_b
4439: WHERE deliverable_id = deliv_id;
4440: l_owner_user_id NUMBER;
4441: l_resource_id NUMBER := AMS_UTILITY_PVT.get_resource_id(FND_GLOBAL.User_id);
4442:

Line 4493: FROM ams_deliverables_all_b

4489:
4490: CURSOR get_currency_code(deliv_id IN NUMBER)
4491: IS
4492: SELECT currency_code
4493: FROM ams_deliverables_all_b
4494: WHERE deliverable_id = deliv_id;
4495:
4496: CURSOR check_budget(deliv_id IN NUMBER)
4497: IS

Line 4757: FROM ams_deliverables_all_b

4753:
4754: CURSOR get_active_flag(deliv_id IN NUMBER)
4755: IS
4756: SELECT active_flag
4757: FROM ams_deliverables_all_b
4758: WHERE deliverable_id = deliv_id;
4759:
4760: l_active_flag VARCHAR2(1) := 'Y';
4761: