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 399: INSERT INTO ams_deliverables_all_b(

395: CLOSE c_status_code;
396: */
397: l_deliv_rec.status_code := l_status_code;
398:
399: INSERT INTO ams_deliverables_all_b(
400: deliverable_id,
401: last_update_date,
402: last_updated_by,
403: creation_date,

Line 988: DELETE FROM ams_deliverables_all_b

984: IF (AMS_DEBUG_HIGH_ON) THEN
985: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
986: END IF;
987:
988: DELETE FROM ams_deliverables_all_b
989: WHERE deliverable_id = p_deliv_id
990: AND object_version_number = p_object_version;
991:
992: IF (SQL%NOTFOUND) THEN

Line 1096: FROM ams_deliverables_all_b

1092: l_deliv_id NUMBER;
1093:
1094: CURSOR c_deliv_b IS
1095: SELECT deliverable_id
1096: FROM ams_deliverables_all_b
1097: WHERE deliverable_id = p_deliv_id
1098: AND object_version_number = p_object_version
1099: FOR UPDATE OF deliverable_id NOWAIT;
1100:

Line 1355: from ams_deliverables_all_b where deliverable_id = delv_id;

1351:
1352:
1353: CURSOR c_get_ob_ver_num(delv_id IN NUMBER) IS
1354: SELECT object_version_number
1355: from ams_deliverables_all_b where deliverable_id = delv_id;
1356:
1357: l_dummy NUMBER;
1358: l_pending_budget_stat VARCHAR2(50);
1359: l_pending_budget_stat_id NUMBER;

Line 1367: FROM ams_deliverables_all_b

1363:
1364: CURSOR get_owner_id(deliv_id IN NUMBER)
1365: IS
1366: SELECT owner_user_id
1367: FROM ams_deliverables_all_b
1368: WHERE deliverable_id = deliv_id;
1369:
1370: l_owner_user_id NUMBER;
1371:

Line 1384: FROM ams_deliverables_all_b

1380:
1381: CURSOR get_detl(deliv_id IN NUMBER)
1382: IS
1383: SELECT kit_flag, inventory_flag,non_inv_quantity_on_hand
1384: FROM ams_deliverables_all_b
1385: WHERE deliverable_id = deliv_id;
1386:
1387: l_kit_flag VARCHAR2(1) ;
1388: l_inventory_flag VARCHAR2(1);

Line 1835: UPDATE ams_deliverables_all_b

1831: IF (AMS_DEBUG_HIGH_ON) THEN
1832: ams_utility_pvt.debug_message (l_full_name || ' - status_code: ' || l_deliv_rec.status_code);
1833: END IF;
1834:
1835: UPDATE ams_deliverables_all_b
1836: SET last_update_date = SYSDATE,
1837: last_updated_by = FND_GLOBAL.user_id,
1838: last_update_login = FND_GLOBAL.conc_login_id,
1839: object_version_number = l_deliv_rec.object_version_number + 1,

Line 2837: FROM ams_deliverables_all_b

2833: ,inventory_flag
2834: ,non_inv_quantity_on_hand
2835: ,kit_flag
2836: ,status_code
2837: FROM ams_deliverables_all_b
2838: WHERE deliverable_id = delivId;
2839:
2840:
2841: l_api_name VARCHAR2(30) := 'check_deliv_flag_items';

Line 4374: FROM ams_deliverables_all_b

4370: CURSOR c_get_period_dets(deliv_id IN NUMBER)
4371: IS SELECT start_period_name
4372: ,end_period_name
4373: ,deliverable_calendar
4374: FROM ams_deliverables_all_b
4375: WHERE deliverable_id = deliv_id;
4376:
4377: l_get_period_cur c_get_period_Dets%ROWTYPE;
4378: l_deliverable_calendar VARCHAR2(15) := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');

Line 4425: FROM ams_deliverables_all_b

4421:
4422: CURSOR c_owner_id(deliv_id IN NUMBER)
4423: IS
4424: SELECT owner_user_id
4425: FROM ams_deliverables_all_b
4426: WHERE deliverable_id = deliv_id;
4427: l_owner_user_id NUMBER;
4428: l_resource_id NUMBER := AMS_UTILITY_PVT.get_resource_id(FND_GLOBAL.User_id);
4429:

Line 4480: FROM ams_deliverables_all_b

4476:
4477: CURSOR get_currency_code(deliv_id IN NUMBER)
4478: IS
4479: SELECT currency_code
4480: FROM ams_deliverables_all_b
4481: WHERE deliverable_id = deliv_id;
4482:
4483: CURSOR check_budget(deliv_id IN NUMBER)
4484: IS

Line 4744: FROM ams_deliverables_all_b

4740:
4741: CURSOR get_active_flag(deliv_id IN NUMBER)
4742: IS
4743: SELECT active_flag
4744: FROM ams_deliverables_all_b
4745: WHERE deliverable_id = deliv_id;
4746:
4747: l_active_flag VARCHAR2(1) := 'Y';
4748: