eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_ATP_INTERFACE_PK dependencies on BOM_CTO_ORDER_DEMAND

Line 155: /* common table to store information to be dumped into bom_cto_order_demand */

151:
152: g_requests_tab CZ_REQUESTS_TBL_TYPE ;
153: g_shipset_status_tbl SHIPSET_SUCCESS_TBL_TYPE ;
154:
155: /* common table to store information to be dumped into bom_cto_order_demand */
156: g_final_cto_shipset CTO_SHIPSET_TBL_TYPE ; /* package global array */
157: g_cto_shipset CTO_SHIPSET_TBL_TYPE ; /* package global array */
158: g_cto_sparse_shipset CTO_SHIPSET_TBL_TYPE ; /* package global sparse array */
159: local_cto_shipset CTO_SHIPSET_TBL_TYPE ; /* package global variable */

Line 5515: into the table BOM_CTO_ORDER_DEMAND.

5511: GET_ATP_BOM_PUB.
5512: This procedure will get the required_qty and
5513: required_date from ATP pegging tree table
5514: MRP_ATP_DETAILS_TEMP and insert the entier row
5515: into the table BOM_CTO_ORDER_DEMAND.
5516: Input :
5517: p_ship_set - This is the IN OUT Parameter. When it is called
5518: from ATP it will have the Reduced Ship set in it.
5519: And the end of this procedure it will be having

Line 5524: Process : The records in the table BOM_CTO_ORDER_DEMAND is

5520: the full ship set(Transformed).
5521: p_success_flag - This will have 'Y' or 'N' based on the scheduling Succeeds or fails.
5522: p_session_id - session_id is used to identify the set of records
5523: in the peggin tree
5524: Process : The records in the table BOM_CTO_ORDER_DEMAND is
5525: populated
5526: Output :
5527: xreturn_status - Return FND_API.G_RET_STS_SUCCESS if the procedure
5528: is executed successfully

Line 5644: --- Delete the row from Bom_cto_order_demand for the line_id

5640: oe_debug_pub.add('create_cto_model_demand: ' || 'Action code = '||to_char(p_shipset.action(p_shipset.action.first)),5);
5641: oe_debug_pub.add('create_cto_model_demand: ' || 'Line id = '||to_char(p_shipset.identifier(p_shipset.identifier.first)),5);
5642: END IF;
5643:
5644: --- Delete the row from Bom_cto_order_demand for the line_id
5645: l_line_id := p_shipset.identifier(p_shipset.identifier.first);
5646: DELETE
5647: FROM BOM_CTO_ORDER_DEMAND
5648: WHERE OE_LINE_ID = l_line_id;

Line 5647: FROM BOM_CTO_ORDER_DEMAND

5643:
5644: --- Delete the row from Bom_cto_order_demand for the line_id
5645: l_line_id := p_shipset.identifier(p_shipset.identifier.first);
5646: DELETE
5647: FROM BOM_CTO_ORDER_DEMAND
5648: WHERE OE_LINE_ID = l_line_id;
5649:
5650: IF PG_DEBUG <> 0 THEN
5651: oe_debug_pub.add('create_cto_model_demand: ' || 'No of records deleted..'||sql%rowcount,2);

Line 5691: delete from bom_cto_order_demand

5687: then
5688:
5689: oe_debug_pub.add('ato line id is '||to_char(slso_shipset(slso_index).ato_line_id), 2);
5690:
5691: delete from bom_cto_order_demand
5692: where ato_line_id = slso_shipset(slso_index).ato_line_id;
5693: rows_deleted := sql%rowcount;
5694:
5695: oe_debug_pub.add('Deleted '||to_char(rows_deleted)||' rows. ', 2);

Line 5821: DELETE FROM BOM_CTO_ORDER_DEMAND

5817: IF PG_DEBUG <> 0 THEN
5818: oe_debug_pub.add('create_cto_model_demand: ' || ' Deleting the Bcod information for the '|| ' Ato line_id...'||to_char(g_final_cto_shipset(i).ato_line_id), 2);
5819: END IF;
5820:
5821: DELETE FROM BOM_CTO_ORDER_DEMAND
5822: WHERE ato_line_id = g_final_cto_shipset(i).ato_line_id;
5823:
5824: lStmtNum := 43;
5825: IF l_config_exists = 'Y' THEN

