APPS.INVWATP dependencies on MTL_GROUP_ATPS_VIEW

Line 11: -- -7 Unable to insert into mtl_group_atps_view

7: -- -3 No ATP Rule specified.
8: -- -4 Item not found.
9: -- -5 No UOM Code.
10: -- -6 No Calendar organization
11: -- -7 Unable to insert into mtl_group_atps_view
12: -- For all the above conditions, message ICX_INV_WATP_FAILED is set.
13: FUNCTION WebAtpInsert
14: (
15: x_organization_id number,

Line 28: rec_mgav mtl_group_atps_view%rowtype;

24: x_n_column2 number
25: )
26: return number
27: is
28: rec_mgav mtl_group_atps_view%rowtype;
29: ret_code number;
30: ret_val number;
31: begin
32: ret_code := 0;

Line 181: INSERT INTO MTL_GROUP_ATPS_VIEW

177: end if; --ret_code=0
178:
179: if ret_code = 0 then
180: begin
181: INSERT INTO MTL_GROUP_ATPS_VIEW
182: (ATP_GROUP_ID,
183: ORGANIZATION_ID,
184: INVENTORY_ITEM_ID,
185: LAST_UPDATE_DATE,

Line 457: MTL_GROUP_ATPS_VIEW

453: x_request_atp_date,
454: x_request_atp_date_quantity,
455: x_infinite_time_fence_date
456: from
457: MTL_GROUP_ATPS_VIEW
458: where
459: ATP_GROUP_ID = x_AtpGrpId and
460: n_column2 = x_n_column2;
461: exception

Line 495: delete from mtl_group_atps_view

491: fnd_message.set_name ( 'EC', 'ICX_INV_WATP_FAILED');
492: ret_code := -2;
493: else
494: begin
495: delete from mtl_group_atps_view
496: where
497: atp_group_id = x_AtpGrpId;
498: exception
499: when OTHERS then