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 2801: AND FND_DATE.canonical_to_date(crl.rule_information2)+TO_NUMBER(crl.rule_information7) = p_date;

2797: AND crg.rgd_code = 'LALEVL'
2798: AND crl.rule_information_category = 'LASLL'
2799: AND crg.dnz_chr_id = p_chr_id
2800: AND crg.cle_id = p_cle_id
2801: AND FND_DATE.canonical_to_date(crl.rule_information2)+TO_NUMBER(crl.rule_information7) = p_date;
2802:
2803: --Added by kthiruva on 12-Dec-2005
2804: --This cursor obtains the SLH id of the payment corresponding to a kle_id
2805: --Bug 4878162 - Start of Changes

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

3283: AND crg.rgd_code = 'LALEVL'
3284: AND crl.rule_information_category = 'LASLL'
3285: AND crg.dnz_chr_id = p_chr_id
3286: AND crg.cle_id = p_cle_id
3287: AND FND_DATE.canonical_to_date(crl.rule_information2)+TO_NUMBER(crl.rule_information7) = p_date;
3288:
3289: --This cursor obtains the SLH id of the payment corresponding to a kle_id
3290: CURSOR get_slh_csr(p_chr_id NUMBER,
3291: p_cle_id NUMBER)