APPS.IGF_AP_ISIR_GEN_PKG dependencies on IGF_AP_ISIR_INTS_ALL

Line 19: PROCEDURE attach_isir( cp_si_id IN igf_ap_isir_ints_all.si_id%TYPE ,

15: --brajendr 02-Nov-2004 Bug 3031287 FA152 and FA137 COA Updates and Repackaging
16: -- Added procedure upd_ant_data_awd_prc_status for Updating Anticipated Data and Award Prcoess status
17: -------------------------------------------------------------------
18:
19: PROCEDURE attach_isir( cp_si_id IN igf_ap_isir_ints_all.si_id%TYPE ,
20: cp_batch_year IN igf_ap_isir_ints_all.batch_year_num%TYPE,
21: cp_message_out OUT NOCOPY VARCHAR2)
22: AS
23: /*

Line 20: cp_batch_year IN igf_ap_isir_ints_all.batch_year_num%TYPE,

16: -- Added procedure upd_ant_data_awd_prc_status for Updating Anticipated Data and Award Prcoess status
17: -------------------------------------------------------------------
18:
19: PROCEDURE attach_isir( cp_si_id IN igf_ap_isir_ints_all.si_id%TYPE ,
20: cp_batch_year IN igf_ap_isir_ints_all.batch_year_num%TYPE,
21: cp_message_out OUT NOCOPY VARCHAR2)
22: AS
23: /*
24: || Created By : rasahoo

Line 725: FROM igf_ap_isir_ints_all;

721:
722: -- Get
723: CURSOR max_seq IS
724: SELECT max(si_id) max_si_id
725: FROM igf_ap_isir_ints_all;
726:
727:
728: todo_items_for_isir_rec todo_items_for_isir_cur%ROWTYPE;
729:

Line 780: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_gen_pkg.delete_isir.debug','Before calling UPDATE igf_ap_isir_ints_all for si_id : '|| rec_chk_isir_in_ints.si_id);

776: IF rec_chk_isir_in_ints.si_id IS NOT NULL THEN
777:
778:
779: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
780: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_gen_pkg.delete_isir.debug','Before calling UPDATE igf_ap_isir_ints_all for si_id : '|| rec_chk_isir_in_ints.si_id);
781: END IF;
782:
783: UPDATE igf_ap_isir_ints_all
784: SET record_status = 'UNMATCHED',

Line 783: UPDATE igf_ap_isir_ints_all

779: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
780: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_gen_pkg.delete_isir.debug','Before calling UPDATE igf_ap_isir_ints_all for si_id : '|| rec_chk_isir_in_ints.si_id);
781: END IF;
782:
783: UPDATE igf_ap_isir_ints_all
784: SET record_status = 'UNMATCHED',
785: last_updated_by = fnd_global.user_id,
786: last_update_date = TRUNC(SYSDATE),
787: last_update_login = fnd_global.login_id

Line 796: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_gen_pkg.delete_isir.debug','Before opening cursor cur_isir_int and insert row into igf_ap_isir_ints_all');

792: ELSE
793:
794: -- If the ISIR data is not present in the ISIR Interface table, then insert the data from the ISIR Matched table and NSLDS data table.
795: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
796: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_gen_pkg.delete_isir.debug','Before opening cursor cur_isir_int and insert row into igf_ap_isir_ints_all');
797: END IF;
798:
799:
800: OPEN cur_isir_int(p_isir_id);

Line 808: INSERT INTO igf_ap_isir_ints_all (

804: OPEN max_seq;
805: FETCH max_seq INTO max_seq_rec;
806: CLOSE max_seq;
807:
808: INSERT INTO igf_ap_isir_ints_all (
809: si_id,
810: batch_year_num,
811: transaction_num_txt,
812: current_ssn_txt,

Line 1976: FROM IGF_AP_ISIR_INTS_ALL intface

1972:
1973: -- Cursor to get rowid of the ISIR interface record.
1974: CURSOR cur_get_rowid_interface ( cp_si_id igf_ap_isir_intrface.si_id%TYPE) IS
1975: SELECT ROWID row_id
1976: FROM IGF_AP_ISIR_INTS_ALL intface
1977: WHERE intface.si_id = cp_si_id;
1978:
1979: rec_get_rowid_interface cur_get_rowid_interface%ROWTYPE;
1980:

Line 2003: DELETE IGF_AP_ISIR_INTS_ALL WHERE si_id = p_si_id;

1999: END IF;
2000:
2001: -- delete the interface record.
2002: --igf_ap_isir_intrface_pkg.delete_row(rec_get_rowid_interface.row_id);
2003: DELETE IGF_AP_ISIR_INTS_ALL WHERE si_id = p_si_id;
2004:
2005: -- delete person match record and match details records
2006: delete_person_match(p_si_id => p_si_id);
2007:

Line 2098: igf_ap_isir_ints_all isir

2094:
2095: CURSOR cur_isir_exists (cp_si_id NUMBER, cp_batch_year NUMBER) IS
2096: SELECT 1
2097: FROM igf_ap_isir_matched iim,
2098: igf_ap_isir_ints_all isir
2099: WHERE iim.original_ssn = isir.original_ssn_txt
2100: AND iim.orig_name_id = isir.orig_name_id_txt
2101: AND iim.system_record_type = 'ORIGINAL'
2102: AND isir.si_id = cp_si_id