APPS.ARP_AUTO_RULE dependencies on GL_PERIODS

Line 197: | Builds the GL periods table (PL/SQL). |

193: | PRIVATE PROCEDURE |
194: | populate_glp_table |
195: | |
196: | DESCRIPTION |
197: | Builds the GL periods table (PL/SQL). |
198: | |
199: | The table has the following columns: |
200: | start_date, end_date, closing_status, bump_date. |
201: | |

Line 324: | gl_periods table. |

320: | refresh |
321: | |
322: | DESCRIPTION |
323: | Updates ar_periods and ar_period_types tables with latest changes in |
324: | gl_periods table. |
325: | |
326: | PARAMETERS |
327: | INPUT |
328: | None. |

Line 364: FROM gl_periods g

360: SET
361: max_regular_period_length =
362: (
363: SELECT MAX(g.end_date - g.start_date) + 1
364: FROM gl_periods g
365: WHERE g.period_type = apt.period_type
366: AND g.adjustment_period_flag = 'N'
367: )
368: WHERE

Line 372: FROM gl_periods g

368: WHERE
369: max_regular_period_length <>
370: (
371: SELECT MAX(g.end_date - g.start_date) + 1
372: FROM gl_periods g
373: WHERE g.period_type = apt.period_type
374: AND g.adjustment_period_flag = 'N'
375: );
376:

Line 390: gl_periods g

386: SELECT
387: g.period_type,
388: MAX(g.end_date - g.start_date) + 1 max_regular_period_length
389: FROM
390: gl_periods g
391: WHERE
392: g.adjustment_period_flag = 'N'
393: AND NOT EXISTS
394: (

Line 413: FROM gl_periods gp

409: WHERE
410: NOT EXISTS
411: (
412: SELECT NULL
413: FROM gl_periods gp
414: WHERE gp.period_name = ap.period_name
415: AND gp.period_set_name = ap.period_set_name
416: AND gp.adjustment_period_flag = 'N'
417: );

Line 429: FROM gl_periods gp

425: SET
426: (period_type, start_date, end_date) =
427: (
428: SELECT period_type, start_date, end_date
429: FROM gl_periods gp
430: WHERE gp.period_name = ap.period_name
431: AND gp.period_set_name = ap.period_set_name
432: )
433: WHERE

Line 437: FROM gl_periods gp

433: WHERE
434: EXISTS
435: (
436: SELECT NULL
437: FROM gl_periods gp
438: WHERE
439: gp.period_name = ap.period_name
440: AND gp.period_set_name = ap.period_set_name
441: AND NOT (gp.period_type = ap.period_type AND

Line 462: gl_periods gp

458: period_set_name, period_type, start_date, end_date,
459: 9999 + ROWNUM new_period_num,
460: period_name
461: FROM
462: gl_periods gp
463: WHERE
464: gp.adjustment_period_flag = 'N'
465: AND NOT EXISTS
466: (

Line 557: /* Populate the GL periods PL/SQL table. */

553: i NUMBER;
554: l_temp_index NUMBER;
555:
556: BEGIN
557: /* Populate the GL periods PL/SQL table. */
558: populate_glp_table(arp_standard.sysparm.set_of_books_id,
559: arp_standard.application_id);
560:
561: /* 3879222 - Added NVLs to accomodate external

Line 651: /* Populate the GL periods PL/SQL table. */

647: RETURN DATE IS
648:
649: BEGIN
650:
651: /* Populate the GL periods PL/SQL table. */
652: populate_glp_table(arp_standard.sysparm.set_of_books_id,
653: arp_standard.application_id);
654:
655: IF (gl_status_t(glp_index_rec) IN ('O', 'F', 'N') )

Line 2758: /* Populate the GL periods PL/SQL table. */

2754: ' Base Minimum Accountable Unit: ' ||
2755: NVL(base_min_acc_unit, 0));
2756: END IF;
2757:
2758: /* Populate the GL periods PL/SQL table. */
2759: populate_glp_table(arp_standard.sysparm.set_of_books_id,
2760: arp_standard.application_id);
2761:
2762: /* DEBUG INFO. */