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

Line 25: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

21:
22: g_unlock_level NUMBER;
23:
24: FUNCTION coa_amount(
25: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
26: p_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
27: p_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE
28: ) RETURN NUMBER AS
29: ------------------------------------------------------------------

Line 42: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

38: --Change History:
39: --Who When What
40: -------------------------------------------------------------------
41: CURSOR c_coa_amount(
42: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
43: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
44: cp_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE
45: ) IS
46: SELECT SUM(coa.amount)

Line 49: igf_ap_fa_base_rec_all fa,

45: ) IS
46: SELECT SUM(coa.amount)
47: FROM igf_aw_coa_itm_terms coa,
48: igf_aw_awd_prd_term trms,
49: igf_ap_fa_base_rec_all fa,
50: igf_aw_coa_items item
51: WHERE fa.base_id = coa.base_id
52: AND fa.ci_cal_type = trms.ci_cal_type
53: AND fa.ci_sequence_number = trms.ci_sequence_number

Line 68: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

64:
65: ln_coa NUMBER;
66:
67: CURSOR c_coa_amount_awd(
68: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
69: cp_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE
70: ) IS
71: SELECT SUM(coa.amount)
72: FROM igf_aw_coa_itm_terms coa,

Line 113: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

109:
110: END coa_amount;
111:
112: FUNCTION award_amount(
113: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
114: p_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
115: p_award_id igf_aw_award_all.award_id%TYPE DEFAULT NULL
116: ) RETURN NUMBER AS
117: ------------------------------------------------------------------

Line 131: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

127: --Who When What
128: -------------------------------------------------------------------
129:
130: CURSOR c_award_amount(
131: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
132: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
133: cp_award_id igf_aw_award_all.award_id%TYPE
134: ) IS
135: SELECT SUM(NVL(disb.disb_gross_amt, 0)) award_amount

Line 139: igf_ap_fa_base_rec_all fa

135: SELECT SUM(NVL(disb.disb_gross_amt, 0)) award_amount
136: FROM igf_aw_award_all awd,
137: igf_aw_awd_disb_all disb,
138: igf_aw_awd_prd_term aprd,
139: igf_ap_fa_base_rec_all fa
140: WHERE disb.award_id = awd.award_id
141: AND awd.base_id = cp_base_id
142: AND awd.base_id = fa.base_id
143: AND awd.award_status IN('OFFERED', 'ACCEPTED')

Line 155: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

151:
152: ln_award NUMBER;
153:
154: CURSOR c_award_amount_awd(
155: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
156: cp_award_id igf_aw_award_all.award_id%TYPE
157: ) IS
158: SELECT SUM(NVL(disb.disb_gross_amt, 0)) award_amount
159: FROM igf_aw_award_all awd,

Line 197: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

193:
194: END award_amount;
195:
196: FUNCTION isCoaLocked(
197: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
198: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
199: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
200: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
201: ) RETURN BOOLEAN AS

Line 217: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

213: -------------------------------------------------------------------
214:
215: -- Get item/term level lock
216: CURSOR c_item_term(
217: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
218: cp_item_code igf_aw_item.item_code%TYPE,
219: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
220: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
221: ) IS

Line 232: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

228: l_item_term c_item_term%ROWTYPE;
229:
230: -- Get item level lock
231: CURSOR c_item(
232: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
233: cp_item_code igf_aw_item.item_code%TYPE
234: ) IS
235: SELECT NVL(lock_flag,'N') lock_flag
236: FROM igf_aw_coa_items

Line 243: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

239: l_item c_item%ROWTYPE;
240:
241: -- Get base record level lock
242: CURSOR c_base(
243: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
244: ) IS
245: SELECT NVL(lock_coa_flag,'N') lock_coa_flag
246: FROM igf_ap_fa_base_rec_all
247: WHERE base_id = cp_base_id;

Line 246: FROM igf_ap_fa_base_rec_all

