APPS.PO_UDA_TEMPLATES_UTIL dependencies on AD_DDL

Line 3264: /* 12.2 Online patching project impact: Use ad_ddl instead of execute immediate */

3260: IF PO_LOG.d_stmt THEN
3261: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);
3262: END IF;
3263:
3264: /* 12.2 Online patching project impact: Use ad_ddl instead of execute immediate */
3265: -- get the APPLSYS schema name
3266: l_dummy := fnd_installation.get_app_info('FND', l_status, l_industry, l_applsys_schema);
3267:
3268:

Line 3269: ad_ddl.do_ddl (applsys_schema => l_applsys_schema,

3265: -- get the APPLSYS schema name
3266: l_dummy := fnd_installation.get_app_info('FND', l_status, l_industry, l_applsys_schema);
3267:
3268:
3269: ad_ddl.do_ddl (applsys_schema => l_applsys_schema,
3270: application_short_name => 'PO',
3271: statement_type => ad_ddl.create_view,
3272: statement => l_create_view,
3273: object_name => l_view_name);

Line 3271: statement_type => ad_ddl.create_view,

3267:
3268:
3269: ad_ddl.do_ddl (applsys_schema => l_applsys_schema,
3270: application_short_name => 'PO',
3271: statement_type => ad_ddl.create_view,
3272: statement => l_create_view,
3273: object_name => l_view_name);
3274:
3275: -- EXECUTE IMMEDIATE (l_create_view);

Line 3318: /* 12.2 online patching project impact: use ad_ddl instead of execute immediate */

3314: IF PO_LOG.d_stmt THEN
3315: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);
3316: END IF;
3317:
3318: /* 12.2 online patching project impact: use ad_ddl instead of execute immediate */
3319: ad_ddl.do_ddl (applsys_schema => l_applsys_schema,
3320: application_short_name => 'PO',
3321: statement_type => ad_ddl.create_view,
3322: statement => l_create_view,

Line 3319: ad_ddl.do_ddl (applsys_schema => l_applsys_schema,

3315: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);
3316: END IF;
3317:
3318: /* 12.2 online patching project impact: use ad_ddl instead of execute immediate */
3319: ad_ddl.do_ddl (applsys_schema => l_applsys_schema,
3320: application_short_name => 'PO',
3321: statement_type => ad_ddl.create_view,
3322: statement => l_create_view,
3323: object_name => l_hist_view_name);

Line 3321: statement_type => ad_ddl.create_view,

3317:
3318: /* 12.2 online patching project impact: use ad_ddl instead of execute immediate */
3319: ad_ddl.do_ddl (applsys_schema => l_applsys_schema,
3320: application_short_name => 'PO',
3321: statement_type => ad_ddl.create_view,
3322: statement => l_create_view,
3323: object_name => l_hist_view_name);
3324:
3325: -- EXECUTE IMMEDIATE (l_create_view);

Line 3409: /* 12.2 Online patching project impact: Use ad_ddl instead of execute immediate */

3405: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);
3406: END IF;
3407:
3408:
3409: /* 12.2 Online patching project impact: Use ad_ddl instead of execute immediate */
3410: -- get the APPLSYS schema name
3411: l_dummy := fnd_installation.get_app_info('FND', l_status, l_industry, l_applsys_schema);
3412:
3413: ad_ddl.do_ddl (applsys_schema => l_applsys_schema,

Line 3413: ad_ddl.do_ddl (applsys_schema => l_applsys_schema,

3409: /* 12.2 Online patching project impact: Use ad_ddl instead of execute immediate */
3410: -- get the APPLSYS schema name
3411: l_dummy := fnd_installation.get_app_info('FND', l_status, l_industry, l_applsys_schema);
3412:
3413: ad_ddl.do_ddl (applsys_schema => l_applsys_schema,
3414: application_short_name => 'PO',
3415: statement_type => ad_ddl.create_view,
3416: statement => l_create_view,
3417: object_name => l_view_name);

Line 3415: statement_type => ad_ddl.create_view,

3411: l_dummy := fnd_installation.get_app_info('FND', l_status, l_industry, l_applsys_schema);
3412:
3413: ad_ddl.do_ddl (applsys_schema => l_applsys_schema,
3414: application_short_name => 'PO',
3415: statement_type => ad_ddl.create_view,
3416: statement => l_create_view,
3417: object_name => l_view_name);
3418:
3419: -- EXECUTE IMMEDIATE (l_create_view);