APPS.PAYWSDYG_PKG dependencies on AD_DDL

Line 400: -- | is created under. Needed for the ad_ddl calls. |

396: -- +---------------------------------------------------------------------------+
397: -- | NAME : get_applsys_user |
398: -- | SCOPE : PRIVATE |
399: -- | DESCRIPTION: Determine the Oracle username that the applsys (FND) user |
400: -- | is created under. Needed for the ad_ddl calls. |
401: -- | PARAMETERS : None |
402: -- | RETURNS : The Oracle user name |
403: -- | RAISES : NO_DATA_FOUND - If we can't work out who the FND user is |
404: -- +---------------------------------------------------------------------------+

Line 439: -- | needed for calls to ad_ddl |

435: -- +---------------------------------------------------------------------------+
436: -- | NAME : get_table_product |
437: -- | SCOPE : PRIVATE |
438: -- | DESCRIPTION: Get the product that a table belongs to (PAY, PER, etc) |
439: -- | needed for calls to ad_ddl |
440: -- | PARAMETERS : p_table - The name of the table to find |
441: -- | RETURNS : The product (application) short name |
442: -- | RAISES : NO_DATA_FOUND - If the table isn't listed as belonging to |
443: -- | any particular application |

Line 577: ad_ddl.do_ddl(

573: -- +---------------------------------------------------------------------------+
574: PROCEDURE drop_trigger(p_name IN VARCHAR2) IS
575: BEGIN
576: IF trigger_exists(p_name) THEN
577: ad_ddl.do_ddl(
578: get_applsys_user,
579: get_table_product(get_table_from_trigger(p_name)),
580: ad_ddl.drop_trigger,
581: 'DROP TRIGGER '||p_name,

Line 580: ad_ddl.drop_trigger,

576: IF trigger_exists(p_name) THEN
577: ad_ddl.do_ddl(
578: get_applsys_user,
579: get_table_product(get_table_from_trigger(p_name)),
580: ad_ddl.drop_trigger,
581: 'DROP TRIGGER '||p_name,
582: p_name
583: );
584: END IF;

Line 632: ad_ddl.do_ddl(

628: ELSIF p_action = 'D' THEN
629: l_mode := 'DELETE';
630: END IF;
631: --
632: ad_ddl.do_ddl(
633: get_applsys_user,
634: get_table_product(p_table),
635: ad_ddl.create_trigger,
636: 'CREATE OR REPLACE TRIGGER '||p_trigger||' '||

Line 635: ad_ddl.create_trigger,

631: --
632: ad_ddl.do_ddl(
633: get_applsys_user,
634: get_table_product(p_table),
635: ad_ddl.create_trigger,
636: 'CREATE OR REPLACE TRIGGER '||p_trigger||' '||
637: 'AFTER '||l_mode||' '||
638: 'ON '||p_table||' FOR EACH ROW '||
639: p_sql,

Line 669: ad_ddl.do_ddl(

665: END IF;
666: --
667: -- Use AOL calls to do the DDL 'properly' (although I don't see how you
668: -- could do this 'improperly' :-)
669: ad_ddl.do_ddl(
670: get_applsys_user,
671: get_table_product(get_table_from_trigger(p_trigger)),
672: ad_ddl.alter_trigger,
673: 'ALTER TRIGGER '||p_trigger||' '||l_mode,

Line 672: ad_ddl.alter_trigger,

668: -- could do this 'improperly' :-)
669: ad_ddl.do_ddl(
670: get_applsys_user,
671: get_table_product(get_table_from_trigger(p_trigger)),
672: ad_ddl.alter_trigger,
673: 'ALTER TRIGGER '||p_trigger||' '||l_mode,
674: p_trigger
675: );
676: END IF;

Line 1284: ad_ddl.do_ddl(

1280: PROCEDURE drop_package(p_table IN VARCHAR2,p_name IN VARCHAR2) IS
1281: BEGIN
1282: --
1283: -- Use the AOL DLL routine
1284: ad_ddl.do_ddl(
1285: get_applsys_user,
1286: get_table_product(p_table),
1287: ad_ddl.drop_package,
1288: 'DROP PACKAGE '||p_name,

Line 1287: ad_ddl.drop_package,

1283: -- Use the AOL DLL routine
1284: ad_ddl.do_ddl(
1285: get_applsys_user,
1286: get_table_product(p_table),
1287: ad_ddl.drop_package,
1288: 'DROP PACKAGE '||p_name,
1289: p_name
1290: );
1291: EXCEPTION

Line 1407: ad_ddl.build_package(l_line,l_num);

1403: l_offs := LENGTH(p_sql) + 1;
1404: END IF;
1405: --
1406: -- Shove the line we found into the PL/SQL table
1407: ad_ddl.build_package(l_line,l_num);
1408: l_num := l_num + 1;
1409: --
1410: -- Bail when we're past the end of the string
1411: EXIT WHEN l_offs > LENGTH(p_sql);

Line 1415: ad_ddl.create_package(

1411: EXIT WHEN l_offs > LENGTH(p_sql);
1412: END LOOP;
1413: --
1414: -- Call the AOL routine to create the package in the 'right' way
1415: ad_ddl.create_package(
1416: l_user,
1417: l_prod,
1418: UPPER(p_name),
1419: p_body,