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

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;

Line 2403: l_term_cal_type IGS_CA_DA_INST.cal_type%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;
2404: l_term_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
2405: l_end_dt IGS_CA_INST.end_dt%TYPE;
2406: v_del BOOLEAN;
2407: v_person_num HZ_PARTIES.party_number%TYPE;

Line 2404: l_term_sequence_number IGS_CA_DA_INST.sequence_number%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;
2404: l_term_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
2405: l_end_dt IGS_CA_INST.end_dt%TYPE;
2406: v_del BOOLEAN;
2407: v_person_num HZ_PARTIES.party_number%TYPE;
2408: l_acad_cal_seq_num IGS_CA_DA_INST.sequence_number%TYPE;

Line 2408: l_acad_cal_seq_num IGS_CA_DA_INST.sequence_number%TYPE;

2404: l_term_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
2405: l_end_dt IGS_CA_INST.end_dt%TYPE;
2406: v_del BOOLEAN;
2407: v_person_num HZ_PARTIES.party_number%TYPE;
2408: l_acad_cal_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
2409: l_acad_cal_type IGS_CA_DA_INST.cal_type%TYPE;
2410: l_message_name VARCHAR2(30);
2411: l_show_warning VARCHAR2(1);
2412: l_rec_exists BOOLEAN;

Line 2409: l_acad_cal_type IGS_CA_DA_INST.cal_type%TYPE;

2405: l_end_dt IGS_CA_INST.end_dt%TYPE;
2406: v_del BOOLEAN;
2407: v_person_num HZ_PARTIES.party_number%TYPE;
2408: l_acad_cal_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
2409: l_acad_cal_type IGS_CA_DA_INST.cal_type%TYPE;
2410: l_message_name VARCHAR2(30);
2411: l_show_warning VARCHAR2(1);
2412: l_rec_exists BOOLEAN;
2413: l_tran_across_careers BOOLEAN;