eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_PERIOD_STATUSES_PKG dependencies on GL_PERIOD_STATUSES

Line 1: PACKAGE BODY gl_period_statuses_pkg AS

1: PACKAGE BODY gl_period_statuses_pkg AS
2: /* $Header: glipstab.pls 120.11.12010000.2 2009/09/18 06:21:33 akhanapu ship $ */
3:
4: --
5: -- PRIVATE FUNCTIONS

Line 82: 'gl_period_statuses_pkg.check_for_gap');

78: RAISE;
79: WHEN OTHERS THEN
80: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
81: fnd_message.set_token('PROCEDURE',
82: 'gl_period_statuses_pkg.check_for_gap');
83: RAISE;
84: END check_for_gap;
85:
86:

Line 95: FROM gl_period_statuses ps,

91: FUNCTION default_actual_period(acc_id NUMBER,
92: led_id NUMBER) RETURN VARCHAR2 IS
93: CURSOR get_latest_opened IS
94: SELECT ps.period_name
95: FROM gl_period_statuses ps,
96: gl_access_set_ledgers acc
97: WHERE ps.application_id = 101
98: AND ps.ledger_id = led_id
99: AND ps.closing_status = 'O'

Line 109: FROM gl_period_statuses ps,

105: ORDER BY effective_period_num DESC;
106:
107: CURSOR get_earliest_future_ent IS
108: SELECT ps.period_name
109: FROM gl_period_statuses ps,
110: gl_access_set_ledgers acc
111: WHERE ps.application_id = 101
112: AND ps.ledger_id = led_id
113: AND ps.closing_status = 'F'

Line 150: 'gl_period_statuses_pkg.default_actual_period');

146: RAISE;
147: WHEN OTHERS THEN
148: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
149: fnd_message.set_token('PROCEDURE',
150: 'gl_period_statuses_pkg.default_actual_period');
151: RAISE;
152: END default_actual_period;
153:
154: PROCEDURE get_next_period(

Line 161: FROM gl_period_statuses ps1,

157: x_next_period IN OUT NOCOPY VARCHAR2 ) IS
158:
159: CURSOR c_period IS
160: SELECT ps1.period_name
161: FROM gl_period_statuses ps1,
162: gl_period_statuses ps2
163: WHERE ps1.application_id = 101
164: AND ps1.ledger_id = x_ledger_id
165: AND ps2.application_id = 101

Line 162: gl_period_statuses ps2

158:
159: CURSOR c_period IS
160: SELECT ps1.period_name
161: FROM gl_period_statuses ps1,
162: gl_period_statuses ps2
163: WHERE ps1.application_id = 101
164: AND ps1.ledger_id = x_ledger_id
165: AND ps2.application_id = 101
166: AND ps2.ledger_id = x_ledger_id

Line 170: FROM gl_period_statuses ps3

166: AND ps2.ledger_id = x_ledger_id
167: AND ps2.period_name = x_period
168: AND ( ps1.start_date =
169: ( SELECT MIN( ps3.start_date )
170: FROM gl_period_statuses ps3
171: WHERE ps3.application_id = 101
172: AND ps3.ledger_id = x_ledger_id
173: AND ps3.start_date > ps2.start_date ) )
174: AND ps1.closing_status NOT IN ( 'N','C','P' );

Line 189: 'gl_period_statuses_pkg.get_next_period');

185: RAISE;
186: WHEN OTHERS THEN
187: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
188: fnd_message.set_token('PROCEDURE',
189: 'gl_period_statuses_pkg.get_next_period');
190: RAISE;
191:
192: END get_next_period;
193:

Line 210: LOCK TABLE GL_PERIOD_STATUSES IN SHARE UPDATE MODE;

