DBA Data[Home] [Help]

APPS.ARP_XLA_UPGRADE dependencies on AR120GIR_PERIODS

Line 3155: insert into ar120gir_periods(period_name)

3151:
3152: -- Added for bug 6673937 ( pref. issue)
3153:
3154: BEGIN
3155: insert into ar120gir_periods(period_name)
3156: select
3157: distinct period_name
3158: from gl_periods p
3159: where start_date >= (select min(start_date) from XLA_UPGRADE_DATES)

Line 3164: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');

3160: and end_date <= (select max(end_date) from XLA_UPGRADE_DATES);
3161: EXCEPTION
3162: WHEN NO_DATA_FOUND THEN
3163: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3164: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');
3165: RAISE;
3166:
3167: WHEN OTHERS THEN
3168: -- arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');

Line 3169: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');

3165: RAISE;
3166:
3167: WHEN OTHERS THEN
3168: -- arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3169: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');
3170: RAISE;
3171: END;
3172:
3173:

Line 3206: from ar120gir_periods periods

3202: XLA_DISTRIBUTION_LINKS LNK,
3203: XLA_AE_LINES LN
3204: WHERE EXISTS
3205: (select /*+ PUSH_SUBQ */ null
3206: from ar120gir_periods periods
3207: where periods.period_name = GHD.period_name
3208: )
3209: AND GIMP.JE_HEADER_ID = GHD.JE_HEADER_ID
3210: AND GHD.JE_SOURCE = 'Receivables'