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 3302: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,

3298:
3299: CURSOR chk_payment_csr
3300: (p_chr_id IN NUMBER,
3301: p_cle_id IN NUMBER) IS
3302: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
3303: DECODE(sll.rule_information7, NULL,
3304: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),
3305: NVL(TO_NUMBER(sll.rule_information3),1) *
3306: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),

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

3300: (p_chr_id IN NUMBER,
3301: p_cle_id IN NUMBER) IS
3302: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
3303: DECODE(sll.rule_information7, NULL,
3304: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),
3305: NVL(TO_NUMBER(sll.rule_information3),1) *
3306: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3307: FND_DATE.canonical_to_date(sll.rule_information2) +
3308: TO_NUMBER(sll.rule_information7) - 1) end_date

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

3303: DECODE(sll.rule_information7, NULL,
3304: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),
3305: NVL(TO_NUMBER(sll.rule_information3),1) *
3306: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3307: FND_DATE.canonical_to_date(sll.rule_information2) +
3308: TO_NUMBER(sll.rule_information7) - 1) end_date
3309: FROM okc_rules_b sll,
3310: okc_rules_b slh,
3311: okc_rule_groups_b rgp,

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

3625: --Made changes by bkatraga for bug 9369915 to fetch stream_type_purpose
3626: CURSOR contract_payment_csr
3627: (p_chr_id IN NUMBER,
3628: p_release_date IN DATE) IS
3629: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
3630: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)factor,
3631: TO_NUMBER(sll.rule_information3) periods,
3632: DECODE(sll.rule_information7, NULL,
3633: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),

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

3629: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
3630: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)factor,
3631: TO_NUMBER(sll.rule_information3) periods,
3632: DECODE(sll.rule_information7, NULL,
3633: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),
3634: NVL(TO_NUMBER(sll.rule_information3),1) *
3635: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3636: FND_DATE.canonical_to_date(sll.rule_information2) +
3637: TO_NUMBER(sll.rule_information7) - 1) end_date,

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

3632: DECODE(sll.rule_information7, NULL,
3633: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),
3634: NVL(TO_NUMBER(sll.rule_information3),1) *
3635: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3636: FND_DATE.canonical_to_date(sll.rule_information2) +
3637: TO_NUMBER(sll.rule_information7) - 1) end_date,
3638: sll.rule_information10 arrears_yn,
3639: TO_NUMBER(sll.rule_information6) amount,
3640: TO_NUMBER(sll.rule_information8) stub_amount,

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

3659: AND slh.object1_id1 = sty.id
3660: AND sll.object2_id1 = slh.id
3661: AND sll.rule_information_category = 'LASLL'
3662: AND sll.rgp_id = rgp.id
3663: AND FND_DATE.canonical_to_date(sll.rule_information2) < p_release_date;
3664:
3665: CURSOR slh_csr(p_chr_id IN NUMBER) IS
3666: SELECT slh.id slh_id
3667: FROM okc_rules_b slh

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

3757: else
3758: l_stub_amount := 0;
3759: end if;
3760:
3761: l_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(p_release_date);
3762: l_rulv_rec.rule_information3 := NULL;
3763: l_rulv_rec.rule_information6 := NULL;
3764: l_rulv_rec.rule_information7 := TO_CHAR(l_stub_days);
3765: l_rulv_rec.rule_information8 := TO_CHAR(l_stub_amount);

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

3809: END IF;
3810:
3811: else
3812:
3813: l_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(l_new_start_date);
3814:
3815: l_no_of_periods := MONTHS_BETWEEN((contract_payment_rec.end_date + 1),l_new_start_date)/contract_payment_rec.factor;
3816: l_rulv_rec.rule_information3 := TO_CHAR(l_no_of_periods);
3817:

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

3860: l_rulv_rec.warn_yn := 'N';
3861: l_rulv_rec.template_yn := 'N';
3862: l_rulv_rec.sfwt_flag := 'N';
3863: l_rulv_rec.rule_information_category := 'LASLL';
3864: l_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(p_release_date);
3865: l_rulv_rec.rule_information5 := contract_payment_rec.rule_information5;
3866: l_rulv_rec.rule_information7 := TO_CHAR(l_stub_days);
3867: l_rulv_rec.rule_information8 := TO_CHAR(l_stub_amount);
3868: l_rulv_rec.rule_information10 := contract_payment_rec.arrears_yn;