APPS.ARP_AUTO_RULE dependencies on GL_PERIOD_STATUSES

Line 15: gl_period_statuses.start_date%TYPE

11: g_autoinv BOOLEAN;
12: g_autoinv_request_id NUMBER;
13:
14: TYPE gl_start_table_type IS TABLE OF
15: gl_period_statuses.start_date%TYPE
16: INDEX BY BINARY_INTEGER;
17:
18: gl_start_t gl_start_table_type;
19:

Line 21: gl_period_statuses.end_date%TYPE

17:
18: gl_start_t gl_start_table_type;
19:
20: TYPE gl_end_table_type IS TABLE OF
21: gl_period_statuses.end_date%TYPE
22: INDEX BY BINARY_INTEGER;
23:
24: gl_end_t gl_end_table_type;
25:

Line 27: gl_period_statuses.closing_status%TYPE

23:
24: gl_end_t gl_end_table_type;
25:
26: TYPE gl_status_table_type IS TABLE OF
27: gl_period_statuses.closing_status%TYPE
28: INDEX BY BINARY_INTEGER;
29:
30: gl_status_t gl_status_table_type;
31:

Line 33: gl_period_statuses.start_date%TYPE

29:
30: gl_status_t gl_status_table_type;
31:
32: TYPE gl_bump_table_type IS TABLE OF
33: gl_period_statuses.start_date%TYPE
34: INDEX BY BINARY_INTEGER;
35:
36: gl_bump_t gl_bump_table_type;
37:

Line 246: gl_period_statuses

242: start_date,
243: end_date,
244: closing_status
245: FROM
246: gl_period_statuses
247: WHERE
248: application_id = v_appl_id
249: AND set_of_books_id = v_sob
250: AND adjustment_period_flag = 'N'

Line 263: arp_standard.debug('Populating gl_period_statuses table.');

259: BEGIN
260: IF PG_DEBUG in ('Y', 'C') THEN
261: arp_standard.debug('arp_auto_rule.populate_glp_table()+ ' ||
262: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
263: arp_standard.debug('Populating gl_period_statuses table.');
264: END IF;
265:
266: /* Bug 2133254 - only call this the first time in for a given SOB */
267: /* Bug 3879222 - moved this logic inside the procedure */

Line 1045: l_period_name gl_period_statuses.period_name%type;

1041: do not process if it is not an existing period */
1042: IF l_max_rule_end_date IS NOT NULL
1043: THEN
1044: DECLARE
1045: l_period_name gl_period_statuses.period_name%type;
1046: BEGIN
1047: SELECT G.period_name
1048: INTO l_period_name
1049: FROM GL_PERIOD_STATUSES G,

Line 1049: FROM GL_PERIOD_STATUSES G,

1045: l_period_name gl_period_statuses.period_name%type;
1046: BEGIN
1047: SELECT G.period_name
1048: INTO l_period_name
1049: FROM GL_PERIOD_STATUSES G,
1050: GL_SETS_OF_BOOKS B
1051: WHERE B.SET_OF_BOOKS_ID = arp_standard.sysparm.set_of_books_id
1052: AND G.SET_OF_BOOKS_ID = B.SET_OF_BOOKS_ID
1053: AND G.PERIOD_TYPE = B.ACCOUNTED_PERIOD_TYPE