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

Line 4: p_dt_alias IN IGS_CA_DA_INST.DT_ALIAS%TYPE ,

1: PACKAGE BODY IGS_CA_GEN_001 AS
2: /* $Header: IGSCA01B.pls 115.3 2002/11/28 22:56:08 nsidana ship $ */
3: FUNCTION calp_get_alias_val(
4: p_dt_alias IN IGS_CA_DA_INST.DT_ALIAS%TYPE ,
5: p_sequence_num IGS_CA_DA_INST.sequence_number%TYPE ,
6: p_cal_type IN IGS_CA_DA_INST.CAL_TYPE%TYPE ,
7: p_ci_sequence_num IN IGS_CA_DA_INST.ci_sequence_number%TYPE )
8: RETURN DATE AS

Line 5: p_sequence_num IGS_CA_DA_INST.sequence_number%TYPE ,

1: PACKAGE BODY IGS_CA_GEN_001 AS
2: /* $Header: IGSCA01B.pls 115.3 2002/11/28 22:56:08 nsidana ship $ */
3: FUNCTION calp_get_alias_val(
4: p_dt_alias IN IGS_CA_DA_INST.DT_ALIAS%TYPE ,
5: p_sequence_num IGS_CA_DA_INST.sequence_number%TYPE ,
6: p_cal_type IN IGS_CA_DA_INST.CAL_TYPE%TYPE ,
7: p_ci_sequence_num IN IGS_CA_DA_INST.ci_sequence_number%TYPE )
8: RETURN DATE AS
9: BEGIN

Line 6: p_cal_type IN IGS_CA_DA_INST.CAL_TYPE%TYPE ,

2: /* $Header: IGSCA01B.pls 115.3 2002/11/28 22:56:08 nsidana ship $ */
3: FUNCTION calp_get_alias_val(
4: p_dt_alias IN IGS_CA_DA_INST.DT_ALIAS%TYPE ,
5: p_sequence_num IGS_CA_DA_INST.sequence_number%TYPE ,
6: p_cal_type IN IGS_CA_DA_INST.CAL_TYPE%TYPE ,
7: p_ci_sequence_num IN IGS_CA_DA_INST.ci_sequence_number%TYPE )
8: RETURN DATE AS
9: BEGIN
10: DECLARE

Line 7: p_ci_sequence_num IN IGS_CA_DA_INST.ci_sequence_number%TYPE )

3: FUNCTION calp_get_alias_val(
4: p_dt_alias IN IGS_CA_DA_INST.DT_ALIAS%TYPE ,
5: p_sequence_num IGS_CA_DA_INST.sequence_number%TYPE ,
6: p_cal_type IN IGS_CA_DA_INST.CAL_TYPE%TYPE ,
7: p_ci_sequence_num IN IGS_CA_DA_INST.ci_sequence_number%TYPE )
8: RETURN DATE AS
9: BEGIN
10: DECLARE
11: -- this cursor finds the alias value for a date alias instance

Line 12: CURSOR c_dai ( cp_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE,

8: RETURN DATE AS
9: BEGIN
10: DECLARE
11: -- this cursor finds the alias value for a date alias instance
12: CURSOR c_dai ( cp_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE,
13: cp_sequence_num IGS_CA_DA_INST.sequence_number%TYPE,
14: cp_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE,
15: cp_ci_sequence_num IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
16: SELECT absolute_val

Line 13: cp_sequence_num IGS_CA_DA_INST.sequence_number%TYPE,

9: BEGIN
10: DECLARE
11: -- this cursor finds the alias value for a date alias instance
12: CURSOR c_dai ( cp_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE,
13: cp_sequence_num IGS_CA_DA_INST.sequence_number%TYPE,
14: cp_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE,
15: cp_ci_sequence_num IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
16: SELECT absolute_val
17: FROM IGS_CA_DA_INST

Line 14: cp_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE,

10: DECLARE
11: -- this cursor finds the alias value for a date alias instance
12: CURSOR c_dai ( cp_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE,
13: cp_sequence_num IGS_CA_DA_INST.sequence_number%TYPE,
14: cp_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE,
15: cp_ci_sequence_num IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
16: SELECT absolute_val
17: FROM IGS_CA_DA_INST
18: WHERE DT_ALIAS = cp_dt_alias AND

Line 15: cp_ci_sequence_num IGS_CA_DA_INST.ci_sequence_number%TYPE) IS

11: -- this cursor finds the alias value for a date alias instance
12: CURSOR c_dai ( cp_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE,
13: cp_sequence_num IGS_CA_DA_INST.sequence_number%TYPE,
14: cp_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE,
15: cp_ci_sequence_num IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
16: SELECT absolute_val
17: FROM IGS_CA_DA_INST
18: WHERE DT_ALIAS = cp_dt_alias AND
19: sequence_number = cp_sequence_num AND

Line 17: FROM IGS_CA_DA_INST

13: cp_sequence_num IGS_CA_DA_INST.sequence_number%TYPE,
14: cp_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE,
15: cp_ci_sequence_num IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
16: SELECT absolute_val
17: FROM IGS_CA_DA_INST
18: WHERE DT_ALIAS = cp_dt_alias AND
19: sequence_number = cp_sequence_num AND
20: CAL_TYPE = cp_cal_type AND
21: ci_sequence_number = cp_ci_sequence_num;

Line 22: v_alias_val IGS_CA_DA_INST.absolute_val%TYPE;

18: WHERE DT_ALIAS = cp_dt_alias AND
19: sequence_number = cp_sequence_num AND
20: CAL_TYPE = cp_cal_type AND
21: ci_sequence_number = cp_ci_sequence_num;
22: v_alias_val IGS_CA_DA_INST.absolute_val%TYPE;
23: v_message_name varchar2(30);
24: BEGIN
25: IF p_dt_alias IS NULL OR
26: p_sequence_num IS NULL OR

Line 209: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

205: cst_null CONSTANT VARCHAR2(4) := 'NULL';
206: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
207: v_start_dt IGS_CA_INST.start_dt%TYPE;
208: v_end_dt IGS_CA_INST.end_dt%TYPE;
209: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
210: v_within BOOLEAN;
211: v_before BOOLEAN;
212: v_after BOOLEAN;
213: CURSOR c_sgcc IS

Line 230: FROM IGS_CA_DA_INST_V daiv

226: cp_related_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
227: cp_related_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
228: cp_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE) IS
229: SELECT daiv.alias_val
230: FROM IGS_CA_DA_INST_V daiv
231: WHERE daiv.CAL_TYPE = cp_related_cal_type AND
232: daiv.ci_sequence_number = cp_related_ci_sequence_number AND
233: daiv.DT_ALIAS = cp_census_dt_alias;
234: BEGIN