[Home] [Help]
2447: p_sql := p_sql||' l_mode := pay_dyn_triggers.g_dyt_mode;'||g_eol;
2448: p_sql := p_sql||' pay_dyn_triggers.g_dyt_mode := pay_dyn_triggers.g_dbms_dyt;'||g_eol;
2449:
2450: -- Add the data migrator check - Bug 1885557
2451: p_sql := p_sql||'IF NOT (hr_general.g_data_migrator_mode <> ''Y'') THEN'||g_eol;
2452: p_sql := p_sql||' RETURN;'||g_eol;
2453: p_sql := p_sql||'END IF;'||g_eol;
2454: --
2455: -- Add the initialisation and component PL/SQL code
2742: ,p_tab_name IN VARCHAR2
2743: ,p_params IN OUT NOCOPY g_params_tab_type) IS
2744:
2745: -- Local variables to catch the values returned from
2746: -- hr_general.describe_procedure
2747: --
2748: l_overload dbms_describe.number_table;
2749: l_position dbms_describe.number_table;
2750: l_level dbms_describe.number_table;
2801: -- value_name - 'P_old_column_name'
2802: << HOOK_MODULES >>
2803: FOR hook_rec in csr_hooks(p_tab_name) LOOP
2804:
2805: hr_general.describe_procedure
2806: (object_name => hook_rec.pkg || '.' || hook_rec.proc
2807: ,reserved1 => null
2808: ,reserved2 => null
2809: ,overload => l_overload
3471:
3472:
3473: --
3474: -- Add the data migrator check - Bug 1885557
3475: p_bs := p_bs||'IF NOT (hr_general.g_data_migrator_mode <> ''Y'') THEN'||g_eol;
3476: p_bs := p_bs||' RETURN;'||g_eol;
3477: p_bs := p_bs||'END IF;'||g_eol;
3478: -- Add the initialisation and component PL/SQL code
3479: l_inits := add_initialisations(l_dyt_id,p_bs,l_tab_name);
3712: --
3713: l_sql := l_sql||' l_mode := pay_dyn_triggers.g_dyt_mode;'||g_eol;
3714: l_sql := l_sql||' pay_dyn_triggers.g_dyt_mode := pay_dyn_triggers.g_dbms_dyt;'||g_eol;
3715:
3716: l_sql := l_sql||' IF NOT (hr_general.g_data_migrator_mode <> ''Y'') THEN'||g_eol;
3717: l_sql := l_sql||' RETURN;'||g_eol;
3718: l_sql := l_sql||' END IF;'||g_eos;
3719:
3720: -- Code call to newly created procedure