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_GEN dependencies on IGF_AP_FA_BASE_REC_ALL

Line 140: p_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,

136:
137: PROCEDURE check_person ( p_person_number IN igf_aw_li_coa_ints.person_number%TYPE,
138: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
139: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
140: p_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,
141: p_fa_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE ) IS
142:
143: /*
144: || Created By : masehgal

Line 141: p_fa_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE ) IS

137: PROCEDURE check_person ( p_person_number IN igf_aw_li_coa_ints.person_number%TYPE,
138: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
139: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
140: p_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,
141: p_fa_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE ) IS
142:
143: /*
144: || Created By : masehgal
145: || Created On : 28-May-2003

Line 165: igf_ap_fa_base_rec_all.person_id%TYPE ) IS

161: l_person_id c_person_exist%ROWTYPE;
162:
163: -- check for fa base rec existence
164: CURSOR c_fabase_exist ( cp_person_id
165: igf_ap_fa_base_rec_all.person_id%TYPE ) IS
166: SELECT base_id fa_base_id
167: FROM igf_ap_fa_base_rec_all
168: WHERE person_id = cp_person_id
169: AND ci_cal_type = p_ci_cal_type

Line 167: FROM igf_ap_fa_base_rec_all

163: -- check for fa base rec existence
164: CURSOR c_fabase_exist ( cp_person_id
165: igf_ap_fa_base_rec_all.person_id%TYPE ) IS
166: SELECT base_id fa_base_id
167: FROM igf_ap_fa_base_rec_all
168: WHERE person_id = cp_person_id
169: AND ci_cal_type = p_ci_cal_type
170: AND ci_sequence_number = p_ci_sequence_number ;
171: l_fa_base_id c_fabase_exist%ROWTYPE;

Line 516: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

512:
513: END check_batch;
514:
515: FUNCTION get_isir_value(
516: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
517: p_sar_field_name IN igf_fc_sar_cd_mst.sar_field_name%TYPE
518: ) RETURN VARCHAR2 AS
519:
520: /*

Line 568: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

564: END get_isir_value;
565:
566:
567: FUNCTION get_indv_efc_4_term(
568: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
569: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
570: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
571: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
572: ) RETURN NUMBER AS

Line 569: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

565:
566:
567: FUNCTION get_indv_efc_4_term(
568: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
569: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
570: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
571: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
572: ) RETURN NUMBER AS
573: /*

Line 570: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

566:
567: FUNCTION get_indv_efc_4_term(
568: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
569: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
570: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
571: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
572: ) RETURN NUMBER AS
573: /*
574: || Created By : rasahoo

Line 586: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

582: || Build ISIR update 2004 - 05
583: */
584:
585: CURSOR c_cum_efc(
586: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
587: cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE
588: ) IS
589: SELECT distinct ca.alternate_code,
590: ca.start_dt ld_start_dt,

Line 622: igf_ap_fa_base_rec_all fa,

618: 10, PRIMARY_ALTERNATE_MONTH_10,
619: 11, PRIMARY_ALTERNATE_MONTH_11,
620: 12, PRIMARY_ALTERNATE_MONTH_12 ) ) efc
621: FROM igf_ap_isir_matched_all isir,
622: igf_ap_fa_base_rec_all fa,
623: igs_ca_inst_all ca,
624: igf_aw_coa_itm_terms coa
625: WHERE coa.base_id = fa.base_id
626: AND coa.base_id = isir.base_id

Line 662: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE

658:
659:
660: FUNCTION get_cumulative_coa_amt(
661: p_ld_start_dt IN DATE,
662: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
663: ) RETURN NUMBER IS
664: /*
665: || Created By : rasahoo
666: || Created On : 27-NOV-2003

Line 677: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE

673: */
674:
675: CURSOR sel_coa_amt_cur(
676: cp_ld_start_dt IN DATE,
677: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
678: )IS
679: SELECT SUM(coait.amount) coa
680: FROM igf_aw_coa_itm_terms coait,
681: igs_ca_inst ca

Line 714: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE

