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.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGF_AP_ISIR_INTS

Line 18: g_isir_intrface_rec igf_ap_isir_ints%ROWTYPE;

14: g_review_count NUMBER := 0;
15: g_rec_not_ins BOOLEAN := TRUE;
16: gv_format igs_pe_person_id_typ.format_mask%TYPE := NULL;
17: g_setup_score igf_ap_record_match%ROWTYPE;
18: g_isir_intrface_rec igf_ap_isir_ints%ROWTYPE;
19: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
20: g_ci_sequence_number igf_ap_batch_aw_map.ci_sequence_number%TYPE;
21: g_pell_match_type VARCHAR2(1) ; -- Stores the Type of Pell match done Duplicate/New rec
22: g_base_id NUMBER;

Line 33: g_rec_processed_status igf_ap_isir_ints_all.record_status%TYPE;

29: g_batch_year igf_ap_batch_aw_map.batch_year%TYPE;
30: g_match_code igf_ap_record_match_all.match_code%TYPE;
31: g_separator_line VARCHAR2(100);
32: g_total_recs_processed NUMBER := 0;
33: g_rec_processed_status igf_ap_isir_ints_all.record_status%TYPE;
34: g_del_success_int_rec VARCHAR2(1); -- Global var for holding p_del_int parameter value
35: g_isir_is_valid BOOLEAN;
36: g_sub_req_num NUMBER;
37: g_gen_party_profile_val VARCHAR2(1);

