725: order by column_name;
726: --
727: begin
728: --
729: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
730: --
731: /* Set up the trigger */
732: pay_dyn_triggers.create_trigger_event(
733: p_table_name||'_ARU',
1087: /* OK put trace on */
1088: hr_utility.trace_on(null, p_table_name);
1089: --
1090: if (p_owner is null) then
1091: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
1092: l_owner := g_pay_schema;
1093: else
1094: if paywsdyg_pkg.is_table_owner_valid(p_table_name,p_owner) = 'N' then
1095: hr_utility.trace('-- WARNING: owner '||p_owner||' is not valid for table '||p_table_name);
1090: if (p_owner is null) then
1091: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
1092: l_owner := g_pay_schema;
1093: else
1094: if paywsdyg_pkg.is_table_owner_valid(p_table_name,p_owner) = 'N' then
1095: hr_utility.trace('-- WARNING: owner '||p_owner||' is not valid for table '||p_table_name);
1096: end if;
1097: l_owner := p_owner;
1098: end if;
1547: begin
1548: /* OK put trace on */
1549: hr_utility.trace_on(null, p_table_name);
1550: --
1551: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
1552: --
1553: proc := ' pay_dyn_triggers.create_trigger_event(
1554: '''||p_table_name||'_ARU'',
1555: '''||p_table_name||''',
1937: END GENERATE_DYT_PKG_BEHAVIOUR;
1938:
1939: /*
1940: Revert back away from the dyt_pkg behaviour. Intended as development util only.
1941: Obsoleted please see paywsdyg_pkg.convert_tab_style
1942: */
1943: PROCEDURE DROP_DYT_PKG_BEHAVIOUR(p_table_name in varchar2) IS
1944:
1945: BEGIN