710:
711:
712: FUNCTION get_individual_coa_amt(
713: p_ld_start_dt IN DATE,
714: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
715: ) RETURN NUMBER IS
716: /*
717: || Created By : rasahoo
718: || Created On : 27-NOV-2003

Line 729: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE

725: */
726:
727: CURSOR sel_coa_amt_cur(
728: cp_ld_start_dt IN DATE,
729: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
730: )IS
731: SELECT SUM(coait.amount) coa
732: FROM igf_aw_coa_itm_terms coait,
733: igs_ca_inst ca

Line 764: PROCEDURE update_preflend_todo_status ( p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,

760: app_exception.raise_exception;
761:
762: END get_individual_coa_amt;
763:
764: PROCEDURE update_preflend_todo_status ( p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
765: p_return_status OUT NOCOPY VARCHAR2
766: ) IS
767: ------------------------------------------------------------------
768: --Created by : bvisvana, Oracle India

Line 779: CURSOR get_active_preflend(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS

775: --Change History:
776: --Who When What
777: -------------------------------------------------------------------
778:
779: CURSOR get_active_preflend(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
780: SELECT clprl_id FROM igf_sl_cl_pref_lenders WHERE
781: person_id = cp_person_id AND TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date,TRUNC(SYSDATE));
782:
783: CURSOR preflend_todo_item_dtls (cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS

Line 783: CURSOR preflend_todo_item_dtls (cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS

779: CURSOR get_active_preflend(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
780: SELECT clprl_id FROM igf_sl_cl_pref_lenders WHERE
781: person_id = cp_person_id AND TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date,TRUNC(SYSDATE));
782:
783: CURSOR preflend_todo_item_dtls (cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
784: SELECT clprl_id,base_id,item_sequence_number,status FROM igf_ap_td_item_inst_v WHERE
785: person_id = cp_person_id AND system_todo_type_code='PREFLEND';
786:
787: preflend_todo_item_rec preflend_todo_item_dtls%ROWTYPE;

Line 847: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

843:
844: END update_preflend_todo_status;
845:
846: PROCEDURE update_td_status(
847: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
848: p_item_sequence_number IN igf_ap_td_item_inst_all.item_sequence_number%TYPE,
849: p_status IN igf_ap_td_item_inst_all.status%TYPE,
850: p_clprl_id IN igf_sl_cl_pref_lenders.clprl_id%TYPE DEFAULT NULL,
851: p_return_status OUT NOCOPY VARCHAR2

Line 868: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

864: -------------------------------------------------------------------
865:
866: -- Get the item
867: CURSOR c_inst(
868: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
869: cp_item_sequence_number igf_ap_td_item_inst_all.item_sequence_number%TYPE
870: ) IS
871: SELECT td.ROWID row_id,
872: td.*

Line 896: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

892: lv_event_name VARCHAR2(4000);
893:
894: -- Get person number
895: CURSOR c_person_number(
896: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
897: ) IS
898: SELECT hz.party_number
899: FROM hz_parties hz,
900: igf_ap_fa_base_rec_all fa

Line 900: igf_ap_fa_base_rec_all fa

896: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
897: ) IS
898: SELECT hz.party_number
899: FROM hz_parties hz,
900: igf_ap_fa_base_rec_all fa
901: WHERE fa.person_id = hz.party_id
902: AND fa.base_id = cp_base_id;
903: l_person_number hz_parties.party_number%TYPE;
904:

Line 916: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

912: l_desc igf_ap_td_item_mst_all.description%TYPE;
913:
914: -- Get award year alternate code
915: CURSOR c_award_year(
916: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
917: ) IS
918: SELECT ca.alternate_code
919: FROM igs_ca_inst_all ca,
920: igf_ap_fa_base_rec_all fa

Line 920: igf_ap_fa_base_rec_all fa

916: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
917: ) IS
918: SELECT ca.alternate_code
919: FROM igs_ca_inst_all ca,
920: igf_ap_fa_base_rec_all fa
921: WHERE fa.base_id = cp_base_id
922: AND fa.ci_cal_type = ca.cal_type
923: AND fa.ci_sequence_number = ca.sequence_number;
924: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;