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_DAIO dependencies on IGS_CA_DA_INST

Line 10: -- Validate insert of IGS_CA_DA_INST_OFST

6: --avenkatr 29-AUG-2001 Bug Id : 1956374. Removed procedure "calp_val_holidat_cat"
7: -------------------------------------------------------------------------------------------
8:
9: --
10: -- Validate insert of IGS_CA_DA_INST_OFST
11: FUNCTION CALP_VAL_DAIO_INS(
12: p_dt_alias IN VARCHAR2 ,
13: p_dai_sequence_number IN NUMBER ,
14: p_cal_type IN VARCHAR2 ,

Line 29: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,

25: v_alias_value DATE;
26: v_dt_alias_status IGS_CA_STAT.s_cal_status%TYPE;
27: v_offset_dt_alias_status IGS_CA_STAT.s_cal_status%TYPE;
28: CURSOR c_dt_alias_instance_offset (
29: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
30: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
31: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
32: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
33: IS

Line 30: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,

26: v_dt_alias_status IGS_CA_STAT.s_cal_status%TYPE;
27: v_offset_dt_alias_status IGS_CA_STAT.s_cal_status%TYPE;
28: CURSOR c_dt_alias_instance_offset (
29: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
30: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
31: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
32: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
33: IS
34: SELECT *

Line 31: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,

27: v_offset_dt_alias_status IGS_CA_STAT.s_cal_status%TYPE;
28: CURSOR c_dt_alias_instance_offset (
29: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
30: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
31: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
32: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
33: IS
34: SELECT *
35: FROM IGS_CA_DA_INST_OFST

Line 32: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)

28: CURSOR c_dt_alias_instance_offset (
29: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
30: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
31: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
32: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
33: IS
34: SELECT *
35: FROM IGS_CA_DA_INST_OFST
36: WHERE dt_alias = cp_dt_alias

Line 35: FROM IGS_CA_DA_INST_OFST

31: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
32: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
33: IS
34: SELECT *
35: FROM IGS_CA_DA_INST_OFST
36: WHERE dt_alias = cp_dt_alias
37: AND dai_sequence_number = cp_dai_sequence_number
38: AND cal_type = cp_cal_type
39: AND ci_sequence_number = cp_ci_sequence_number

Line 57: p_org_dt_alias_inst_ofst IGS_CA_DA_INST_OFST.dt_alias%TYPE,

53: SELECT *
54: FROM IGS_CA_STAT
55: WHERE cal_status = cp_cal_status;
56: FUNCTION find_daio(
57: p_org_dt_alias_inst_ofst IGS_CA_DA_INST_OFST.dt_alias%TYPE,
58: p_org_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
59: p_org_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
60: p_org_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE,
61: p_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,

Line 58: p_org_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,

54: FROM IGS_CA_STAT
55: WHERE cal_status = cp_cal_status;
56: FUNCTION find_daio(
57: p_org_dt_alias_inst_ofst IGS_CA_DA_INST_OFST.dt_alias%TYPE,
58: p_org_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
59: p_org_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
60: p_org_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE,
61: p_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
62: p_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,

Line 59: p_org_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,

55: WHERE cal_status = cp_cal_status;
56: FUNCTION find_daio(
57: p_org_dt_alias_inst_ofst IGS_CA_DA_INST_OFST.dt_alias%TYPE,
58: p_org_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
59: p_org_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
60: p_org_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE,
61: p_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
62: p_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
63: p_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,

Line 60: p_org_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE,

56: FUNCTION find_daio(
57: p_org_dt_alias_inst_ofst IGS_CA_DA_INST_OFST.dt_alias%TYPE,
58: p_org_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
59: p_org_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
60: p_org_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE,
61: p_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
62: p_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
63: p_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
64: p_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)

Line 61: p_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,

57: p_org_dt_alias_inst_ofst IGS_CA_DA_INST_OFST.dt_alias%TYPE,
58: p_org_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
59: p_org_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
60: p_org_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE,
61: p_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
62: p_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
63: p_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
64: p_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
65: RETURN BOOLEAN AS

Line 62: p_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,

58: p_org_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
59: p_org_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
60: p_org_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE,
61: p_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
62: p_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
63: p_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
64: p_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
65: RETURN BOOLEAN AS
66: v_dt_alias_instance_offset_rec IGS_CA_DA_INST_OFST%ROWTYPE;

Line 63: p_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,

59: p_org_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
60: p_org_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE,
61: p_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
62: p_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
63: p_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
64: p_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
65: RETURN BOOLEAN AS
66: v_dt_alias_instance_offset_rec IGS_CA_DA_INST_OFST%ROWTYPE;
67: CURSOR c_dt_alias_instance_offset (

Line 64: p_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)

60: p_org_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE,
61: p_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
62: p_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
63: p_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
64: p_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
65: RETURN BOOLEAN AS
66: v_dt_alias_instance_offset_rec IGS_CA_DA_INST_OFST%ROWTYPE;
67: CURSOR c_dt_alias_instance_offset (
68: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,

Line 66: v_dt_alias_instance_offset_rec IGS_CA_DA_INST_OFST%ROWTYPE;

62: p_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
63: p_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
64: p_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
65: RETURN BOOLEAN AS
66: v_dt_alias_instance_offset_rec IGS_CA_DA_INST_OFST%ROWTYPE;
67: CURSOR c_dt_alias_instance_offset (
68: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
69: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
70: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,

Line 68: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,

64: p_ci_seq_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
65: RETURN BOOLEAN AS
66: v_dt_alias_instance_offset_rec IGS_CA_DA_INST_OFST%ROWTYPE;
67: CURSOR c_dt_alias_instance_offset (
68: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
69: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
70: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
71: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
72: IS

Line 69: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,

65: RETURN BOOLEAN AS
66: v_dt_alias_instance_offset_rec IGS_CA_DA_INST_OFST%ROWTYPE;
67: CURSOR c_dt_alias_instance_offset (
68: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
69: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
70: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
71: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
72: IS
73: SELECT *

Line 70: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,

66: v_dt_alias_instance_offset_rec IGS_CA_DA_INST_OFST%ROWTYPE;
67: CURSOR c_dt_alias_instance_offset (
68: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
69: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
70: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
71: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
72: IS
73: SELECT *
74: FROM IGS_CA_DA_INST_OFST

Line 71: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)

67: CURSOR c_dt_alias_instance_offset (
68: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
69: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
70: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
71: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
72: IS
73: SELECT *
74: FROM IGS_CA_DA_INST_OFST
75: WHERE dt_alias = cp_dt_alias

Line 74: FROM IGS_CA_DA_INST_OFST

70: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,
71: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE)
72: IS
73: SELECT *
74: FROM IGS_CA_DA_INST_OFST
75: WHERE dt_alias = cp_dt_alias
76: AND dai_sequence_number = cp_dai_sequence_number
77: AND cal_type = cp_cal_type
78: AND ci_sequence_number = cp_ci_sequence_number;

Line 187: -- Validate if a IGS_CA_DA_INST_OFST can be deleted.

183: IGS_GE_MSG_STACK.ADD;
184: App_Exception.Raise_Exception;
185: END calp_val_daio_ins;
186: --
187: -- Validate if a IGS_CA_DA_INST_OFST can be deleted.
188: FUNCTION CALP_VAL_DAIO_DEL(
189: p_dt_alias IN VARCHAR2 ,
190: p_dai_sequence_number IN NUMBER ,
191: p_cal_type IN VARCHAR2 ,

Line 200: v_dt_alias_instance_rec IGS_CA_DA_INST%ROWTYPE;

196: p_offset_ci_sequence_number IN NUMBER ,
197: p_message_name OUT NOCOPY VARCHAR2 )
198: RETURN boolean AS
199: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
200: v_dt_alias_instance_rec IGS_CA_DA_INST%ROWTYPE;
201: v_other_detail VARCHAR2(255);
202: e_no_dt_alias_instance EXCEPTION;
203: CURSOR c_dt_alias_instance
204: IS

Line 206: FROM IGS_CA_DA_INST

202: e_no_dt_alias_instance EXCEPTION;
203: CURSOR c_dt_alias_instance
204: IS
205: SELECT *
206: FROM IGS_CA_DA_INST
207: WHERE dt_alias = p_dt_alias and
208: sequence_number = p_dai_sequence_number and
209: cal_type = p_cal_type and
210: ci_sequence_number = p_ci_sequence_number;