DBA Data[Home] [Help]

APPS.QP_FORMULA_RULES_PVT dependencies on AD_DDL

Line 51: ad_ddl.build_package(' ',line_number);

47: IS
48: BEGIN
49:
50: line_number := line_number + 1;
51: ad_ddl.build_package(' ',line_number);
52: -- oe_debug_pub.add(' ');
53:
54: END New_Line;
55:

Line 64: ad_ddl.build_package(LPAD(p_string,p_level*2+LENGTH(p_string)),line_number);

60: IS
61: BEGIN
62:
63: line_number := line_number + 1;
64: ad_ddl.build_package(LPAD(p_string,p_level*2+LENGTH(p_string)),line_number);
65: -- oe_debug_pub.add(LPAD(p_string,p_level*2+LENGTH(p_string)));
66: --dbms_output.put_line(LPAD(p_string,p_level*2+LENGTH(p_string)));
67:
68: END text;

Line 219: PUT_LINE( 'Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);

215: ELSE
216: l_is_pkg_body := 'FALSE';
217: END IF;
218:
219: PUT_LINE( 'Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);
220: oe_debug_pub.add('Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);
221:
222:
223: ad_ddl.create_package(applsys_schema => g_schema

Line 220: oe_debug_pub.add('Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);

216: l_is_pkg_body := 'FALSE';
217: END IF;
218:
219: PUT_LINE( 'Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);
220: oe_debug_pub.add('Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);
221:
222:
223: ad_ddl.create_package(applsys_schema => g_schema
224: ,application_short_name => 'QP'

Line 223: ad_ddl.create_package(applsys_schema => g_schema

219: PUT_LINE( 'Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);
220: oe_debug_pub.add('Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);
221:
222:
223: ad_ddl.create_package(applsys_schema => g_schema
224: ,application_short_name => 'QP'
225: ,package_name => p_pkg_name
226: ,is_package_body => l_is_pkg_body
227: ,lb => 1

Line 294: IF instr(ad_ddl.glprogtext(1),p_pkg_name) > 0 THEN

290: END;
291:
292: END IF;
293: -- 13638721
294: IF instr(ad_ddl.glprogtext(1),p_pkg_name) > 0 THEN
295:
296: ad_ddl.glprogtext(1) := REPLACE(ad_ddl.glprogtext(1)
297: ,p_pkg_name
298: ,l_new_pkg_name);

Line 296: ad_ddl.glprogtext(1) := REPLACE(ad_ddl.glprogtext(1)

292: END IF;
293: -- 13638721
294: IF instr(ad_ddl.glprogtext(1),p_pkg_name) > 0 THEN
295:
296: ad_ddl.glprogtext(1) := REPLACE(ad_ddl.glprogtext(1)
297: ,p_pkg_name
298: ,l_new_pkg_name);
299:
300: PUT_LINE('First change : ' ||ad_ddl.glprogtext(1));

Line 300: PUT_LINE('First change : ' ||ad_ddl.glprogtext(1));

296: ad_ddl.glprogtext(1) := REPLACE(ad_ddl.glprogtext(1)
297: ,p_pkg_name
298: ,l_new_pkg_name);
299:
300: PUT_LINE('First change : ' ||ad_ddl.glprogtext(1));
301:
302: oe_debug_pub.add('First change : ' ||ad_ddl.glprogtext(1));
303:
304: ad_ddl.glprogtext(line_number) := REPLACE(ad_ddl.glprogtext(line_number)

Line 302: oe_debug_pub.add('First change : ' ||ad_ddl.glprogtext(1));

298: ,l_new_pkg_name);
299:
300: PUT_LINE('First change : ' ||ad_ddl.glprogtext(1));
301:
302: oe_debug_pub.add('First change : ' ||ad_ddl.glprogtext(1));
303:
304: ad_ddl.glprogtext(line_number) := REPLACE(ad_ddl.glprogtext(line_number)
305: ,p_pkg_name
306: ,l_new_pkg_name);

Line 304: ad_ddl.glprogtext(line_number) := REPLACE(ad_ddl.glprogtext(line_number)

300: PUT_LINE('First change : ' ||ad_ddl.glprogtext(1));
301:
302: oe_debug_pub.add('First change : ' ||ad_ddl.glprogtext(1));
303:
304: ad_ddl.glprogtext(line_number) := REPLACE(ad_ddl.glprogtext(line_number)
305: ,p_pkg_name
306: ,l_new_pkg_name);
307:
308: PUT_LINE('Second change : ' ||' '||ad_ddl.glprogtext(line_number));

Line 308: PUT_LINE('Second change : ' ||' '||ad_ddl.glprogtext(line_number));

304: ad_ddl.glprogtext(line_number) := REPLACE(ad_ddl.glprogtext(line_number)
305: ,p_pkg_name
306: ,l_new_pkg_name);
307:
308: PUT_LINE('Second change : ' ||' '||ad_ddl.glprogtext(line_number));
309:
310: oe_debug_pub.add('Second change : ' ||' '||ad_ddl.glprogtext(line_number));
311:
312: PUT_LINE('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);

Line 310: oe_debug_pub.add('Second change : ' ||' '||ad_ddl.glprogtext(line_number));

306: ,l_new_pkg_name);
307:
308: PUT_LINE('Second change : ' ||' '||ad_ddl.glprogtext(line_number));
309:
310: oe_debug_pub.add('Second change : ' ||' '||ad_ddl.glprogtext(line_number));
311:
312: PUT_LINE('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);
313:
314: oe_debug_pub.add('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);

Line 316: ad_ddl.create_package(applsys_schema => g_schema

312: PUT_LINE('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);
313:
314: oe_debug_pub.add('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);
315:
316: ad_ddl.create_package(applsys_schema => g_schema
317: ,application_short_name => 'QP'
318: ,package_name => l_new_pkg_name
319: ,is_package_body => l_is_pkg_body
320: ,lb => 1

Line 401: raise_application_error(-20000,SQLERRM||' '||ad_ddl.error_buf);

397: exception
398: when FND_API.G_EXC_ERROR then
399: raise FND_API.G_EXC_ERROR;
400: when others THEN
401: raise_application_error(-20000,SQLERRM||' '||ad_ddl.error_buf);
402: -- PUT_LINE('Iam into exception' ||ad_ddl.error_buf);
403: -- RAISE FND_API.G_EXC_ERROR;
404:
405: END Pkg_End;

Line 402: -- PUT_LINE('Iam into exception' ||ad_ddl.error_buf);

398: when FND_API.G_EXC_ERROR then
399: raise FND_API.G_EXC_ERROR;
400: when others THEN
401: raise_application_error(-20000,SQLERRM||' '||ad_ddl.error_buf);
402: -- PUT_LINE('Iam into exception' ||ad_ddl.error_buf);
403: -- RAISE FND_API.G_EXC_ERROR;
404:
405: END Pkg_End;
406: