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

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

83: fin_cle_rec fin_cle_csr%ROWTYPE;
84:
85: CURSOR pymt_sched_csr(p_chr_id IN NUMBER,
86: p_cle_id IN NUMBER) IS
87: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
88: TO_NUMBER(sll.rule_information7) stub_days,
89: TO_NUMBER(sll.rule_information3) periods,
90: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12) frequency,
91: sll.rule_information10 arrears_yn

Line 2725: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).start_date := Fnd_Date.canonical_to_date(l_payment_table(i).start_date);

2721: l_pmnt_tab_counter := l_pmnt_tab_counter + 1;
2722: l_payment_details_counter := 1;
2723: l_pmnt_tab(l_pmnt_tab_counter).kle_id := l_payment_table(i).kle_id;
2724:
2725: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).start_date := Fnd_Date.canonical_to_date(l_payment_table(i).start_date);
2726: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).number_of_periods := l_payment_table(i).number_of_periods;
2727: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_days := l_payment_table(i).stub_days;
2728: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_amount := l_payment_table(i).stub_amount;
2729: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).advance_or_arrears := l_payment_table(i).advance_or_arrears;

Line 2735: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).start_date := Fnd_Date.canonical_to_date(l_payment_table(i).start_date);

2731:
2732: l_prev_kle_id := l_payment_table(i).kle_id;
2733: l_payment_details_counter := l_payment_details_counter + 1;
2734: ELSE
2735: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).start_date := Fnd_Date.canonical_to_date(l_payment_table(i).start_date);
2736: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).number_of_periods := l_payment_table(i).number_of_periods;
2737: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_days := l_payment_table(i).stub_days;
2738: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_amount := l_payment_table(i).stub_amount;
2739: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).advance_or_arrears := l_payment_table(i).advance_or_arrears;

Line 2776: IF (Fnd_Date.canonical_to_date(l_start_date) <> Fnd_Date.canonical_to_date(l_pmnt_tab(i).l_payment_details(j).start_date)) OR

2772: l_advance_or_arrears := l_pmnt_tab(1).l_payment_details(j).advance_or_arrears;
2773: l_frequency := l_pmnt_tab(1).l_payment_details(j).frequency;
2774: FOR i IN 2..l_pmnt_tab.LAST
2775: LOOP
2776: IF (Fnd_Date.canonical_to_date(l_start_date) <> Fnd_Date.canonical_to_date(l_pmnt_tab(i).l_payment_details(j).start_date)) OR
2777: (NVL(l_number_of_periods,0) <> NVL(l_pmnt_tab(i).l_payment_details(j).number_of_periods,0)) OR
2778: (NVL(l_stub_days,0) <> NVL(l_pmnt_tab(i).l_payment_details(j).stub_days,0)) OR
2779: (NVL(l_advance_or_arrears,'N') <> NVL(l_pmnt_tab(i).l_payment_details(j).advance_or_arrears,'N')) OR
2780: (NVL(l_frequency,'X') <> NVL(l_pmnt_tab(i).l_payment_details(j).frequency,'X')) THEN

Line 2806: l_pmnt_tab_tmt(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).start_date := Fnd_Date.canonical_to_date(l_payment_table_tmt(i).start_date);

2802: l_pmnt_tab_counter := l_pmnt_tab_counter + 1;
2803: l_payment_details_counter := 1;
2804: l_pmnt_tab_tmt(l_pmnt_tab_counter).kle_id := l_payment_table_tmt(i).kle_id;
2805:
2806: l_pmnt_tab_tmt(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).start_date := Fnd_Date.canonical_to_date(l_payment_table_tmt(i).start_date);
2807: l_pmnt_tab_tmt(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).number_of_periods := l_payment_table_tmt(i).number_of_periods;
2808: l_pmnt_tab_tmt(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_days := l_payment_table_tmt(i).stub_days;
2809: l_pmnt_tab_tmt(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_amount := l_payment_table_tmt(i).stub_amount;
2810: l_pmnt_tab_tmt(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).advance_or_arrears := l_payment_table_tmt(i).advance_or_arrears;

Line 2816: l_pmnt_tab_tmt(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).start_date := Fnd_Date.canonical_to_date(l_payment_table_tmt(i).start_date);

2812:
2813: l_prev_kle_id := l_payment_table_tmt(i).kle_id;
2814: l_payment_details_counter := l_payment_details_counter + 1;
2815: ELSE
2816: l_pmnt_tab_tmt(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).start_date := Fnd_Date.canonical_to_date(l_payment_table_tmt(i).start_date);
2817: l_pmnt_tab_tmt(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).number_of_periods := l_payment_table_tmt(i).number_of_periods;
2818: l_pmnt_tab_tmt(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_days := l_payment_table_tmt(i).stub_days;
2819: l_pmnt_tab_tmt(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_amount := l_payment_table_tmt(i).stub_amount;
2820: l_pmnt_tab_tmt(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).advance_or_arrears := l_payment_table_tmt(i).advance_or_arrears;

Line 2846: IF (Fnd_Date.canonical_to_date(l_start_date) <> Fnd_Date.canonical_to_date(l_pmnt_tab_tmt(i).l_payment_details(j).start_date)) OR

2842: FOR i IN l_pmnt_tab_tmt.FIRST..l_pmnt_tab_tmt.LAST
2843: LOOP
2844:
2845: IF l_pmnt_tab_tmt(i).l_payment_details.EXISTS(j) THEN
2846: IF (Fnd_Date.canonical_to_date(l_start_date) <> Fnd_Date.canonical_to_date(l_pmnt_tab_tmt(i).l_payment_details(j).start_date)) OR
2847: (NVL(l_advance_or_arrears,'N') <> NVL(l_pmnt_tab_tmt(i).l_payment_details(j).advance_or_arrears,'N')) OR
2848: (NVL(l_frequency,'X') <> NVL(l_pmnt_tab_tmt(i).l_payment_details(j).frequency,'X')) THEN
2849:
2850: RAISE schedule_mismatch;