DBA Data[Home] [Help]

APPS.ZX_TPI_PLUGIN_PKG dependencies on AD_DDL

Line 115: ad_ddl.build_statement(p_str,g_counter);

111:
112: PROCEDURE print_string(p_str IN VARCHAR2) IS
113: BEGIN
114:
115: ad_ddl.build_statement(p_str,g_counter);
116: increment_counter;
117: -- dbms_output.put_line(p_str);
118: Fnd_file.put_line(FND_FILE.log,p_str);
119: END;

Line 329: ad_ddl.create_plsql_object(

325: Open C_Oracle_Username;
326: FETCH c_oracle_username INTO
327: l_oracle_username;
328: Close c_oracle_username;
329: ad_ddl.create_plsql_object(
330: l_oracle_username,'ZX',l_pack_name,1,(g_counter-1),'TRUE',dummy);
331:
332: END create_third_party_pkg_spec;
333: /*------------------------------------------------------------------------*/

Line 710: ad_ddl.do_ddl(

706: Open C_Oracle_Username;
707: FETCH c_oracle_username INTO
708: l_oracle_username;
709: Close c_oracle_username;
710: ad_ddl.do_ddl(
711: l_oracle_username,'ZX','AD_DDL.DROP_TABLE','DROP PACKAGE '||l_pack_name,l_pack_name );
712:
713: ELSIF (t_prv.status_code(l_prvidx) <> 'GENERATED') THEN
714:

Line 711: l_oracle_username,'ZX','AD_DDL.DROP_TABLE','DROP PACKAGE '||l_pack_name,l_pack_name );

707: FETCH c_oracle_username INTO
708: l_oracle_username;
709: Close c_oracle_username;
710: ad_ddl.do_ddl(
711: l_oracle_username,'ZX','AD_DDL.DROP_TABLE','DROP PACKAGE '||l_pack_name,l_pack_name );
712:
713: ELSIF (t_prv.status_code(l_prvidx) <> 'GENERATED') THEN
714:
715: g_counter := 1;

Line 886: ad_ddl.create_plsql_object(

882: Open C_Oracle_Username;
883: FETCH c_oracle_username INTO
884: l_oracle_username;
885: Close c_oracle_username;
886: ad_ddl.create_plsql_object(
887: l_oracle_username,'ZX',l_pack_name,1,(g_counter-1),'TRUE',dummy);
888:
889: print_debug('-- CG: After creating pl/sql object');
890:

Line 1008: ad_ddl.create_plsql_object(

1004: Open C_Oracle_Username;
1005: FETCH c_oracle_username INTO
1006: l_oracle_username;
1007: Close c_oracle_username;
1008: ad_ddl.create_plsql_object(
1009: l_oracle_username,'ZX','ZX_'||p_srvc_category||'_PKG',1,(g_counter-1),'TRUE',dummy);
1010:
1011: END IF;
1012: