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

Line 6: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE

2: /* $Header: IGFAW12B.pls 120.23 2006/08/04 07:40:11 veramach ship $ */
3:
4:
5: FUNCTION get_plan_disb_count(p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
6: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
7: ) RETURN NUMBER IS
8: --
9: ------------------------------------------------------------------
10: -- Created by :

Line 38: igf_aw_awd_prd_term aprd

34: SELECT COUNT(*) common_terms
35: FROM igf_aw_awd_dist_plans adplans,
36: igf_aw_dp_terms terms,
37: igf_aw_dp_teach_prds teach_periods,
38: igf_aw_awd_prd_term aprd
39: WHERE terms.adplans_id = p_adplans_id
40: AND terms.adterms_id = teach_periods.adterms_id
41: AND terms.ld_cal_type = aprd.ld_cal_type
42: AND terms.ld_sequence_number = terms.ld_sequence_number

Line 1006: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE

1002: p_offered_amt IN igf_aw_award.offered_amt%TYPE,
1003: p_award_status IN igf_aw_award.award_status%TYPE,
1004: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
1005: p_method_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1006: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
1007: )
1008: AS
1009: /*
1010: || Created By :

Line 1064: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

1060: --
1061: CURSOR c_auto_disb(
1062: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1063: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1064: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1065: ) IS
1066: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1067: terms.ld_cal_type ld_cal_type,
1068: terms.ld_sequence_number ld_sequence_number,

Line 1085: igf_aw_awd_prd_term aprd

1081: FROM igf_aw_coa_itm_terms
1082: WHERE base_id = cp_base_id
1083: GROUP BY base_id,ld_cal_type, ld_sequence_number) coaterms,
1084: igf_aw_awd_dist_plans dp,
1085: igf_aw_awd_prd_term aprd
1086: WHERE terms.adplans_id = cp_adplans_id
1087: AND terms.adterms_id = teach_periods.adterms_id
1088: AND coaterms.ld_cal_type = terms.ld_cal_type
1089: AND coaterms.ld_sequence_number = terms.ld_sequence_number

Line 1109: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

1105:
1106: CURSOR c_auto_disb_wcoa(
1107: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1108: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1109: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1110: ) IS
1111: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1112: terms.ld_cal_type ld_cal_type,
1113: terms.ld_sequence_number ld_sequence_number,

Line 1123: igf_aw_awd_prd_term aprd,

1119: teach_periods.credit_points_num min_credit_points,
1120: teach_periods.attendance_type_code attendance_type_code
1121: FROM igf_aw_dp_terms terms,
1122: igf_aw_dp_teach_prds_v teach_periods,
1123: igf_aw_awd_prd_term aprd,
1124: igf_aw_awd_dist_plans dp
1125: WHERE terms.adplans_id = cp_adplans_id
1126: AND terms.adterms_id = teach_periods.adterms_id
1127: AND terms.ld_cal_type = aprd.ld_cal_type

Line 1144: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

1140: CURSOR c_auto_disb_equal(
1141: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1142: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1143: cp_num_terms NUMBER,
1144: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1145: ) IS
1146: SELECT NVL(igf_aw_packaging.get_date_instance (cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1147: terms.ld_cal_type ld_cal_type,
1148: terms.ld_sequence_number ld_sequence_number,

Line 1165: igf_aw_awd_prd_term aprd

1161: FROM igf_aw_coa_itm_terms
1162: WHERE base_id = cp_base_id
1163: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms,
1164: igf_aw_awd_dist_plans dp,
1165: igf_aw_awd_prd_term aprd
1166: WHERE terms.adplans_id = cp_adplans_id
1167: AND terms.adterms_id = teach_periods.adterms_id
1168: AND coaterms.ld_cal_type = terms.ld_cal_type
1169: AND coaterms.ld_sequence_number = terms.ld_sequence_number

Line 1186: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

1182: CURSOR c_auto_disb_equal_wcoa(
1183: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1184: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1185: cp_num_terms NUMBER,
1186: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1187: ) IS
1188: SELECT NVL(igf_aw_packaging.get_date_instance (cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1189: terms.ld_cal_type ld_cal_type,
1190: terms.ld_sequence_number ld_sequence_number,

Line 1201: igf_aw_awd_prd_term aprd

1197: teach_periods.attendance_type_code attendance_type_code
1198: FROM igf_aw_dp_terms terms,
1199: igf_aw_dp_teach_prds_v teach_periods,
1200: igf_aw_awd_dist_plans dp,
1201: igf_aw_awd_prd_term aprd
1202: WHERE terms.adplans_id = cp_adplans_id
1203: AND terms.adterms_id = teach_periods.adterms_id
1204: AND terms.adplans_id = dp.adplans_id
1205: AND dp.cal_type = aprd.ci_cal_type

Line 1218: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

1214: CURSOR c_auto_disb_coa_match(
1215: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1216: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1217: cp_total_coa_amount NUMBER,
1218: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1219: ) IS
1220: SELECT NVL(igf_aw_packaging.get_date_instance (cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1221: terms.ld_cal_type ld_cal_type,
1222: terms.ld_sequence_number ld_sequence_number,

Line 1239: igf_aw_awd_prd_term aprd

1235: amount coa_term_amount
1236: FROM igf_aw_coa_term_tot_v
1237: WHERE base_id = cp_base_id) coaterms,
1238: igf_aw_awd_dist_plans dp,
1239: igf_aw_awd_prd_term aprd
1240: WHERE terms.adplans_id = cp_adplans_id
1241: AND terms.adterms_id = teach_periods.adterms_id
1242: AND coaterms.ld_cal_type = terms.ld_cal_type
1243: AND coaterms.ld_sequence_number = terms.ld_sequence_number

Line 1440: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

1436: -- Get COA
1437: CURSOR c_coa(
1438: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1439: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1440: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1441: ) IS
1442: SELECT SUM(amount) coa
1443: FROM igf_aw_coa_itm_terms coa_terms,
1444: (SELECT ld_cal_type,

Line 1450: igf_aw_awd_prd_term aprd

1446: FROM igf_aw_dp_terms
1447: WHERE adplans_id = cp_adplans_id
1448: )dist_terms,
1449: igf_ap_fa_base_rec_all fa,
1450: igf_aw_awd_prd_term aprd
1451: WHERE dist_terms.ld_cal_type = coa_terms.ld_cal_type
1452: AND dist_terms.ld_sequence_number = coa_terms.ld_sequence_number
1453: AND coa_terms.base_id = cp_base_id
1454: AND coa_terms.base_id = fa.base_id

Line 1469: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

1465: --
1466: CURSOR cur_terms_count(
1467: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1468: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1469: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1470: ) IS
1471: SELECT COUNT(*)
1472: FROM igf_aw_dp_terms terms,
1473: (SELECT base_id,

Line 1479: igf_aw_awd_prd_term aprd,

1475: ld_sequence_number
1476: FROM igf_aw_coa_itm_terms
1477: WHERE base_id = cp_base_id
1478: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms,
1479: igf_aw_awd_prd_term aprd,
1480: igf_ap_fa_base_rec_all fa
1481: WHERE terms.adplans_id = cp_adplans_id
1482: AND coaterms.ld_cal_type = terms.ld_cal_type
1483: AND coaterms.ld_sequence_number = terms.ld_sequence_number

Line 1496: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

1492: l_terms_count NUMBER := 0;
1493:
1494: CURSOR cur_terms_count_wcoa(
1495: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1496: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1497: )
1498: IS
1499: SELECT COUNT(*)
1500: FROM igf_aw_dp_terms terms,

Line 1502: igf_aw_awd_prd_term aprd

1498: IS
1499: SELECT COUNT(*)
1500: FROM igf_aw_dp_terms terms,
1501: igf_aw_awd_dist_plans dp,
1502: igf_aw_awd_prd_term aprd
1503: WHERE terms.adplans_id = cp_adplans_id
1504: AND terms.adplans_id = dp.adplans_id
1505: AND dp.cal_type = aprd.ci_cal_type
1506: AND dp.sequence_number = aprd.ci_sequence_number

Line 3151: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE,

3147: p_person_number IN igf_aw_award_v.person_number%TYPE,
3148: p_award_id IN igf_aw_award_all.award_id%TYPE,
3149: p_act_isir IN VARCHAR2,
3150: p_ld_seq_number IN NUMBER,
3151: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE,
3152: p_chk_holds OUT NOCOPY VARCHAR2)
3153: RETURN VARCHAR2
3154: IS
3155:

Line 4362: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE

4358: PROCEDURE get_common_perct(
4359: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
4360: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
4361: p_perct OUT NOCOPY NUMBER,
4362: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
4363: ) AS
4364: ------------------------------------------------------------------
4365: --Created by : veramach, Oracle India
4366: --Date created: 11-NOV-2003

Line 4398: igf_aw_awd_prd_term aprd,

4394: CURSOR cur_get_perct_awd IS
4395: SELECT SUM((teach_periods.tp_perct_num * terms.ld_perct_num)/100) perct
4396: FROM igf_aw_dp_terms terms,
4397: igf_aw_dp_teach_prds teach_periods,
4398: igf_aw_awd_prd_term aprd,
4399: igf_ap_fa_base_rec_all fa,
4400: (SELECT base_id,
4401: ld_cal_type,
4402: ld_sequence_number

Line 4437: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE

4433: PROCEDURE check_common_terms(
4434: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
4435: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
4436: p_result OUT NOCOPY NUMBER,
4437: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
4438: ) AS
4439: ------------------------------------------------------------------
4440: --Created by : veramach, Oracle India
4441: --Date created: 11-NOV-2003

Line 4482: igf_aw_awd_prd_term aprd

4478: FROM igf_aw_coa_itm_terms
4479: WHERE base_id = p_base_id
4480: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms,
4481: igf_ap_fa_base_rec_all fa,
4482: igf_aw_awd_prd_term aprd
4483: WHERE terms.adplans_id = p_adplans_id
4484: AND terms.adterms_id = teach_periods.adterms_id
4485: AND coaterms.ld_cal_type = terms.ld_cal_type
4486: AND coaterms.ld_sequence_number = terms.ld_sequence_number

Line 4618: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL

4614: END update_award_app_trans;
4615:
4616: FUNCTION check_coa(
4617: p_base_id IN NUMBER,
4618: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
4619: ) RETURN BOOLEAN IS
4620: ------------------------------------------------------------------
4621: -- Created by : sjadhav, Oracle India
4622: -- Date created: 4-Dec-2003