APPS.AMS_DELIVKITITEM_PVT dependencies on AMS_DELIVERABLES_ALL_B

Line 56: FROM ams_deliverables_all_b

52:
53: -- AMS_KIT_PART_CANNOT_BE_KIT
54: CURSOR c_deliv_kit_part_flag(deliv_kit_item_id IN NUMBER) IS
55: SELECT kit_flag
56: FROM ams_deliverables_all_b
57: WHERE deliverable_id = deliv_kit_item_id;
58:
59: -- AMS_KIT_CANNOT_BE_KIT_PART
60: /*

Line 232: -- change ams_deliverables_all_b.kit_flag to 'Y'

228: -- because the user would be allowed to change
229: -- the kit flag from the screen.
230:
231: -- modified by khung 12/13/1999
232: -- change ams_deliverables_all_b.kit_flag to 'Y'
233: UPDATE ams_deliverables_all_b
234: SET kit_flag = 'Y'
235: WHERE deliverable_id = l_deliv_kit_item_rec.deliverable_kit_id;
236:

Line 233: UPDATE ams_deliverables_all_b

229: -- the kit flag from the screen.
230:
231: -- modified by khung 12/13/1999
232: -- change ams_deliverables_all_b.kit_flag to 'Y'
233: UPDATE ams_deliverables_all_b
234: SET kit_flag = 'Y'
235: WHERE deliverable_id = l_deliv_kit_item_rec.deliverable_kit_id;
236:
237:

Line 442: -- UPDATE ams_deliverables_all_b

438: -- the kit flag from the screen.
439:
440: -- IF (l_kit_count < 1)
441: -- THEN
442: -- UPDATE ams_deliverables_all_b
443: -- SET kit_flag = 'N'
444: -- WHERE deliverable_id = l_kit_id;
445:
446: -- commented by musman

Line 1116: 'ams_deliverables_all_b',

1112: IF p_deliv_kit_item_rec.deliverable_kit_id <> FND_API.g_miss_num
1113: AND p_deliv_kit_item_rec.deliverable_kit_id IS NOT NULL
1114: THEN
1115: IF AMS_Utility_PVT.check_fk_exists(
1116: 'ams_deliverables_all_b',
1117: 'deliverable_id',
1118: p_deliv_kit_item_rec.deliverable_kit_id,
1119: AMS_Utility_PVT.g_number,
1120: NULL

Line 1134: 'ams_deliverables_all_b',

1130: IF p_deliv_kit_item_rec.deliverable_kit_part_id <> FND_API.g_miss_num
1131: AND p_deliv_kit_item_rec.deliverable_kit_part_id IS NOT NULL
1132: THEN
1133: IF AMS_Utility_PVT.check_fk_exists(
1134: 'ams_deliverables_all_b',
1135: 'deliverable_id',
1136: p_deliv_kit_item_rec.deliverable_kit_part_id,
1137: AMS_Utility_PVT.g_number,
1138: NULL

Line 1190: FROM ams_Deliverables_all_b

1186:
1187: CURSOR get_type(p_Deliv_id IN NUMBER)
1188: IS
1189: SELECT DECODE(can_fulfill_electronic_flag, 'Y', 'ELEC','PHYS')
1190: FROM ams_Deliverables_all_b
1191: where deliverable_id = p_deliv_id;
1192:
1193:
1194: CURSOR get_detail(p_deliv_id IN NUMBER)

Line 1198: FROM ams_Deliverables_all_b

1194: CURSOR get_detail(p_deliv_id IN NUMBER)
1195: IS
1196: SELECT DECODE(inventory_flag, 'Y', 'INVN','PHYS') TYPE
1197: ,nvl(non_inv_quantity_on_hand,-99999) Quantity
1198: FROM ams_Deliverables_all_b
1199: where deliverable_id = p_deliv_id;
1200:
1201: l_kit_type VARCHAR2(4);
1202: l_kit_part_type VARCHAR2(4);