242: CURSOR c_base(
243: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
244: ) IS
245: SELECT NVL(lock_coa_flag,'N') lock_coa_flag
246: FROM igf_ap_fa_base_rec_all
247: WHERE base_id = cp_base_id;
248: l_base c_base%ROWTYPE;
249:
250: BEGIN

Line 340: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

336:
337: END isCoaLocked;
338:
339: PROCEDURE updateLock(
340: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
341: p_mode VARCHAR2,
342: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
343: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
344: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL

Line 348: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

344: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
345: );
346:
347: PROCEDURE doLockInternal(
348: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
349: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
350: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
351: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
352: ) AS

Line 379: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

375: updateLock(p_base_id,'Y',p_item_code,p_ld_cal_type,p_ld_sequence_number);
376: END doLockInternal;
377:
378: PROCEDURE doUnlockInternal(
379: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
380: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
381: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
382: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
383: ) AS

Line 410: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

406: updateLock(p_base_id,'N',p_item_code,p_ld_cal_type,p_ld_sequence_number);
407: END doUnlockInternal;
408:
409: PROCEDURE updateLock(
410: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
411: p_mode VARCHAR2,
412: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
413: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
414: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL

Line 430: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

426: --Who When What
427: -------------------------------------------------------------------
428:
429: CURSOR c_item_term(
430: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
431: cp_item_code igf_aw_item.item_code%TYPE,
432: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
433: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
434: ) IS

Line 445: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

441: AND ld_sequence_number = cp_ld_sequence_number;
442: l_item_term c_item_term%ROWTYPE;
443:
444: CURSOR c_item(
445: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
446: cp_item_code igf_aw_item.item_code%TYPE
447: ) IS
448: SELECT items.rowid row_id,
449: items.*

Line 456: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

452: AND item_code = cp_item_code;
453: l_item c_item%ROWTYPE;
454:
455: CURSOR c_base(
456: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
457: ) IS
458: SELECT fa.rowid row_id,
459: fa.*
460: FROM igf_ap_fa_base_rec_all fa

Line 460: FROM igf_ap_fa_base_rec_all fa

456: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
457: ) IS
458: SELECT fa.rowid row_id,
459: fa.*
460: FROM igf_ap_fa_base_rec_all fa
461: WHERE base_id = cp_base_id;
462: l_base c_base%ROWTYPE;
463:
464: CURSOR c_terms(

Line 465: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

461: WHERE base_id = cp_base_id;
462: l_base c_base%ROWTYPE;
463:
464: CURSOR c_terms(
465: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
466: cp_item_code igf_aw_item.item_code%TYPE
467: ) IS
468: SELECT terms.ld_cal_type,
469: terms.ld_sequence_number

Line 476: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

472: AND item_code = cp_item_code;
473:
474:
475: CURSOR c_items(
476: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
477: ) IS
478: SELECT items.item_code
479: FROM igf_aw_coa_items items
480: WHERE base_id = cp_base_id;

Line 578: igf_ap_fa_base_rec_pkg.update_row(

574: fnd_message.set_name('IGF','IGF_AW_BUDGET_LOCK');
575: fnd_file.put_line(fnd_file.log,RPAD(' ',4)||fnd_message.get);
576:
577:
578: igf_ap_fa_base_rec_pkg.update_row(
579: x_rowid => l_base.row_id,
580: x_base_id => l_base.base_id,
581: x_ci_cal_type => l_base.ci_cal_type,
582: x_person_id => l_base.person_id,

Line 811: igf_ap_fa_base_rec_pkg.update_row(

807: fnd_message.set_name('IGF','IGF_AW_BUDGET_UNLOCK');
808: fnd_file.put_line(fnd_file.log,RPAD(' ',8)||fnd_message.get);
809:
810:
811: igf_ap_fa_base_rec_pkg.update_row(
812: x_rowid => l_base.row_id,
813: x_base_id => l_base.base_id,
814: x_ci_cal_type => l_base.ci_cal_type,
815: x_person_id => l_base.person_id,

Line 951: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

947:
948: END updateLock;
949:
950: FUNCTION doLock(
951: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
952: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
953: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
954: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
955: ) RETURN VARCHAR2 AS

Line 993: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

989:
990: END doLock;
991:
992: FUNCTION doUnlock(
993: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
994: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
995: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
996: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
997: ) RETURN VARCHAR2 AS

Line 1045: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

1041:
1042: END doUnlock;
1043:
1044: PROCEDURE get_coa_months(
1045: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1046: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
1047: p_start_dt OUT NOCOPY DATE,
1048: p_end_dt OUT NOCOPY DATE,
1049: p_coa_months OUT NOCOPY NUMBER

Line 1064: cp_base_id igf_ap_fa_base_rec.base_id%TYPE,

1060: --Change History:
1061: --Who When What
1062: -------------------------------------------------------------------
1063: CURSOR c_terms(
1064: cp_base_id igf_ap_fa_base_rec.base_id%TYPE,
1065: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1066: ) IS
1067: SELECT coa.ld_cal_type,
1068: coa.ld_sequence_number

Line 1070: igf_ap_fa_base_rec_all fa,

1066: ) IS
1067: SELECT coa.ld_cal_type,
1068: coa.ld_sequence_number
1069: FROM igf_aw_awd_prd_term ap,
1070: igf_ap_fa_base_rec_all fa,
1071: igf_aw_coa_itm_terms coa
1072: WHERE fa.base_id = cp_base_id
1073: AND fa.ci_cal_type = ap.ci_cal_type
1074: AND fa.ci_sequence_number = ap.ci_sequence_number

Line 1082: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

1078: AND ap.award_prd_cd = cp_awd_prd_code
1079: GROUP BY coa.ld_cal_type,coa.ld_sequence_number;
1080:
1081: CURSOR c_terms_awd(
1082: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1083: ) IS
1084: SELECT coa.ld_cal_type,
1085: coa.ld_sequence_number
1086: FROM igf_aw_coa_itm_terms coa

Line 1091: cp_base_id igf_ap_fa_base_rec.base_id%TYPE

1087: WHERE coa.base_id = cp_base_id
1088: GROUP BY coa.ld_cal_type,coa.ld_sequence_number;
1089:
1090: CURSOR get_round_off(
1091: cp_base_id igf_ap_fa_base_rec.base_id%TYPE
1092: ) IS
1093: SELECT num_days_divisor, roundoff_fact
1094: FROM igf_ap_efc_v efc,
1095: igf_ap_fa_base_rec_all fabase

Line 1095: igf_ap_fa_base_rec_all fabase

1091: cp_base_id igf_ap_fa_base_rec.base_id%TYPE
1092: ) IS
1093: SELECT num_days_divisor, roundoff_fact
1094: FROM igf_ap_efc_v efc,
1095: igf_ap_fa_base_rec_all fabase
1096: WHERE efc.ci_cal_type = fabase.ci_cal_type
1097: AND efc.ci_sequence_number = fabase.ci_sequence_number
1098: AND fabase.base_id = cp_base_id;
1099: lv_round_off_rec get_round_off%ROWTYPE;

Line 1165: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

1161: p_coa_months := l_no_of_months;
1162: END get_coa_months;
1163:
1164: FUNCTION coa_duration(
1165: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1166: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
1167: ) RETURN NUMBER AS
1168: ------------------------------------------------------------------
1169: --Created by : veramach, Oracle India

Line 1218: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

1214: END IF;
1215: END canUseAnticipVal;
1216:
1217: FUNCTION getBaseDetails(
1218: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1219: p_ld_cal_type igs_ca_inst.cal_type%TYPE,
1220: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1221: ) RETURN base_details AS
1222: ------------------------------------------------------------------

Line 1249: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

1245: l_base_det base_details;
1246:
1247: -- Get person_id
1248: CURSOR c_person_id(
1249: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1250: ) IS
1251: SELECT person_id
1252: FROM igf_ap_fa_base_rec_all
1253: WHERE base_id = cp_base_id;

Line 1252: FROM igf_ap_fa_base_rec_all

1248: CURSOR c_person_id(
1249: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1250: ) IS
1251: SELECT person_id
1252: FROM igf_ap_fa_base_rec_all
1253: WHERE base_id = cp_base_id;
1254:
1255: -- Get anticipated values
1256: CURSOR c_anticip(

Line 1257: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

1253: WHERE base_id = cp_base_id;
1254:
1255: -- Get anticipated values
1256: CURSOR c_anticip(
1257: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1258: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1259: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1260: ) IS
1261: SELECT org_unit_cd,

Line 1444: cp_base_id igf_ap_fa_base_rec.base_id%TYPE

1440:
1441: l_term_duration NUMBER;
1442:
1443: CURSOR get_round_off(
1444: cp_base_id igf_ap_fa_base_rec.base_id%TYPE
1445: ) IS
1446: SELECT num_days_divisor, roundoff_fact
1447: FROM igf_ap_efc_v efc,
1448: igf_ap_fa_base_rec_all fabase

Line 1448: igf_ap_fa_base_rec_all fabase

1444: cp_base_id igf_ap_fa_base_rec.base_id%TYPE
1445: ) IS
1446: SELECT num_days_divisor, roundoff_fact
1447: FROM igf_ap_efc_v efc,
1448: igf_ap_fa_base_rec_all fabase
1449: WHERE efc.ci_cal_type = fabase.ci_cal_type
1450: AND efc.ci_sequence_number = fabase.ci_sequence_number
1451: AND fabase.base_id = cp_base_id;
1452: lv_round_off_rec get_round_off%ROWTYPE;

Line 1867: igf_ap_fa_base_rec_all fa,

1863: ) IS
1864: SELECT batch.ci_cal_type,
1865: batch.ci_sequence_number
1866: FROM igf_ap_batch_aw_map_all batch,
1867: igf_ap_fa_base_rec_all fa,
1868: igf_aw_coa_items coa
1869: WHERE batch.award_year_status_code = 'O'
1870: AND fa.ci_cal_type = batch.ci_cal_type
1871: AND fa.ci_sequence_number = batch.ci_sequence_number

Line 1956: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

1952: END ins_coa_todo;
1953:
1954: -- This procedure is to set and return the Awarding Process Status
1955: FUNCTION set_awd_proc_status(
1956: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1957: p_award_prd_code IN igf_aw_award_prd.award_prd_cd%TYPE DEFAULT NULL
1958: ) RETURN VARCHAR2 AS
1959: --------------------------------------------------------------------------------
1960: -- Created by : ridas, Oracle India

Line 1969: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE ,

1965: --------------------------------------------------------------------------------
1966:
1967: --Cursor to filter out those awards that fall within the awarding period
1968: CURSOR c_award_prd(
1969: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE ,
1970: c_award_prd_code igf_aw_award_prd.award_prd_cd%TYPE
1971: ) IS
1972: SELECT awd.rowid row_id,
1973: awd.*

Line 1985: FROM igf_ap_fa_base_rec_all fab,

1981: WHERE disb.award_id = awd.award_id
1982: MINUS
1983: SELECT apt.ld_cal_type,
1984: apt.ld_sequence_number
1985: FROM igf_ap_fa_base_rec_all fab,
1986: igf_aw_awd_prd_term apt
1987: WHERE fab.base_id = c_base_id AND
1988: apt.ci_cal_type = fab.ci_cal_type AND
1989: apt.ci_sequence_number = fab.ci_sequence_number AND

Line 1996: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE

1992:
1993:
1994: --Cursor to fetch all the awards for the base id
1995: CURSOR c_awards(
1996: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1997: ) IS
1998: SELECT awd.rowid row_id,
1999: awd.*
2000: FROM igf_aw_award_all awd