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_AP_MATCHING_PROCESS_PKG dependencies on IGF_AP_ISIR_MATCHED

Line 42: g_old_active_isir_id igf_ap_isir_matched_all.isir_id%TYPE; -- bbb

38: g_enable_debug_logging VARCHAR2(1);
39: g_upd_ant_val VARCHAR2(1);
40:
41: g_debug_seq NUMBER:=0; --- #R1 Remove after debugging
42: g_old_active_isir_id igf_ap_isir_matched_all.isir_id%TYPE; -- bbb
43:
44: -- pl/sql table def for deleting from match details using BULK operation.
45: TYPE match_details_amd_id IS TABLE OF igf_ap_match_details.amd_id%TYPE;
46: g_amd_id_tab match_details_amd_id;

Line 186: l_mesg_class igf_ap_isir_matched_all.message_class_txt%TYPE;

182: ||
183: || (reverse chronological order - newest change first)
184: */
185:
186: l_mesg_class igf_ap_isir_matched_all.message_class_txt%TYPE;
187: l_dot_in_file_name NUMBER :=0;
188:
189: BEGIN
190: -- Check if data file has a file extn

Line 630: PROCEDURE update_isir_matched_rec(p_isir_matched_record igf_ap_isir_matched%ROWTYPE,

626: igs_ge_msg_stack.add;
627: app_exception.raise_exception;
628: END update_fa_base_rec;
629:
630: PROCEDURE update_isir_matched_rec(p_isir_matched_record igf_ap_isir_matched%ROWTYPE,
631: p_payment_isir igf_ap_isir_matched_all.payment_isir%TYPE,
632: p_active_isir igf_ap_isir_matched_all.active_isir%TYPE )
633: IS
634: /*

Line 631: p_payment_isir igf_ap_isir_matched_all.payment_isir%TYPE,

627: app_exception.raise_exception;
628: END update_fa_base_rec;
629:
630: PROCEDURE update_isir_matched_rec(p_isir_matched_record igf_ap_isir_matched%ROWTYPE,
631: p_payment_isir igf_ap_isir_matched_all.payment_isir%TYPE,
632: p_active_isir igf_ap_isir_matched_all.active_isir%TYPE )
633: IS
634: /*
635: || Created By : rgangara

Line 632: p_active_isir igf_ap_isir_matched_all.active_isir%TYPE )

628: END update_fa_base_rec;
629:
630: PROCEDURE update_isir_matched_rec(p_isir_matched_record igf_ap_isir_matched%ROWTYPE,
631: p_payment_isir igf_ap_isir_matched_all.payment_isir%TYPE,
632: p_active_isir igf_ap_isir_matched_all.active_isir%TYPE )
633: IS
634: /*
635: || Created By : rgangara
636: || Created On : 05-AUG-2004

Line 651: igf_ap_isir_matched_pkg.update_row(

647:
648: log_debug_message(' Beginning Update of ISIR Matched record. ISIR ID : ' || p_isir_matched_record.isir_id);
649: -- call the TBH to update the isir matched record
650:
651: igf_ap_isir_matched_pkg.update_row(
652: x_Mode => 'R',
653: x_rowid => p_isir_matched_record.row_id,
654: x_isir_id => p_isir_matched_record.isir_id,
655: x_base_id => p_isir_matched_record.base_id,

Line 980: FROM igf_ap_isir_matched im

976: PROCEDURE make_old_isir_non_awarding(p_base_id NUMBER) AS
977:
978: CURSOR cur_old_awd_isir(pn_base_id NUMBER) IS
979: SELECT im.*
980: FROM igf_ap_isir_matched im
981: WHERE im.base_id = pn_base_id
982: AND im.active_isir = 'Y';
983:
984: old_awd_isir_rec cur_old_awd_isir%ROWTYPE;

Line 1001: FROM igf_ap_isir_matched im

997: PROCEDURE make_old_isir_non_payment(p_base_id NUMBER) AS
998:
999: CURSOR cur_old_pymt_isir(pn_base_id NUMBER) IS
1000: SELECT im.*
1001: FROM igf_ap_isir_matched im
1002: WHERE im.base_id = pn_base_id
1003: AND im.payment_isir = 'Y';
1004:
1005: old_pymt_isir_rec cur_old_pymt_isir%ROWTYPE;

Line 1020: p_payment_isir igf_ap_isir_matched_all.payment_isir%TYPE,

1016: END;
1017:
1018:
1019: PROCEDURE insert_isir_matched_rec(cp_isir_int_rec igf_ap_isir_ints%ROWTYPE,
1020: p_payment_isir igf_ap_isir_matched_all.payment_isir%TYPE,
1021: p_active_isir igf_ap_isir_matched_all.active_isir%TYPE,
1022: p_base_id NUMBER,
1023: p_out_isir_id OUT NOCOPY NUMBER
1024: ) IS

Line 1021: p_active_isir igf_ap_isir_matched_all.active_isir%TYPE,

1017:
1018:
1019: PROCEDURE insert_isir_matched_rec(cp_isir_int_rec igf_ap_isir_ints%ROWTYPE,
1020: p_payment_isir igf_ap_isir_matched_all.payment_isir%TYPE,
1021: p_active_isir igf_ap_isir_matched_all.active_isir%TYPE,
1022: p_base_id NUMBER,
1023: p_out_isir_id OUT NOCOPY NUMBER
1024: ) IS
1025:

Line 1041: l_mesg_class igf_ap_isir_matched_all.message_class_txt%TYPE;

1037: ||
1038: || (reverse chronological order - newest change first)
1039: */
1040:
1041: l_mesg_class igf_ap_isir_matched_all.message_class_txt%TYPE;
1042: lv_rowid VARCHAR2(30);
1043:
1044: BEGIN
1045: lv_rowid := NULL;

Line 1068: igf_ap_isir_matched_pkg.insert_row(

1064: make_old_isir_non_awarding(p_base_id);
1065: END IF;
1066:
1067: -- Insert old record into ISIR Matched Table
1068: igf_ap_isir_matched_pkg.insert_row(
1069: x_Mode => 'R',
1070: x_rowid => lv_rowid,
1071: x_isir_id => p_out_isir_id, -- value copied to OUT parameter
1072: x_base_id => p_base_id,

Line 1396: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,

1392:
1393:
1394:
1395: PROCEDURE insert_nslds_data_rec(cp_isir_intrface_rec igf_ap_isir_ints%ROWTYPE,
1396: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
1397: p_base_id NUMBER,
1398: p_out_nslds_id OUT NOCOPY NUMBER
1399: )
1400: IS

Line 2443: PROCEDURE update_person_info (pn_isir_id igf_ap_isir_matched.isir_id%TYPE)

2439: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2440: igs_ge_msg_stack.add;
2441: END create_updt_email_address;
2442:
2443: PROCEDURE update_person_info (pn_isir_id igf_ap_isir_matched.isir_id%TYPE)
2444: IS
2445: /*
2446: || Created By : rgangara
2447: || Created On : 17-AUG-2004

Line 2463: CURSOR isir_cur (cp_isir_id igf_ap_isir_matched.isir_id%TYPE) IS

2459: || notification event is NOT raised for this.
2460: || (reverse chronological order - newest change first)
2461: */
2462:
2463: CURSOR isir_cur (cp_isir_id igf_ap_isir_matched.isir_id%TYPE) IS
2464: SELECT ssn_name_change_type,
2465: first_name,
2466: last_name,
2467: current_ssn_txt,

Line 2760: FROM igf_ap_ISIR_matched isir

2756: l_cur_per_rec cur_per_det%ROWTYPE;
2757:
2758: CURSOR get_payment_isir (ln_base_id NUMBER) IS
2759: SELECT isir_id
2760: FROM igf_ap_ISIR_matched isir
2761: WHERE base_id = ln_base_id
2762: AND payment_isir = 'Y' ;
2763:
2764: lv_chk_py_isir_rec get_payment_isir%ROWTYPE;

Line 2768: FROM igf_ap_ISIR_matched isir, igf_ap_isir_corr_all corr

2764: lv_chk_py_isir_rec get_payment_isir%ROWTYPE;
2765:
2766: CURSOR check_correction_items (ln_base_id NUMBER) IS
2767: SELECT 'x'
2768: FROM igf_ap_ISIR_matched isir, igf_ap_isir_corr_all corr
2769: WHERE isir.isir_id = corr.isir_id
2770: AND isir.base_id = ln_base_id;
2771:
2772: lv_chk_corrections check_correction_items%ROWTYPE;

Line 3670: FROM igf_ap_isir_matched_all

3666: */
3667: CURSOR chk_isir_exist (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
3668: IS
3669: SELECT 'x'
3670: FROM igf_ap_isir_matched_all
3671: WHERE base_id = cp_base_id AND
3672: ROWNUM = 1;
3673:
3674: l_chk_isir_exist chk_isir_exist%ROWTYPE;

Line 3684: lv_isir_id igf_ap_isir_matched_all.isir_id%TYPE;

3680:
3681: lv_cur_fabase_rec cur_fabase%ROWTYPE;
3682:
3683: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;
3684: lv_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
3685: lv_nslds_id igf_ap_nslds_data_all.nslds_id%TYPE;
3686: l_pymt_isir_flag igf_ap_isir_matched_all.payment_isir%TYPE;
3687: l_chk_fo_ant_data BOOLEAN;
3688: l_anticip_status VARCHAR2(30);

Line 3686: l_pymt_isir_flag igf_ap_isir_matched_all.payment_isir%TYPE;

3682:
3683: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;
3684: lv_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
3685: lv_nslds_id igf_ap_nslds_data_all.nslds_id%TYPE;
3686: l_pymt_isir_flag igf_ap_isir_matched_all.payment_isir%TYPE;
3687: l_chk_fo_ant_data BOOLEAN;
3688: l_anticip_status VARCHAR2(30);
3689: l_awd_prc_status VARCHAR2(30);
3690:

Line 3889: l_pymt_isir_flag igf_ap_isir_matched_all.payment_isir%TYPE;

3885: lv_person_id igf_ap_person_v.person_id%TYPE ;
3886: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;
3887: lv_isir_id igf_ap_css_profile.cssp_id%TYPE;
3888: lv_nslds_id igf_ap_nslds_data_all.nslds_id%TYPE;
3889: l_pymt_isir_flag igf_ap_isir_matched_all.payment_isir%TYPE;
3890:
3891: BEGIN
3892:
3893:

Line 4704: FROM igf_ap_isir_matched_all

4700:
4701: CURSOR chk_isir_exist (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
4702: IS
4703: SELECT 'x'
4704: FROM igf_ap_isir_matched_all
4705: WHERE base_id = cp_base_id AND
4706: ROWNUM = 1;
4707:
4708: l_chk_isir_exist chk_isir_exist%ROWTYPE;

Line 4907: FROM igf_ap_isir_matched_all

4903: IS
4904:
4905: CURSOR c_get_payment_isir(cp_base_id NUMBER) IS
4906: SELECT isir_id
4907: FROM igf_ap_isir_matched_all
4908: WHERE base_id = cp_base_id
4909: AND payment_isir = 'Y';
4910:
4911: CURSOR c_get_trans_num(cp_base_id NUMBER) IS

Line 4913: FROM igf_ap_isir_matched_all

4909: AND payment_isir = 'Y';
4910:
4911: CURSOR c_get_trans_num(cp_base_id NUMBER) IS
4912: SELECT transaction_num
4913: FROM igf_ap_isir_matched_all
4914: WHERE base_id = cp_base_id
4915: AND system_record_type = 'CORRECTION';
4916:
4917: CURSOR c_get_isir_id(cp_trans_num igf_ap_isir_matched_all.transaction_num%TYPE,

Line 4917: CURSOR c_get_isir_id(cp_trans_num igf_ap_isir_matched_all.transaction_num%TYPE,

4913: FROM igf_ap_isir_matched_all
4914: WHERE base_id = cp_base_id
4915: AND system_record_type = 'CORRECTION';
4916:
4917: CURSOR c_get_isir_id(cp_trans_num igf_ap_isir_matched_all.transaction_num%TYPE,
4918: cp_base_id igf_ap_isir_matched_all.base_id%TYPE) IS
4919: SELECT isir_id
4920: FROM igf_ap_isir_matched_all
4921: WHERE base_id = cp_base_id

Line 4918: cp_base_id igf_ap_isir_matched_all.base_id%TYPE) IS

4914: WHERE base_id = cp_base_id
4915: AND system_record_type = 'CORRECTION';
4916:
4917: CURSOR c_get_isir_id(cp_trans_num igf_ap_isir_matched_all.transaction_num%TYPE,
4918: cp_base_id igf_ap_isir_matched_all.base_id%TYPE) IS
4919: SELECT isir_id
4920: FROM igf_ap_isir_matched_all
4921: WHERE base_id = cp_base_id
4922: AND transaction_num = cp_trans_num

Line 4920: FROM igf_ap_isir_matched_all

4916:
4917: CURSOR c_get_isir_id(cp_trans_num igf_ap_isir_matched_all.transaction_num%TYPE,
4918: cp_base_id igf_ap_isir_matched_all.base_id%TYPE) IS
4919: SELECT isir_id
4920: FROM igf_ap_isir_matched_all
4921: WHERE base_id = cp_base_id
4922: AND transaction_num = cp_trans_num
4923: AND system_record_type <> 'CORRECTION';
4924:

Line 4925: l_get_trans_num igf_ap_isir_matched_all.transaction_num%TYPE;

4921: WHERE base_id = cp_base_id
4922: AND transaction_num = cp_trans_num
4923: AND system_record_type <> 'CORRECTION';
4924:
4925: l_get_trans_num igf_ap_isir_matched_all.transaction_num%TYPE;
4926:
4927: BEGIN
4928:
4929: OPEN c_get_payment_isir(p_base_id);

Line 4966: FROM igf_ap_isir_matched isir

4962: */
4963:
4964: CURSOR get_ISIR (ln_isir_id NUMBER) IS
4965: SELECT isir.*
4966: FROM igf_ap_isir_matched isir
4967: WHERE isir_id = ln_isir_id ;
4968:
4969: lv_payment_isir_rec get_isir%ROWTYPE;
4970:

Line 4972: CURSOR get_corr_isir (cp_base_id igf_ap_isir_matched_all.base_id%TYPE) IS

4968:
4969: lv_payment_isir_rec get_isir%ROWTYPE;
4970:
4971:
4972: CURSOR get_corr_isir (cp_base_id igf_ap_isir_matched_all.base_id%TYPE) IS
4973: SELECT row_id, isir_id
4974: FROM igf_ap_isir_matched
4975: WHERE base_id = cp_base_id
4976: AND NVL(system_record_type,'*') = 'CORRECTION';

Line 4974: FROM igf_ap_isir_matched

4970:
4971:
4972: CURSOR get_corr_isir (cp_base_id igf_ap_isir_matched_all.base_id%TYPE) IS
4973: SELECT row_id, isir_id
4974: FROM igf_ap_isir_matched
4975: WHERE base_id = cp_base_id
4976: AND NVL(system_record_type,'*') = 'CORRECTION';
4977:
4978: l_cor_isir get_corr_isir%ROWTYPE;

Line 4981: CURSOR cur_isir_corr (cp_base_id igf_ap_isir_matched.base_id%TYPE,

4977:
4978: l_cor_isir get_corr_isir%ROWTYPE;
4979:
4980:
4981: CURSOR cur_isir_corr (cp_base_id igf_ap_isir_matched.base_id%TYPE,
4982: cp_corr_stat VARCHAR2 ) IS
4983: SELECT corr.*,
4984: sar.sar_field_name column_name
4985: FROM igf_ap_batch_aw_map map,

Line 4988: igf_ap_isir_matched isir

4984: sar.sar_field_name column_name
4985: FROM igf_ap_batch_aw_map map,
4986: igf_ap_ISIR_corr corr,
4987: igf_fc_sar_cd_mst sar,
4988: igf_ap_isir_matched isir
4989: WHERE map.ci_cal_type = g_ci_cal_type
4990: AND map.ci_sequence_number = g_ci_sequence_number
4991: AND corr.isir_id = isir.isir_id
4992: AND isir.base_id = cp_base_id

Line 5002: CURSOR cur_isir_corr_pymt (cp_isir_id igf_ap_isir_matched.isir_id%TYPE) IS

4998:
4999: l_corr_stat VARCHAR2(30) ;
5000:
5001:
5002: CURSOR cur_isir_corr_pymt (cp_isir_id igf_ap_isir_matched.isir_id%TYPE) IS
5003: SELECT corr.*
5004: FROM igf_ap_ISIR_corr corr
5005: WHERE corr.isir_id = cp_isir_id ;
5006:

Line 6602: igf_ap_isir_matched_pkg.delete_row(l_cor_isir.row_id); -- delete the correction type isir.

6598: CLOSE get_corr_isir;
6599:
6600: -- now delete the correction isir
6601: IF l_cor_isir.row_id IS NOT NULL THEN
6602: igf_ap_isir_matched_pkg.delete_row(l_cor_isir.row_id); -- delete the correction type isir.
6603:
6604: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Deleted existing Correction ISIR ID: ' || l_cor_isir.isir_id);
6606: END IF;

Line 6761: FROM igf_ap_isir_matched im

6757:
6758:
6759: CURSOR cur_old_pymt_isir(pn_base_id NUMBER) IS
6760: SELECT im.*
6761: FROM igf_ap_isir_matched im
6762: WHERE im.base_id = pn_base_id
6763: AND im.payment_isir = 'Y';
6764:
6765: old_pymt_isir_rec cur_old_pymt_isir%ROWTYPE;

Line 6776: FROM igf_ap_isir_matched_all

6772:
6773: -- Get the privious Active ISIR id for the base id.
6774: CURSOR cur_old_active_isir(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
6775: SELECT isir_id
6776: FROM igf_ap_isir_matched_all
6777: WHERE base_id = cp_base_id
6778: AND active_isir = 'Y';
6779:
6780: CURSOR cur_loan_orig_chk(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

Line 6785: IGF_AW_AWARD_ALL AWD, igf_ap_isir_matched_all m

6781: SELECT
6782: 'X'
6783: FROM
6784: IGF_SL_LOR_ALL LOR, IGF_SL_LOANS_ALL LOAN,
6785: IGF_AW_AWARD_ALL AWD, igf_ap_isir_matched_all m
6786: WHERE
6787: m.base_id = awd.base_id and
6788: awd.award_id = loan.award_id and
6789: loan.loan_id = lor.loan_id and

Line 6801: lv_isir_id igf_ap_isir_matched.isir_id%TYPE;

6797: lv_payment_isir VARCHAR2(1);
6798: lv_rowid VARCHAR2(30);
6799: lv_status VARCHAR2(30);
6800: is_orig_isir_exists BOOLEAN;
6801: lv_isir_id igf_ap_isir_matched.isir_id%TYPE;
6802: lv_nslds_id NUMBER;
6803: lv_all_corr_rcvd VARCHAR2(1);
6804:
6805: BEGIN

Line 7120: FROM igf_ap_isir_matched iim

7116: cp_sys_rec_type VARCHAR2)
7117: IS
7118: SELECT MAX(iim.transaction_num) max_id,
7119: iim.base_id
7120: FROM igf_ap_isir_matched iim
7121: WHERE iim.original_ssn = cp_original_ssn
7122: AND iim.orig_name_id = cp_orig_name_id
7123: AND iim.system_record_type = cp_sys_rec_type
7124: AND iim.batch_year = cp_batch_year

Line 7137: FROM igf_ap_isir_matched iim

7133: cp_sys_rec_type VARCHAR2,
7134: cp_transaction_num VARCHAR2)
7135: IS
7136: SELECT 1
7137: FROM igf_ap_isir_matched iim
7138: WHERE iim.original_ssn = cp_original_ssn
7139: AND iim.orig_name_id = cp_orig_name_id
7140: AND iim.system_record_type = cp_sys_rec_type
7141: AND iim.batch_year = cp_batch_year

Line 7152: FROM igf_ap_isir_matched

7148: WHERE base_id = pn_base_id;
7149:
7150: CURSOR get_pymnt_isir_tran_cur(pn_base_id NUMBER) IS
7151: SELECT transaction_num
7152: FROM igf_ap_isir_matched
7153: WHERE base_id = pn_base_id
7154: AND payment_isir = 'Y';
7155:
7156: l_chk_transaction_num chk_transaction_num%ROWTYPE;

Line 7942: pn_base_id igf_ap_isir_matched.base_id%TYPE)

7938: pv_last_name VARCHAR2,
7939: pd_date_of_birth DATE,
7940: pn_ci_sequence_number NUMBER,
7941: pv_ci_cal_type VARCHAR2,
7942: pn_base_id igf_ap_isir_matched.base_id%TYPE)
7943: IS
7944: /*
7945: || Created By : brajendr
7946: || Created On : 24-NOV-2000

Line 7970: ln_isir_id igf_ap_isir_matched.isir_id%TYPE;

7966: AND ibm.ci_cal_type = pv_ci_cal_type
7967: AND iii.batch_year_num = ibm.batch_year
7968: AND (iii.record_status = 'UNMATCHED' OR iii.record_status = 'NEW');
7969:
7970: ln_isir_id igf_ap_isir_matched.isir_id%TYPE;
7971:
7972: BEGIN
7973:
7974: --Get all the unmatched records which are valid for this batch year and creates a new matched record for it.

Line 8029: -- INsert Record in IGF_AP_ISIR_Matched table

8025: lv_rowid VARCHAR2(30);
8026:
8027: BEGIN
8028:
8029: -- INsert Record in IGF_AP_ISIR_Matched table
8030: FOR cur_isir_intrface_rec IN cur_isir_intrface ( pn_si_id)
8031: LOOP
8032:
8033: lv_rowid := NULL;

Line 8383: p_batch_year IN igf_ap_isir_matched.batch_year%TYPE,

8379:
8380: -- Added p_award_yr as a part of Bug Fix 4241350
8381: PROCEDURE wrpr_auto_fa_rec(p_si_id IN igf_ap_isir_ints_all.si_id%TYPE,
8382: p_person_id IN igf_ap_match_details.person_id%TYPE,
8383: p_batch_year IN igf_ap_isir_matched.batch_year%TYPE,
8384: p_return_status OUT NOCOPY VARCHAR2,
8385: p_message_out OUT NOCOPY VARCHAR2)
8386: IS
8387: /*

Line 8422: FROM igf_ap_isir_matched

8418: AND am.batch_year = cp_batch_year;
8419:
8420: CURSOR cur_isir_matched(cp_base_id NUMBER, cp_transaction_num VARCHAR2) IS
8421: SELECT 'Y'
8422: FROM igf_ap_isir_matched
8423: WHERE base_id = cp_base_id
8424: AND transaction_num = cp_transaction_num;
8425:
8426: lv_profile_value VARCHAR2(10);