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.OKL_ACCOUNT_DIST_PVT dependencies on OKL_AE_TEMPLATES

Line 347: l_advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE

343:
344: l_product_id NUMBER := P_TMPL_IDENTIFY_REC.PRODUCT_ID;
345: l_transaction_type_id NUMBER := P_TMPL_IDENTIFY_REC.TRANSACTION_TYPE_ID;
346: l_stream_type_id NUMBER := P_TMPL_IDENTIFY_REC.STREAM_TYPE_ID;
347: l_advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE
348: := P_TMPL_IDENTIFY_REC.advance_arrears;
349: l_factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE
350: := P_TMPL_IDENTIFY_REC.FACTORING_SYND_FLAG;
351: l_syndication_code OKL_AE_TEMPLATES.SYT_CODE%TYPE

Line 349: l_factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE

345: l_transaction_type_id NUMBER := P_TMPL_IDENTIFY_REC.TRANSACTION_TYPE_ID;
346: l_stream_type_id NUMBER := P_TMPL_IDENTIFY_REC.STREAM_TYPE_ID;
347: l_advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE
348: := P_TMPL_IDENTIFY_REC.advance_arrears;
349: l_factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE
350: := P_TMPL_IDENTIFY_REC.FACTORING_SYND_FLAG;
351: l_syndication_code OKL_AE_TEMPLATES.SYT_CODE%TYPE
352: := P_TMPL_IDENTIFY_REC.SYNDICATION_CODE;
353: l_factoring_code OKL_AE_TEMPLATES.FAC_CODE%TYPE

Line 351: l_syndication_code OKL_AE_TEMPLATES.SYT_CODE%TYPE

347: l_advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE
348: := P_TMPL_IDENTIFY_REC.advance_arrears;
349: l_factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE
350: := P_TMPL_IDENTIFY_REC.FACTORING_SYND_FLAG;
351: l_syndication_code OKL_AE_TEMPLATES.SYT_CODE%TYPE
352: := P_TMPL_IDENTIFY_REC.SYNDICATION_CODE;
353: l_factoring_code OKL_AE_TEMPLATES.FAC_CODE%TYPE
354: := P_TMPL_IDENTIFY_REC.FACTORING_CODE;
355: l_investor_code OKL_AE_TEMPLATES.INV_CODE%TYPE

Line 353: l_factoring_code OKL_AE_TEMPLATES.FAC_CODE%TYPE

349: l_factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE
350: := P_TMPL_IDENTIFY_REC.FACTORING_SYND_FLAG;
351: l_syndication_code OKL_AE_TEMPLATES.SYT_CODE%TYPE
352: := P_TMPL_IDENTIFY_REC.SYNDICATION_CODE;
353: l_factoring_code OKL_AE_TEMPLATES.FAC_CODE%TYPE
354: := P_TMPL_IDENTIFY_REC.FACTORING_CODE;
355: l_investor_code OKL_AE_TEMPLATES.INV_CODE%TYPE
356: := P_TMPL_IDENTIFY_REC.INVESTOR_CODE;
357: l_memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := P_TMPL_IDENTIFY_REC.MEMO_YN;

Line 355: l_investor_code OKL_AE_TEMPLATES.INV_CODE%TYPE

351: l_syndication_code OKL_AE_TEMPLATES.SYT_CODE%TYPE
352: := P_TMPL_IDENTIFY_REC.SYNDICATION_CODE;
353: l_factoring_code OKL_AE_TEMPLATES.FAC_CODE%TYPE
354: := P_TMPL_IDENTIFY_REC.FACTORING_CODE;
355: l_investor_code OKL_AE_TEMPLATES.INV_CODE%TYPE
356: := P_TMPL_IDENTIFY_REC.INVESTOR_CODE;
357: l_memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := P_TMPL_IDENTIFY_REC.MEMO_YN;
358: l_prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := P_TMPL_IDENTIFY_REC.PRIOR_YEAR_YN;
359: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 357: l_memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := P_TMPL_IDENTIFY_REC.MEMO_YN;

353: l_factoring_code OKL_AE_TEMPLATES.FAC_CODE%TYPE
354: := P_TMPL_IDENTIFY_REC.FACTORING_CODE;
355: l_investor_code OKL_AE_TEMPLATES.INV_CODE%TYPE
356: := P_TMPL_IDENTIFY_REC.INVESTOR_CODE;
357: l_memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := P_TMPL_IDENTIFY_REC.MEMO_YN;
358: l_prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := P_TMPL_IDENTIFY_REC.PRIOR_YEAR_YN;
359: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
360:
361: -- Bug 3948354

Line 358: l_prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := P_TMPL_IDENTIFY_REC.PRIOR_YEAR_YN;

354: := P_TMPL_IDENTIFY_REC.FACTORING_CODE;
355: l_investor_code OKL_AE_TEMPLATES.INV_CODE%TYPE
356: := P_TMPL_IDENTIFY_REC.INVESTOR_CODE;
357: l_memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := P_TMPL_IDENTIFY_REC.MEMO_YN;
358: l_prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := P_TMPL_IDENTIFY_REC.PRIOR_YEAR_YN;
359: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
360:
361: -- Bug 3948354
362:

Line 437: FROM OKL_AE_TEMPLATES A WHERE 1 = 1 ';

433: ,LAST_UPDATED_BY
434: ,LAST_UPDATE_DATE
435: ,LAST_UPDATE_LOGIN
436: ,INV_CODE
437: FROM OKL_AE_TEMPLATES A WHERE 1 = 1 ';
438:
439:
440: OPEN prod_csr(l_product_id);
441: FETCH prod_csr INTO l_aes_id ;