APPS.GL_PERIODS_PKG dependencies on GL_PERIODS_PKG

Line 1: PACKAGE BODY gl_periods_pkg AS

1: PACKAGE BODY gl_periods_pkg AS
2: /* $Header: gliprdeb.pls 120.8 2006/12/06 06:44:34 spala ship $ */
3:
4: --
5: -- PRIVATE FUNCTIONS

Line 629: gl_periods_pkg.Update_Row (

625: WHERE period_set_name = X_Period_Set_Name
626: AND period_name = X_Period_Name;
627:
628: IF ( X_OWNER = 'SEED' ) THEN
629: gl_periods_pkg.Update_Row (
630: X_Rowid => v_rowid ,
631: X_Period_Set_Name => X_Period_Set_Name,
632: X_Period_Name => X_Period_Name,
633: X_Last_Update_Date => sysdate,

Line 660: gl_periods_pkg.Insert_Row (

656:
657: EXCEPTION
658: WHEN NO_DATA_FOUND THEN
659:
660: gl_periods_pkg.Insert_Row (
661: X_Rowid => v_rowid ,
662: X_Period_Set_Name => X_Period_Set_Name,
663: X_Period_Name => X_Period_Name,
664: X_Last_Update_Date => sysdate,

Line 1020: IF (gl_periods_pkg.period_changed(X_Rowid,

1016:
1017: BEGIN
1018:
1019: -- Make sure you are allowed to change this period
1020: IF (gl_periods_pkg.period_changed(X_Rowid,
1021: X_Period_Set_Name,
1022: X_Period_Name,
1023: X_Start_Date,
1024: X_End_Date,

Line 1031: IF (gl_periods_pkg.check_period_used(X_Rowid)) THEN

1027: X_Period_Num,
1028: X_Quarter_Num,
1029: X_Entered_Period_Name,
1030: X_Description)) THEN
1031: IF (gl_periods_pkg.check_period_used(X_Rowid)) THEN
1032: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_IN_USE');
1033: app_exception.raise_exception;
1034: END IF;
1035: END IF;

Line 1213: IF (gl_periods_pkg.check_period_used(X_Rowid)) THEN

1209: end if;
1210: CLOSE get_old_name;
1211:
1212: -- Make sure the period has never been used
1213: IF (gl_periods_pkg.check_period_used(X_Rowid)) THEN
1214: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_IN_USE');
1215: app_exception.raise_exception;
1216: END IF;
1217:

Line 1417: 'gl_periods_pkg.period_set_with_AB');

1413: EXCEPTION
1414: WHEN OTHERS THEN
1415: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1416: fnd_message.set_token('PROCEDURE',
1417: 'gl_periods_pkg.period_set_with_AB');
1418: RAISE;
1419:
1420: END period_set_with_AB;
1421:

Line 1635: GL_PERIODS_PKG.check_unique_num(calendar_name => Y_Period_Set_Name,

1631: v_number_per_fiscal_year NUMBER;
1632:
1633: BEGIN
1634: -- Check Unique Combination
1635: GL_PERIODS_PKG.check_unique_num(calendar_name => Y_Period_Set_Name,
1636: period_type => Y_Period_Type,
1637: period_year => Y_Period_Year,
1638: period_num => Y_Period_Num,
1639: row_id => Y_Rowid);

Line 1679: GL_PERIODS_PKG.Insert_Row(Y_Rowid,

1675: app_exception.raise_exception;
1676: END IF;
1677:
1678: -- Call the forms table handler.
1679: GL_PERIODS_PKG.Insert_Row(Y_Rowid,
1680: Y_Period_Set_Name,
1681: Y_Period_Name,
1682: Y_Last_Update_Date,
1683: Y_Last_Updated_By,

Line 1712: fnd_message.set_token('PROCEDURE', 'GL_PERIODS_PKG.Insert_Period');

1708: WHEN app_exceptions.application_exception THEN
1709: RAISE;
1710: WHEN OTHERS THEN
1711: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1712: fnd_message.set_token('PROCEDURE', 'GL_PERIODS_PKG.Insert_Period');
1713: RAISE;
1714: END Insert_Period;
1715:
1716: PROCEDURE Update_Period(Y_Rowid IN OUT NOCOPY VARCHAR2,

Line 1790: IF (GL_PERIODS_PKG.check_period_used(Y_Rowid)) THEN

1786: -- Check if the period has been used. If the period has been used,
1787: -- the period year, quarter number, period number, start date,
1788: -- end date, entered period name, and the adjustment flag fields
1789: -- cannot be updated.
1790: IF (GL_PERIODS_PKG.check_period_used(Y_Rowid)) THEN
1791: v_period_used_flag := 'Y';
1792: ELSE
1793: v_period_used_flag := 'N';
1794: END IF;

Line 1821: GL_PERIODS_PKG.check_unique_num(calendar_name => Y_Period_Set_Name,

1817: app_exception.raise_exception;
1818: END IF;
1819:
1820: -- Check Unique Combination.
1821: GL_PERIODS_PKG.check_unique_num(calendar_name => Y_Period_Set_Name,
1822: period_type => Y_Period_Type,
1823: period_year => Y_Period_Year,
1824: period_num => Y_Period_Num,
1825: row_id => Y_Rowid);

Line 1864: GL_PERIODS_PKG.Update_Row(Y_Rowid,

1860: app_exception.raise_exception;
1861: END IF;
1862:
1863: -- Call the forms table handler.
1864: GL_PERIODS_PKG.Update_Row(Y_Rowid,
1865: Y_Period_Set_Name,
1866: Y_Period_Name,
1867: Y_Last_Update_Date,
1868: Y_Last_Updated_By,

Line 1895: fnd_message.set_token('PROCEDURE', 'GL_PERIODS_PKG.Update_Period');

1891: WHEN app_exceptions.application_exception THEN
1892: RAISE;
1893: WHEN OTHERS THEN
1894: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1895: fnd_message.set_token('PROCEDURE', 'GL_PERIODS_PKG.Update_Period');
1896: RAISE;
1897: END Update_Period;
1898:
1899: END gl_periods_pkg;

Line 1899: END gl_periods_pkg;

1895: fnd_message.set_token('PROCEDURE', 'GL_PERIODS_PKG.Update_Period');
1896: RAISE;
1897: END Update_Period;
1898:
1899: END gl_periods_pkg;