APPS.OKL_TCN_PVT dependencies on GL_LEDGERS

Line 3545: FROM gl_ledgers

3541: CURSOR rep_valid_csr(p_rep_name VARCHAR2,
3542: p_rep_code VARCHAR2)
3543: IS
3544: SELECT '1'
3545: FROM gl_ledgers
3546: WHERE name = p_rep_name
3547: AND short_name = p_rep_code;
3548:
3549: --sechawla 8967918 : during upgrade, gl_ledgers may not have data. Use gl_sets_of_books_11i in that case

Line 3549: --sechawla 8967918 : during upgrade, gl_ledgers may not have data. Use gl_sets_of_books_11i in that case

3545: FROM gl_ledgers
3546: WHERE name = p_rep_name
3547: AND short_name = p_rep_code;
3548:
3549: --sechawla 8967918 : during upgrade, gl_ledgers may not have data. Use gl_sets_of_books_11i in that case
3550: CURSOR rep_valid_csr_11i(p_rep_name VARCHAR2,
3551: p_rep_code VARCHAR2)
3552: IS
3553: SELECT '1'

Line 3570: --sechawla 8967918 : during upgrade, gl_ledgers may not have data. Use gl_sets_of_books_11i in that case : begin

3566: FETCH rep_valid_csr INTO l_dummy;
3567: l_row_notfound := rep_valid_csr%NOTFOUND;
3568: CLOSE rep_valid_csr;
3569: IF (l_row_notfound) THEN
3570: --sechawla 8967918 : during upgrade, gl_ledgers may not have data. Use gl_sets_of_books_11i in that case : begin
3571: OPEN rep_valid_csr_11i(p_rep_name => p_tcnv_rec.representation_name,
3572: p_rep_code => p_tcnv_rec.representation_code);
3573: FETCH rep_valid_csr_11i INTO l_dummy;
3574: l_11i_row_notfound := rep_valid_csr_11i%NOTFOUND;

Line 3578: --sechawla 8967918 : during upgrade, gl_ledgers may not have data. Use gl_sets_of_books_11i in that case : end

3574: l_11i_row_notfound := rep_valid_csr_11i%NOTFOUND;
3575: CLOSE rep_valid_csr_11i;
3576:
3577: IF (l_11i_row_notfound) THEN
3578: --sechawla 8967918 : during upgrade, gl_ledgers may not have data. Use gl_sets_of_books_11i in that case : end
3579: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'REPRESENTATION_CODE');
3580: RAISE item_not_found_error;
3581: END IF;
3582: END IF;