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_CALC dependencies on IGF_AW_COA_ITM_TERMS

Line 230: FROM igf_aw_coa_itm_terms

226: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
227: c_process_id NUMBER
228: ) IS
229: SELECT DISTINCT ld_cal_type,ld_sequence_number
230: FROM igf_aw_coa_itm_terms
231: WHERE base_id = c_base_id
232: MINUS
233: SELECT DISTINCT ld_cal_type,ld_sequence_number
234: FROM igf_aw_award_t

Line 249: FROM igf_aw_coa_itm_terms

245: FROM igf_aw_award_t
246: WHERE process_id = c_process_id
247: MINUS
248: SELECT DISTINCT ld_cal_type,ld_sequence_number
249: FROM igf_aw_coa_itm_terms
250: WHERE base_id = c_base_id;
251:
252: c_cal_chk_rec1 c_load_cal_chk1%ROWTYPE;
253:

Line 310: FROM igf_aw_coa_itm_terms

306: cp_item_code igf_aw_coa_items.item_code%TYPE
307: ) IS
308: SELECT rowid row_id,
309: lock_flag
310: FROM igf_aw_coa_itm_terms
311: WHERE base_id = cp_base_id
312: AND item_code = cp_item_code;
313:
314:

Line 381: FROM igf_aw_coa_itm_terms

377: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
378: cp_item_code igf_aw_coa_items.item_code%TYPE
379: ) IS
380: SELECT rowid row_id
381: FROM igf_aw_coa_itm_terms
382: WHERE base_id = cp_base_id
383: AND item_code = cp_item_code;
384:
385:

Line 397: igf_aw_coa_itm_terms_pkg.delete_row(

393: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.delete_coa.debug','deleting item '||coa_rec.item_code);
394: END IF;
395: FOR coa_terms_rec IN c_coa_terms(p_base_id,coa_rec.item_code) LOOP
396:
397: igf_aw_coa_itm_terms_pkg.delete_row(
398: x_rowid => coa_terms_rec.row_id
399: );
400: END LOOP;
401:

Line 698: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE,

694:
695: -- select item's terms and term amount
696: CURSOR c_item_term(
697: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
698: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE,
699: cp_ld_cal_type igf_aw_coa_itm_terms.ld_cal_type%TYPE,
700: cp_ld_sequence_number igf_aw_coa_itm_terms.ld_sequence_number%TYPE
701: ) IS
702: SELECT rowid row_id,

Line 699: cp_ld_cal_type igf_aw_coa_itm_terms.ld_cal_type%TYPE,

695: -- select item's terms and term amount
696: CURSOR c_item_term(
697: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
698: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE,
699: cp_ld_cal_type igf_aw_coa_itm_terms.ld_cal_type%TYPE,
700: cp_ld_sequence_number igf_aw_coa_itm_terms.ld_sequence_number%TYPE
701: ) IS
702: SELECT rowid row_id,
703: lock_flag

Line 700: cp_ld_sequence_number igf_aw_coa_itm_terms.ld_sequence_number%TYPE

696: CURSOR c_item_term(
697: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
698: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE,
699: cp_ld_cal_type igf_aw_coa_itm_terms.ld_cal_type%TYPE,
700: cp_ld_sequence_number igf_aw_coa_itm_terms.ld_sequence_number%TYPE
701: ) IS
702: SELECT rowid row_id,
703: lock_flag
704: FROM igf_aw_coa_itm_terms

Line 704: FROM igf_aw_coa_itm_terms

700: cp_ld_sequence_number igf_aw_coa_itm_terms.ld_sequence_number%TYPE
701: ) IS
702: SELECT rowid row_id,
703: lock_flag
704: FROM igf_aw_coa_itm_terms
705: WHERE base_id = cp_base_id
706: AND item_code = cp_item_code
707: AND ld_cal_type = cp_ld_cal_type
708: AND ld_sequence_number = cp_ld_sequence_number;

Line 716: c_item_code igf_aw_coa_itm_terms.item_code%TYPE

712:
713: --Cursor to fetch item details for the base id
714: CURSOR c_items(
715: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
716: c_item_code igf_aw_coa_itm_terms.item_code%TYPE
717: ) IS
718: SELECT item.rowid row_id,
719: item.*
720: FROM igf_aw_coa_items item

Line 732: FROM igf_aw_coa_itm_terms term

728: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE
729: ) IS
730: SELECT item_code,
731: SUM(NVL(amount,0)) amount
732: FROM igf_aw_coa_itm_terms term
733: WHERE base_id = c_base_id
734: GROUP BY item_code;
735:
736: l_terms c_terms%ROWTYPE;

