DBA Data[Home] [Help]

APPS.ZX_TPI_PLUGIN_PKG dependencies on AD_DDL

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

88:
89: PROCEDURE print_string(p_str IN VARCHAR2) IS
90: BEGIN
91:
92: ad_ddl.build_statement(p_str,g_counter);
93: increment_counter;
94: -- dbms_output.put_line(p_str);
95: Fnd_file.put_line(FND_FILE.log,p_str);
96: END;

Line 303: ad_ddl.create_plsql_object(

299:
300: l_string := 'END '||l_pack_name||' ;';
301: print_string(l_string);
302:
303: ad_ddl.create_plsql_object(
304: 'APPS','ZX',l_pack_name,1,(g_counter-1),'TRUE',dummy);
305:
306: END create_third_party_pkg_spec;
307: /*------------------------------------------------------------------------*/

Line 681: ad_ddl.do_ddl(

677: /*------------------------------------------------------------------------*/
678:
679: IF (t_prv.status_code(l_prvidx) = 'DELETED') THEN
680:
681: ad_ddl.do_ddl(
682: 'APPS','ZX','AD_DDL.DROP_TABLE','DROP PACKAGE '||l_pack_name,l_pack_name );
683:
684: ELSIF (t_prv.status_code(l_prvidx) <> 'GENERATED') THEN
685:

Line 682: 'APPS','ZX','AD_DDL.DROP_TABLE','DROP PACKAGE '||l_pack_name,l_pack_name );

678:
679: IF (t_prv.status_code(l_prvidx) = 'DELETED') THEN
680:
681: ad_ddl.do_ddl(
682: 'APPS','ZX','AD_DDL.DROP_TABLE','DROP PACKAGE '||l_pack_name,l_pack_name );
683:
684: ELSIF (t_prv.status_code(l_prvidx) <> 'GENERATED') THEN
685:
686: g_counter := 1;

Line 854: ad_ddl.create_plsql_object(

850: l_string := 'END '||l_pack_name||' ;';
851: print_string(l_string);
852: print_debug('-- CG: Before creating pl/sql object '||l_pack_name || 'G_counter = '|| to_char(g_counter));
853:
854: ad_ddl.create_plsql_object(
855: 'APPS','ZX',l_pack_name,1,(g_counter-1),'TRUE',dummy);
856:
857: print_debug('-- CG: After creating pl/sql object');
858:

Line 962: ad_ddl.create_plsql_object(

958:
959: l_string := 'END ZX_'||p_srvc_category||'_PKG ;';
960: print_string(l_string);
961:
962: ad_ddl.create_plsql_object(
963: 'APPS','ZX','ZX_'||p_srvc_category||'_PKG',1,(g_counter-1),'TRUE',dummy);
964:
965: END IF;
966: