APPS.CTO_MSUTIL_PUB dependencies on BOM_CTO_MODEL_ORGS

Line 426: update bom_cto_model_orgs set create_bom = 'N'

422:
423: select group_reference_id into v_group_reference_id from bom_cto_src_orgs_b
424: where line_id = v_model_lines.line_id ;
425:
426: update bom_cto_model_orgs set create_bom = 'N'
427: where group_reference_id = v_group_reference_id ;
428:
429: oe_debug_pub.add( 'UPDATED BCMO create_bom = N for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;
430: else

Line 452: update bom_cto_model_orgs set create_bom = 'Y'

448:
449: select group_reference_id into v_group_reference_id from bom_cto_src_orgs_b
450: where line_id = v_model_lines.line_id ;
451:
452: update bom_cto_model_orgs set create_bom = 'Y'
453: where group_reference_id = v_group_reference_id and organization_id = v_orgs_list(i)
454: -- bugfix 4274446 : Check create_config_bom parameter
455: and exists
456: ( select 1 from bom_parameters

Line 996: update bom_cto_model_orgs set create_bom = 'N'

992:
993: select group_reference_id into v_group_reference_id from bom_cto_src_orgs_b
994: where line_id = v_model_lines.line_id ;
995:
996: update bom_cto_model_orgs set create_bom = 'N'
997: where group_reference_id = v_group_reference_id ;
998:
999: oe_debug_pub.add( 'UPDATED BCMO create_bom = N for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;
1000: else

Line 1022: update bom_cto_model_orgs set create_bom = 'Y'

1018:
1019: select group_reference_id into v_group_reference_id from bom_cto_src_orgs_b
1020: where line_id = v_model_lines.line_id ;
1021:
1022: update bom_cto_model_orgs set create_bom = 'Y'
1023: where group_reference_id = v_group_reference_id and organization_id = v_orgs_list(i)
1024: -- bugfix 4274446 : Check create_config_bom parameter
1025: and exists
1026: ( select 1 from bom_parameters

Line 4291: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;

4287: begin
4288:
4289: oe_debug_pub.add( '$$$ insert type3 bcmo bcso ' , 1 ) ;
4290:
4291: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4292:
4293:
4294:
4295: insert into bom_cto_model_orgs

Line 4295: insert into bom_cto_model_orgs

4291: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4292:
4293:
4294:
4295: insert into bom_cto_model_orgs
4296: (
4297: reference_id,
4298: group_reference_id,
4299: model_item_id,

Line 4318: bom_cto_model_orgs_s1.nextval,

4314: program_id,
4315: program_update_date
4316: )
4317: select -- distinct
4318: bom_cto_model_orgs_s1.nextval,
4319: v_group_reference_id,
4320: p_model_item_id ,
4321: null ,
4322: msi.organization_id,

Line 4348: from bom_cto_model_orgs bcmo

4344: and msi.organization_id = bp.organization_id (+) /* added for bug 3504744 */;
4345: /*
4346: and NOT EXISTS
4347: (select NULL
4348: from bom_cto_model_orgs bcmo
4349: where bcmo.model_item_id = msi.inventory_item_id
4350: and bcmo.organization_id = msi.organization_id );
4351: */
4352:

Line 4432: select group_reference_id into v_group_reference_id from bom_cto_model_orgs

4428:
4429: oe_debug_pub.add( '$$$ insert type3 referenced bcso ' , 1 ) ;
4430:
4431: begin
4432: select group_reference_id into v_group_reference_id from bom_cto_model_orgs
4433: where config_item_id = p_config_item_id and rownum = 1 ; /* all records have the same group reference id */
4434:
4435:
4436: exception

Line 4440: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;

4436: exception
4437: when no_data_found then
4438:
4439: oe_debug_pub.add( '$$$ short circuit for type3 referenced bcso ' , 1 ) ;
4440: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4441:
4442:
4443:
4444: insert into bom_cto_model_orgs

Line 4444: insert into bom_cto_model_orgs

4440: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4441:
4442:
4443:
4444: insert into bom_cto_model_orgs
4445: (
4446: reference_id,
4447: group_reference_id,
4448: model_item_id,

Line 4467: bom_cto_model_orgs_s1.nextval,

4463: program_id,
4464: program_update_date
4465: )
4466: select -- distinct
4467: bom_cto_model_orgs_s1.nextval,
4468: v_group_reference_id,
4469: p_model_item_id ,
4470: null ,
4471: msi.organization_id,