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.

[Home] [Help]

APPS.IGF_GR_GEN dependencies on IGF_AW_COA_ITM_TERMS

Line 2345: PROCEDURE insert_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,

2341:
2342: END insert_coa_terms;
2343:
2344:
2345: PROCEDURE insert_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2346: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2347: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,
2348: p_result OUT NOCOPY VARCHAR2
2349: )

Line 2352: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE)

2348: p_result OUT NOCOPY VARCHAR2
2349: )
2350: IS
2351:
2352: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE)
2353: IS
2354: SELECT item_code
2355: FROM igf_aw_coa_items
2356: WHERE base_id = p_base_id;

Line 2369: igf_aw_coa_itm_terms_pkg.insert_row( x_rowid => lv_rowid,

2365:
2366: lv_rowid := NULL;
2367:
2368:
2369: igf_aw_coa_itm_terms_pkg.insert_row( x_rowid => lv_rowid,
2370: x_base_id => p_base_id,
2371: x_item_code => get_terms_rec.item_code,
2372: x_amount => 0,
2373: x_ld_cal_type => p_ld_cal_type,

Line 2397: PROCEDURE insert_existing_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,

2393: END insert_stu_coa_terms;
2394:
2395: --CODE ADDED BY GAUTAM
2396:
2397: PROCEDURE insert_existing_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2398: p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
2399: p_result OUT NOCOPY VARCHAR2
2400: )
2401: IS

Line 2398: p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,

2394:
2395: --CODE ADDED BY GAUTAM
2396:
2397: PROCEDURE insert_existing_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2398: p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
2399: p_result OUT NOCOPY VARCHAR2
2400: )
2401: IS
2402:

Line 2403: CURSOR cur_get_existing_terms(c_base_id igf_aw_coa_itm_terms.base_id%TYPE)

2399: p_result OUT NOCOPY VARCHAR2
2400: )
2401: IS
2402:
2403: CURSOR cur_get_existing_terms(c_base_id igf_aw_coa_itm_terms.base_id%TYPE)
2404: IS
2405: SELECT DISTINCT ld_cal_type,ld_sequence_number
2406: FROM igf_aw_coa_itm_terms
2407: WHERE base_id = c_base_id;

Line 2406: FROM igf_aw_coa_itm_terms

2402:
2403: CURSOR cur_get_existing_terms(c_base_id igf_aw_coa_itm_terms.base_id%TYPE)
2404: IS
2405: SELECT DISTINCT ld_cal_type,ld_sequence_number
2406: FROM igf_aw_coa_itm_terms
2407: WHERE base_id = c_base_id;
2408:
2409: get_exisiting_terms_rec cur_get_existing_terms%ROWTYPE;
2410: lv_rowid ROWID;

Line 2420: igf_aw_coa_itm_terms_pkg.insert_row( x_rowid => lv_rowid,

2416: FOR get_existing_terms_rec IN cur_get_existing_terms(p_base_id) LOOP
2417:
2418: lv_rowid := NULL;
2419:
2420: igf_aw_coa_itm_terms_pkg.insert_row( x_rowid => lv_rowid,
2421: x_base_id => p_base_id,
2422: x_item_code => p_item_code,
2423: x_amount => 0,
2424: x_ld_cal_type => get_existing_terms_rec.ld_cal_type,

Line 2446: PROCEDURE delete_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,

2442: app_exception.raise_exception;
2443:
2444: END insert_existing_terms;
2445:
2446: PROCEDURE delete_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2447: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2448: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,
2449: p_result OUT NOCOPY VARCHAR2
2450: )

Line 2455: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,

2451:
2452: IS
2453:
2454:
2455: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2456: p_ld_cal_type igf_aw_coa_ld_all.ld_cal_type%TYPE,
2457: p_ld_sequence_number igf_aw_coa_ld_all.ld_sequence_number%TYPE
2458: )
2459: IS

Line 2461: FROM igf_aw_coa_itm_terms

2457: p_ld_sequence_number igf_aw_coa_ld_all.ld_sequence_number%TYPE
2458: )
2459: IS
2460: SELECT rowid
2461: FROM igf_aw_coa_itm_terms
2462: WHERE base_id = p_base_id
2463: AND ld_cal_type = p_ld_cal_type
2464: AND ld_sequence_number = p_ld_sequence_number;
2465:

Line 2475: igf_aw_coa_itm_terms_pkg.delete_row( x_rowid => get_terms_rec.rowid);

2471: FOR get_terms_rec IN cur_get_terms (p_base_id,
2472: p_ld_cal_type,
2473: p_ld_sequence_number)
2474: LOOP
2475: igf_aw_coa_itm_terms_pkg.delete_row( x_rowid => get_terms_rec.rowid);
2476: END LOOP;
2477:
2478: EXCEPTION
2479:

