APPS.MRP_SCATP_PUB dependencies on MTL_DEMAND_INTERFACE

Line 6: -- This procedure inserts information from so_lines to mtl_demand_interface

2: /* $Header: MRPPATPB.pls 120.4 2007/11/29 12:34:54 rgurugub ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MRP_SCATP_PUB';
4:
5: -- ========================================================================
6: -- This procedure inserts information from so_lines to mtl_demand_interface
7: -- for Supply Chain ATP.
8: -- ========================================================================
9:
10: PROCEDURE Insert_Line_MDI(

Line 34: -- items into mtl_demand_interface for Supply Chain ATP.

30: END Insert_Line_MDI;
31:
32: -- ========================================================================
33: -- This procedure inserts information source org information for the request
34: -- items into mtl_demand_interface for Supply Chain ATP.
35: -- ========================================================================
36: PROCEDURE Insert_Supply_Sources_MDI(
37: p_api_version IN NUMBER,
38: x_return_status OUT NOCOPY VARCHAR2,

Line 73: -- It also null out some columns in mtl_demand_interface

69:
70: -- ========================================================================
71: -- This procedure deletes information from mtl_supply_demand_temp for
72: -- the atp_group_id specified by the user
73: -- It also null out some columns in mtl_demand_interface
74: -- ========================================================================
75:
76: PROCEDURE Uncheck(
77: p_api_version IN NUMBER,

Line 94: -- inserts into mtl_demand_interface for

90: END Uncheck;
91:
92: -- ========================================================================
93: -- This procedure gets resource/line information from mrp_atp_v and then
94: -- inserts into mtl_demand_interface for
95: -- the atp_group_id specified by the user
96: -- ========================================================================
97:
98: PROCEDURE Insert_Res_MDI(

Line 150: mtl_demand_interface mdi

146: mtl_parameters mp,
147: wip_parameters wp,
148: bom_explosions be,
149: bom_bill_of_materials bom,
150: mtl_demand_interface mdi
151: WHERE mdi.atp_group_id = l_atp_group_id
152: AND bom.assembly_item_id = mdi.inventory_item_id
153: AND bom.organization_id = mdi.organization_id
154: AND bom.alternate_bom_designator is NULL

Line 206: -- insert component records into mtl_demand_interface

202: END IF;
203:
204: EXIT WHEN C1%NOTFOUND;
205:
206: -- insert component records into mtl_demand_interface
207: INSERT INTO MTL_DEMAND_INTERFACE(
208: atp_group_id,
209: organization_id,
210: inventory_item_id,

Line 207: INSERT INTO MTL_DEMAND_INTERFACE(

203:
204: EXIT WHEN C1%NOTFOUND;
205:
206: -- insert component records into mtl_demand_interface
207: INSERT INTO MTL_DEMAND_INTERFACE(
208: atp_group_id,
209: organization_id,
210: inventory_item_id,
211: last_update_date,