APPS.ARP_AUTO_RULE dependencies on AR_PERIOD_TYPES

Line 323: | Updates ar_periods and ar_period_types tables with latest changes in |

319: | PUBLIC PROCEDURE |
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 |

Line 356: arp_standard.debug('Updating ar_period_types: ');

352:
353: SAVEPOINT AR_PERIODS_1;
354:
355: IF PG_DEBUG in ('Y', 'C') THEN
356: arp_standard.debug('Updating ar_period_types: ');
357: END IF;
358:
359: UPDATE ar_period_types apt
360: SET

Line 359: UPDATE ar_period_types apt

355: IF PG_DEBUG in ('Y', 'C') THEN
356: arp_standard.debug('Updating ar_period_types: ');
357: END IF;
358:
359: UPDATE ar_period_types apt
360: SET
361: max_regular_period_length =
362: (
363: SELECT MAX(g.end_date - g.start_date) + 1

Line 379: arp_standard.debug('Inserting into ar_period_types: ');

375: );
376:
377: IF PG_DEBUG in ('Y', 'C') THEN
378: arp_standard.debug('row(s) updated: ' || TO_CHAR(sql%rowcount));
379: arp_standard.debug('Inserting into ar_period_types: ');
380: END IF;
381:
382: INSERT
383: INTO ar_period_types

Line 383: INTO ar_period_types

379: arp_standard.debug('Inserting into ar_period_types: ');
380: END IF;
381:
382: INSERT
383: INTO ar_period_types
384: ( period_type, max_regular_period_length )
385: (
386: SELECT
387: g.period_type,

Line 396: FROM ar_period_types apt

392: g.adjustment_period_flag = 'N'
393: AND NOT EXISTS
394: (
395: SELECT NULL
396: FROM ar_period_types apt
397: WHERE apt.period_type = g.period_type
398: )
399: GROUP BY period_type
400: );