APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGF_AP_ISIR_INTS_ALL

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 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 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 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 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 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 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 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: /*