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 2722: gl_period_statuses b

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

Line 2764: FROM gl_period_statuses

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

Line 2769: FROM gl_period_statuses

2765: WHERE adjustment_period_flag = 'N'
2766: AND period_type = c1_rec.period_type
2767: AND start_date = (
2768: SELECT MAX(start_date)
2769: FROM gl_period_statuses
2770: WHERE closing_status = 'O'
2771: AND adjustment_period_flag = 'N'
2772: AND period_type = c1_rec.period_type
2773: AND application_id = p_appId

Line 2795: FROM gl_period_statuses

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

Line 2819: 'gl_period_statuses');

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