DBA Data[Home] [Help]

APPS.QA_CHAR_INDEXES_PKG dependencies on AD_DDL

Line 393: -- rdbms CREATE INDEX command and pass to ad_ddl.

389:
390: --
391: -- Here l_ddl contains the actual DECODE function.
392: -- we prepend and append the rest of the actual
393: -- rdbms CREATE INDEX command and pass to ad_ddl.
394: -- String overflow is still possible.
395: --
396: l_ddl := 'CREATE INDEX ' || g_qa_schema || '.' ||
397: '"' || p_index_name || '" ON ' ||

Line 402: ad_ddl.do_ddl(

398: g_qa_schema || '.QA_RESULTS ' || p_alias ||
399: '(' || l_alias_dot || 'PLAN_ID, ' || l_ddl || ') ' ||
400: p_additional_parameters;
401:
402: ad_ddl.do_ddl(
403: applsys_schema => g_fnd_schema,
404: application_short_name => g_qa,
405: statement_type => ad_ddl.create_index,
406: statement => l_ddl,

Line 405: statement_type => ad_ddl.create_index,

401:
402: ad_ddl.do_ddl(
403: applsys_schema => g_fnd_schema,
404: application_short_name => g_qa,
405: statement_type => ad_ddl.create_index,
406: statement => l_ddl,
407: object_name => p_index_name);
408:
409: RETURN 0;

Line 554: ad_ddl.do_ddl(

550:
551: l_ddl := 'DROP INDEX ' || g_qa_schema || '.' ||
552: '"' || l_index_name || '"';
553:
554: ad_ddl.do_ddl(
555: applsys_schema => g_fnd_schema,
556: application_short_name => g_qa,
557: statement_type => ad_ddl.drop_index,
558: statement => l_ddl,

Line 557: statement_type => ad_ddl.drop_index,

553:
554: ad_ddl.do_ddl(
555: applsys_schema => g_fnd_schema,
556: application_short_name => g_qa,
557: statement_type => ad_ddl.drop_index,
558: statement => l_ddl,
559: object_name => l_index_name);
560:
561: RETURN 0;