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_PACKAGING dependencies on IGF_AW_AWD_PRD_TERM

Line 346: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

342:
343: FUNCTION check_disb(
344: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
345: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
346: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
347: ) RETURN BOOLEAN AS
348: ------------------------------------------------------------------
349: --Created by : veramach, Oracle India
350: --Date created: 21-Jun-2004

Line 362: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

358: --Who When What
359: -------------------------------------------------------------------
360: CURSOR c_term_wcoa(
361: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
362: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
363: ) IS
364: SELECT COUNT(tp.adteach_id) tp,
365: COUNT(DISTINCT terms.adterms_id) terms
366: FROM igf_aw_dp_teach_prds tp,

Line 369: igf_aw_awd_prd_term aprd

365: COUNT(DISTINCT terms.adterms_id) terms
366: FROM igf_aw_dp_teach_prds tp,
367: igf_aw_dp_terms terms,
368: igf_aw_awd_dist_plans dp,
369: igf_aw_awd_prd_term aprd
370: WHERE terms.adterms_id = tp.adterms_id
371: AND terms.adplans_id = cp_adplans_id
372: AND terms.adplans_id = dp.adplans_id
373: AND dp.cal_type = aprd.ci_cal_type

Line 382: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

378:
379: CURSOR c_term(
380: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
381: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
382: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
383: ) IS
384: SELECT COUNT(tp.adteach_id) tp,
385: COUNT(DISTINCT terms.adterms_id) terms
386: FROM igf_aw_dp_teach_prds tp,

Line 394: igf_aw_awd_prd_term aprd,

390: ld_sequence_number
391: FROM igf_aw_coa_itm_terms
392: WHERE base_id = cp_base_id
393: GROUP BY base_id, ld_cal_type, ld_sequence_number) coaterms,
394: igf_aw_awd_prd_term aprd,
395: igf_aw_awd_dist_plans dp
396: WHERE terms.adterms_id = tp.adterms_id
397: AND terms.adplans_id = cp_adplans_id
398: AND coaterms.ld_cal_type = terms.ld_cal_type

Line 747: FROM igf_aw_awd_prd_term apt

743: WHERE disb.award_id = awd.award_id
744: MINUS
745: SELECT ld_cal_type,
746: ld_sequence_number
747: FROM igf_aw_awd_prd_term apt
748: WHERE apt.ci_cal_type = l_ci_cal_type
749: AND apt.ci_sequence_number = l_ci_sequence_number
750: AND apt.award_prd_cd = p_award_prd_cd);
751:

Line 4364: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

4360: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
4361: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4362: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
4363: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
4364: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
4365: ) RETURN BOOLEAN AS
4366: ------------------------------------------------------------------
4367: --Created by : veramach, Oracle India
4368: --Date created: 13-Oct-2004

Line 4384: igf_aw_awd_prd_term aprd

4380: CURSOR c_awd IS
4381: SELECT 'x'
4382: FROM igf_aw_award_all awd,
4383: igf_aw_awd_disb_all disb,
4384: igf_aw_awd_prd_term aprd
4385: WHERE awd.fund_id = p_fund_id
4386: AND awd.base_id = p_base_id
4387: AND awd.award_status IN ('ACCEPTED','OFFERED','CANCELLED')
4388: AND awd.award_id = disb.award_id

Line 4522: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

4518: FUNCTION doesAwardSpanOutsideAP(
4519: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
4520: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4521: p_award_id igf_aw_award_all.award_id%TYPE,
4522: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
4523: ) RETURN BOOLEAN AS
4524: ------------------------------------------------------------------
4525: --Created by : veramach, Oracle India
4526: --Date created: 13-Oct-2004

Line 4547: FROM igf_aw_awd_prd_term

