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.AR_INVOICE_UTILS dependencies on GL_PERIOD_STATUSES

Line 2491: l_period_status gl_period_statuses.closing_status%type DEFAULT 'U';

2487: from ar_trx_header_gt hdr,
2488: ra_cust_trx_types tt
2489: where tt.cust_trx_type_id = hdr.cust_trx_type_id;
2490:
2491: l_period_status gl_period_statuses.closing_status%type DEFAULT 'U';
2492: BEGIN
2493: IF pg_debug = 'Y'
2494: THEN
2495: debug ('AR_INVOICE_UTILS.validate_gl_date(+)' );

Line 2509: FROM gl_period_statuses g,

2505: /* Validate the gl_date for open period, etc */
2506: BEGIN
2507: SELECT closing_status
2508: INTO l_period_status
2509: FROM gl_period_statuses g,
2510: gl_sets_of_books b
2511: WHERE b.set_of_books_id = g.set_of_books_id
2512: AND g.set_of_books_id = arp_global.set_of_books_id
2513: AND g.period_type = b.accounted_period_type

Line 5706: and also added check for the status of the gl_period with a join to gl_period_statuses */

5702: END IF;
5703: END IF;
5704: ELSE -- frequency <> 'SPECIFIC'
5705: /* Bug 5444387 - Checked for line rule_start_date to be in a GL period instead of trx_date
5706: and also added check for the status of the gl_period with a join to gl_period_statuses */
5707: SELECT COUNT(*)
5708: INTO l_period_exist
5709: FROM gl_periods gp,
5710: gl_sets_of_books sob,

Line 5711: gl_period_statuses gps

5707: SELECT COUNT(*)
5708: INTO l_period_exist
5709: FROM gl_periods gp,
5710: gl_sets_of_books sob,
5711: gl_period_statuses gps
5712: WHERE sob.set_of_books_id = l_set_of_books_id
5713: AND gp.adjustment_period_flag = 'N'
5714: AND gp.period_set_name = sob.period_set_name
5715: AND gp.period_type = l_frequency