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
1601:
1602: lStmtNumber := 570;
1603:
1604: --to delete the row corresponding to CID in BCOD table
1605: delete from bom_cto_order_demand
1606: where ato_line_id=pModelLineId
1607: and inventory_item_id=pConfigId;
1608:
1609: --updating the demand_visible flag to yes in BCOD table CID removal
1608:
1609: --updating the demand_visible flag to yes in BCOD table CID removal
1610: lStmtNumber := 580;
1611:
1612: update bom_cto_order_demand
1613: set demand_visible = 'Y'
1614: where ato_line_id =pModelLineId;
1615:
1616: END IF;
8736:
8737: /* Not Required for Patcshet J */
8738: /*
8739: lStmtNumber := 430;
8740: update bom_cto_order_demand
8741: set demand_visible = 'N'
8742: where ato_line_id =pLineId;
8743:
8744: --adding the CID row to BCOD table
8743:
8744: --adding the CID row to BCOD table
8745:
8746: lStmtNumber := 440;
8747: insert into bom_cto_order_demand(
8748: bcod_line_id,
8749: oe_line_id,
8750: ato_line_id,
8751: inventory_item_id,
8764: program_application_id,
8765: program_update_date
8766: )
8767: select
8768: BOM_CTO_ORDER_DEMAND_S1.nextval,
8769: line_id,
8770: pLineId,
8771: pConfigId,
8772: pOrgId,
9010: END link_item;
9011:
9012: /*****************************************************************************
9013: chk_model_in_bcod
9014: bcod implies BOM CTO ORDER DEMAND
9015: 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
9016: *****************************************************************************/
9017:
9018: FUNCTION chk_model_in_bcod(
9011:
9012: /*****************************************************************************
9013: chk_model_in_bcod
9014: bcod implies BOM CTO ORDER DEMAND
9015: 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
9016: *****************************************************************************/
9017:
9018: FUNCTION chk_model_in_bcod(
9019: pLineId in number)
9021: is
9022: l_dummy number;
9023: BEGIN
9024: select oe_line_id into l_dummy
9025: from bom_cto_order_demand
9026: where oe_line_id=pLineId;
9027: return (1);
9028: EXCEPTION
9029: when no_data_found then