DBA Data[Home] [Help]

APPS.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on BOM_EXPLOSION_TEMP

Line 113: | row from bom_explosion_temp

109: | 03/26/02 Refai Farook Operation sequence number inheritance lo
110: gic has been changed
111: | 03/27/02 Refai Farook Club component quantitites will be using
112: rowid to identify the unique
113: | row from bom_explosion_temp
114: |
115: |************************************************************************
116: |
117: |

Line 475: FROM bom_explosion_temp be

471: SYSDATE, /* Implementation Date */
472: be.wip_supply_type, /* wip_supply_type */
473: substr(be.pricing_attribute1,1,30), /* Used for From_Unit_Number */
474: substr(be.pricing_attribute2,1,30) /* Used for To_Unit_Number */
475: FROM bom_explosion_temp be
476: WHERE be.bill_sequence_id = p_Bill_Sequence_id;
477:
478: -- dbms_output.put_line('Transfer Complete . . .No. Of Comps Transfered: ' || sql%rowcount);
479:

Line 505: FROM bom_explosion_temp bet

501: , bet.operation_seq_num
502: , bet.component_sequence_id
503: , round( bet.component_quantity, 7 ) component_quantity /* Support Decimal-Qty for Option Items */
504: , rowid /* Sushant added on 19-Aug-2002 */
505: FROM bom_explosion_temp bet
506: WHERE bill_sequence_id = p_bill_sequence_id
507: ORDER BY bet.bill_sequence_id,
508: bet.component_item_id,
509: bet.operation_seq_num;

Line 519: from bom_explosion_temp

515: l_rowid VARCHAR2(50); /* Added by Sushant on 19-Aug-2002*/
516:
517: cursor bill_list is
518: select component_item_id, operation_seq_num, component_sequence_id
519: from bom_explosion_temp
520: where bill_sequence_id = p_bill_sequence_id
521: order by component_item_id;
522: BEGIN
523:

Line 533: DELETE FROM Bom_Explosion_Temp

529: l_quantity := l_quantity + c_components.component_quantity;
530: -- dbms_output.put_line('Found ' || l_component_item_id);
531:
532: -- And then delete the component
533: DELETE FROM Bom_Explosion_Temp
534: WHERE rowid = c_components.rowid; /* changed by Sushant on 19-AUG-2002 */
535: /*
536: WHERE component_sequence_id = c_components.component_sequence_id
537: AND bill_sequence_id = p_bill_sequence_id;

Line 549: UPDATE BOM_EXPLOSION_TEMP

545: l_operation_seq_num <> c_components.operation_seq_num
546: THEN
547:
548: -- Update the Component and then reset the local variables
549: UPDATE BOM_EXPLOSION_TEMP
550: SET component_quantity = l_quantity
551: WHERE rowid = l_rowid; /* Changed by Sushant on 19-Aug-2002 */
552: /*
553: WHERE component_sequence_id = l_component_seq_id;

Line 587: UPDATE BOM_EXPLOSION_TEMP

583: END LOOP; /* Changed by Sushant on 20-Aug-2002 */
584:
585: /* Update the last component which will be left out in the loop */
586: /* Added by Sushant on 19-Aug-2002 */
587: UPDATE BOM_EXPLOSION_TEMP
588: SET component_quantity = l_quantity
589: WHERE rowid = l_rowid;
590:
591:

Line 651: UPDATE bom_explosion_temp

647: );
648:
649: IF c_comps_of_options.operation_seq_num = 1 THEN /* Added by sushant on 19-Aug-2002 */
650: BEGIN
651: UPDATE bom_explosion_temp
652: SET operation_seq_num = l_operation_seq_num /* Changed by Sushant on 19-Aug-2002 */
653: WHERE component_sequence_id =
654: c_comps_of_options.component_sequence_id;
655:

Line 3013: Additional table used here is bom_explosion_temp and the join to cz_config_details_v

3009: AND nvl(bic.disable_date,SYSDATE+1) > SYSDATE;
3010:
3011: /* Mandatory Components for the all the options classes in which user has chosen
3012: atleast 1 option (this is used for operation sequence inheritance from the parent)
3013: Additional table used here is bom_explosion_temp and the join to cz_config_details_v
3014: has been made using the component_code
3015: */
3016:
3017: CURSOR c_cz_req_items_with_Inherit IS

Line 3071: , bom_explosion_temp bet

3067: FROM bom_inventory_components bic
3068: , bom_inventory_components mod_oc
3069: , bom_bill_of_materials bom
3070: , cz_config_details_v cz
3071: , bom_explosion_temp bet
3072: WHERE cz.config_hdr_id = x_cz_config_hdr_id
3073: AND cz.config_rev_nbr = x_cz_config_rev_num
3074: AND cz.component_code = bet.component_code
3075: AND mod_oc.component_sequence_id = cz.component_sequence_id

Line 3093: SELECT * from bom_explosion_temp WHERE component_code IS NOT NULL

