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_PROCESS_STREAMS_PVT dependencies on FND_DATE

Line 237: l_date_start := FND_DATE.CANONICAL_TO_DATE(rules_data_csr.RULE_INFORMATION2);

233: IF( rules_data_csr.RULE_INFORMATION2 IS NOT NULL and rules_data_csr.RULE_INFORMATION2 <> OKL_API.G_MISS_CHAR)
234: THEN
235: -- Get all the Rules for this rule group
236: l_frequency := rules_data_csr.object1_id1 ;
237: l_date_start := FND_DATE.CANONICAL_TO_DATE(rules_data_csr.RULE_INFORMATION2);
238: l_number_of_periods := TO_NUMBER(rules_data_csr.RULE_INFORMATION3) ;
239: l_amount := TO_NUMBER(rules_data_csr.RULE_INFORMATION6) ;
240: l_arrear_yn := NVL(rules_data_csr.RULE_INFORMATION10, 'N');
241: l_num_of_adv_payments := TO_NUMBER(rules_data_csr.RULE_INFORMATION5) ;

Line 465: l_date_start := FND_DATE.CANONICAL_TO_DATE(rules_data_csr.RULE_INFORMATION2);

461: IF( rules_data_csr.RULE_INFORMATION2 IS NOT NULL and rules_data_csr.RULE_INFORMATION2 <> OKL_API.G_MISS_CHAR)
462: THEN
463: -- Get all the Rules for this rule group
464: l_frequency := rules_data_csr.object1_id1 ;
465: l_date_start := FND_DATE.CANONICAL_TO_DATE(rules_data_csr.RULE_INFORMATION2);
466: l_number_of_periods := TO_NUMBER(rules_data_csr.RULE_INFORMATION3) ;
467: l_amount := TO_NUMBER(rules_data_csr.RULE_INFORMATION6) ;
468: l_arrear_yn := NVL(rules_data_csr.RULE_INFORMATION10, 'N');
469: l_num_of_adv_payments := TO_NUMBER(rules_data_csr.RULE_INFORMATION5) ;

Line 2748: AND FND_DATE.canonical_to_date(crl.rule_information2)+TO_NUMBER(crl.rule_information7) = p_date;

2744: AND crg.rgd_code = 'LALEVL'
2745: AND crl.rule_information_category = 'LASLL'
2746: AND crg.dnz_chr_id = p_chr_id
2747: AND crg.cle_id = p_cle_id
2748: AND FND_DATE.canonical_to_date(crl.rule_information2)+TO_NUMBER(crl.rule_information7) = p_date;
2749:
2750: --Added by kthiruva on 12-Dec-2005
2751: --This cursor obtains the SLH id of the payment corresponding to a kle_id
2752: --Bug 4878162 - Start of Changes

Line 3229: AND FND_DATE.canonical_to_date(crl.rule_information2)+TO_NUMBER(crl.rule_information7) = p_date;

3225: AND crg.rgd_code = 'LALEVL'
3226: AND crl.rule_information_category = 'LASLL'
3227: AND crg.dnz_chr_id = p_chr_id
3228: AND crg.cle_id = p_cle_id
3229: AND FND_DATE.canonical_to_date(crl.rule_information2)+TO_NUMBER(crl.rule_information7) = p_date;
3230:
3231: --This cursor obtains the SLH id of the payment corresponding to a kle_id
3232: CURSOR get_slh_csr(p_chr_id NUMBER,
3233: p_cle_id NUMBER)