[Home] [Help]
2477: p_sql := p_sql||' l_mode := pay_dyn_triggers.g_dyt_mode;'||g_eol;
2478: p_sql := p_sql||' pay_dyn_triggers.g_dyt_mode := pay_dyn_triggers.g_dbms_dyt;'||g_eol;
2479:
2480: -- Add the data migrator check - Bug 1885557
2481: p_sql := p_sql||'IF NOT (hr_general.g_data_migrator_mode <> ''Y'') THEN'||g_eol;
2482: p_sql := p_sql||' RETURN;'||g_eol;
2483: p_sql := p_sql||'END IF;'||g_eol;
2484: --
2485: -- Add the initialisation and component PL/SQL code
2779: ,p_tab_name IN VARCHAR2
2780: ,p_params IN OUT NOCOPY g_params_tab_type) IS
2781:
2782: -- Local variables to catch the values returned from
2783: -- hr_general.describe_procedure
2784: --
2785: l_overload dbms_describe.number_table;
2786: l_position dbms_describe.number_table;
2787: l_level dbms_describe.number_table;
2838: -- value_name - 'P_old_column_name'
2839: << HOOK_MODULES >>
2840: FOR hook_rec in csr_hooks(p_tab_name) LOOP
2841:
2842: hr_general.describe_procedure
2843: (object_name => hook_rec.pkg || '.' || hook_rec.proc
2844: ,reserved1 => null
2845: ,reserved2 => null
2846: ,overload => l_overload
3509:
3510:
3511: --
3512: -- Add the data migrator check - Bug 1885557
3513: p_bs := p_bs||'IF NOT (hr_general.g_data_migrator_mode <> ''Y'') THEN'||g_eol;
3514: p_bs := p_bs||' RETURN;'||g_eol;
3515: p_bs := p_bs||'END IF;'||g_eol;
3516: -- Add the initialisation and component PL/SQL code
3517: l_inits := add_initialisations(l_dyt_id,p_bs,l_tab_name);
3750: --
3751: l_sql := l_sql||' l_mode := pay_dyn_triggers.g_dyt_mode;'||g_eol;
3752: l_sql := l_sql||' pay_dyn_triggers.g_dyt_mode := pay_dyn_triggers.g_dbms_dyt;'||g_eol;
3753:
3754: l_sql := l_sql||' IF NOT (hr_general.g_data_migrator_mode <> ''Y'') THEN'||g_eol;
3755: l_sql := l_sql||' RETURN;'||g_eol;
3756: l_sql := l_sql||' END IF;'||g_eos;
3757:
3758: -- Code call to newly created procedure