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_EN_FUTURE_DT_TRANS dependencies on IGS_CA_DA_INST_V

Line 2295: cp_cleanup_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE ) IS

2291:
2292: -- cursor to get the clean up date alias value
2293: CURSOR c_cln_up_dt_alias_val(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2294: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
2295: cp_cleanup_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE ) IS
2296: SELECT alias_val
2297: FROM igs_ca_da_inst_v
2298: WHERE cal_type = cp_term_cal_type
2299: AND ci_sequence_number = cp_term_sequence_number

Line 2297: FROM igs_ca_da_inst_v

2293: CURSOR c_cln_up_dt_alias_val(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2294: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
2295: cp_cleanup_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE ) IS
2296: SELECT alias_val
2297: FROM igs_ca_da_inst_v
2298: WHERE cal_type = cp_term_cal_type
2299: AND ci_sequence_number = cp_term_sequence_number
2300: AND dt_alias = cp_cleanup_dt_alias;
2301:

Line 2305: cp_begin_pt_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS

2301:
2302: -- cursor to get the begin program transfer details
2303: CURSOR c_begin_pt_dt_alias_val(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2304: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
2305: cp_begin_pt_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
2306: SELECT alias_val
2307: FROM igs_ca_da_inst_v
2308: WHERE cal_type = cp_term_cal_type
2309: AND ci_sequence_number = cp_term_sequence_number

Line 2307: FROM igs_ca_da_inst_v

2303: CURSOR c_begin_pt_dt_alias_val(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2304: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
2305: cp_begin_pt_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
2306: SELECT alias_val
2307: FROM igs_ca_da_inst_v
2308: WHERE cal_type = cp_term_cal_type
2309: AND ci_sequence_number = cp_term_sequence_number
2310: AND dt_alias = cp_begin_pt_dt_alias;
2311:

Line 2396: v_begin_pt_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;

2392:
2393:
2394: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
2395: cst_prog_trans CONSTANT VARCHAR2(20) := 'PROGRAM_TRANSFER';
2396: v_begin_pt_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;
2397: v_begin_pt_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
2398: v_cleanup_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;
2399: v_cleanup_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
2400: is_prim_in_prev_term VARCHAR2(1);

Line 2397: v_begin_pt_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

2393:
2394: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
2395: cst_prog_trans CONSTANT VARCHAR2(20) := 'PROGRAM_TRANSFER';
2396: v_begin_pt_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;
2397: v_begin_pt_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
2398: v_cleanup_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;
2399: v_cleanup_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
2400: is_prim_in_prev_term VARCHAR2(1);
2401: v_sca_src_rec c_sca%ROWTYPE;

Line 2398: v_cleanup_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;

2394: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
2395: cst_prog_trans CONSTANT VARCHAR2(20) := 'PROGRAM_TRANSFER';
2396: v_begin_pt_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;
2397: v_begin_pt_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
2398: v_cleanup_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;
2399: v_cleanup_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
2400: is_prim_in_prev_term VARCHAR2(1);
2401: v_sca_src_rec c_sca%ROWTYPE;
2402: v_sca_dest_rec c_sca%ROWTYPE;

Line 2399: v_cleanup_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

2395: cst_prog_trans CONSTANT VARCHAR2(20) := 'PROGRAM_TRANSFER';
2396: v_begin_pt_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;
2397: v_begin_pt_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
2398: v_cleanup_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;
2399: v_cleanup_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
2400: is_prim_in_prev_term VARCHAR2(1);
2401: v_sca_src_rec c_sca%ROWTYPE;
2402: v_sca_dest_rec c_sca%ROWTYPE;
2403: l_term_cal_type IGS_CA_DA_INST.cal_type%TYPE;