[Home] [Help]
169:
170:
171: l_all_pds_exist_sql := l_all_pds_exist_sql ||
172: ' SELECT 1
173: FROM gl_periods p1, /* to get the first period */
174: gl_periods p2, /* to get the last period */
175: gl_sets_of_books b,
176: gl_period_types t,
177: ra_rules r
170:
171: l_all_pds_exist_sql := l_all_pds_exist_sql ||
172: ' SELECT 1
173: FROM gl_periods p1, /* to get the first period */
174: gl_periods p2, /* to get the last period */
175: gl_sets_of_books b,
176: gl_period_types t,
177: ra_rules r
178: WHERE r.rule_id = ' || l_temp_rule || '
205: MAX( TO_CHAR(p9.period_year,999999)||''-''||
206: TO_CHAR(p9.period_num,999999)||''-''||
207: TO_CHAR(rownum,9999)
208: )
209: FROM gl_periods p9
210: WHERE p9.period_set_name = p1.period_set_name
211: AND p9.period_type = p1.period_type
212: AND p9.start_date >= p1.start_date
213: AND p9.adjustment_period_flag = ''N''
227: ''PP_DR_PP'',
228: ' || l_temp_duration ||',
229: r.occurrences) =
230: ( SELECT COUNT(p3.period_set_name)
231: FROM gl_periods p3
232: WHERE p3.period_set_name = b.period_set_name
233: AND p3.period_type = p1.period_type
234: AND p3.adjustment_period_flag = ''N''
235: AND p3.start_date >= p1.start_date
244: COUNT(*), 1,
245: 2
246: )
247: )
248: FROM gl_periods p,
249: gl_sets_of_books b,
250: ra_rules r,
251: ra_rule_schedules rl
252: WHERE r.rule_id =' || l_temp_rule || '
296:
297:
298: l_overlapping_pds_sql := l_overlapping_pds_sql ||
299: ' SELECT 1
300: FROM gl_periods p1,
301: gl_periods p2,
302: gl_sets_of_books b,
303: ra_rules r
304: WHERE r.rule_id = ' || l_temp_rule || '
297:
298: l_overlapping_pds_sql := l_overlapping_pds_sql ||
299: ' SELECT 1
300: FROM gl_periods p1,
301: gl_periods p2,
302: gl_sets_of_books b,
303: ra_rules r
304: WHERE r.rule_id = ' || l_temp_rule || '
305: AND b.set_of_books_id = ' || l_temp_sob || '
395: END;
396:
397: /*===========================================================================+
398: | PROCEDURE |
399: | val_gl_periods_for_rules |
400: | |
401: | DESCRIPTION |
402: | Validates for an accounting rule and rule start date, that: |
403: | - GL periods exist |
399: | val_gl_periods_for_rules |
400: | |
401: | DESCRIPTION |
402: | Validates for an accounting rule and rule start date, that: |
403: | - GL periods exist |
404: | - that there are no overlapping periods |
405: | |
406: | SCOPE - PUBLIC |
407: | |
431: | 17-JUL-95 Charlie Tomberg Created |
432: | |
433: +===========================================================================*/
434:
435: PROCEDURE val_gl_periods_for_rules(
436: p_request_id IN ra_customer_trx.request_id%type,
437: p_acc_rule_id IN ra_rules.rule_id%type,
438: p_acc_duration IN
439: ra_customer_trx_lines.accounting_rule_duration%type,
446: l_result integer;
447:
448: BEGIN
449:
450: arp_util.print_fcn_label('arp_dates.val_gl_periods_for_rules()+ ');
451:
452: /*---------------------------------------------+
453: | Do nothing if the line does not use rules |
454: +---------------------------------------------*/
454: +---------------------------------------------*/
455:
456: IF ( p_acc_rule_id IS NULL )
457: THEN arp_util.debug('accounting_rule_id is null - no action taken');
458: arp_util.print_fcn_label('arp_dates.val_gl_periods_for_rules()- ');
459: RETURN;
460: END IF;
461:
462: /*-----------------------------------------------------------------+
598:
599:
600: END IF;
601:
602: arp_util.print_fcn_label('arp_dates.val_gl_periods_for_rules()- ');
603:
604:
605: EXCEPTION
606: WHEN OTHERS THEN
608: /*---------------------------------------------+
609: | Display parameters and raise the exception |
610: +---------------------------------------------*/
611:
612: arp_util.debug('EXCEPTION: arp_dates.val_gl_periods_for_rules()');
613:
614: arp_util.debug('');
615: arp_util.debug('------- parameters for val_gl_periods_for_rules() -------');
616:
611:
612: arp_util.debug('EXCEPTION: arp_dates.val_gl_periods_for_rules()');
613:
614: arp_util.debug('');
615: arp_util.debug('------- parameters for val_gl_periods_for_rules() -------');
616:
617: arp_util.debug( 'p_request_id = ' || p_request_id );
618: arp_util.debug( 'p_acc_rule_id = ' || p_acc_rule_id );
619: arp_util.debug( 'p_acc_duration = ' || p_acc_duration );
631: | get_date_based_on_rev_sched |
632: | |
633: | DESCRIPTION |
634: | Validates for an accounting rule and rule start date, that: |
635: | - GL periods exist |
636: | - that there are no overlapping periods |
637: | |
638: | SCOPE - PUBLIC |
639: | |
657: | 28-JUL-95 Charlie Tomberg Created |
658: | |
659: | 10-Nov-00 Y Rakotonirainy Bug 1296673 |
660: | Modified to exclude adjustment period |
661: | while calculating gl periods | |
662: | |
663: +===========================================================================*/
664:
665: PROCEDURE get_date_based_on_rev_sched(
669: ra_customer_trx.invoicing_rule_id%type,
670: p_candidate_date OUT NOCOPY DATE
671: ) IS
672:
673: actual_num_fiscal_year gl_periods.period_year%TYPE;
674:
675: BEGIN
676:
677: arp_util.print_fcn_label('arp_dates.get_date_based_on_rev_sched()+ ');
698: SELECT COUNT(gp1.period_set_name)
699: INTO actual_num_fiscal_year
700: FROM ra_customer_trx_lines ctl,
701: gl_sets_of_books b,
702: gl_periods gp1
703: WHERE ctl.customer_trx_id = p_customer_trx_id
704: AND ctl.set_of_books_id = b.set_of_books_id
705: AND gp1.period_set_name = b.period_set_name
706: AND gp1.period_type = b.accounted_period_type
721: )
722: )
723: INTO p_candidate_date
724: FROM ra_customer_trx_lines ctl,
725: gl_periods gp1,
726: gl_periods gp2,
727: gl_sets_of_books b,
728: gl_period_types t,
729: ra_rules r,
722: )
723: INTO p_candidate_date
724: FROM ra_customer_trx_lines ctl,
725: gl_periods gp1,
726: gl_periods gp2,
727: gl_sets_of_books b,
728: gl_period_types t,
729: ra_rules r,
730: ra_rule_schedules rl