Line 828: igf_aw_coa_itm_terms_pkg.insert_row(

824: g_coa_updated := 'Y';
825: lv_terms_updated := 'Y';
826: lv_item_assigned := 'Y';
827:
828: igf_aw_coa_itm_terms_pkg.insert_row(
829: x_rowid => l_rowid,
830: x_base_id => p_base_id,
831: x_item_code => first_itm_term_rec.item_code,
832: x_amount => ln_amount,

Line 861: igf_aw_coa_itm_terms_pkg.insert_row(

857: g_coa_updated := 'Y';
858: lv_terms_updated := 'Y';
859: lv_item_assigned := 'Y';
860:
861: igf_aw_coa_itm_terms_pkg.insert_row(
862: x_rowid => l_rowid,
863: x_base_id => p_base_id,
864: x_item_code => first_itm_term_rec.item_code,
865: x_amount => first_itm_term_rec.item_term_amount,

Line 962: igf_aw_coa_itm_terms_pkg.insert_row(

958: g_coa_updated := 'Y';
959: lv_terms_updated := 'Y';
960: lv_item_assigned := 'Y';
961:
962: igf_aw_coa_itm_terms_pkg.insert_row(
963: x_rowid => l_rowid,
964: x_base_id => p_base_id,
965: x_item_code => sec_itm_term_rec.item_code,
966: x_amount => ln_amount,

Line 995: igf_aw_coa_itm_terms_pkg.insert_row(

991: g_coa_updated := 'Y';
992: lv_terms_updated := 'Y';
993: lv_item_assigned := 'Y';
994:
995: igf_aw_coa_itm_terms_pkg.insert_row(
996: x_rowid => l_rowid,
997: x_base_id => p_base_id,
998: x_item_code => sec_itm_term_rec.item_code,
999: x_amount => sec_itm_term_rec.item_term_amount,

Line 1105: igf_aw_coa_itm_terms_pkg.insert_row(

1101: g_coa_updated := 'Y';
1102: lv_terms_updated := 'Y';
1103: lv_item_assigned := 'Y';
1104:
1105: igf_aw_coa_itm_terms_pkg.insert_row(
1106: x_rowid => l_rowid,
1107: x_base_id => p_base_id,
1108: x_item_code => sec_itm_term_rec.item_code,
1109: x_amount => ln_amount,

Line 1134: igf_aw_coa_itm_terms_pkg.insert_row(

1130: g_coa_updated := 'Y';
1131: lv_terms_updated := 'Y';
1132: lv_item_assigned := 'Y';
1133:
1134: igf_aw_coa_itm_terms_pkg.insert_row(
1135: x_rowid => l_rowid,
1136: x_base_id => p_base_id,
1137: x_item_code => sec_itm_term_rec.item_code,
1138: x_amount => sec_itm_term_rec.item_term_amount,

Line 1238: igf_aw_coa_itm_terms_pkg.update_row(

1234: g_coa_updated := 'Y';
1235: lv_terms_updated := 'Y';
1236: lv_item_assigned := 'Y';
1237:
1238: igf_aw_coa_itm_terms_pkg.update_row(
1239: x_rowid => l_item_term.row_id,
1240: x_base_id => p_base_id,
1241: x_item_code => sec_itm_term_rec.item_code,
1242: x_amount => ln_amount,

Line 1267: igf_aw_coa_itm_terms_pkg.update_row(

1263: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1264: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.add_coa_items.debug','sec_itm_term_rec.item_term_amount IS NOT NULL');
1265: END IF;
1266:
1267: igf_aw_coa_itm_terms_pkg.update_row(
1268: x_rowid => l_item_term.row_id,
1269: x_base_id => p_base_id,
1270: x_item_code => sec_itm_term_rec.item_code,
1271: x_amount => sec_itm_term_rec.item_term_amount,

Line 1402: igf_aw_coa_itm_terms_pkg.insert_row(

1398: g_coa_updated := 'Y';
1399: lv_terms_updated := 'Y';
1400: lv_item_assigned := 'Y';
1401:
1402: igf_aw_coa_itm_terms_pkg.insert_row(
1403: x_rowid => l_rowid,
1404: x_base_id => p_base_id,
1405: x_item_code => sec_itm_term_rec.item_code,
1406: x_amount => ln_amount,

Line 1431: igf_aw_coa_itm_terms_pkg.insert_row(

1427: g_coa_updated := 'Y';
1428: lv_terms_updated := 'Y';
1429: lv_item_assigned := 'Y';
1430:
1431: igf_aw_coa_itm_terms_pkg.insert_row(
1432: x_rowid => l_rowid,
1433: x_base_id => p_base_id,
1434: x_item_code => sec_itm_term_rec.item_code,
1435: x_amount => sec_itm_term_rec.item_term_amount,

Line 1535: igf_aw_coa_itm_terms_pkg.update_row(

1531: g_coa_updated := 'Y';
1532: lv_terms_updated := 'Y';
1533: lv_item_assigned := 'Y';
1534:
1535: igf_aw_coa_itm_terms_pkg.update_row(
1536: x_rowid => l_item_term.row_id,
1537: x_base_id => p_base_id,
1538: x_item_code => sec_itm_term_rec.item_code,
1539: x_amount => ln_amount,

Line 1564: igf_aw_coa_itm_terms_pkg.update_row(

1560: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.add_coa_items.debug','sec_itm_term_rec.item_term_amount IS NOT NULL');
1562: END IF;
1563:
1564: igf_aw_coa_itm_terms_pkg.update_row(
1565: x_rowid => l_item_term.row_id,
1566: x_base_id => p_base_id,
1567: x_item_code => sec_itm_term_rec.item_code,
1568: x_amount => sec_itm_term_rec.item_term_amount,

Line 1675: FROM igf_aw_coa_itm_terms terms,

1671: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1672: ) IS
1673: SELECT ca.alternate_code term,
1674: SUM(NVL(terms.amount,0)) amount
1675: FROM igf_aw_coa_itm_terms terms,
1676: igs_ca_inst ca
1677: WHERE ca.cal_type = terms.ld_cal_type
1678: AND ca.sequence_number = terms.ld_sequence_number
1679: AND terms.base_id = c_base_id

Line 1763: FROM igf_aw_coa_itm_terms coa

1759: CURSOR cur_per_coa(
1760: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1761: ) IS
1762: SELECT 'x'
1763: FROM igf_aw_coa_itm_terms coa
1764: WHERE coa.base_id = p_base_id
1765: AND rownum = 1;
1766:
1767: l_cur_per_coa cur_per_coa%ROWTYPE;