Line 2494: PROCEDURE delete_stu_coa_items( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,

2490:
2491: END delete_stu_coa_terms;
2492:
2493:
2494: PROCEDURE delete_stu_coa_items( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2495: p_result OUT NOCOPY VARCHAR2,
2496: p_item_code IN igf_aw_coa_items.item_code%TYPE
2497: )
2498: IS

Line 2500: CURSOR cur_get_coa_itms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,

2496: p_item_code IN igf_aw_coa_items.item_code%TYPE
2497: )
2498: IS
2499:
2500: CURSOR cur_get_coa_itms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2501: p_item_code igf_aw_coa_items.item_code%TYPE)
2502: IS
2503: SELECT item_code,rowid
2504: FROM igf_aw_coa_items

Line 2509: CURSOR cur_get_coa_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,

2505: WHERE base_id = p_base_id
2506: AND item_code = NVL(p_item_code,item_code);
2507:
2508:
2509: CURSOR cur_get_coa_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2510: p_item_code igf_aw_coa_itm_terms.item_code%TYPE)
2511:
2512: IS
2513: SELECT rowid

Line 2510: p_item_code igf_aw_coa_itm_terms.item_code%TYPE)

2506: AND item_code = NVL(p_item_code,item_code);
2507:
2508:
2509: CURSOR cur_get_coa_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2510: p_item_code igf_aw_coa_itm_terms.item_code%TYPE)
2511:
2512: IS
2513: SELECT rowid
2514: FROM igf_aw_coa_itm_terms

Line 2514: FROM igf_aw_coa_itm_terms

2510: p_item_code igf_aw_coa_itm_terms.item_code%TYPE)
2511:
2512: IS
2513: SELECT rowid
2514: FROM igf_aw_coa_itm_terms
2515: WHERE base_id = p_base_id
2516: AND item_code = p_item_code;
2517:
2518: BEGIN

Line 2528: igf_aw_coa_itm_terms_pkg.delete_row(x_rowid => get_coa_terms_rec.rowid);

2524: LOOP
2525: FOR get_coa_terms_rec IN cur_get_coa_terms (p_base_id,
2526: get_coa_itms_rec.item_code)
2527: LOOP
2528: igf_aw_coa_itm_terms_pkg.delete_row(x_rowid => get_coa_terms_rec.rowid);
2529: END LOOP;
2530: -- igf_aw_coa_items_pkg.delete_row(x_rowid => get_coa_itms_rec.rowid);
2531: END LOOP;
2532:

Line 2550: PROCEDURE update_stu_coa_items( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,

2546: app_exception.raise_exception;
2547:
2548: END delete_stu_coa_items;
2549:
2550: PROCEDURE update_stu_coa_items( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2551: p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
2552: p_result OUT NOCOPY VARCHAR2)
2553: IS
2554:

Line 2551: p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,

2547:
2548: END delete_stu_coa_items;
2549:
2550: PROCEDURE update_stu_coa_items( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2551: p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
2552: p_result OUT NOCOPY VARCHAR2)
2553: IS
2554:
2555: CURSOR cur_get_items (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,

Line 2555: CURSOR cur_get_items (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,

2551: p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
2552: p_result OUT NOCOPY VARCHAR2)
2553: IS
2554:
2555: CURSOR cur_get_items (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2556: p_item_code igf_aw_coa_itm_terms.item_code%TYPE)
2557: IS
2558: SELECT items.rowid,items.*
2559: FROM

Line 2556: p_item_code igf_aw_coa_itm_terms.item_code%TYPE)

2552: p_result OUT NOCOPY VARCHAR2)
2553: IS
2554:
2555: CURSOR cur_get_items (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2556: p_item_code igf_aw_coa_itm_terms.item_code%TYPE)
2557: IS
2558: SELECT items.rowid,items.*
2559: FROM
2560: igf_aw_coa_items items

Line 2564: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,

2560: igf_aw_coa_items items
2561: WHERE base_id = p_base_id
2562: AND item_code = NVL(p_item_code,item_code);
2563:
2564: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2565: p_item_code igf_aw_coa_items.item_code%TYPE)
2566: IS
2567: SELECT
2568: SUM (amount) item_amount

Line 2569: FROM igf_aw_coa_itm_terms

2565: p_item_code igf_aw_coa_items.item_code%TYPE)
2566: IS
2567: SELECT
2568: SUM (amount) item_amount
2569: FROM igf_aw_coa_itm_terms
2570: WHERE base_id = p_base_id
2571: AND item_code = p_item_code
2572: GROUP BY item_code;
2573: