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.IGI_EXP_UTILS dependencies on GL_SETS_OF_BOOKS

Line 147: ,gl_sets_of_books gsob

143:
144: CURSOR c_fiscal_year(p_sob_id NUMBER) IS
145: SELECT period_year
146: FROM gl_periods gp
147: ,gl_sets_of_books gsob
148: WHERE gp.period_set_name = gsob.period_set_name
149: AND gp.period_type = gsob.accounted_period_type
150: -- AND TRUNC(TO_DATE(pi_gl_date, 'DD-MON-RRRR'))
151: AND TRUNC(pi_gl_date)

Line 156: l_sob_id gl_sets_of_books.set_of_books_id%TYPE;

152: BETWEEN TRUNC(gp.start_date)
153: AND TRUNC(gp.end_date)
154: AND gsob.set_of_books_id = p_sob_id;
155:
156: l_sob_id gl_sets_of_books.set_of_books_id%TYPE;
157: l_sob_name gl_sets_of_books.name%TYPE;
158:
159: e_invalid_params EXCEPTION;
160: e_sob_not_found EXCEPTION;

Line 157: l_sob_name gl_sets_of_books.name%TYPE;

153: AND TRUNC(gp.end_date)
154: AND gsob.set_of_books_id = p_sob_id;
155:
156: l_sob_id gl_sets_of_books.set_of_books_id%TYPE;
157: l_sob_name gl_sets_of_books.name%TYPE;
158:
159: e_invalid_params EXCEPTION;
160: e_sob_not_found EXCEPTION;
161: e_fiscal_year_not_found EXCEPTION;

Line 489: CURSOR c_open_period(pv_sob_id gl_sets_of_books.set_of_books_id%TYPE,

485: IS
486: SELECT purch_encumbrance_flag
487: FROM financials_system_parameters;
488:
489: CURSOR c_open_period(pv_sob_id gl_sets_of_books.set_of_books_id%TYPE,
490: pv_app_id igi_exp_du_type_headers.application_id%TYPE,
491: pv_gl_date DATE)
492: IS
493: SELECT gps.period_year,

Line 496: gl_sets_of_books gsob

492: IS
493: SELECT gps.period_year,
494: gsob.latest_encumbrance_year
495: FROM gl_period_statuses gps,
496: gl_sets_of_books gsob
497: WHERE gps.application_id = pv_app_id
498: AND gps.set_of_books_id = pv_sob_id
499: AND gps.set_of_books_id = gsob.set_of_books_id
500: AND trunc(pv_gl_date) BETWEEN trunc(gps.start_date) AND trunc(gps.end_date) --Bug5705031

Line 504: CURSOR c_last_open_period(pv_sob_id gl_sets_of_books.set_of_books_id%TYPE,

500: AND trunc(pv_gl_date) BETWEEN trunc(gps.start_date) AND trunc(gps.end_date) --Bug5705031
501: AND gps.closing_status IN ('O', 'F')
502: AND NVL(gps.adjustment_period_flag, 'N') = 'N';
503:
504: CURSOR c_last_open_period(pv_sob_id gl_sets_of_books.set_of_books_id%TYPE,
505: pv_app_id igi_exp_du_type_headers.application_id%TYPE,
506: pv_period_year number)
507: IS
508: SELECT gps.period_year,

Line 512: gl_sets_of_books gsob

508: SELECT gps.period_year,
509: gsob.latest_encumbrance_year,
510: gps.end_date
511: FROM gl_period_statuses gps,
512: gl_sets_of_books gsob
513: WHERE gps.application_id = pv_app_id
514: AND gps.set_of_books_id = pv_sob_id
515: AND gps.set_of_books_id = gsob.set_of_books_id
516: AND gsob.latest_opened_period_name = gps.period_name

Line 520: CURSOR Cur_current_fis_year (pv_sob_id gl_sets_of_books.set_of_books_id%TYPE,

516: AND gsob.latest_opened_period_name = gps.period_name
517: AND gps.period_year = pv_period_year; -- shsaxena Bug 2777575.
518:
519: /* shsaxena Bug 2777575 START */
520: CURSOR Cur_current_fis_year (pv_sob_id gl_sets_of_books.set_of_books_id%TYPE,
521: pv_app_id igi_exp_du_type_headers.application_id%TYPE,
522: pv_gl_date DATE)
523: IS
524: SELECT gps.period_year

Line 526: gl_sets_of_books gsob

522: pv_gl_date DATE)
523: IS
524: SELECT gps.period_year
525: FROM gl_period_statuses gps,
526: gl_sets_of_books gsob
527: WHERE gps.application_id = pv_app_id
528: AND gps.set_of_books_id = pv_sob_id
529: AND gps.set_of_books_id = gsob.set_of_books_id
530: AND trunc(pv_gl_date) BETWEEN trunc(gps.start_date) AND trunc(gps.end_date);

Line 533: CURSOR Cur_prev_year_end_date (pv_sob_id gl_sets_of_books.set_of_books_id%TYPE,

529: AND gps.set_of_books_id = gsob.set_of_books_id
530: AND trunc(pv_gl_date) BETWEEN trunc(gps.start_date) AND trunc(gps.end_date);
531:
532:
533: CURSOR Cur_prev_year_end_date (pv_sob_id gl_sets_of_books.set_of_books_id%TYPE,
534: pv_app_id igi_exp_du_type_headers.application_id%TYPE,
535: pv_period_year number)
536: IS
537: SELECT gps.end_date

Line 557: l_latest_encumbrance_year gl_sets_of_books.latest_encumbrance_year%TYPE ;

553: l_current_fiscal_year igi_exp_dus_v.du_fiscal_year%TYPE;
554: l_du_fiscal_year igi_exp_dus_v.du_fiscal_year%TYPE;
555: /* shsaxena Bug 2777575 END */
556:
557: l_latest_encumbrance_year gl_sets_of_books.latest_encumbrance_year%TYPE ;
558: l_period_year gl_period_statuses.period_year%TYPE ;
559: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE ;
560: l_sob_id gl_sets_of_books.set_of_books_id%TYPE ;
561: l_debug_info VARCHAR2(2000);

Line 560: l_sob_id gl_sets_of_books.set_of_books_id%TYPE ;

556:
557: l_latest_encumbrance_year gl_sets_of_books.latest_encumbrance_year%TYPE ;
558: l_period_year gl_period_statuses.period_year%TYPE ;
559: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE ;
560: l_sob_id gl_sets_of_books.set_of_books_id%TYPE ;
561: l_debug_info VARCHAR2(2000);
562: l_gl_date DATE;
563: p_error_message VARCHAR2(2000);
564:

Line 567: l_sob_name gl_sets_of_books.name%TYPE;

563: p_error_message VARCHAR2(2000);
564:
565: NO_OPEN_PERIOD Exception; -- shsaxena Bug 2777575.
566:
567: l_sob_name gl_sets_of_books.name%TYPE;
568: l_current_org_id hr_operating_units.organization_id%type;
569:
570:
571: BEGIN