4543: WHERE award_id = p_award_id
4544: AND (ld_cal_type, ld_sequence_number) IN(
4545: SELECT ld_cal_type,
4546: ld_sequence_number
4547: FROM igf_aw_awd_prd_term
4548: WHERE ci_cal_type = p_ci_cal_type
4549: AND ci_sequence_number = p_ci_sequence_number
4550: AND award_prd_cd = p_awd_prd_code))
4551: AND EXISTS(

Line 4558: FROM igf_aw_awd_prd_term

4554: WHERE award_id = p_award_id
4555: AND (ld_cal_type, ld_sequence_number) NOT IN(
4556: SELECT ld_cal_type,
4557: ld_sequence_number
4558: FROM igf_aw_awd_prd_term
4559: WHERE ci_cal_type = p_ci_cal_type
4560: AND ci_sequence_number = p_ci_sequence_number
4561: AND award_prd_cd = p_awd_prd_code));
4562: l_terms c_terms%ROWTYPE;

Line 4859: p_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,

4855:
4856: PROCEDURE load_awards(
4857: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
4858: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4859: p_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
4860: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
4861: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
4862: p_lock_award_flag igf_aw_fund_mast_all.lock_award_flag%TYPE,
4863: p_re_pkg_verif_flag igf_aw_fund_mast_all.re_pkg_verif_flag%TYPE,

Line 4888: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,

4884: -- Get awards from a fund
4885: CURSOR c_awds(
4886: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
4887: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4888: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
4889: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
4890: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE
4891: ) IS
4892: SELECT awd.award_id,

Line 4915: igf_aw_awd_prd_term aprd

4911: AND awd.award_id IN(
4912: SELECT DISTINCT awd.award_id
4913: FROM igf_aw_award_all awd,
4914: igf_aw_awd_disb_all disb,
4915: igf_aw_awd_prd_term aprd
4916: WHERE awd.fund_id = cp_fund_id
4917: AND awd.base_id = cp_base_id
4918: AND awd.award_id = disb.award_id
4919: AND disb.ld_cal_type = aprd.ld_cal_type

Line 5736: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

5732: CURSOR c_dp_ap(
5733: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
5734: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
5735: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
5736: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
5737: ) IS
5738: SELECT 'x'
5739: FROM dual
5740: WHERE EXISTS (

Line 5748: FROM igf_aw_awd_prd_term

5744:
5745: MINUS
5746:
5747: SELECT ld_cal_type,ld_sequence_number
5748: FROM igf_aw_awd_prd_term
5749: WHERE ci_cal_type = cp_ci_cal_type
5750: AND ci_sequence_number = cp_ci_sequence_number
5751: AND award_prd_cd = cp_award_prd_code
5752: );

Line 5757: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,

5753: l_dp_ap c_dp_ap%ROWTYPE;
5754:
5755: CURSOR c_other_awards(
5756: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5757: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
5758: cp_group_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5759: cp_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,
5760: cp_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE
5761: ) IS

Line 5769: igf_aw_awd_prd_term aprd

5765: fmast.donot_repkg_if_code
5766: FROM igf_aw_award_all awd,
5767: igf_aw_fund_mast_all fmast,
5768: igf_aw_awd_disb_all disb,
5769: igf_aw_awd_prd_term aprd
5770: WHERE fmast.fund_id = awd.fund_id
5771: AND awd.base_id = cp_base_id
5772: AND awd.award_id = disb.award_id
5773: AND disb.ld_cal_type = aprd.ld_cal_type

Line 5806: cp_awd_per igf_aw_awd_prd_term.award_prd_cd%TYPE

5802: CURSOR c_get_ant_prog(
5803: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
5804: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
5805: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5806: cp_awd_per igf_aw_awd_prd_term.award_prd_cd%TYPE
5807: )
5808: IS
5809: SELECT ant_data.program_cd prog,
5810: ant_data.ld_cal_type load_cal_type,

Line 5813: igf_aw_awd_prd_term awd_per,

5809: SELECT ant_data.program_cd prog,
5810: ant_data.ld_cal_type load_cal_type,
5811: ant_data.ld_sequence_number load_seq_num
5812: FROM
5813: igf_aw_awd_prd_term awd_per,
5814: igs_ca_inst_all cal_inst,
5815: igf_ap_fa_ant_data ant_data,
5816: igs_ps_ver prog
5817: WHERE

Line 6647: x_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

6643: CURSOR cur_new_awards(
6644: x_fund_code igf_aw_fund_cat.fund_code%TYPE,
6645: x_base_id igf_aw_award_t.base_id%TYPE,
6646: x_process_id igf_aw_award_t.base_id%TYPE,
6647: x_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
6648: ) IS
6649: SELECT COUNT(awdt.fund_id) ftotal
6650: FROM igf_aw_award_t awdt,
6651: igf_aw_fund_mast_all fmast,

Line 6653: igf_aw_awd_prd_term aprd

6649: SELECT COUNT(awdt.fund_id) ftotal
6650: FROM igf_aw_award_t awdt,
6651: igf_aw_fund_mast_all fmast,
6652: igf_aw_dp_terms adterms,
6653: igf_aw_awd_prd_term aprd
6654: WHERE fmast.fund_code = x_fund_code
6655: AND awdt.base_id = x_base_id
6656: AND awdt.process_id = x_process_id
6657: AND awdt.fund_id = fmast.fund_id

Line 6673: x_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

6669:
6670: CURSOR cur_prior_awards(
6671: x_fund_code igf_aw_fund_cat.fund_code%TYPE,
6672: x_base_id igf_aw_award_t.base_id%TYPE,
6673: x_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
6674: ) IS
6675: SELECT COUNT(fmast.fund_code) ftotal
6676: FROM igf_aw_award_all awd,
6677: igf_aw_awd_disb_all disb,

Line 6679: igf_aw_awd_prd_term aprd

6675: SELECT COUNT(fmast.fund_code) ftotal
6676: FROM igf_aw_award_all awd,
6677: igf_aw_awd_disb_all disb,
6678: igf_aw_fund_mast_all fmast,
6679: igf_aw_awd_prd_term aprd
6680: WHERE fmast.fund_code = x_fund_code
6681: AND awd.base_id = x_base_id
6682: AND awd.fund_id = fmast.fund_id
6683: AND awd.award_id = disb.award_id

Line 7535: p_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,

7531:
7532: FUNCTION get_award_process_status(
7533: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
7534: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
7535: p_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
7536: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
7537: ) RETURN VARCHAR2 AS
7538: ------------------------------------------------------------------
7539: --Created by : veramach, Oracle India

Line 7585: FROM igf_aw_awd_prd_term apt

7581: WHERE disb.award_id = awd.award_id
7582: MINUS
7583: SELECT ld_cal_type,
7584: ld_sequence_number
7585: FROM igf_aw_awd_prd_term apt
7586: WHERE apt.ci_cal_type = p_ci_cal_type
7587: AND apt.ci_sequence_number = p_ci_sequence_number
7588: AND apt.award_prd_cd = p_award_prd_code));
7589: l_award_process_status igf_aw_award_all.awd_proc_status_code%TYPE;

Line 12010: igf_aw_awd_prd_term aprd

12006: FROM igf_aw_coa_itm_terms
12007: WHERE base_id = cp_base_id
12008: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms,
12009: igf_aw_awd_dist_plans adplans,
12010: igf_aw_awd_prd_term aprd
12011: WHERE terms.adplans_id = cp_adplans_id
12012: AND coaterms.ld_cal_type = terms.ld_cal_type
12013: AND coaterms.ld_sequence_number = terms.ld_sequence_number
12014: AND coaterms.base_id = cp_base_id

Line 12063: igf_aw_awd_prd_term aprd

12059: SELECT SUM(amount) coa
12060: FROM igf_aw_coa_itm_terms coa_terms,
12061: igf_aw_dp_terms terms,
12062: igf_aw_awd_dist_plans adplans,
12063: igf_aw_awd_prd_term aprd
12064: WHERE terms.ld_cal_type = coa_terms.ld_cal_type
12065: AND terms.ld_sequence_number = coa_terms.ld_sequence_number
12066: AND coa_terms.base_id = cp_base_id
12067: AND terms.adplans_id = cp_adplans_id