Line 399: PROCEDURE update_isir_int_record (p_si_id igf_ap_isir_ints.si_id%TYPE,

395: app_exception.raise_exception;
396: END process_todo_items;
397:
398:
399: PROCEDURE update_isir_int_record (p_si_id igf_ap_isir_ints.si_id%TYPE,
400: p_isir_rec_status igf_ap_isir_ints_all.record_status%TYPE,
401: p_match_code igf_ap_isir_ints.match_code%TYPE)
402: IS
403: /*

Line 400: p_isir_rec_status igf_ap_isir_ints_all.record_status%TYPE,

396: END process_todo_items;
397:
398:
399: PROCEDURE update_isir_int_record (p_si_id igf_ap_isir_ints.si_id%TYPE,
400: p_isir_rec_status igf_ap_isir_ints_all.record_status%TYPE,
401: p_match_code igf_ap_isir_ints.match_code%TYPE)
402: IS
403: /*
404: || Created By : rgangara

Line 401: p_match_code igf_ap_isir_ints.match_code%TYPE)

397:
398:
399: PROCEDURE update_isir_int_record (p_si_id igf_ap_isir_ints.si_id%TYPE,
400: p_isir_rec_status igf_ap_isir_ints_all.record_status%TYPE,
401: p_match_code igf_ap_isir_ints.match_code%TYPE)
402: IS
403: /*
404: || Created By : rgangara
405: || Created On : 03-AUG-2004

Line 422: DELETE FROM igf_ap_isir_ints_all

418: BEGIN
419:
420: IF g_del_success_int_rec = 'Y' AND p_isir_rec_status = 'MATCHED' THEN
421:
422: DELETE FROM igf_ap_isir_ints_all
423: WHERE si_id = p_si_id;
424:
425: log_debug_message('Deleted ISIR Interface record. SI ID : ' || p_si_id);
426: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 431: UPDATE igf_ap_isir_ints_all

427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_isir_int_record.statement','Deleted ISIR Interface record for SI_ID: ' || p_si_id);
428: END IF;
429:
430: ELSE -- if parameter is No or status is not 'MATCHED'
431: UPDATE igf_ap_isir_ints_all
432: SET record_status = p_isir_rec_status,
433: match_code = p_match_code,
434: last_update_date = SYSDATE
435: WHERE si_id = p_si_id;

Line 1019: PROCEDURE insert_isir_matched_rec(cp_isir_int_rec igf_ap_isir_ints%ROWTYPE,

1015: END LOOP;
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

Line 1395: PROCEDURE insert_nslds_data_rec(cp_isir_intrface_rec igf_ap_isir_ints%ROWTYPE,

1391: END insert_isir_matched_rec;
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: )

Line 2475: FROM igf_ap_isir_ints

2471: perm_state_txt,
2472: perm_zip_cd,
2473: birth_date,
2474: ss_r_u_male_flag
2475: FROM igf_ap_isir_ints
2476: WHERE si_id = cp_isir_id;
2477:
2478: isir_rec isir_cur%ROWTYPE;
2479:

Line 3843: -- call procedure to update the record_status of igf_ap_isir_ints to 'REVIEW'

3839: -- call procedure to update the record_status of igf_ap_person_match and match details table
3840: update_prsn_match_rec_status(p_apm_id => p_apm_id,
3841: p_rec_status => 'REVIEW');
3842:
3843: -- call procedure to update the record_status of igf_ap_isir_ints to 'REVIEW'
3844: update_isir_int_record (p_si_id => g_isir_intrface_rec.si_id,
3845: p_isir_rec_status => 'REVIEW',
3846: p_match_code => g_match_code);
3847:

Line 4031: PROCEDURE calculate_match_score(p_isir_rec igf_ap_isir_ints%ROWTYPE,

4027: END unmatched_rec ;
4028:
4029:
4030:
4031: PROCEDURE calculate_match_score(p_isir_rec igf_ap_isir_ints%ROWTYPE,
4032: p_match_setup igf_ap_record_match%ROWTYPE,
4033: p_match_dtls_rec igf_ap_match_details%ROWTYPE,
4034: p_apm_id NUMBER,
4035: p_person_id NUMBER)

Line 7464: FROM igf_ap_isir_ints iia

7460: WHERE batch_year = cp_batch_yr;
7461:
7462: CURSOR cur_isir_intrface(cp_si_id NUMBER) IS
7463: SELECT iia.*
7464: FROM igf_ap_isir_ints iia
7465: WHERE si_id = cp_si_id;
7466:
7467: -- cursor to get records to process current request (as sub request)
7468: CURSOR cur_sub_req_int(cp_parent_req_id NUMBER, cp_sub_req_num NUMBER) IS

Line 7470: FROM igf_ap_isir_ints iia

7466:
7467: -- cursor to get records to process current request (as sub request)
7468: CURSOR cur_sub_req_int(cp_parent_req_id NUMBER, cp_sub_req_num NUMBER) IS
7469: SELECT iia.*
7470: FROM igf_ap_isir_ints iia
7471: WHERE parent_req_id = cp_parent_req_id
7472: AND sub_req_num = cp_sub_req_num
7473: ORDER BY si_id;
7474:

Line 7733: FUNCTION remove_spl_chr(pv_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE)

7729:
7730: END convert_to_date;
7731:
7732:
7733: FUNCTION remove_spl_chr(pv_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE)
7734: RETURN VARCHAR2
7735: IS
7736: /*
7737: || Created By : rasingh

Line 7960: FROM igf_ap_isir_ints iii,

7956: iii.last_name,
7957: iii.birth_date,
7958: iii.batch_year_num,
7959: iii.record_status
7960: FROM igf_ap_isir_ints iii,
7961: igf_ap_batch_aw_map ibm
7962: WHERE original_ssn_txt = pn_ssn
7963: AND iii.last_name = pv_last_name
7964: AND iii.birth_date = pd_date_of_birth

Line 8022: FROM igf_ap_isir_ints iii

8018: */
8019: CURSOR cur_isir_intrface ( pn_si_id NUMBER)
8020: IS
8021: SELECT iii.*
8022: FROM igf_ap_isir_ints iii
8023: WHERE iii.si_id = pn_si_id;
8024:
8025: lv_rowid VARCHAR2(30);
8026:

Line 8077: FROM igf_ap_isir_ints_all iii

8073: || (reverse chronological order - newest change first)
8074: */
8075: CURSOR cur_isir_intrface ( pn_si_id NUMBER) IS
8076: SELECT rowid row_id, iii.si_id
8077: FROM igf_ap_isir_ints_all iii
8078: WHERE si_id = pn_si_id FOR UPDATE NOWAIT ;
8079:
8080: lv_rowid VARCHAR2(30);
8081: retcode NUMBER;

Line 8090: UPDATE igf_ap_isir_ints_all

8086: -- Update record _status
8087: FOR cur_isir_intrface_rec IN cur_isir_intrface ( pn_si_id)
8088: LOOP
8089:
8090: UPDATE igf_ap_isir_ints_all
8091: SET record_status = pv_record_status
8092: WHERE si_id = cur_isir_intrface_rec.si_id;
8093:
8094: END LOOP;

Line 8134: FROM igf_ap_isir_ints iii

8130: */
8131: -- Get all the NSLDS data for the matched isir record.
8132: CURSOR cur_isir_intrface (cp_si_id NUMBER) IS
8133: SELECT iii.*
8134: FROM igf_ap_isir_ints iii
8135: WHERE si_id = pn_si_id;
8136:
8137: CURSOR cur_nslds_data (cp_base_id NUMBER ,
8138: cp_trans_num igf_ap_nslds_data_all.transaction_num_txt%TYPE) IS

Line 8234: PROCEDURE wrpr_refresh_matches(p_si_id IN igf_ap_isir_ints_all.si_id%TYPE,

8230: igs_ge_msg_stack.add;
8231:
8232: END check_ptyp_code;
8233:
8234: PROCEDURE wrpr_refresh_matches(p_si_id IN igf_ap_isir_ints_all.si_id%TYPE,
8235: p_match_code IN igf_ap_record_match_all.match_code%TYPE,
8236: p_return_status OUT NOCOPY VARCHAR2,
8237: p_message_out OUT NOCOPY VARCHAR2)
8238: IS

Line 8252: FROM igf_ap_isir_ints iia

8248: */
8249:
8250: CURSOR cur_isir_intrface(cp_si_id NUMBER) IS
8251: SELECT iia.*
8252: FROM igf_ap_isir_ints iia
8253: WHERE si_id = cp_si_id;
8254:
8255: CURSOR cur_award_year_dtl(cp_batch_year igf_ap_isir_ints.batch_year_num%TYPE) IS
8256: SELECT ci_sequence_number,ci_cal_type

Line 8255: CURSOR cur_award_year_dtl(cp_batch_year igf_ap_isir_ints.batch_year_num%TYPE) IS

8251: SELECT iia.*
8252: FROM igf_ap_isir_ints iia
8253: WHERE si_id = cp_si_id;
8254:
8255: CURSOR cur_award_year_dtl(cp_batch_year igf_ap_isir_ints.batch_year_num%TYPE) IS
8256: SELECT ci_sequence_number,ci_cal_type
8257: FROM igf_ap_batch_aw_map
8258: WHERE batch_year = cp_batch_year;
8259:

Line 8381: PROCEDURE wrpr_auto_fa_rec(p_si_id IN igf_ap_isir_ints_all.si_id%TYPE,

8377: p_message_out := fnd_message.get || '. Exception is : ' || SQLERRM;
8378: END wrpr_refresh_matches;
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)

Line 8401: FROM igf_ap_isir_ints iia

8397: */
8398:
8399: CURSOR cur_isir_intrface(cp_si_id NUMBER) IS
8400: SELECT iia.*
8401: FROM igf_ap_isir_ints iia
8402: WHERE si_id = cp_si_id;
8403:
8404: CURSOR get_person_match_cur (cp_si_id IN NUMBER) IS
8405: SELECT apm_id,

Line 8554: PROCEDURE wrpr_unmatched_rec(p_si_id IN igf_ap_isir_ints_all.si_id%TYPE,

8550: p_message_out := p_message_out || '. ' || fnd_message.get || ' Exception is : ' || SQLERRM;
8551: END wrpr_auto_fa_rec;
8552:
8553:
8554: PROCEDURE wrpr_unmatched_rec(p_si_id IN igf_ap_isir_ints_all.si_id%TYPE,
8555: p_return_status OUT NOCOPY VARCHAR2,
8556: p_message_out OUT NOCOPY VARCHAR2)
8557: IS
8558: /*

Line 8571: FROM igf_ap_isir_ints iia

8567: */
8568:
8569: CURSOR cur_isir_intrface(cp_si_id NUMBER) IS
8570: SELECT iia.*
8571: FROM igf_ap_isir_ints iia
8572: WHERE si_id = cp_si_id;
8573:
8574:
8575: CURSOR get_person_match_cur (cp_si_id IN NUMBER) IS