APPS.JTF_DIAGNOSTIC_COREAPI dependencies on GL_PERIOD_STATUSES

Line 511: gl_period_statuses b

507: count(b.period_name) total_periods,
508: count(decode(b.closing_status,'O',b.PERIOD_NAME,null)) open_periods,
509: a.accounted_period_type period_type
510: from gl_sets_of_books a,
511: gl_period_statuses b
512: where a.set_of_books_id = b.set_of_books_id (+)
513: and b.application_id = p_appId
514: and a.set_of_books_id = p_sobId
515: and b.period_type = a.accounted_period_type

Line 554: FROM gl_period_statuses

550: ELSE
551: BEGIN
552: SELECT period_name, start_date, end_date, sysdate
553: INTO l_period_name, l_start_date, l_end_date, l_sysdate
554: FROM gl_period_statuses
555: WHERE adjustment_period_flag = 'N'
556: AND period_type = c1_rec.period_type
557: AND start_date = (
558: SELECT MAX(start_date)

Line 559: FROM gl_period_statuses

555: WHERE adjustment_period_flag = 'N'
556: AND period_type = c1_rec.period_type
557: AND start_date = (
558: SELECT MAX(start_date)
559: FROM gl_period_statuses
560: WHERE closing_status = 'O'
561: AND adjustment_period_flag = 'N'
562: AND period_type = c1_rec.period_type
563: AND application_id = p_appId

Line 584: FROM gl_period_statuses

580: ELSE
581: BEGIN
582: SELECT period_name, start_date, end_date, sysdate
583: INTO l_period_name, l_start_date, l_end_date, l_sysdate
584: FROM gl_period_statuses
585: WHERE adjustment_period_flag = 'N'
586: AND period_type = c1_rec.period_type
587: AND sysdate between start_date and end_date
588: AND closing_status = 'O'

Line 614: 'gl_period_statuses for this application and set of books');

610: END IF;
611: EXCEPTION
612: WHEN NO_ROWS THEN
613: WarningPrint('There are no accounting periods defined in '||
614: 'gl_period_statuses for this application and set of books');
615: ActionWArningprint('If required, define the accounting calendar for this '||
616: 'application and set of books');
617: WHEN NO_DATA_FOUND THEN
618: ErrorPrint('Invalid Application id passed to checkFinPeriod');

Line 2726: gl_period_statuses b

2722: count(b.period_name) total_periods,
2723: count(decode(b.closing_status,'O',b.PERIOD_NAME,null)) open_periods,
2724: a.accounted_period_type period_type
2725: from gl_sets_of_books a,
2726: gl_period_statuses b
2727: where a.set_of_books_id = b.set_of_books_id (+)
2728: and b.application_id = p_appId
2729: and a.set_of_books_id = p_sobId
2730: and b.period_type = a.accounted_period_type

Line 2768: FROM gl_period_statuses

2764: ELSE
2765: BEGIN
2766: SELECT period_name, start_date, end_date, sysdate
2767: INTO l_period_name, l_start_date, l_end_date, l_sysdate
2768: FROM gl_period_statuses
2769: WHERE adjustment_period_flag = 'N'
2770: AND period_type = c1_rec.period_type
2771: AND start_date = (
2772: SELECT MAX(start_date)

Line 2773: FROM gl_period_statuses

2769: WHERE adjustment_period_flag = 'N'
2770: AND period_type = c1_rec.period_type
2771: AND start_date = (
2772: SELECT MAX(start_date)
2773: FROM gl_period_statuses
2774: WHERE closing_status = 'O'
2775: AND adjustment_period_flag = 'N'
2776: AND period_type = c1_rec.period_type
2777: AND application_id = p_appId

Line 2799: FROM gl_period_statuses

2795: ELSE
2796: BEGIN
2797: SELECT period_name, start_date, end_date, sysdate
2798: INTO l_period_name, l_start_date, l_end_date, l_sysdate
2799: FROM gl_period_statuses
2800: WHERE adjustment_period_flag = 'N'
2801: AND period_type = c1_rec.period_type
2802: AND sysdate between start_date and end_date
2803: AND closing_status = 'O'

Line 2823: 'gl_period_statuses');

2819: END IF;
2820: EXCEPTION
2821: WHEN NO_ROWS THEN
2822: WarningPrint('There are no accounting periods defined in '||
2823: 'gl_period_statuses');
2824: ActionWArningprint('If required, define the accounting calendar for this '||
2825: 'application and set of books');
2826: WHEN NO_DATA_FOUND THEN
2827: ErrorPrint('Invalid Application id passed to checkFinPeriod');