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_LG_TD_IMP dependencies on IGF_AP_FA_BASE_REC

Line 159: FROM igf_ap_fa_base_rec_all FA

155: isir_locked_by,
156: adnl_unsub_loan_elig_flag,
157: lock_awd_flag,
158: lock_coa_flag
159: FROM igf_ap_fa_base_rec_all FA
160: WHERE FA.base_id = cp_base_id;
161:
162: g_baseid_exists c_baseid_exists%ROWTYPE;
163:

Line 166: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

162: g_baseid_exists c_baseid_exists%ROWTYPE;
163:
164: -- museshad (FA 140). Forward declaration
165: PROCEDURE process_pref_lender(
166: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
167: p_rel_cd IN igf_ap_li_todo_ints.relationship_cd%TYPE,
168: p_clprl_id OUT NOCOPY igf_sl_cl_pref_lenders.clprl_id%TYPE
169: );
170: -- museshad (FA 140)

Line 197: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;

193: l_error_flag BOOLEAN := FALSE;
194: l_error VARCHAR2(10);
195: lv_row_id VARCHAR2(80) := NULL;
196: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
197: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
198: l_old_person_number igf_ap_li_todo_ints.person_number%TYPE := '******';
199: l_current_person_number igf_ap_li_todo_ints.person_number%TYPE := NULL;
200: l_person_skip_flag BOOLEAN := FALSE;
201: l_success_record_cnt NUMBER := 0;

Line 211: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;

207: l_total_record_cnt NUMBER := 0;
208: l_get_meaning igf_lookups_view.meaning%TYPE := NULL;
209: l_todo_number igf_ap_td_item_mst_all.todo_number%TYPE := NULL;
210:
211: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
212: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
213:
214: -- Cursor for getting the context award year details
215: CURSOR c_get_status(cp_cal_type VARCHAR2,

Line 212: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;

208: l_get_meaning igf_lookups_view.meaning%TYPE := NULL;
209: l_todo_number igf_ap_td_item_mst_all.todo_number%TYPE := NULL;
210:
211: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
212: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
213:
214: -- Cursor for getting the context award year details
215: CURSOR c_get_status(cp_cal_type VARCHAR2,
216: cp_seq_number NUMBER)

Line 785: CURSOR c_person_id(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

781: || Who When What
782: || (reverse chronological order - newest change first)
783: */
784: -- Get person_id
785: CURSOR c_person_id(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
786: IS
787: SELECT person_id
788: FROM igf_ap_fa_base_rec_all
789: WHERE base_id = cp_base_id;

Line 788: FROM igf_ap_fa_base_rec_all

784: -- Get person_id
785: CURSOR c_person_id(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
786: IS
787: SELECT person_id
788: FROM igf_ap_fa_base_rec_all
789: WHERE base_id = cp_base_id;
790:
791: CURSOR cur_todo(
792: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

Line 792: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

788: FROM igf_ap_fa_base_rec_all
789: WHERE base_id = cp_base_id;
790:
791: CURSOR cur_todo(
792: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
793: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE
794: )
795: IS
796: SELECT 1

Line 793: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE

789: WHERE base_id = cp_base_id;
790:
791: CURSOR cur_todo(
792: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
793: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE
794: )
795: IS
796: SELECT 1
797: FROM igf_ap_td_item_inst_all tdinst,

Line 810: igf_ap_fa_base_rec_all fa

806: UNION
807: SELECT 1
808: FROM igf_ap_td_item_inst_all tdinst,
809: igf_ap_td_item_mst_all tdmst,
810: igf_ap_fa_base_rec_all fa
811: WHERE tdinst.base_id = fa.base_id
812: AND tdinst.status IN ('INC','REQ','REC')
813: AND tdinst.required_for_application = 'Y'
814: AND NVL(tdinst.inactive_flag,'N') <> 'Y'

Line 820: CURSOR cur_ver_status (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

816: AND tdmst.career_item = 'Y'
817: AND fa.person_id = cp_person_id
818: AND ROWNUM < 2;
819:
820: CURSOR cur_ver_status (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
821: IS
822: SELECT NVL(fa_process_status,'RECEIVED') fa_process_status
823: FROM igf_ap_fa_base_rec
824: WHERE base_id = cp_base_id;

Line 823: FROM igf_ap_fa_base_rec

819:
820: CURSOR cur_ver_status (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
821: IS
822: SELECT NVL(fa_process_status,'RECEIVED') fa_process_status
823: FROM igf_ap_fa_base_rec
824: WHERE base_id = cp_base_id;
825:
826: ln_count_open_items NUMBER;
827: l_person_id hz_parties.party_id%TYPE;

Line 828: lv_fa_process_status igf_ap_fa_base_rec_all.fa_process_status%TYPE;

824: WHERE base_id = cp_base_id;
825:
826: ln_count_open_items NUMBER;
827: l_person_id hz_parties.party_id%TYPE;
828: lv_fa_process_status igf_ap_fa_base_rec_all.fa_process_status%TYPE;
829: ln_auto_na_complete VARCHAR2(80);
830:
831: BEGIN
832:

Line 885: || igf_ap_fa_base_rec_pkg.update_row

881: || Who When What
882: || (reverse chronological order - newest change first)
883: || rasahoo 17-NOV-2003 FA 128 - ISIR update 2004-05
884: || added new parameter award_fmly_contribution_type to
885: || igf_ap_fa_base_rec_pkg.update_row
886: || ugummall 25-SEP-2003 FA 126 - Multiple FA Offices
887: || added new parameter assoc_org_num to
888: || igf_ap_fa_base_rec_pkg.update_row call
889: */

Line 888: || igf_ap_fa_base_rec_pkg.update_row call

884: || added new parameter award_fmly_contribution_type to
885: || igf_ap_fa_base_rec_pkg.update_row
886: || ugummall 25-SEP-2003 FA 126 - Multiple FA Offices
887: || added new parameter assoc_org_num to
888: || igf_ap_fa_base_rec_pkg.update_row call
889: */
890:
891: BEGIN
892: igf_ap_fa_base_rec_pkg.update_row(

Line 892: igf_ap_fa_base_rec_pkg.update_row(

888: || igf_ap_fa_base_rec_pkg.update_row call
889: */
890:
891: BEGIN
892: igf_ap_fa_base_rec_pkg.update_row(
893: x_Mode => 'R' ,
894: x_rowid => g_baseid_exists.row_id ,
895: x_base_id => g_baseid_exists.base_id ,
896: x_ci_cal_type => g_baseid_exists.ci_cal_type ,

Line 1010: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

1006:
1007: END update_fabase_rec;
1008:
1009: PROCEDURE process_pref_lender(
1010: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1011: p_rel_cd IN igf_ap_li_todo_ints.relationship_cd%TYPE,
1012: p_clprl_id OUT NOCOPY igf_sl_cl_pref_lenders.clprl_id%TYPE
1013: )
1014: IS

Line 1029: CURSOR c_get_person_id (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

1025: || (reverse chronological order - newest change first)
1026: */
1027:
1028: -- Get Person Id
1029: CURSOR c_get_person_id (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1030: IS
1031: SELECT person_id
1032: FROM igf_ap_fa_base_rec_all
1033: WHERE base_id = cp_base_id;

Line 1032: FROM igf_ap_fa_base_rec_all

1028: -- Get Person Id
1029: CURSOR c_get_person_id (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1030: IS
1031: SELECT person_id
1032: FROM igf_ap_fa_base_rec_all
1033: WHERE base_id = cp_base_id;
1034:
1035: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
1036: