DBA Data[Home] [Help]

APPS.CSP_REPAIR_PO_GRP dependencies on AD_TSPACE_UTIL

Line 855: ad_tspace_util.is_new_ts_mode(lv_is_new_ts_mode);

851: lv_dummy2 varchar2(32);
852: lv_is_new_ts_mode VARCHAR2(10);
853: BEGIN
854:
855: ad_tspace_util.is_new_ts_mode(lv_is_new_ts_mode);
856: IF(upper(lv_is_new_ts_mode) = 'N') THEN
857: SELECT a.oracle_username
858: INTO lv_schema
859: FROM FND_ORACLE_USERID a,

Line 865: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(p_apps_id);

861: WHERE a.oracle_id = b.oracle_id
862: AND b.application_id = p_apps_id;
863:
864: ELSE
865: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(p_apps_id);
866: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
867: END IF;
868:
869: RETURN lv_schema;

Line 927: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(523);

923: begin
924: lv_retval := FND_INSTALLATION.GET_APP_INFO(
925: 'FND', lv_dummy1,lv_dummy2, v_applsys_schema);
926:
927: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(523);
928: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
929: application_short_name => lv_prod_short_name,
930: statement_type => AD_DDL.CREATE_INDEX,
931: statement => p_sql_stmt,