206:
207: -- Before doing anything else...
208: check_for_gap(x_period_set_name, x_accounted_period_type);
209:
210: LOCK TABLE GL_PERIOD_STATUSES IN SHARE UPDATE MODE;
211:
212: INSERT INTO GL_PERIOD_STATUSES
213: ( application_id,
214: ledger_id,

Line 212: INSERT INTO GL_PERIOD_STATUSES

208: check_for_gap(x_period_set_name, x_accounted_period_type);
209:
210: LOCK TABLE GL_PERIOD_STATUSES IN SHARE UPDATE MODE;
211:
212: INSERT INTO GL_PERIOD_STATUSES
213: ( application_id,
214: ledger_id,
215: set_of_books_id,
216: period_name,

Line 274: 'gl_period_statuses_pkg.insert_led_ps');

270: RAISE;
271: WHEN OTHERS THEN
272: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
273: fnd_message.set_token('PROCEDURE',
274: 'gl_period_statuses_pkg.insert_led_ps');
275: RAISE;
276:
277: END insert_led_ps;
278:

Line 291: LOCK TABLE GL_PERIOD_STATUSES IN SHARE UPDATE MODE;

287:
288:
289: BEGIN
290:
291: LOCK TABLE GL_PERIOD_STATUSES IN SHARE UPDATE MODE;
292:
293: INSERT INTO GL_PERIOD_STATUSES
294: ( application_id,
295: ledger_id,

Line 293: INSERT INTO GL_PERIOD_STATUSES

289: BEGIN
290:
291: LOCK TABLE GL_PERIOD_STATUSES IN SHARE UPDATE MODE;
292:
293: INSERT INTO GL_PERIOD_STATUSES
294: ( application_id,
295: ledger_id,
296: set_of_books_id,
297: period_name,

Line 354: 'gl_period_statuses_pkg.insert_ps_api');

350: RAISE;
351: WHEN OTHERS THEN
352: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
353: fnd_message.set_token('PROCEDURE',
354: 'gl_period_statuses_pkg.insert_ps_api');
355: RAISE;
356:
357: END insert_ps_api;
358:

Line 375: l_Effective_period_num GL_PERIOD_STATUSES.effective_period_num%type;

371: x_last_update_login NUMBER,
372: x_quarter_start_date DATE,
373: x_year_start_date DATE) IS
374:
375: l_Effective_period_num GL_PERIOD_STATUSES.effective_period_num%type;
376: l_track_bc_ytd_flag GL_PERIOD_STATUSES.track_bc_ytd_flag%type;
377: l_sob_id GL_PERIOD_STATUSES.ledger_id%type;
378:
379: CURSOR c_period_statuses IS

Line 376: l_track_bc_ytd_flag GL_PERIOD_STATUSES.track_bc_ytd_flag%type;

372: x_quarter_start_date DATE,
373: x_year_start_date DATE) IS
374:
375: l_Effective_period_num GL_PERIOD_STATUSES.effective_period_num%type;
376: l_track_bc_ytd_flag GL_PERIOD_STATUSES.track_bc_ytd_flag%type;
377: l_sob_id GL_PERIOD_STATUSES.ledger_id%type;
378:
379: CURSOR c_period_statuses IS
380: SELECT track_bc_ytd_flag, set_of_books_id

Line 377: l_sob_id GL_PERIOD_STATUSES.ledger_id%type;

373: x_year_start_date DATE) IS
374:
375: l_Effective_period_num GL_PERIOD_STATUSES.effective_period_num%type;
376: l_track_bc_ytd_flag GL_PERIOD_STATUSES.track_bc_ytd_flag%type;
377: l_sob_id GL_PERIOD_STATUSES.ledger_id%type;
378:
379: CURSOR c_period_statuses IS
380: SELECT track_bc_ytd_flag, set_of_books_id
381: FROM gl_period_statuses

Line 381: FROM gl_period_statuses

377: l_sob_id GL_PERIOD_STATUSES.ledger_id%type;
378:
379: CURSOR c_period_statuses IS
380: SELECT track_bc_ytd_flag, set_of_books_id
381: FROM gl_period_statuses
382: WHERE application_id = 101
383: AND set_of_books_id in (SELECT ledger_id
384: FROM gl_ledgers
385: WHERE period_set_name = x_calendar_name

Line 393: FROM gl_period_statuses

389: BEGIN
390:
391: SELECT max(effective_period_num)
392: INTO l_Effective_period_num
393: FROM gl_period_statuses
394: WHERE application_id = 101
395: AND set_of_books_id in (
396: SELECT ledger_id
397: FROM gl_ledgers

Line 401: INSERT INTO GL_PERIOD_STATUSES

397: FROM gl_ledgers
398: WHERE period_set_name = x_calendar_name
399: AND accounted_period_type = x_period_type);
400:
401: INSERT INTO GL_PERIOD_STATUSES
402: ( application_id,
403: ledger_id,
404: set_of_books_id,
405: period_name,

Line 463: UPDATE gl_period_statuses

459: EXIT WHEN c_period_statuses%NOTFOUND ;
460:
461: IF l_track_bc_ytd_flag IS NOT NULL AND l_track_bc_ytd_flag = 'Y' THEN
462:
463: UPDATE gl_period_statuses
464: SET track_bc_ytd_flag = 'Y'
465: WHERE application_id = 101
466: AND set_of_books_id = l_sob_id
467: AND period_year=x_period_year

Line 482: 'gl_period_statuses_pkg.insert_period');

478: RAISE;
479: WHEN OTHERS THEN
480: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
481: fnd_message.set_token('PROCEDURE',
482: 'gl_period_statuses_pkg.insert_period');
483: RAISE;
484: END insert_period;
485:
486:

Line 502: UPDATE GL_PERIOD_STATUSES ps

498: x_last_updated_by NUMBER,
499: x_last_update_login NUMBER) IS
500: BEGIN
501:
502: UPDATE GL_PERIOD_STATUSES ps
503: SET ps.period_name = x_period_name,
504: ps.start_date = x_start_date,
505: ps.end_date = x_end_date,
506: ps.period_type = x_period_type,

Line 529: 'gl_period_statuses_pkg.update_period');

525: RAISE;
526: WHEN OTHERS THEN
527: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
528: fnd_message.set_token('PROCEDURE',
529: 'gl_period_statuses_pkg.update_period');
530: RAISE;
531: END update_period;
532:
533:

Line 538: DELETE gl_period_statuses ps

534: PROCEDURE delete_period(
535: x_calendar_name VARCHAR2,
536: x_old_period_name VARCHAR2) IS
537: BEGIN
538: DELETE gl_period_statuses ps
539: WHERE ps.period_name = x_old_period_name
540: AND ps.ledger_id in
541: (SELECT led.ledger_id
542: FROM gl_ledgers led

Line 553: 'gl_period_statuses_pkg.delete_period');

549: RAISE;
550: WHEN OTHERS THEN
551: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
552: fnd_message.set_token('PROCEDURE',
553: 'gl_period_statuses_pkg.delete_period');
554: RAISE;
555: END delete_period;
556:
557:

Line 558: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_period_statuses%ROWTYPE ) IS

554: RAISE;
555: END delete_period;
556:
557:
558: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_period_statuses%ROWTYPE ) IS
559: BEGIN
560: SELECT *
561: INTO recinfo
562: FROM gl_period_statuses

Line 562: FROM gl_period_statuses

558: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_period_statuses%ROWTYPE ) IS
559: BEGIN
560: SELECT *
561: INTO recinfo
562: FROM gl_period_statuses
563: WHERE application_id = recinfo.application_id
564: AND ledger_id = recinfo.ledger_id
565: AND period_name = recinfo.period_name ;
566: EXCEPTION

Line 574: 'gl_period_statuses_pkg.select_row');

570: RAISE;
571: WHEN OTHERS THEN
572: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
573: fnd_message.set_token('PROCEDURE',
574: 'gl_period_statuses_pkg.select_row');
575: RAISE;
576: END select_row;
577:
578:

Line 588: recinfo gl_period_statuses%ROWTYPE;

584: x_start_date IN OUT NOCOPY DATE,
585: x_end_date IN OUT NOCOPY DATE,
586: x_period_num IN OUT NOCOPY NUMBER,
587: x_period_year IN OUT NOCOPY NUMBER ) IS
588: recinfo gl_period_statuses%ROWTYPE;
589: BEGIN
590: recinfo.application_id := x_application_id;
591: recinfo.ledger_id := x_ledger_id;
592: recinfo.period_name := x_period_name;

Line 607: 'gl_period_statuses_pkg.select_columns');

603: RAISE;
604: WHEN OTHERS THEN
605: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
606: fnd_message.set_token('PROCEDURE',
607: 'gl_period_statuses_pkg.select_columns');
608: RAISE;
609: END select_columns;
610:
611:

Line 631: update gl_period_statuses ps

627: v_period_type
628: from gl_ledgers led
629: where led.ledger_id = x_ledger_id;
630:
631: update gl_period_statuses ps
632: set ps.closing_status =
633: decode(ps.period_year, x_period_year,
634: decode(ps.period_num, x_period_num,'O',
635: 'F'),

Line 643: from gl_period_statuses ps1,

639: where ps.ledger_id = x_ledger_id
640: and ps.application_id = x_application_id
641: and ps.period_name in
642: (select period_name
643: from gl_period_statuses ps1,
644: gl_period_types pt
645: where v_period_type = pt.period_type
646: and ps1.application_id = x_application_id
647: and ps1.ledger_id = x_ledger_id

Line 675: 'gl_period_statuses_pkg.initialize_period_statuses');

671: RAISE;
672: WHEN OTHERS THEN
673: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
674: fnd_message.set_token('PROCEDURE',
675: 'gl_period_statuses_pkg.initialize_period_statuses');
676: RAISE;
677: END initialize_period_statuses;
678:
679: PROCEDURE select_encumbrance_periods(

Line 695: GL_PERIOD_STATUSES PS1,

691: PS2.period_name,
692: PS2.period_year,
693: PS2.start_date
694: FROM GL_LEDGERS LED,
695: GL_PERIOD_STATUSES PS1,
696: GL_PERIOD_STATUSES PS2,
697: GL_PERIOD_TYPES GPT
698: WHERE PS1.application_id = x_application_id
699: AND PS1.closing_status || '' in ('C', 'P')

Line 696: GL_PERIOD_STATUSES PS2,

692: PS2.period_year,
693: PS2.start_date
694: FROM GL_LEDGERS LED,
695: GL_PERIOD_STATUSES PS1,
696: GL_PERIOD_STATUSES PS2,
697: GL_PERIOD_TYPES GPT
698: WHERE PS1.application_id = x_application_id
699: AND PS1.closing_status || '' in ('C', 'P')
700: AND PS1.ledger_id = x_ledger_id

Line 728: 'gl_period_statuses_pkg.select_encumbrance_periods');

724: RAISE;
725: WHEN OTHERS THEN
726: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
727: fnd_message.set_token('PROCEDURE',
728: 'gl_period_statuses_pkg.select_encumbrance_periods');
729: RAISE;
730:
731: END select_encumbrance_periods;
732:

Line 742: FROM GL_PERIOD_STATUSES

738: x_period_name IN OUT NOCOPY VARCHAR2) IS
739:
740: CURSOR c_period IS
741: SELECT period_name
742: FROM GL_PERIOD_STATUSES
743: WHERE application_id = x_application_id
744: AND ledger_id = x_ledger_id
745: AND period_year = x_period_year - 1
746: AND period_num = (SELECT min(period_num)

Line 747: FROM GL_PERIOD_STATUSES

743: WHERE application_id = x_application_id
744: AND ledger_id = x_ledger_id
745: AND period_year = x_period_year - 1
746: AND period_num = (SELECT min(period_num)
747: FROM GL_PERIOD_STATUSES
748: WHERE application_id = x_application_id
749: AND ledger_id = x_ledger_id
750: AND period_year = x_period_year - 1);
751:

Line 765: 'gl_period_statuses_pkg.select_prior_year_1st_period');

761: RAISE;
762: WHEN OTHERS THEN
763: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
764: fnd_message.set_token('PROCEDURE',
765: 'gl_period_statuses_pkg.select_prior_year_1st_period');
766: RAISE;
767: END select_prior_year_1st_period;
768:
769:

Line 781: gl_period_statuses s1

777: CURSOR c_period IS
778: select
779: period_name
780: from
781: gl_period_statuses s1
782: where
783: s1.application_id = x_application_id
784: and s1.ledger_id = x_ledger_id
785: and s1.period_year = x_period_year

Line 787: from gl_period_statuses s2

783: s1.application_id = x_application_id
784: and s1.ledger_id = x_ledger_id
785: and s1.period_year = x_period_year
786: and s1.period_num = (select min(period_num)
787: from gl_period_statuses s2
788: where s2.period_year = x_period_year
789: and s2.application_id = x_application_id
790: and s2.ledger_id = x_ledger_id);
791:

Line 805: 'gl_period_statuses_pkg.select_year_1st_period');

801: RAISE;
802: WHEN OTHERS THEN
803: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
804: fnd_message.set_token('PROCEDURE',
805: 'gl_period_statuses_pkg.select_year_1st_period');
806: RAISE;
807: END select_year_1st_period;
808:
809:

Line 826: gl_period_statuses

822: CURSOR c_qtde IS
823: select
824: period_name, period_num, period_year, quarter_num
825: from
826: gl_period_statuses
827: where
828: application_id = x_application_id
829: and ledger_id = x_ledger_id
830: and period_year = x_period_year

Line 832: from gl_period_statuses glps

828: application_id = x_application_id
829: and ledger_id = x_ledger_id
830: and period_year = x_period_year
831: and period_num = (select max(glps.period_num)
832: from gl_period_statuses glps
833: where glps.closing_status in ('O','C','P')
834: and glps.quarter_num = (
835: select quarter_num from gl_periods
836: where period_name = x_period_name

Line 862: 'gl_period_statuses_pkg.get_extended_quarter');

858: RAISE;
859: WHEN OTHERS THEN
860: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
861: fnd_message.set_token('PROCEDURE',
862: 'gl_period_statuses_pkg.get_extended_quarter');
863: RAISE;
864: END get_extended_quarter;
865:
866:

Line 881: gl_period_statuses

877: CURSOR c_ytde IS
878: select
879: period_name, period_num, period_year, quarter_num
880: from
881: gl_period_statuses
882: where
883: application_id = x_application_id
884: and ledger_id = x_ledger_id
885: and period_year = x_period_year

Line 887: from gl_period_statuses

883: application_id = x_application_id
884: and ledger_id = x_ledger_id
885: and period_year = x_period_year
886: and period_num = (select max(period_num)
887: from gl_period_statuses
888: where period_type = x_accounted_period_type
889: and ledger_id = x_ledger_id
890: and period_year = x_period_year
891: and closing_status in ('O','C','P')

Line 910: 'gl_period_statuses_pkg.get_extended_year');

906: RAISE;
907: WHEN OTHERS THEN
908: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
909: fnd_message.set_token('PROCEDURE',
910: 'gl_period_statuses_pkg.get_extended_year');
911: RAISE;
912: END get_extended_year;
913:
914:

Line 941: CURSOR C IS SELECT rowid FROM gl_period_statuses

937: X_Attribute5 VARCHAR2,
938: X_Context VARCHAR2
939:
940: ) IS
941: CURSOR C IS SELECT rowid FROM gl_period_statuses
942: WHERE application_id = X_Application_Id
943:
944: AND ledger_id = X_Ledger_Id
945:

Line 953: INSERT INTO gl_period_statuses(

949:
950: BEGIN
951:
952:
953: INSERT INTO gl_period_statuses(
954: application_id,
955: ledger_id,
956: set_of_books_id,
957: period_name,

Line 1039: FROM gl_period_statuses

1035:
1036: ) IS
1037: CURSOR C IS
1038: SELECT *
1039: FROM gl_period_statuses
1040: WHERE rowid = X_Rowid
1041: FOR UPDATE of Application_Id NOWAIT;
1042: Recinfo C%ROWTYPE;
1043: BEGIN

Line 1118: UPDATE gl_period_statuses

1114: ) IS
1115: BEGIN
1116:
1117: IF (X_Closing_Status IN ('C', 'P')) THEN
1118: UPDATE gl_period_statuses
1119: SET
1120: application_id = X_Application_Id,
1121: ledger_id = X_Ledger_Id,
1122: period_name = X_Period_Name,

Line 1145: UPDATE gl_period_statuses

1141: effective_period_num = X_Period_Year * 10000 + X_Period_Num
1142:
1143: WHERE rowid = X_rowid;
1144: ELSE
1145: UPDATE gl_period_statuses
1146: SET
1147: application_id = X_Application_Id,
1148: ledger_id = X_Ledger_Id,
1149: period_name = X_Period_Name,

Line 1180: DELETE FROM gl_period_statuses

1176: END Update_Row;
1177:
1178: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
1179: BEGIN
1180: DELETE FROM gl_period_statuses
1181: WHERE rowid = X_Rowid;
1182:
1183: if (SQL%NOTFOUND) then
1184: Raise NO_DATA_FOUND;

Line 1202: FROM gl_period_statuses

1198: X_Last_Update_Login NUMBER
1199: ) IS
1200: CURSOR C IS
1201: SELECT *
1202: FROM gl_period_statuses
1203: WHERE rowid = X_rowid
1204: FOR UPDATE of Application_Id NOWAIT;
1205: Recinfo C%ROWTYPE;
1206: BEGIN

Line 1250: UPDATE gl_period_statuses

1246: OR ( (Recinfo.context IS NULL)
1247: AND (X_Context IS NOT NULL))
1248: )
1249: )) THEN
1250: UPDATE gl_period_statuses
1251: SET
1252: Attribute1 = X_Attribute1,
1253: Attribute2 = X_Attribute2,
1254: Attribute3 = X_Attribute3,

Line 1280: FROM gl_period_statuses ps,

1276: SELECT ps.period_name, ps.closing_status,
1277: ps.period_year, ps.period_num, ps.period_type
1278: INTO x_period_name, x_closing_status, x_period_year,
1279: x_period_num, x_period_type
1280: FROM gl_period_statuses ps,
1281: gl_date_period_map dpm,
1282: gl_ledgers led
1283: WHERE led.ledger_id = x_ledger_id
1284: AND dpm.accounting_date = x_given_date

Line 1300: 'gl_period_statuses_pkg.get_period_by_date');

1296: RETURN;
1297: /*
1298: fnd_message.set_name('SQLGL', 'GL_IEA_NOT_IN_OPEN_FUTURE_PER');
1299: fnd_message.set_token('PROCEDURE',
1300: 'gl_period_statuses_pkg.get_period_by_date');
1301: APP_EXCEPTION.Raise_Exception;
1302: */
1303: WHEN app_exceptions.application_exception THEN
1304: RAISE;

Line 1308: 'gl_period_statuses_pkg.get_period_by_date');

1304: RAISE;
1305: WHEN OTHERS THEN
1306: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1307: fnd_message.set_token('PROCEDURE',
1308: 'gl_period_statuses_pkg.get_period_by_date');
1309: RAISE;
1310: END get_period_by_date;
1311:
1312:

Line 1319: FROM gl_period_statuses

1315: x_start_date IN OUT NOCOPY DATE,
1316: x_end_date IN OUT NOCOPY DATE) IS
1317: CURSOR not_never_opened_period IS
1318: SELECT min(start_date), max(end_date)
1319: FROM gl_period_statuses
1320: WHERE application_id = 101
1321: AND ledger_id = x_ledger_id
1322: AND closing_status <> 'N';
1323:

Line 1339: 'gl_period_statuses_pkg.get_calendar_range');

1335: RAISE;
1336: WHEN OTHERS THEN
1337: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1338: fnd_message.set_token('PROCEDURE',
1339: 'gl_period_statuses_pkg.get_calendar_range');
1340: RAISE;
1341: END get_calendar_range;
1342:
1343:

Line 1350: FROM gl_period_statuses

1346: x_start_date IN OUT NOCOPY DATE,
1347: x_end_date IN OUT NOCOPY DATE) IS
1348: CURSOR closed_opened_period IS
1349: SELECT min(start_date), max(end_date)
1350: FROM gl_period_statuses
1351: WHERE application_id = 101
1352: AND ledger_id = x_ledger_id
1353: AND closing_status in ('C', 'O', 'P');
1354:

Line 1370: 'gl_period_statuses_pkg.get_open_closed_calendar_range');

1366: RAISE;
1367: WHEN OTHERS THEN
1368: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1369: fnd_message.set_token('PROCEDURE',
1370: 'gl_period_statuses_pkg.get_open_closed_calendar_range');
1371: RAISE;
1372: END get_open_closed_calendar_range;
1373:
1374:

Line 1381: FROM gl_period_statuses

1377: x_start_date IN OUT NOCOPY DATE,
1378: x_end_date IN OUT NOCOPY DATE) IS
1379: CURSOR journal_period IS
1380: SELECT min(start_date), max(end_date)
1381: FROM gl_period_statuses
1382: WHERE application_id = 101
1383: AND ledger_id = x_ledger_id
1384: AND closing_status||'' IN ('O', 'F');
1385:

Line 1401: 'gl_period_statuses_pkg.get_journal_range');

1397: RAISE;
1398: WHEN OTHERS THEN
1399: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1400: fnd_message.set_token('PROCEDURE',
1401: 'gl_period_statuses_pkg.get_journal_range');
1402: RAISE;
1403: END get_journal_range;
1404:
1405: END gl_period_statuses_pkg;

Line 1405: END gl_period_statuses_pkg;

1401: 'gl_period_statuses_pkg.get_journal_range');
1402: RAISE;
1403: END get_journal_range;
1404:
1405: END gl_period_statuses_pkg;