Line 6068: INSERT INTO BOM_CTO_ORDER_DEMAND (

6064: ' forecast_visible ' || l_vis_forecast_flag ||
6065: ' demand_visible ' || l_vis_demand_flag , 1);
6066: END IF;
6067:
6068: INSERT INTO BOM_CTO_ORDER_DEMAND (
6069: bcod_line_id,
6070: oe_line_id,
6071: ato_line_id,
6072: inventory_item_id,

Line 6088: BOM_CTO_ORDER_DEMAND_S1.nextval, -- bcod_line_id

6084: last_update_login,
6085: program_application_id,
6086: program_update_date)
6087: VALUES(
6088: BOM_CTO_ORDER_DEMAND_S1.nextval, -- bcod_line_id
6089: g_final_cto_shipset(i).line_id, -- oe_line_id
6090: g_final_cto_shipset(i).ato_line_id, -- ato_line_id
6091: g_final_cto_shipset(i).inventory_item_id, -- Inventory_item_id
6092: g_final_cto_shipset(i).sourcing_org, -- organization_id

Line 6419: INSERT INTO BOM_CTO_ORDER_DEMAND (

6415: ELSE
6416:
6417: l_stmt_no := 40;
6418:
6419: INSERT INTO BOM_CTO_ORDER_DEMAND (
6420: bcod_line_id,
6421: oe_line_id,
6422: ato_line_id,
6423: inventory_item_id,

Line 6439: BOM_CTO_ORDER_DEMAND_S1.nextval, -- bcod_line_id

6435: last_update_login,
6436: program_application_id,
6437: program_update_date)
6438: VALUES(
6439: BOM_CTO_ORDER_DEMAND_S1.nextval, -- bcod_line_id
6440: l_line_id, -- oe_line_id
6441: p_ato_line_id, -- ato_line_id
6442: l_inv_item_id, -- Inventory_item_id
6443: l_org_id, -- organization_id

Line 6534: BOM_CTO_ORDER_DEMAND

6530: and create the demand in the proper manufacturing
6531: organizations.
6532: Input :
6533: Output : The proper demand record stored in the
6534: BOM_CTO_ORDER_DEMAND
6535: ********************************************************************/
6536:
6537:
6538: --- Modified for performance reason

Line 6634: BOM_CTO_ORDER_DEMAND

6630: END IF;
6631:
6632: DELETE
6633: FROM
6634: BOM_CTO_ORDER_DEMAND
6635: WHERE parent_demand_type = '2'; --- The rows belongs to ato items
6636:
6637: lStmtNum := 20;
6638:

Line 6698: BOM_CTO_ORDER_DEMAND(

6694: oe_debug_pub.add('create_cto_item_demand: ' || 'Inserting Config line info into bcod...',2);
6695: END IF;
6696:
6697: INSERT INTO
6698: BOM_CTO_ORDER_DEMAND(
6699: bcod_line_id,
6700: oe_line_id,
6701: ato_line_id,
6702: inventory_item_id,

Line 6718: bom_cto_order_demand_s1.nextval, -- bcod_line_id

6714: last_update_login,
6715: program_application_id,
6716: program_update_date)
6717: VALUES (
6718: bom_cto_order_demand_s1.nextval, -- bcod_line_id
6719: myrec.line_id, -- oe_line_id
6720: myrec.line_id, -- ato_line_id
6721: myrec.inventory_item_id, -- inventory_item_id
6722: myrec.ship_from_org_id, -- organization_id

Line 6974: bom_cto_order_demand(

6970: guserid := nvl(FND_GLOBAL.user_id,-1);
6971: gloginid := nvl(FND_GLOBAL.login_id,-1);
6972: /* First level model and Option class rows are inserted in to the bcod table.*/
6973: insert into
6974: bom_cto_order_demand(
6975: bcod_line_id,
6976: oe_line_id,
6977: ato_line_id,
6978: inventory_item_id,

Line 6994: BOM_CTO_ORDER_DEMAND_S1.nextval, -- bcod_line_id

6990: last_update_login,
6991: program_application_id,
6992: program_update_date)
6993: select
6994: BOM_CTO_ORDER_DEMAND_S1.nextval, -- bcod_line_id
6995: p_line_id, -- oe_line_id
6996: p_line_id, -- ato_line_id
6997: bic.component_item_id, -- inventory_item_id
6998: p_org_id, -- organization_id

Line 7024: bom_cto_order_demand(

7020: and mtl.inventory_item_id= bic.component_item_id
7021: and mtl.organization_id = p_org_id;
7022: /* Insert the option items for the first level models and option classes */
7023: insert into
7024: bom_cto_order_demand(
7025: bcod_line_id,
7026: oe_line_id,
7027: ato_line_id,
7028: inventory_item_id,

Line 7044: BOM_CTO_ORDER_DEMAND_S1.nextval, -- bcod_line_id

7040: last_update_login,
7041: program_application_id,
7042: program_update_date)
7043: select
7044: BOM_CTO_ORDER_DEMAND_S1.nextval, -- bcod_line_id
7045: p_line_id, -- oe_line_id
7046: p_line_id, -- ato_line_id
7047: bic.component_item_id, -- inventory_item_id
7048: p_org_id, -- organization_id