APPS.OKL_PERD_STATUS_PVT dependencies on GL_PERIOD_STATUSES

Line 92: FROM GL_PERIOD_STATUSES

88: ,YEAR_START_DATE
89: ,QUARTER_START_DATE
90: ,EFFECTIVE_PERIOD_NUM
91: ,ELIMINATION_CONFIRMED_FLAG
92: FROM GL_PERIOD_STATUSES
93: WHERE Application_id = ' || ':1' ||
94: ' AND ledger_id = ' || ':2' ;
95:
96:

Line 189: FROM gl_period_statuses

185: i NUMBER := 0;
186:
187: CURSOR perd_csr(p_period_name VARCHAR2,p_ledger_id NUMBER) IS
188: SELECT closing_status
189: FROM gl_period_statuses
190: WHERE application_id = 540
191: AND ledger_id = p_ledger_id
192: AND period_name = p_period_name;
193:

Line 196: l_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;

192: AND period_name = p_period_name;
193:
194: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
195: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
196: l_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;
197: l_msg_data_comp VARCHAR2(2000);
198: l_msg_data VARCHAR2(2000);
199: l_msg_count NUMBER;
200:

Line 332: FROM GL_PERIOD_STATUSES

328: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
329:
330: CURSOR prd_csr (v_period_name VARCHAR2,p_ledger_id NUMBER) IS
331: SELECT closing_status
332: FROM GL_PERIOD_STATUSES
333: WHERE application_id = 540
334: AND ledger_id = p_ledger_id
335: AND period_name = v_period_name
336: FOR UPDATE;

Line 379: FROM gl_period_statuses

375: -- Fixed Bug 3621515 by Santonyr on 15-May-2004
376:
377: CURSOR gl_csr1(p_start_date DATE,p_ledger_id NUMBER) IS
378: SELECT period_name
379: FROM gl_period_statuses
380: WHERE application_id = 101
381: AND ledger_id = p_ledger_id
382: AND start_date <= p_start_date
383: AND closing_status IN ('O', 'F');

Line 389: FROM gl_period_statuses

385:
386: --- Cursor to find out status of a period in GL
387: CURSOR gl_csr2(p_period_name VARCHAR2,p_ledger_id NUMBER) IS
388: SELECT closing_status
389: FROM gl_period_statuses
390: WHERE application_id = 101
391: AND ledger_id = p_ledger_id
392: AND period_name = p_period_name;
393:

Line 400: FROM gl_period_statuses

396: --- which is being closed
397:
398: CURSOR prior_csr(p_start_date DATE,p_ledger_id NUMBER) IS
399: SELECT period_name
400: FROM gl_period_statuses
401: WHERE application_id = 540
402: AND ledger_id = p_ledger_id
403: AND closing_status IN ('F','O')
404: AND start_date < p_start_date;

Line 413: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;

409: l_start_date DATE;
410: l_end_date DATE;
411: l_dummy VARCHAR2(1);
412: l_duplicate VARCHAR2(1);
413: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
414:
415: l_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;
416: l_gl_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;
417:

Line 415: l_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;

411: l_dummy VARCHAR2(1);
412: l_duplicate VARCHAR2(1);
413: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
414:
415: l_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;
416: l_gl_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;
417:
418: BEGIN
419:

Line 416: l_gl_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;

412: l_duplicate VARCHAR2(1);
413: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
414:
415: l_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;
416: l_gl_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;
417:
418: BEGIN
419:
420: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 644: UPDATE GL_PERIOD_STATUSES

640: END IF;
641:
642: ---- All validations done. Now update the GL period Status table.
643:
644: UPDATE GL_PERIOD_STATUSES
645: SET CLOSING_STATUS = p_period_rec.closing_status,
646: LAST_UPDATE_DATE = SYSDATE,
647: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
648: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID