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_PACKNG_SUBFNS dependencies on IGF_AW_PACKAGING

Line 16: || when called from the Packaging process (igf_aw_packaging).

12: || Stafford loan limits setup through IGFAW021.fmb
13: || museshad 15-Jun-2005 Build# FA157 - Bug# 4382371.
14: || Added the parameters - l_awd_period, l_called_from.
15: || As of now, these parameters (defaultable) will get passed only
16: || when called from the Packaging process (igf_aw_packaging).
17: || Passed these paramaters to get_class_stnd()
18: || to get the class standing data from anticipated data, if
19: || actual data is not available.
20: || sjadhav 09-Nov-2004 corrected garde level override comparsion

Line 900: SELECT igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) start_dt

896:
897: CURSOR c_get_min_date(
898: cp_award_id igf_aw_award_all.award_id%TYPE
899: )IS
900: SELECT igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) start_dt
901: FROM igf_aw_awd_disb_v disb,
902: igf_aw_award_all awd
903: WHERE disb.award_id = cp_award_id
904: AND disb.award_id = awd.award_id

Line 905: ORDER BY igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number);

901: FROM igf_aw_awd_disb_v disb,
902: igf_aw_award_all awd
903: WHERE disb.award_id = cp_award_id
904: AND disb.award_id = awd.award_id
905: ORDER BY igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number);
906:
907: -- museshad (Bug# 4604393)
908: -- Get the start date of the earliest term in the (COA + DP) matching terms
909: CURSOR c_get_ear_term_st_date(

Line 914: SELECT igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ear_term_start_date

910: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
911: cp_adplans_id NUMBER
912: )
913: IS
914: SELECT igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ear_term_start_date
915: FROM
916: igf_aw_coa_term_tot_v coa_terms,
917: igf_aw_dp_terms dp_terms,
918: igf_aw_awd_dist_plans adplans

Line 925: ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ASC;

921: AND dp_terms.ld_sequence_number = coa_terms.ld_sequence_number
922: AND dp_terms.adplans_id = adplans.adplans_id
923: AND coa_terms.base_id = cp_base_id
924: AND dp_terms.adplans_id = cp_adplans_id
925: ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ASC;
926:
927: -- Get the start date of the earliest term in the DP matching terms
928: CURSOR c_get_ear_term_st_date_dp(
929: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

Line 932: SELECT igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ear_term_start_date

928: CURSOR c_get_ear_term_st_date_dp(
929: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
930: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
931: ) IS
932: SELECT igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ear_term_start_date
933: FROM igf_aw_dp_terms dp_terms,
934: igf_aw_awd_dist_plans adplans
935: WHERE dp_terms.adplans_id = adplans.adplans_id
936: AND dp_terms.adplans_id = cp_adplans_id

Line 937: ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ASC;

933: FROM igf_aw_dp_terms dp_terms,
934: igf_aw_awd_dist_plans adplans
935: WHERE dp_terms.adplans_id = adplans.adplans_id
936: AND dp_terms.adplans_id = cp_adplans_id
937: ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ASC;
938:
939: -- Gets start date of the eariest term in the award
940: CURSOR c_get_ear_term_st_date_awd(
941: cp_award_id igf_aw_award_all.award_id%TYPE

Line 943: SELECT igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) ear_term_start_date

939: -- Gets start date of the eariest term in the award
940: CURSOR c_get_ear_term_st_date_awd(
941: cp_award_id igf_aw_award_all.award_id%TYPE
942: ) IS
943: SELECT igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) ear_term_start_date
944: FROM igf_aw_awd_disb_all disb,
945: igf_aw_award_all awd
946: WHERE awd.award_id = cp_award_id
947: AND awd.award_id = disb.award_id

Line 948: ORDER BY igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) ASC;

944: FROM igf_aw_awd_disb_all disb,
945: igf_aw_award_all awd
946: WHERE awd.award_id = cp_award_id
947: AND awd.award_id = disb.award_id
948: ORDER BY igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) ASC;
949:
950: l_ear_term_start_date DATE;
951: l_pred_flag VARCHAR2(1);
952: -- museshad (Bug# 4604393)

Line 988: ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, awd_per.ld_cal_type, awd_per.ld_sequence_number) ASC;

984: fabase.base_id = cp_base_id AND
985: awd_per.award_prd_cd = cp_awd_per AND
986: ant_data.base_id = cp_base_id AND
987: ant_data.class_standing IS NOT NULL
988: ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, awd_per.ld_cal_type, awd_per.ld_sequence_number) ASC;
989:
990: l_get_ant_class_stnd_rec c_get_ant_class_stnd%ROWTYPE;
991:
992: -- Getting anticipated Prog type

Line 1021: ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, awd_per.ld_cal_type, awd_per.ld_sequence_number) ASC;

1017: fabase.base_id = cp_base_id AND
1018: awd_per.award_prd_cd = cp_awd_per AND
1019: ant_data.base_id = cp_base_id AND
1020: ant_data.program_type IS NOT NULL
1021: ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, awd_per.ld_cal_type, awd_per.ld_sequence_number) ASC;
1022:
1023: l_get_ant_prog_type_rec c_get_ant_prog_type%ROWTYPE;
1024:
1025: -- Get the award year Calendar details