3089: for the records that are from cz_config_details_v (i.e all the option classes for the
3090: configured item and all the choosen options) */
3091:
3092: CURSOR c_Comps_With_ComponentCode IS
3093: SELECT * from bom_explosion_temp WHERE component_code IS NOT NULL
3094: ORDER BY component_code;
3095:
3096: /* Option classes that are under the top model */
3097:

Line 3117: FROM bom_explosion_temp bet

3113: SELECT bet.bill_sequence_id
3114: , bet.component_item_id
3115: , bet.operation_seq_num
3116: , bet.component_sequence_id
3117: FROM bom_explosion_temp bet
3118: WHERE bill_sequence_id = x_bill_sequence_id
3119: ORDER BY bet.bill_sequence_id,
3120: bet.component_item_id,
3121: bet.operation_seq_num,

Line 3146: DELETE from bom_explosion_temp;

3142: X_Stmt_Num := 10;
3143:
3144: /* Flush the temp table before starting the process */
3145:
3146: DELETE from bom_explosion_temp;
3147:
3148: /* Insert Model */
3149:
3150: INSERT INTO BOM_INVENTORY_COMPONENTS

Line 3254: INSERT INTO BOM_EXPLOSION_TEMP

3250: AND be.plan_level = 0;
3251:
3252: /* Insert the Mandatory Components of the Model */
3253:
3254: INSERT INTO BOM_EXPLOSION_TEMP
3255: ( top_bill_sequence_id,
3256: organization_id,
3257: plan_level,
3258: sort_order,

Line 3364: INSERT INTO BOM_EXPLOSION_TEMP

3360:
3361: /* Insert the Option Classes from which user has chosen atleast one option item along with
3362: the component code*/
3363:
3364: INSERT INTO BOM_EXPLOSION_TEMP
3365: ( top_bill_sequence_id,
3366: organization_id,
3367: plan_level,
3368: sort_order,

Line 3484: INSERT INTO bom_explosion_temp(

3480: IF l_op_seq_profile <> 1 THEN
3481:
3482: FOR cz_mandatory_items IN c_cz_required_items
3483: LOOP
3484: INSERT INTO bom_explosion_temp(
3485: top_bill_sequence_id,
3486: organization_id,
3487: plan_level,
3488: sort_order,

Line 3592: INSERT INTO bom_explosion_temp(

3588: /* Insert all the selected Options along with the component code */
3589:
3590: FOR cz_options IN cz_options_chosen
3591: LOOP
3592: INSERT INTO bom_explosion_temp(
3593: top_bill_sequence_id,
3594: organization_id,
3595: plan_level,
3596: sort_order,

Line 3727: UPDATE bom_explosion_temp btemp

3723: IF r1.operation_seq_num = 1 AND Instr(r1.component_code,'-',1,2) <> 0
3724: /* If operation seq number is 1 and the component is not the first level comp. under the top model */
3725: THEN
3726: /* Get the op.seq number from it's immediate parent */
3727: UPDATE bom_explosion_temp btemp
3728: SET btemp.operation_seq_num = (SELECT operation_seq_num FROM
3729: bom_explosion_temp WHERE component_code =
3730: substr(btemp.component_code,1,to_number(instr(btemp.component_code,'-',-1,1))-1))
3731: WHERE component_code = r1.component_code;

Line 3729: bom_explosion_temp WHERE component_code =

3725: THEN
3726: /* Get the op.seq number from it's immediate parent */
3727: UPDATE bom_explosion_temp btemp
3728: SET btemp.operation_seq_num = (SELECT operation_seq_num FROM
3729: bom_explosion_temp WHERE component_code =
3730: substr(btemp.component_code,1,to_number(instr(btemp.component_code,'-',-1,1))-1))
3731: WHERE component_code = r1.component_code;
3732: END IF;
3733:

Line 3744: INSERT INTO bom_explosion_temp(

3740: IF l_op_seq_profile = 1 THEN
3741:
3742: FOR cz_mandatory_items IN c_cz_req_items_with_Inherit
3743: LOOP
3744: INSERT INTO bom_explosion_temp(
3745: top_bill_sequence_id,
3746: organization_id,
3747: plan_level,
3748: sort_order,

Line 3880: DELETE from bom_explosion_temp;

3876: ( p_bill_sequence_id => x_bill_sequence_id );
3877:
3878: /* Flush the temp table after the process */
3879:
3880: DELETE from bom_explosion_temp;
3881:
3882: IF (X_Return_Val <> 0 ) THEN
3883: return;
3884: END IF;

Line 3888: DELETE from bom_explosion_temp;

3884: END IF;
3885: -- Commit;
3886: EXCEPTION
3887: WHEN OTHERS THEN
3888: DELETE from bom_explosion_temp;
3889: x_message := 'BOM_CONFIG_EXPLOSIONS_PKG.Insert_Mandatory_Components('
3890: || to_char(X_Stmt_Num) || '):';
3891: FND_MESSAGE.Set_Name('BOM','CZ_PLSQL_ERROR');
3892: FND_MESSAGE.Set_Token('PACKAGE',x_message);