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.IGF_AW_LI_IMPORT dependencies on IGS_CA_INST

Line 107: CURSOR cur_legacy_award_int(p_alternate_code igs_ca_inst.alternate_code%TYPE,

103:
104:
105: -- cursor to fetch records from the award legacy interface tables
106:
107: CURSOR cur_legacy_award_int(p_alternate_code igs_ca_inst.alternate_code%TYPE,
108: p_batch_num igf_aw_li_awd_ints.batch_num%TYPE) IS
109: SELECT
110: awdint.batch_num,
111: trim(awdint.ci_alternate_code) ci_alternate_code,

Line 1780: l_var_cal_type igs_ca_inst.cal_type%TYPE;

1776: cur_legacy_disb_total_fws_rec cur_legacy_disb_fws_total%ROWTYPE;
1777:
1778: l_ctr PLS_INTEGER;
1779: l_ret_val BOOLEAN;
1780: l_var_cal_type igs_ca_inst.cal_type%TYPE;
1781: l_var_seq_number igs_ca_inst.sequence_number%TYPE;
1782: l_return_status_dh VARCHAR2(1);
1783: l_return_status_da VARCHAR2(1);
1784: l_disb_rec_ins_status VARCHAR2(1);

Line 1781: l_var_seq_number igs_ca_inst.sequence_number%TYPE;

1777:
1778: l_ctr PLS_INTEGER;
1779: l_ret_val BOOLEAN;
1780: l_var_cal_type igs_ca_inst.cal_type%TYPE;
1781: l_var_seq_number igs_ca_inst.sequence_number%TYPE;
1782: l_return_status_dh VARCHAR2(1);
1783: l_return_status_da VARCHAR2(1);
1784: l_disb_rec_ins_status VARCHAR2(1);
1785: l_net_amount igf_aw_awd_disb_all.disb_net_amt%TYPE;

Line 1809: CURSOR c_get_cal_typ_seq_num(p_alternate_code igs_ca_inst.alternate_code%TYPE) IS

1805: --rasahoo 25/Aug/2003 #3101894 Called procedure send_work_auth with parameter 'LEGACY'
1806: ***************************************************************/
1807: l_rowid VARCHAR2(25);
1808:
1809: CURSOR c_get_cal_typ_seq_num(p_alternate_code igs_ca_inst.alternate_code%TYPE) IS
1810: SELECT cal_type, sequence_number
1811: FROM igs_ca_inst
1812: WHERE alternate_code = p_alternate_code;
1813:

Line 1811: FROM igs_ca_inst

1807: l_rowid VARCHAR2(25);
1808:
1809: CURSOR c_get_cal_typ_seq_num(p_alternate_code igs_ca_inst.alternate_code%TYPE) IS
1810: SELECT cal_type, sequence_number
1811: FROM igs_ca_inst
1812: WHERE alternate_code = p_alternate_code;
1813:
1814: CURSOR cur_awd_disb( cp_row_id ROWID) IS
1815: SELECT rowid row_id, disb.*

Line 1830: l_cal_type igs_ca_inst_all.cal_type%TYPE;

1826: c_tp_calseq_rec c_get_cal_typ_seq_num%ROWTYPE;
1827: c_ld_calseq_rec c_get_cal_typ_seq_num%ROWTYPE;
1828: l_warning VARCHAR2(200);
1829: l_trans_type VARCHAR2(1);
1830: l_cal_type igs_ca_inst_all.cal_type%TYPE;
1831: ln_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1832: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
1833: l_hol_rel_ind VARCHAR2(30) := NULL;
1834:

Line 1831: ln_sequence_number igs_ca_inst_all.sequence_number%TYPE;

1827: c_ld_calseq_rec c_get_cal_typ_seq_num%ROWTYPE;
1828: l_warning VARCHAR2(200);
1829: l_trans_type VARCHAR2(1);
1830: l_cal_type igs_ca_inst_all.cal_type%TYPE;
1831: ln_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1832: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
1833: l_hol_rel_ind VARCHAR2(30) := NULL;
1834:
1835:

Line 2566: CURSOR c_get_cal_typ_seq_num(p_alternate_code igs_ca_inst.alternate_code%TYPE) IS

2562: cur_sf_credit_num_rec cur_sf_credit_num%ROWTYPE;
2563: l_trans_credit_id igs_fi_credits_all.credit_id%TYPE;
2564: l_trans_spnsr_credit_id igs_fi_credits_all.credit_id%TYPE;
2565:
2566: CURSOR c_get_cal_typ_seq_num(p_alternate_code igs_ca_inst.alternate_code%TYPE) IS
2567: SELECT cal_type, sequence_number
2568: FROM igs_ca_inst
2569: WHERE alternate_code = p_alternate_code;
2570:

Line 2568: FROM igs_ca_inst

2564: l_trans_spnsr_credit_id igs_fi_credits_all.credit_id%TYPE;
2565:
2566: CURSOR c_get_cal_typ_seq_num(p_alternate_code igs_ca_inst.alternate_code%TYPE) IS
2567: SELECT cal_type, sequence_number
2568: FROM igs_ca_inst
2569: WHERE alternate_code = p_alternate_code;
2570:
2571: r_get_cal_typ_seq_num c_get_cal_typ_seq_num%ROWTYPE;
2572:

Line 3246: l_cal_type igs_ca_inst.cal_type%TYPE;

3242: Change History :
3243: Who When What
3244: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
3245: ***************************************************************/
3246: l_cal_type igs_ca_inst.cal_type%TYPE;
3247: l_seq_number igs_ca_inst.sequence_number%TYPE;
3248:
3249: l_var_cal_type igs_ca_inst.cal_type%TYPE;
3250: l_var_seq_number igs_ca_inst.sequence_number%TYPE;

Line 3247: l_seq_number igs_ca_inst.sequence_number%TYPE;

3243: Who When What
3244: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
3245: ***************************************************************/
3246: l_cal_type igs_ca_inst.cal_type%TYPE;
3247: l_seq_number igs_ca_inst.sequence_number%TYPE;
3248:
3249: l_var_cal_type igs_ca_inst.cal_type%TYPE;
3250: l_var_seq_number igs_ca_inst.sequence_number%TYPE;
3251: l_ret_value BOOLEAN;

Line 3249: l_var_cal_type igs_ca_inst.cal_type%TYPE;

3245: ***************************************************************/
3246: l_cal_type igs_ca_inst.cal_type%TYPE;
3247: l_seq_number igs_ca_inst.sequence_number%TYPE;
3248:
3249: l_var_cal_type igs_ca_inst.cal_type%TYPE;
3250: l_var_seq_number igs_ca_inst.sequence_number%TYPE;
3251: l_ret_value BOOLEAN;
3252:
3253: l_success_records PLS_INTEGER;

Line 3250: l_var_seq_number igs_ca_inst.sequence_number%TYPE;

3246: l_cal_type igs_ca_inst.cal_type%TYPE;
3247: l_seq_number igs_ca_inst.sequence_number%TYPE;
3248:
3249: l_var_cal_type igs_ca_inst.cal_type%TYPE;
3250: l_var_seq_number igs_ca_inst.sequence_number%TYPE;
3251: l_ret_value BOOLEAN;
3252:
3253: l_success_records PLS_INTEGER;
3254: l_warning_records PLS_INTEGER;

Line 3262: CURSOR cur_alt_code ( x_ci_cal_type igs_ca_inst.cal_type%TYPE,

3258: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
3259:
3260:
3261: -- cursor to get the calendar alternate code
3262: CURSOR cur_alt_code ( x_ci_cal_type igs_ca_inst.cal_type%TYPE,
3263: x_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
3264: SELECT cal.alternate_code
3265: FROM igs_ca_inst cal
3266: WHERE cal.cal_type = x_ci_cal_type

Line 3263: x_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS

3259:
3260:
3261: -- cursor to get the calendar alternate code
3262: CURSOR cur_alt_code ( x_ci_cal_type igs_ca_inst.cal_type%TYPE,
3263: x_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
3264: SELECT cal.alternate_code
3265: FROM igs_ca_inst cal
3266: WHERE cal.cal_type = x_ci_cal_type
3267: AND cal.sequence_number = x_ci_sequence_number;

Line 3265: FROM igs_ca_inst cal

3261: -- cursor to get the calendar alternate code
3262: CURSOR cur_alt_code ( x_ci_cal_type igs_ca_inst.cal_type%TYPE,
3263: x_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
3264: SELECT cal.alternate_code
3265: FROM igs_ca_inst cal
3266: WHERE cal.cal_type = x_ci_cal_type
3267: AND cal.sequence_number = x_ci_sequence_number;
3268: l_alternate_code igs_ca_inst.alternate_code%TYPE;
3269:

Line 3268: l_alternate_code igs_ca_inst.alternate_code%TYPE;

3264: SELECT cal.alternate_code
3265: FROM igs_ca_inst cal
3266: WHERE cal.cal_type = x_ci_cal_type
3267: AND cal.sequence_number = x_ci_sequence_number;
3268: l_alternate_code igs_ca_inst.alternate_code%TYPE;
3269:
3270: -- cursor to verify if the cal_type and seq_number are present in the system award year
3271: CURSOR cur_in_award_year_form(x_ci_cal_type igs_ca_inst.cal_type%TYPE,
3272: x_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS

Line 3271: CURSOR cur_in_award_year_form(x_ci_cal_type igs_ca_inst.cal_type%TYPE,

3267: AND cal.sequence_number = x_ci_sequence_number;
3268: l_alternate_code igs_ca_inst.alternate_code%TYPE;
3269:
3270: -- cursor to verify if the cal_type and seq_number are present in the system award year
3271: CURSOR cur_in_award_year_form(x_ci_cal_type igs_ca_inst.cal_type%TYPE,
3272: x_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
3273: SELECT award_year_status_code, sys_award_year
3274: FROM igf_ap_batch_aw_map
3275: WHERE ci_cal_type = x_ci_cal_type

Line 3272: x_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS

3268: l_alternate_code igs_ca_inst.alternate_code%TYPE;
3269:
3270: -- cursor to verify if the cal_type and seq_number are present in the system award year
3271: CURSOR cur_in_award_year_form(x_ci_cal_type igs_ca_inst.cal_type%TYPE,
3272: x_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
3273: SELECT award_year_status_code, sys_award_year
3274: FROM igf_ap_batch_aw_map
3275: WHERE ci_cal_type = x_ci_cal_type
3276: AND ci_sequence_number = x_ci_sequence_number;

Line 3576: p_cal_type igs_ca_inst.cal_type%TYPE,

3572: -------------------------------------------------------------------------------------------------------
3573: -- Generic Functions
3574: -------------------------------------------------------------------------------------------------------
3575: FUNCTION get_base_id_from_per_num (p_person_number hz_parties.party_number%TYPE,
3576: p_cal_type igs_ca_inst.cal_type%TYPE,
3577: p_sequence_number igs_ca_inst.sequence_number%TYPE
3578: ) RETURN NUMBER IS
3579: CURSOR cur_base_id IS
3580: SELECT base.base_id

Line 3577: p_sequence_number igs_ca_inst.sequence_number%TYPE

3573: -- Generic Functions
3574: -------------------------------------------------------------------------------------------------------
3575: FUNCTION get_base_id_from_per_num (p_person_number hz_parties.party_number%TYPE,
3576: p_cal_type igs_ca_inst.cal_type%TYPE,
3577: p_sequence_number igs_ca_inst.sequence_number%TYPE
3578: ) RETURN NUMBER IS
3579: CURSOR cur_base_id IS
3580: SELECT base.base_id
3581: FROM igf_ap_fa_base_rec_all base,