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

Line 3248: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,

3244:
3245: CURSOR chk_payment_csr
3246: (p_chr_id IN NUMBER,
3247: p_cle_id IN NUMBER) IS
3248: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
3249: DECODE(sll.rule_information7, NULL,
3250: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),
3251: NVL(TO_NUMBER(sll.rule_information3),1) *
3252: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),

Line 3250: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),

3246: (p_chr_id IN NUMBER,
3247: p_cle_id IN NUMBER) IS
3248: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
3249: DECODE(sll.rule_information7, NULL,
3250: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),
3251: NVL(TO_NUMBER(sll.rule_information3),1) *
3252: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3253: FND_DATE.canonical_to_date(sll.rule_information2) +
3254: TO_NUMBER(sll.rule_information7) - 1) end_date

Line 3253: FND_DATE.canonical_to_date(sll.rule_information2) +

3249: DECODE(sll.rule_information7, NULL,
3250: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),
3251: NVL(TO_NUMBER(sll.rule_information3),1) *
3252: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3253: FND_DATE.canonical_to_date(sll.rule_information2) +
3254: TO_NUMBER(sll.rule_information7) - 1) end_date
3255: FROM okc_rules_b sll,
3256: okc_rules_b slh,
3257: okc_rule_groups_b rgp,

Line 3574: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,

3570:
3571: CURSOR contract_payment_csr
3572: (p_chr_id IN NUMBER,
3573: p_release_date IN DATE) IS
3574: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
3575: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)factor,
3576: TO_NUMBER(sll.rule_information3) periods,
3577: DECODE(sll.rule_information7, NULL,
3578: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),

Line 3578: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),

3574: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
3575: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)factor,
3576: TO_NUMBER(sll.rule_information3) periods,
3577: DECODE(sll.rule_information7, NULL,
3578: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),
3579: NVL(TO_NUMBER(sll.rule_information3),1) *
3580: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3581: FND_DATE.canonical_to_date(sll.rule_information2) +
3582: TO_NUMBER(sll.rule_information7) - 1) end_date,

Line 3581: FND_DATE.canonical_to_date(sll.rule_information2) +

3577: DECODE(sll.rule_information7, NULL,
3578: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),
3579: NVL(TO_NUMBER(sll.rule_information3),1) *
3580: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3581: FND_DATE.canonical_to_date(sll.rule_information2) +
3582: TO_NUMBER(sll.rule_information7) - 1) end_date,
3583: sll.rule_information10 arrears_yn,
3584: TO_NUMBER(sll.rule_information6) amount,
3585: TO_NUMBER(sll.rule_information8) stub_amount,

Line 3605: AND FND_DATE.canonical_to_date(sll.rule_information2) < p_release_date;

3601: AND slh.rule_information_category = 'LASLH'
3602: AND sll.object2_id1 = slh.id
3603: AND sll.rule_information_category = 'LASLL'
3604: AND sll.rgp_id = rgp.id
3605: AND FND_DATE.canonical_to_date(sll.rule_information2) < p_release_date;
3606:
3607: CURSOR slh_csr(p_chr_id IN NUMBER) IS
3608: SELECT slh.id slh_id
3609: FROM okc_rules_b slh

Line 3701: l_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(p_release_date);

3697: else
3698: l_stub_amount := 0;
3699: end if;
3700:
3701: l_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(p_release_date);
3702: l_rulv_rec.rule_information3 := NULL;
3703: l_rulv_rec.rule_information6 := NULL;
3704: l_rulv_rec.rule_information7 := TO_CHAR(l_stub_days);
3705: l_rulv_rec.rule_information8 := TO_CHAR(l_stub_amount);

Line 3753: l_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(l_new_start_date);

3749: END IF;
3750:
3751: else
3752:
3753: l_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(l_new_start_date);
3754:
3755: l_no_of_periods := MONTHS_BETWEEN((contract_payment_rec.end_date + 1),l_new_start_date)/contract_payment_rec.factor;
3756: l_rulv_rec.rule_information3 := TO_CHAR(l_no_of_periods);
3757:

Line 3804: l_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(p_release_date);

3800: l_rulv_rec.warn_yn := 'N';
3801: l_rulv_rec.template_yn := 'N';
3802: l_rulv_rec.sfwt_flag := 'N';
3803: l_rulv_rec.rule_information_category := 'LASLL';
3804: l_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(p_release_date);
3805: l_rulv_rec.rule_information5 := contract_payment_rec.rule_information5;
3806: l_rulv_rec.rule_information7 := TO_CHAR(l_stub_days);
3807: l_rulv_rec.rule_information8 := TO_CHAR(l_stub_amount);
3808: l_rulv_rec.rule_information10 := contract_payment_rec.arrears_yn;