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.

[Home] [Help]

APPS.IGS_CA_VAL_DAI dependencies on IGS_CA_DA

Line 31: -- To validate the insert of a IGS_CA_DA_INST record

27: END IF;
28:
29: END calp_val_holiday_cat;
30: --
31: -- To validate the insert of a IGS_CA_DA_INST record
32: FUNCTION calp_val_dai_upd(
33: p_dt_alias IN VARCHAR2 ,
34: p_sequence_number IN NUMBER ,
35: p_cal_type IN VARCHAR2 ,

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

Line 103: -- Validate the dt_alias of the IGS_CA_DA_INST

99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END calp_val_dai_upd;
102: --
103: -- Validate the dt_alias of the IGS_CA_DA_INST
104: FUNCTION CALP_VAL_DAI_DA(
105: p_dt_alias IN VARCHAR2 ,
106: p_cal_type IN VARCHAR2 ,
107: p_message_name OUT NOCOPY VARCHAR2 )

Line 113: FROM IGS_CA_DA

109: CURSOR c_dt_alias
110: IS
111: SELECT closed_ind,
112: s_cal_cat
113: FROM IGS_CA_DA
114: WHERE dt_alias = p_dt_alias;
115: CURSOR c_cal_type
116: IS
117: SELECT s_cal_cat

Line 121: v_dt_alias_s_cal_cat IGS_CA_DA.S_CAL_CAT%TYPE;

117: SELECT s_cal_cat
118: FROM IGS_CA_TYPE
119: WHERE cal_type = p_cal_type;
120: v_dt_alias_closed_ind VARCHAR2(1);
121: v_dt_alias_s_cal_cat IGS_CA_DA.S_CAL_CAT%TYPE;
122: v_cal_type_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE;
123: v_other_detail VARCHAR2(255);
124: BEGIN
125: OPEN c_dt_alias;