DBA Data[Home] [Help]

APPS.ARP_BATCH_SOURCE dependencies on AD_DDL

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

83: l_sql_stmt := 'create sequence '||l_sequence_name||
84: ' minvalue 1 maxvalue 99999999999999999999 start with '||
85: to_char(P_last_number + 1)||' cache 20';
86:
87: ad_ddl.do_ddl(l_fnd_user, 'AR', ad_ddl.create_sequence, l_sql_stmt, l_sequence_name);
88:
89: -- Start Bug 6010774, 6903507
90: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
91: IF (l_country_code = 'TW') THEN

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

92: l_sql_stmt_2 := 'create sequence '||l_sequence_name_2||
93: ' minvalue 1 maxvalue 99999999999999999999 start with '||
94: to_char(P_last_number + 1)||' nocache';
95:
96: ad_ddl.do_ddl(l_fnd_user, 'JA', ad_ddl.create_sequence, l_sql_stmt_2, l_sequence_name_2);
97: ELSIF (l_country_code = 'BR') THEN
98: l_sql_stmt_4 := 'create sequence '||l_sequence_name_4||
99: ' minvalue 1 maxvalue 99999999999999999999 start with '||
100: to_char(P_last_number + 1)||' nocache';

Line 102: ad_ddl.do_ddl(l_fnd_user, 'JL', ad_ddl.create_sequence, l_sql_stmt_4,l_sequence_name_4);

98: l_sql_stmt_4 := 'create sequence '||l_sequence_name_4||
99: ' minvalue 1 maxvalue 99999999999999999999 start with '||
100: to_char(P_last_number + 1)||' nocache';
101: /* bug 9131562 */
102: ad_ddl.do_ddl(l_fnd_user, 'JL', ad_ddl.create_sequence, l_sql_stmt_4,l_sequence_name_4);
103: ELSIF (l_country_code = 'AR') THEN
104: l_sql_stmt_3 := 'create sequence '||l_sequence_name_3||
105: ' minvalue 1 maxvalue 99999999999999999999 start with '||
106: to_char(P_last_number + 1)||' nocache';

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

104: l_sql_stmt_3 := 'create sequence '||l_sequence_name_3||
105: ' minvalue 1 maxvalue 99999999999999999999 start with '||
106: to_char(P_last_number + 1)||' nocache';
107:
108: ad_ddl.do_ddl(l_fnd_user, 'JL', ad_ddl.create_sequence, l_sql_stmt_3, l_sequence_name_3);
109: END IF;
110: -- End Bug 6010774, 6903507
111: END; /* end of procedure create_trx_sequence */
112: