APPS.MSC_CL_BOM_PULL dependencies on AD_DDL

Line 709: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

705: if MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN /*osfm change*/
706: select instance_code into lv_icode from msc_apps_instances where instance_id = MSC_CL_PULL.v_instance_id;
707: BEGIN
708:
709: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
710: application_short_name => 'MSC',
711: statement_type => AD_DDL.CREATE_INDEX,
712: statement =>
713: 'create index MSC_ST_BOM_COMPONENTS_'||lv_icode

Line 711: statement_type => AD_DDL.CREATE_INDEX,

707: BEGIN
708:
709: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
710: application_short_name => 'MSC',
711: statement_type => AD_DDL.CREATE_INDEX,
712: statement =>
713: 'create index MSC_ST_BOM_COMPONENTS_'||lv_icode
714: ||' ON MSC_ST_BOM_COMPONENTS (BILL_SEQUENCE_ID,SR_INSTANCE_ID) '
715: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',

Line 728: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

724:
725: LOAD_CO_PRODUCT_BOMS;
726:
727: BEGIN
728: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
729: application_short_name => 'MSC',
730: statement_type => AD_DDL.DROP_INDEX,
731: statement =>
732: 'drop index MSC_ST_BOM_COMPONENTS_'||lv_icode,

Line 730: statement_type => AD_DDL.DROP_INDEX,

726:
727: BEGIN
728: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
729: application_short_name => 'MSC',
730: statement_type => AD_DDL.DROP_INDEX,
731: statement =>
732: 'drop index MSC_ST_BOM_COMPONENTS_'||lv_icode,
733: object_name => 'MSC_ST_BOM_COMPONENTS_'||lv_icode);
734: EXCEPTION