APPS.CN_PERIODS_API dependencies on GL_PERIOD_STATUSES

Line 17: -- 11-28-95 A Erickson Support WHO columns in GL_PERIOD_STATUSES update.

13: -- procedures to support new API.
14: -- 07-26-95 A Erickson cn_periods.period_name colum name update.
15: -- 07-24-95 A Erickson check_cn_period_record. set repository_status = F.
16: -- 08-08-95 A Erickson init srp periods when new cn period created.
17: -- 11-28-95 A Erickson Support WHO columns in GL_PERIOD_STATUSES update.
18: -- 01-26-96 A Erickson Added Set_Dates routine for Collection code.
19: -- 03-13-96 A Erickson Remove reference to system start date.
20: -- 26-MAR-03 (gasriniv) updated to fix bug#2804029
21: -- 02-02-07 jxsingh Bug#5707688 + Open Period Log Messages Added.

Line 37: -- Update status in GL_PERIOD_STATUSES

33: --
34: -- Procedure Name
35: -- Update_GL_Status
36: -- Purpose
37: -- Update status in GL_PERIOD_STATUSES
38: --
39:
40: PROCEDURE update_gl_status ( x_org_id NUMBER,
41: x_period_name VARCHAR2,

Line 54: FROM GL_PERIOD_STATUSES GL

50: IS
51: CURSOR c IS
52: SELECT gl.closing_status, gl.start_date, gl.end_date,
53: gl.quarter_num, gl.period_year
54: FROM GL_PERIOD_STATUSES GL
55: WHERE gl.application_id = x_application_id
56: AND gl.adjustment_period_flag = 'N'
57: and gl.set_of_books_id = x_set_of_books_id
58: and gl.period_name = x_period_name;

Line 103: UPDATE gl_period_statuses

99: CLOSE cn_period_info;
100: -- End add as part of bug fix bug#2804029
101:
102:
103: UPDATE gl_period_statuses
104: SET closing_status = x_closing_status,
105: last_update_date = x_last_update_date,
106: last_update_login = x_last_update_login,
107: last_updated_by = x_last_updated_by