APPS.ARP_AUTO_RULE dependencies on GL_PERIODS

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

197: | PRIVATE PROCEDURE |
198: | populate_glp_table |
199: | |
200: | DESCRIPTION |
201: | Builds the GL periods table (PL/SQL). |
202: | |
203: | The table has the following columns: |
204: | start_date, end_date, closing_status, bump_date. |
205: | |

Line 328: | gl_periods table. |

324: | refresh |
325: | |
326: | DESCRIPTION |
327: | Updates ar_periods and ar_period_types tables with latest changes in |
328: | gl_periods table. |
329: | |
330: | PARAMETERS |
331: | INPUT |
332: | None. |

Line 368: FROM gl_periods g

364: SET
365: max_regular_period_length =
366: (
367: SELECT MAX(g.end_date - g.start_date) + 1
368: FROM gl_periods g
369: WHERE g.period_type = apt.period_type
370: AND g.adjustment_period_flag = 'N'
371: )
372: WHERE

Line 376: FROM gl_periods g

372: WHERE
373: max_regular_period_length <>
374: (
375: SELECT MAX(g.end_date - g.start_date) + 1
376: FROM gl_periods g
377: WHERE g.period_type = apt.period_type
378: AND g.adjustment_period_flag = 'N'
379: );
380:

Line 394: gl_periods g

390: SELECT
391: g.period_type,
392: MAX(g.end_date - g.start_date) + 1 max_regular_period_length
393: FROM
394: gl_periods g
395: WHERE
396: g.adjustment_period_flag = 'N'
397: AND NOT EXISTS
398: (

Line 417: FROM gl_periods gp

413: WHERE
414: NOT EXISTS
415: (
416: SELECT NULL
417: FROM gl_periods gp
418: WHERE gp.period_name = ap.period_name
419: AND gp.period_set_name = ap.period_set_name
420: AND gp.adjustment_period_flag = 'N'
421: );

Line 433: FROM gl_periods gp

429: SET
430: (period_type, start_date, end_date) =
431: (
432: SELECT period_type, start_date, end_date
433: FROM gl_periods gp
434: WHERE gp.period_name = ap.period_name
435: AND gp.period_set_name = ap.period_set_name
436: )
437: WHERE

Line 441: FROM gl_periods gp

437: WHERE
438: EXISTS
439: (
440: SELECT NULL
441: FROM gl_periods gp
442: WHERE
443: gp.period_name = ap.period_name
444: AND gp.period_set_name = ap.period_set_name
445: AND NOT (gp.period_type = ap.period_type AND

Line 466: gl_periods gp

462: period_set_name, period_type, start_date, end_date,
463: 9999 + ROWNUM new_period_num,
464: period_name
465: FROM
466: gl_periods gp
467: WHERE
468: gp.adjustment_period_flag = 'N'
469: AND NOT EXISTS
470: (

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

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

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

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

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

3074: ' Base Minimum Accountable Unit: ' ||
3075: NVL(base_min_acc_unit, 0));
3076: END IF;
3077:
3078: /* Populate the GL periods PL/SQL table. */
3079: populate_glp_table(arp_standard.sysparm.set_of_books_id,
3080: arp_standard.application_id);
3081:
3082: /* DEBUG INFO. */