APPS.CTO_MSUTIL_PUB dependencies on BOM_CTO_MODEL_ORGS

Line 429: update bom_cto_model_orgs set create_bom = 'N'

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

Line 455: update bom_cto_model_orgs set create_bom = 'Y'

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

Line 1001: update bom_cto_model_orgs set create_bom = 'N'

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

Line 1027: update bom_cto_model_orgs set create_bom = 'Y'

1023:
1024: select group_reference_id into v_group_reference_id from bom_cto_src_orgs_b
1025: where line_id = v_model_lines.line_id ;
1026:
1027: update bom_cto_model_orgs set create_bom = 'Y'
1028: where group_reference_id = v_group_reference_id and organization_id = v_orgs_list(i)
1029: -- bugfix 4274446 : Check create_config_bom parameter
1030: and exists
1031: ( select 1 from bom_parameters

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

4804: begin
4805:
4806: oe_debug_pub.add( '$$$ insert type3 bcmo bcso ' , 1 ) ;
4807:
4808: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4809:
4810:
4811:
4812: insert into bom_cto_model_orgs

Line 4812: insert into bom_cto_model_orgs

4808: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4809:
4810:
4811:
4812: insert into bom_cto_model_orgs
4813: (
4814: reference_id,
4815: group_reference_id,
4816: model_item_id,

Line 4835: bom_cto_model_orgs_s1.nextval,

4831: program_id,
4832: program_update_date
4833: )
4834: select -- distinct
4835: bom_cto_model_orgs_s1.nextval,
4836: v_group_reference_id,
4837: p_model_item_id ,
4838: null ,
4839: msi.organization_id,

Line 4865: from bom_cto_model_orgs bcmo

4861: and msi.organization_id = bp.organization_id (+) /* added for bug 3504744 */;
4862: /*
4863: and NOT EXISTS
4864: (select NULL
4865: from bom_cto_model_orgs bcmo
4866: where bcmo.model_item_id = msi.inventory_item_id
4867: and bcmo.organization_id = msi.organization_id );
4868: */
4869:

Line 4957: select group_reference_id into v_group_reference_id from bom_cto_model_orgs

4953: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_config_item_id:' || p_config_item_id) ;
4954: --debug end
4955:
4956: begin
4957: select group_reference_id into v_group_reference_id from bom_cto_model_orgs
4958: where config_item_id = p_config_item_id and rownum = 1 ; /* all records have the same group reference id */
4959:
4960:
4961: exception

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

4961: exception
4962: when no_data_found then
4963:
4964: oe_debug_pub.add( '$$$ short circuit for type3 referenced bcso ' , 1 ) ;
4965: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4966:
4967:
4968:
4969: insert into bom_cto_model_orgs

Line 4969: insert into bom_cto_model_orgs

4965: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4966:
4967:
4968:
4969: insert into bom_cto_model_orgs
4970: (
4971: reference_id,
4972: group_reference_id,
4973: model_item_id,

Line 4992: bom_cto_model_orgs_s1.nextval,

4988: program_id,
4989: program_update_date
4990: )
4991: select -- distinct
4992: bom_cto_model_orgs_s1.nextval,
4993: v_group_reference_id,
4994: p_model_item_id ,
4995: null ,
4996: msi.organization_id,