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 gl_period_statuses_pkg AS

1: PACKAGE gl_period_statuses_pkg AS
2: /* $Header: glipstas.pls 120.6 2006/08/11 12:31:06 aktelang ship $ */
3: --
4: -- Package
5: -- gl_period_statuses_pkg

Line 5: -- gl_period_statuses_pkg

1: PACKAGE gl_period_statuses_pkg AS
2: /* $Header: glipstas.pls 120.6 2006/08/11 12:31:06 aktelang ship $ */
3: --
4: -- Package
5: -- gl_period_statuses_pkg
6: -- Purpose
7: -- To contain validation and insertion routines for gl_period_statuses
8: -- History
9: -- 10-07-93 D. J. Ogg Created

Line 7: -- To contain validation and insertion routines for gl_period_statuses

3: --
4: -- Package
5: -- gl_period_statuses_pkg
6: -- Purpose
7: -- To contain validation and insertion routines for gl_period_statuses
8: -- History
9: -- 10-07-93 D. J. Ogg Created
10: -- 01-10-94 D. J. Ogg Modified select_columns to also return the
11: -- period number and year

Line 43: -- gl_period_statuses_pkg.get_next_period(

39: -- x_ledger_id Ledger id
40: -- x_period Last executed period
41: -- x_next_period Next open period
42: -- Example
43: -- gl_period_statuses_pkg.get_next_period(
44: -- :block.ledger_id,
45: -- :block.period,
46: -- :block.next_period );
47: -- Notes

Line 59: -- Used to insert records into gl_period_statuses

55: --
56: -- Procedure
57: -- insert_led_ps
58: -- Purpose
59: -- Used to insert records into gl_period_statuses
60: -- for a new ledger.
61: -- History
62: -- 12-06-93 E. Rumanang Created
63: -- Arguments

Line 73: -- gl_period_statuses_pkg.insert_led_ps(

69: -- x_last_update_login
70: -- x_creation_date
71: -- x_created_by
72: -- Example
73: -- gl_period_statuses_pkg.insert_led_ps(
74: -- '1', 'Standard', 'Month', '01-JAN-93', 100, 100, '01-JAN-93', 100)
75: -- Notes
76: --
77: PROCEDURE insert_led_ps(

Line 106: -- 1. gl_period_statuses_pkg.insert_ps_api(

102: -- x_period_set_name Name of the calendar
103: -- x_user_id User ID
104: -- x_login_id Login ID
105: -- Example
106: -- 1. gl_period_statuses_pkg.insert_ps_api(
107: -- 275, 1, 'JAN-93', 'O','', 1034, 1034 )
108: -- 2. gl_period_statuses_pkg.insert_ps_api(
109: -- 275, 1, 'JAN-93', 'O', 'Standard', 1034, 1034 )
110: -- Notes

Line 108: -- 2. gl_period_statuses_pkg.insert_ps_api(

104: -- x_login_id Login ID
105: -- Example
106: -- 1. gl_period_statuses_pkg.insert_ps_api(
107: -- 275, 1, 'JAN-93', 'O','', 1034, 1034 )
108: -- 2. gl_period_statuses_pkg.insert_ps_api(
109: -- 275, 1, 'JAN-93', 'O', 'Standard', 1034, 1034 )
110: -- Notes
111: -- 1. If x_period_set_name is NULL, period_set_name
112: -- from led will be used.

Line 127: -- Used to insert records into gl_period_statuses

123: --
124: -- Procedure
125: -- insert_period
126: -- Purpose
127: -- Used to insert records into gl_period_statuses
128: -- for a new period.
129: -- History
130: -- 10-07-93 D. J. Ogg Created
131: -- Arguments

Line 148: -- gl_period_statuses_pkg.insert_period(

144: -- update the period
145: -- x_last_update_login Login ID of the last person
146: -- to update the period
147: -- Example
148: -- gl_period_statuses_pkg.insert_period(
149: -- 'Standard', 'JAN-93', '01-JAN-93', '31-JAN-93', 'Month',
150: -- 1993, 1, 1, 'N', 0, 0);
151: -- Notes
152: --

Line 172: -- Updates the entries in gl_period_statuses associated with a given

168: --
169: -- Procedure
170: -- update_period
171: -- Purpose
172: -- Updates the entries in gl_period_statuses associated with a given
173: -- period.
174: -- History
175: -- 10-07-93 D. J. Ogg Created
176: -- Arguments

Line 218: -- Deletes the rows in gl_period_statuses associated with

214: --
215: -- Procedure
216: -- delete_period
217: -- Purpose
218: -- Deletes the rows in gl_period_statuses associated with
219: -- a period.
220: -- History
221: -- 10-07-93 D. J. Ogg Created
222: -- Arguments

Line 239: -- Gets the row from gl_period_statuses associated with

235: --
236: -- Procedure
237: -- select_row
238: -- Purpose
239: -- Gets the row from gl_period_statuses associated with
240: -- the given period.
241: -- History
242: -- 11-05-93 E. Rumanang Created
243: -- Arguments

Line 244: -- recinfo gl_period_statuses

240: -- the given period.
241: -- History
242: -- 11-05-93 E. Rumanang Created
243: -- Arguments
244: -- recinfo gl_period_statuses
245: -- Example
246: -- select_row.recinfo;
247: -- Notes
248: --

Line 249: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_period_statuses%ROWTYPE );

245: -- Example
246: -- select_row.recinfo;
247: -- Notes
248: --
249: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_period_statuses%ROWTYPE );
250:
251: --
252: -- Procedure
253: -- select_columns

Line 256: -- and period_year columns from gl_period_statuses associated with

252: -- Procedure
253: -- select_columns
254: -- Purpose
255: -- Gets the value for closing_status, start_date, end_date, period_num,
256: -- and period_year columns from gl_period_statuses associated with
257: -- the given period.
258: -- History
259: -- 11-05-93 E. Rumanang Created
260: -- 01-10-94 D J Ogg Added arguments for period num and period year

Line 271: -- gl_period_statuses_pkg.select_columns( :block.application_id,

267: -- x_end_date End date of the period
268: -- x_period_num Number of the period
269: -- x_period_year Year containing the period
270: -- Example
271: -- gl_period_statuses_pkg.select_columns( :block.application_id,
272: -- :block.ledger_id, :block.period_name, :block.closing_status,
273: -- :block.start_date, :block.end_date, :block.pnum, :block.pyear );
274: -- Notes
275: --

Line 301: -- gl_period_statuses_pkg.initialize_period_statuses(

297: -- x_period_year period year
298: -- x_period_num period number
299: -- x_user_id User Id
300: -- Example
301: -- gl_period_statuses_pkg.initialize_period_statuses(
302: -- :block.application_id,
303: -- :block.ledger_id,
304: -- :block.period_year,
305: -- :block.period_num,

Line 336: -- gl_period_statuses_pkg.select_encumbrance_periods

332: -- x_second_period PS2.period_name
333: -- x_second_period_year PS2.period_year
334: -- x_second_period_start_date PS2.start_date
335: -- Example
336: -- gl_period_statuses_pkg.select_encumbrance_periods
337: -- :block.application_id,
338: -- :block.ledger_id,
339: -- :block.first_period,
340: -- :block.first_start,

Line 367: -- gl_period_statuses_pkg.select_prior_year_1st_period

363: -- x_ledger_id Ledger id
364: -- x_period_year Period Year
365: -- x_period_name Period Name
366: -- Example
367: -- gl_period_statuses_pkg.select_prior_year_1st_period
368: -- :block.application_id,
369: -- :block.ledger_id,
370: -- :block.period_year,
371: -- :block.period_name)

Line 393: -- gl_period_statuses_pkg.select_year_1st_period

389: -- x_ledger_id Ledger id
390: -- x_period_year Period Year
391: -- x_period_name Period Name
392: -- Example
393: -- gl_period_statuses_pkg.select_year_1st_period
394: -- :block.application_id,
395: -- :block.ledger_id,
396: -- :block.period_year,
397: -- :block.period_name)

Line 547: -- gl_period_statuses associated with the given period of the supplied rowid.

543: -- Procedure
544: -- update_row_dff
545: -- Purpose
546: -- Updates the value for attribute columns of
547: -- gl_period_statuses associated with the given period of the supplied rowid.
548: -- History
549: -- 08/10/06 aktelang Created
550: -- Arguments
551: -- X_rowid Row id for the period

Line 563: -- gl_period_statuses_pkg.update_row_dff( :block.rowid,

559: -- X_Last_Updated_By Who column
560: -- X_Last_Update_Login Who column
561:
562: -- Example
563: -- gl_period_statuses_pkg.update_row_dff( :block.rowid,
564: -- :block.attribute1, :block.attribute2,
565: -- :block.attribute3, :block.attribute4,
566: -- :block.attribute4, :block.context,
567: -- :block.Last_Update_Date, :block.Last_Updated_By,

Line 588: -- gl_period_statuses associated with the given date.

584: -- Procedure
585: -- get_period_by_date
586: -- Purpose
587: -- Gets the value for closing_status, period_name from
588: -- gl_period_statuses associated with the given date.
589: -- History
590: -- 07/31/95 Eugene Weinstein Created
591: -- Arguments
592: -- x_application_id Application id of the product

Line 598: -- gl_period_statuses_pkg.get_period_by_date( :block.application_id,

594: -- x_given_date the date which being analyzed
595: -- x_period_name Name of the period
596: -- x_closing_status Status of the period
597: -- Example
598: -- gl_period_statuses_pkg.get_period_by_date( :block.application_id,
599: -- :block.ledger_id, :block.x_given_date,
600: -- :block.period_name, :block.closing_status);
601: -- Notes
602: --

Line 628: -- gl_period_statuses_pkg.get_calendar_range(:led_id, :start_date, :end_date)

624: -- x_ledger_id Ledger id
625: -- x_start_date Start date for the range
626: -- x_end_date End date for the range
627: -- Example
628: -- gl_period_statuses_pkg.get_calendar_range(:led_id, :start_date, :end_date)
629: -- Notes
630: --
631: PROCEDURE get_calendar_range(
632: x_ledger_id NUMBER,

Line 650: -- gl_period_statuses_pkg.get_open_closed_calendar_range(:led_id,

646: -- x_ledger_id Ledger id
647: -- x_start_date Start date for the range
648: -- x_end_date End date for the range
649: -- Example
650: -- gl_period_statuses_pkg.get_open_closed_calendar_range(:led_id,
651: -- :start_date, :end_date)
652: -- Notes
653: --
654: PROCEDURE get_open_closed_calendar_range(

Line 674: -- gl_period_statuses_pkg.get_journal_range(:led_id,:start_date,:end_date)

670: -- x_ledger_id Ledger id
671: -- x_start_date Start date for the range
672: -- x_end_date End date for the range
673: -- Example
674: -- gl_period_statuses_pkg.get_journal_range(:led_id,:start_date,:end_date)
675: -- Notes
676: --
677: PROCEDURE get_journal_range(
678: x_ledger_id NUMBER,

Line 682: END gl_period_statuses_pkg;

678: x_ledger_id NUMBER,
679: x_start_date IN OUT NOCOPY DATE,
680: x_end_date IN OUT NOCOPY DATE);
681:
682: END gl_period_statuses_pkg;