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 2568: l_period_status gl_period_statuses.closing_status%type DEFAULT 'U';

2564: from ar_trx_header_gt hdr,
2565: ra_cust_trx_types tt
2566: where tt.cust_trx_type_id = hdr.cust_trx_type_id;
2567:
2568: l_period_status gl_period_statuses.closing_status%type DEFAULT 'U';
2569: BEGIN
2570: IF pg_debug = 'Y'
2571: THEN
2572: debug ('AR_INVOICE_UTILS.validate_gl_date(+)' );

Line 2586: FROM gl_period_statuses g,

2582: /* Validate the gl_date for open period, etc */
2583: BEGIN
2584: SELECT closing_status
2585: INTO l_period_status
2586: FROM gl_period_statuses g,
2587: gl_sets_of_books b
2588: WHERE b.set_of_books_id = g.set_of_books_id
2589: AND g.set_of_books_id = arp_global.set_of_books_id
2590: AND g.period_type = b.accounted_period_type

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

5830: END IF;
5831: END IF;
5832: ELSE -- frequency <> 'SPECIFIC'
5833: /* Bug 5444387 - Checked for line rule_start_date to be in a GL period instead of trx_date
5834: and also added check for the status of the gl_period with a join to gl_period_statuses */
5835: SELECT COUNT(*)
5836: INTO l_period_exist
5837: FROM gl_periods gp,
5838: gl_sets_of_books sob,

Line 5839: gl_period_statuses gps

5835: SELECT COUNT(*)
5836: INTO l_period_exist
5837: FROM gl_periods gp,
5838: gl_sets_of_books sob,
5839: gl_period_statuses gps
5840: WHERE sob.set_of_books_id = l_set_of_books_id
5841: AND gp.adjustment_period_flag = 'N'
5842: AND gp.period_set_name = sob.period_set_name
5843: AND gp.period_type = l_frequency