DBA Data[Home] [Help]

APPS.IGS_OR_INST_IMP_001 dependencies on IGS_LOOKUPS_VIEW

Line 39: cursor c_error_log(p_err_cd igs_lookups_view.lookup_code%TYPE, cp_lookup_type igs_lookups_view.lookup_type%TYPE) is

35: PROCEDURE log_writer(p_which_rec IN varchar2,
36: p_error_code IN igs_or_inst_int.error_code%TYPE,
37: p_error_text igs_or_inst_int.error_text%TYPE) AS
38:
39: cursor c_error_log(p_err_cd igs_lookups_view.lookup_code%TYPE, cp_lookup_type igs_lookups_view.lookup_type%TYPE) is
40: select rpad(lookup_code,10)||meaning LINEX from igs_lookups_view where lookup_code = p_err_cd
41: and lookup_type = cp_lookup_type;
42:
43: v_error_log c_error_log%ROWTYPE;

Line 40: select rpad(lookup_code,10)||meaning LINEX from igs_lookups_view where lookup_code = p_err_cd

36: p_error_code IN igs_or_inst_int.error_code%TYPE,
37: p_error_text igs_or_inst_int.error_text%TYPE) AS
38:
39: cursor c_error_log(p_err_cd igs_lookups_view.lookup_code%TYPE, cp_lookup_type igs_lookups_view.lookup_type%TYPE) is
40: select rpad(lookup_code,10)||meaning LINEX from igs_lookups_view where lookup_code = p_err_cd
41: and lookup_type = cp_lookup_type;
42:
43: v_error_log c_error_log%ROWTYPE;
44: BEGIN