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.JAI_AR_TCS_REP_PKG dependencies on GL_PERIODS

Line 102: -- cursor to get period year from gl_periods

98: WHERE jrd.REGIME_ID = jrr.REGIME_ID
99: AND jrr.ATTRIBUTE_CODE = cp_attr_code
100: AND jrd.REGIME_CODE = cp_rgm_code;
101:
102: -- cursor to get period year from gl_periods
103: CURSOR c_get_period_year(cp_calendar_id NUMBER,
104: cp_accounting_date DATE)
105: IS
106: SELECT a.PERIOD_YEAR

Line 107: FROM GL_PERIODS a

103: CURSOR c_get_period_year(cp_calendar_id NUMBER,
104: cp_accounting_date DATE)
105: IS
106: SELECT a.PERIOD_YEAR
107: FROM GL_PERIODS a
108: , gl_period_sets b
109: WHERE a.PERIOD_SET_NAME = b.period_set_name
110: AND b.period_set_id = cp_calendar_id
111: AND cp_accounting_date BETWEEN a.START_DATE AND a.END_DATE;

Line 114: lv_fin_year GL_PERIODS.PERIOD_YEAR%TYPE;

110: AND b.period_set_id = cp_calendar_id
111: AND cp_accounting_date BETWEEN a.START_DATE AND a.END_DATE;
112:
113: lv_gl_calendar_id number;
114: lv_fin_year GL_PERIODS.PERIOD_YEAR%TYPE;
115:
116: BEGIN
117:
118: OPEN c_get_tcs_rgm_atrbt;

Line 455: lv_period_name gl_periods.period_name%type;

451: ln_set_of_books_id org_organization_definitions.set_of_books_id%type;
452: r_trx c_trx%ROWTYPE;
453: lv_account_nature VARCHAR2(30) := 'REVERSAL';
454: lv_account_type VARCHAR2(30);
455: lv_period_name gl_periods.period_name%type;
456: v_process_status VARCHAR2(30);
457: v_process_message VARCHAR2(200);
458: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
459: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE := 'jai_tcs_repp_pkg.receipt_interim_accounting' ; -- holds the object name