eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_CA_VAL_DAI dependencies on IGS_CA_DA_INST_V

Line 41: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

37: p_message_name OUT NOCOPY VARCHAR2 )
38: RETURN boolean AS
39: v_other_detail VARCHAR2(255);
40: v_dt_alias_inst_found BOOLEAN;
41: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
42: CURSOR c_dt_alias_instance_1(cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
43: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
44: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
45: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE)

Line 42: CURSOR c_dt_alias_instance_1(cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,

38: RETURN boolean AS
39: v_other_detail VARCHAR2(255);
40: v_dt_alias_inst_found BOOLEAN;
41: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
42: CURSOR c_dt_alias_instance_1(cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
43: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
44: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
45: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE)
46: IS

Line 43: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,

39: v_other_detail VARCHAR2(255);
40: v_dt_alias_inst_found BOOLEAN;
41: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
42: CURSOR c_dt_alias_instance_1(cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
43: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
44: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
45: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE)
46: IS
47: SELECT *

Line 44: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

40: v_dt_alias_inst_found BOOLEAN;
41: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
42: CURSOR c_dt_alias_instance_1(cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
43: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
44: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
45: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE)
46: IS
47: SELECT *
48: FROM IGS_CA_DA_INST_V

Line 45: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE)

41: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
42: CURSOR c_dt_alias_instance_1(cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
43: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
44: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
45: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE)
46: IS
47: SELECT *
48: FROM IGS_CA_DA_INST_V
49: WHERE dt_alias = cp_dt_alias

Line 48: FROM IGS_CA_DA_INST_V

44: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
45: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE)
46: IS
47: SELECT *
48: FROM IGS_CA_DA_INST_V
49: WHERE dt_alias = cp_dt_alias
50: AND sequence_number = cp_sequence_number
51: AND cal_type = cp_cal_type
52: AND ci_sequence_number = cp_ci_sequence_number;

Line 53: CURSOR c_dt_alias_instance_2(cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,

49: WHERE dt_alias = cp_dt_alias
50: AND sequence_number = cp_sequence_number
51: AND cal_type = cp_cal_type
52: AND ci_sequence_number = cp_ci_sequence_number;
53: CURSOR c_dt_alias_instance_2(cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
54: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
55: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
56: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
57: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE)

Line 54: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,

50: AND sequence_number = cp_sequence_number
51: AND cal_type = cp_cal_type
52: AND ci_sequence_number = cp_ci_sequence_number;
53: CURSOR c_dt_alias_instance_2(cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
54: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
55: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
56: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
57: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE)
58: IS

Line 55: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

51: AND cal_type = cp_cal_type
52: AND ci_sequence_number = cp_ci_sequence_number;
53: CURSOR c_dt_alias_instance_2(cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
54: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
55: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
56: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
57: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE)
58: IS
59: SELECT *

Line 56: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

52: AND ci_sequence_number = cp_ci_sequence_number;
53: CURSOR c_dt_alias_instance_2(cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
54: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
55: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
56: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
57: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE)
58: IS
59: SELECT *
60: FROM IGS_CA_DA_INST_V

Line 57: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE)

53: CURSOR c_dt_alias_instance_2(cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
54: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
55: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
56: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
57: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE)
58: IS
59: SELECT *
60: FROM IGS_CA_DA_INST_V
61: WHERE dt_alias = cp_dt_alias

Line 60: FROM IGS_CA_DA_INST_V

56: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
57: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE)
58: IS
59: SELECT *
60: FROM IGS_CA_DA_INST_V
61: WHERE dt_alias = cp_dt_alias
62: AND sequence_number <> cp_sequence_number
63: AND cal_type = cp_cal_type
64: AND ci_sequence_number = cp_ci_sequence_number