DBA Data[Home] [Help]

APPS.ARP_BATCH_SOURCE dependencies on AD_DDL

Line 81: ad_ddl.do_ddl(l_fnd_user, 'AR', ad_ddl.create_sequence, l_sql_stmt, l_sequence_name);

77: l_sql_stmt := 'create sequence '||l_sequence_name||
78: ' minvalue 1 maxvalue 99999999999999999999 start with '||
79: to_char(P_last_number + 1)||' cache 20';
80:
81: ad_ddl.do_ddl(l_fnd_user, 'AR', ad_ddl.create_sequence, l_sql_stmt, l_sequence_name);
82:
83: -- Start Bug 6010774, 6903507
84: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
85: IF (l_country_code = 'TW') THEN

Line 90: ad_ddl.do_ddl(l_fnd_user, 'JA', ad_ddl.create_sequence, l_sql_stmt_2, l_sequence_name_2);

86: l_sql_stmt_2 := 'create sequence '||l_sequence_name_2||
87: ' minvalue 1 maxvalue 99999999999999999999 start with '||
88: to_char(P_last_number + 1)||' nocache';
89:
90: ad_ddl.do_ddl(l_fnd_user, 'JA', ad_ddl.create_sequence, l_sql_stmt_2, l_sequence_name_2);
91: ELSIF (l_country_code = 'AR') THEN
92: l_sql_stmt_3 := 'create sequence '||l_sequence_name_3||
93: ' minvalue 1 maxvalue 99999999999999999999 start with '||
94: to_char(P_last_number + 1)||' nocache';

Line 96: ad_ddl.do_ddl(l_fnd_user, 'JL', ad_ddl.create_sequence, l_sql_stmt_3, l_sequence_name_3);

92: l_sql_stmt_3 := 'create sequence '||l_sequence_name_3||
93: ' minvalue 1 maxvalue 99999999999999999999 start with '||
94: to_char(P_last_number + 1)||' nocache';
95:
96: ad_ddl.do_ddl(l_fnd_user, 'JL', ad_ddl.create_sequence, l_sql_stmt_3, l_sequence_name_3);
97: END IF;
98: -- End Bug 6010774, 6903507
99: END; /* end of procedure create_trx_sequence */
100: