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

Line 65: -- igf_ap_fa_base_rec_pkg.update_row call.

61: -- igf_aw_award_pkg.update_row
62: --------------------------------------------------------------------------------------
63: -- ugummall 25-SEP-2003 FA 126 - Multiple FA Offices
64: -- added new parameter assoc_org_num to
65: -- igf_ap_fa_base_rec_pkg.update_row call.
66: --------------------------------------------------------------------------------------
67: -- bkkumar 04-jun-2003 Bug 2858504 Added legacy_record_flag
68: -- and award_number_txt in the table
69: -- handler calls for igf_aw_award_pkg.update_row

Line 818: p_base_id in igf_ap_fa_base_rec_all.base_id%TYPE,

814: END update_disb;
815:
816:
817: PROCEDURE update_fabase_awds(
818: p_base_id in igf_ap_fa_base_rec_all.base_id%TYPE,
819: p_pack_status igf_ap_fa_base_rec.packaging_status%TYPE
820: ) IS
821: /*
822: || Created By : cdcruz

Line 819: p_pack_status igf_ap_fa_base_rec.packaging_status%TYPE

815:
816:
817: PROCEDURE update_fabase_awds(
818: p_base_id in igf_ap_fa_base_rec_all.base_id%TYPE,
819: p_pack_status igf_ap_fa_base_rec.packaging_status%TYPE
820: ) IS
821: /*
822: || Created By : cdcruz
823: || Created On : 29-JAN-2001

Line 831: || igf_ap_fa_base_rec_pkg.update_row

827: || Who When What
828: || (reverse chronological order - newest change first)
829: || rasahoo 27-NOV-2003 FA 128 - ISIR update 2004-05
830: || added new parameter award_fmly_contribution_type to
831: || igf_ap_fa_base_rec_pkg.update_row
832: ||
833: || ugummall 25-SEP-2003 FA 126 - Multiple FA Offices
834: || added new parameter assoc_org_num to
835: || igf_ap_fa_base_rec_pkg.update_row call.

Line 835: || igf_ap_fa_base_rec_pkg.update_row call.

831: || igf_ap_fa_base_rec_pkg.update_row
832: ||
833: || ugummall 25-SEP-2003 FA 126 - Multiple FA Offices
834: || added new parameter assoc_org_num to
835: || igf_ap_fa_base_rec_pkg.update_row call.
836: ||
837: || brajendr 18-Dec-2002 Bug # 2691832
838: || Modified the logic for updating the Packaging Status.
839: ||

Line 859: CURSOR c_stud_det ( x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

855: AND award_status NOT IN( 'CANCELLED', 'DECLINED','SIMULATED' ) ;
856:
857: l_pkg_tot c_pkg_tot%rowtype ;
858:
859: CURSOR c_stud_det ( x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
860: SELECT fabase.*
861: FROM igf_ap_fa_base_rec fabase
862: WHERE fabase.base_id = x_base_id ;
863:

Line 861: FROM igf_ap_fa_base_rec fabase

857: l_pkg_tot c_pkg_tot%rowtype ;
858:
859: CURSOR c_stud_det ( x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
860: SELECT fabase.*
861: FROM igf_ap_fa_base_rec fabase
862: WHERE fabase.base_id = x_base_id ;
863:
864: l_stud_det c_stud_det%rowtype ;
865:

Line 917: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','Updating igf_ap_fa_base_rec');

913: l_stud_det.total_package_accepted := l_pkg_tot.accepted_amt ;
914: l_stud_det.total_package_offered := l_pkg_tot.offered_amt ;
915:
916: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
917: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','Updating igf_ap_fa_base_rec');
918: END IF;
919: igf_ap_fa_base_rec_pkg.update_row(
920: x_rowid => l_stud_det.row_id,
921: x_base_id => l_stud_det.base_id,

Line 919: igf_ap_fa_base_rec_pkg.update_row(

915:
916: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
917: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','Updating igf_ap_fa_base_rec');
918: END IF;
919: igf_ap_fa_base_rec_pkg.update_row(
920: x_rowid => l_stud_det.row_id,
921: x_base_id => l_stud_det.base_id,
922: x_ci_cal_type => l_stud_det.ci_cal_type,
923: x_person_id => l_stud_det.person_id,

Line 1837: ( p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,

1833:
1834: END check_number_format;
1835:
1836: PROCEDURE depend_stat_2001
1837: ( p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1838: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
1839: p_method_code IN VARCHAR2,
1840: p_category OUT NOCOPY NUMBER,
1841: p_dependency_status OUT NOCOPY VARCHAR2)

Line 1893: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,

1889: PROCEDURE get_notification_status (
1890: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1891: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1892: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1893: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1894: p_notification_status_code OUT NOCOPY igf_aw_award_all.notification_status_code%TYPE,
1895: p_notification_status_date OUT NOCOPY igf_aw_award_all.notification_status_date%TYPE
1896: ) AS
1897: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS

Line 1901: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

1897: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
1898: CURSOR c_process_status (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1899: cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1900: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
1901: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1902: IS
1903: SELECT TO_CHAR(MIN(status_order)) min_award_status, MAX(notification_status_date) notification_status_date
1904: FROM
1905: (SELECT

Line 1986: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,

1982: PROCEDURE update_notification_status (
1983: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1984: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1985: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1986: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1987: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,
1988: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,
1989: p_called_from IN VARCHAR2
1990: ) AS

Line 1995: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

1991: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
1992: CURSOR c_awards (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1993: cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1994: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
1995: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1996: IS
1997: SELECT
1998: awd.award_id
1999: FROM

Line 2199: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,

2195: || Who When What
2196: || (reverse chronological order - newest change first)
2197: */
2198: FUNCTION is_fund_locked_for_awd_period (
2199: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2200: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2201: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
2202: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2203: p_fund_id IN igf_aw_award_all.fund_id%TYPE

Line 2206: cp_base_id IN igf_ap_fa_base_rec_all.base_id%type,

2202: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2203: p_fund_id IN igf_aw_award_all.fund_id%TYPE
2204: ) RETURN BOOLEAN AS
2205: CURSOR locked_award_count_cur (
2206: cp_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2207: cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2208: cp_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
2209: cp_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2210: cp_fund_id IN igf_aw_award_all.fund_id%TYPE