[Home] [Help]
22: | Multilevel/Multi-org CTO functionality
23: | 11-06-2000 Kiran Konada Added code to support
24: | Multilevel/Multi-org CTO functionality
25: | of changing visible demand flag IN
26: | BOM_CTO_ORDER_DEMAND table while creation
27: | of Configuration item
28: | 01/03/2001 Renga Kannan Removed the raise statements in the
29: | exception block. This fix is done as
30: | part of the bug fix #1509712
1509:
1510: lStmtNumber := 570;
1511:
1512: --to delete the row corresponding to CID in BCOD table
1513: delete from bom_cto_order_demand
1514: where ato_line_id=pModelLineId
1515: and inventory_item_id=pConfigId;
1516:
1517: --updating the demand_visible flag to yes in BCOD table CID removal
1516:
1517: --updating the demand_visible flag to yes in BCOD table CID removal
1518: lStmtNumber := 580;
1519:
1520: update bom_cto_order_demand
1521: set demand_visible = 'Y'
1522: where ato_line_id =pModelLineId;
1523:
1524: END IF;
8435:
8436: /* Not Required for Patcshet J */
8437: /*
8438: lStmtNumber := 430;
8439: update bom_cto_order_demand
8440: set demand_visible = 'N'
8441: where ato_line_id =pLineId;
8442:
8443: --adding the CID row to BCOD table
8442:
8443: --adding the CID row to BCOD table
8444:
8445: lStmtNumber := 440;
8446: insert into bom_cto_order_demand(
8447: bcod_line_id,
8448: oe_line_id,
8449: ato_line_id,
8450: inventory_item_id,
8463: program_application_id,
8464: program_update_date
8465: )
8466: select
8467: BOM_CTO_ORDER_DEMAND_S1.nextval,
8468: line_id,
8469: pLineId,
8470: pConfigId,
8471: pOrgId,
8709: END link_item;
8710:
8711: /*****************************************************************************
8712: chk_model_in_bcod
8713: bcod implies BOM CTO ORDER DEMAND
8714: checks if model is there in BOM CTO ORDER DEMAND table before the creation of row for configured item in the BOM CTO ORDER DEMAND table. This function is being called from link_item()function
8715: *****************************************************************************/
8716:
8717: FUNCTION chk_model_in_bcod(
8710:
8711: /*****************************************************************************
8712: chk_model_in_bcod
8713: bcod implies BOM CTO ORDER DEMAND
8714: checks if model is there in BOM CTO ORDER DEMAND table before the creation of row for configured item in the BOM CTO ORDER DEMAND table. This function is being called from link_item()function
8715: *****************************************************************************/
8716:
8717: FUNCTION chk_model_in_bcod(
8718: pLineId in number)
8720: is
8721: l_dummy number;
8722: BEGIN
8723: select oe_line_id into l_dummy
8724: from bom_cto_order_demand
8725: where oe_line_id=pLineId;
8726: return (1);
8727: EXCEPTION
8728: when no_data_found then