APPS.JTY_ASSIGN_BULK_PUB dependencies on AD_DDL

Line 3003: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.drop_table, 'drop table ' || l_mp_winner_target, l_mp_winner_target);

2999: /* create a temp table that will contain all the transaction objects */
3000: /* and their matching territories in a single row */
3001: /* drop the table if it alreday exists */
3002: BEGIN
3003: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.drop_table, 'drop table ' || l_mp_winner_target, l_mp_winner_target);
3004: EXCEPTION
3005: when others then
3006: null;
3007: END;

Line 3042: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_mp_winner_target);

3038: substr(l_dyn_str, 1, 4000));
3039: END IF;
3040:
3041: /* create the table in jtf schema */
3042: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_mp_winner_target);
3043:
3044: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3045: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3046: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',

Line 3054: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.drop_table, 'drop table ' || l_dmc_winner_target, l_dmc_winner_target);

3050: /* create a temp table that will contain only the distinct */
3051: /* combination of matching territories in a single row */
3052: /* drop the table if it alreday exists */
3053: BEGIN
3054: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.drop_table, 'drop table ' || l_dmc_winner_target, l_dmc_winner_target);
3055: EXCEPTION
3056: when others then
3057: null;
3058: END;

Line 3088: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_dmc_winner_target);

3084: substr(l_dyn_str, 1, 4000));
3085: END IF;
3086:
3087: /* Create the table in JTF schema */
3088: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_dmc_winner_target);
3089:
3090: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3091: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3092: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',

Line 3206: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_index, l_dyn_str, l_dmc_winner_target || 'N');

3202: substr(l_dyn_str, 1, 4000));
3203: END IF;
3204:
3205: /* Create the index in JTF schema */
3206: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_index, l_dyn_str, l_dmc_winner_target || 'N');
3207:
3208: /* update the temporary table to maintain the link */
3209: /* between txn objects and unique terr matching combinations */
3210: l_dyn_str :=