27: | |
28: | PARAMETER DESCRIPTION |
29: | --------------------- |
30: | p_ledger_short_name IN short_name from gl_ledgers table. |
31: | p_start_date IN start_date of the period from gl_period_statuses |
32: | p_end_date IN end_date of the period from gl_period_statuses |
33: | errbuf OUT Default out parameter to capture error message |
34: | retcode OUT Default out parameter to capture error code |
35: | x_return_status OUT Default out parameter to capture status |
28: | PARAMETER DESCRIPTION |
29: | --------------------- |
30: | p_ledger_short_name IN short_name from gl_ledgers table. |
31: | p_start_date IN start_date of the period from gl_period_statuses |
32: | p_end_date IN end_date of the period from gl_period_statuses |
33: | errbuf OUT Default out parameter to capture error message |
34: | retcode OUT Default out parameter to capture error code |
35: | x_return_status OUT Default out parameter to capture status |
36: | HISTORY |
85: c_end_date DATE
86: )
87: IS
88: SELECT *
89: FROM gl_period_statuses
90: WHERE application_id = c_application_id --101
91: AND closing_status <> c_closing_status --'O'
92: AND ledger_id = c_ledger_id
93: AND start_date >= c_start_date
102: c_end_date DATE
103: )
104: IS
105: SELECT *
106: FROM gl_period_statuses
107: WHERE application_id = c_application_id
108: AND closing_status = c_closing_status
109: AND ledger_id = c_ledger_id
110: AND (start_date < c_start_date OR end_date > c_end_date);
116: c_period_name IN VARCHAR2
117: )
118: IS
119: SELECT closing_status
120: FROM gl_period_statuses
121: WHERE ledger_id = c_ledger_id
122: AND application_id = c_application_id
123: AND period_name = c_period_name;
124:
141: SELECT 'Y'
142: FROM DUAL
143: WHERE EXISTS (
144: SELECT 1
145: FROM gl_period_statuses gps, gl_ledgers gl
146: WHERE gl.ledger_id = gps.ledger_id
147: AND gps.application_id = c_application_id
148: AND gl.short_name = c_ledger_short_name
149: AND gps.start_date = c_start_date);
158: SELECT 'Y'
159: FROM DUAL
160: WHERE EXISTS (
161: SELECT 1
162: FROM gl_period_statuses gps, gl_ledgers gl
163: WHERE gl.ledger_id = gps.ledger_id
164: AND gps.application_id = c_application_id
165: AND gl.short_name = c_ledger_short_name
166: AND gps.end_date = c_end_date);