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

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

167:
168: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'get_quote_amortization';
169:
170: CURSOR c_rent_slls ( streamName VARCHAR2 ) IS
171: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
172: TO_NUMBER(SLL.rule_information3) periods,
173: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
174: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
175: NVL(sll.rule_information10, 'N') arrears_yn,

Line 194: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);

190: AND STYT.LANGUAGE = USERENV('LANG') -- Bug 4626837
191: AND styt.name = streamName
192: AND TO_CHAR(slh.id) = sll.object2_id1
193: AND sll.rule_information_category = 'LASLL'
194: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
195:
196: l_rent_sll c_rent_slls%ROWTYPE;
197:
198: -- bug 2992184. Added where condition for multi-gaap reporting streams.

Line 236: SELECT TRUNC(FND_DATE.canonical_to_date(crl.rule_information2))

232: CURSOR c_date_pay_stub(p_khr_id NUMBER,
233: p_kle_id NUMBER,
234: p_date date)
235: IS
236: SELECT TRUNC(FND_DATE.canonical_to_date(crl.rule_information2))
237: FROM okc_rule_groups_b crg,
238: okc_rules_b crl
239: WHERE crl.rgp_id = crg.id
240: AND crg.rgd_code = 'LALEVL'

Line 244: AND TRUNC(FND_DATE.canonical_to_date(crl.rule_information2)) > TRUNC(p_date)

240: AND crg.rgd_code = 'LALEVL'
241: AND crl.rule_information_category = 'LASLL'
242: AND crg.dnz_chr_id = p_khr_id
243: AND crg.cle_id = p_kle_id
244: AND TRUNC(FND_DATE.canonical_to_date(crl.rule_information2)) > TRUNC(p_date)
245: AND crl.rule_information2 IS NOT NULL
246: AND crl.rule_information6 IS NOT NULL
247: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
248:

Line 247: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);

243: AND crg.cle_id = p_kle_id
244: AND TRUNC(FND_DATE.canonical_to_date(crl.rule_information2)) > TRUNC(p_date)
245: AND crl.rule_information2 IS NOT NULL
246: AND crl.rule_information6 IS NOT NULL
247: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
248:
249: l_stub_id NUMBER;
250:
251: TYPE loan_rec IS RECORD (

Line 335: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);

331: AND sty.id = styt.id
332: AND STYT.LANGUAGE = USERENV('LANG') -- Bug 4626837
333: AND TO_CHAR(slh.id) = sll.object2_id1
334: AND sll.rule_information_category = 'LASLL'
335: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
336:
337: l_was_a_stub_payment VARCHAR2(1) := 'N';
338:
339: l_day_convention_month VARCHAR2(30);

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

1254:
1255: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'get_loan_amortization';
1256:
1257: CURSOR c_rent_slls ( streamName VARCHAR2 ) IS
1258: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
1259: TO_NUMBER(SLL.rule_information3) periods,
1260: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
1261: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
1262: NVL(sll.rule_information10, 'N') arrears_yn,

Line 1281: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);

1277: AND STYT.LANGUAGE = USERENV('LANG') -- Bug 4626837
1278: AND styt.name = streamName
1279: AND TO_CHAR(slh.id) = sll.object2_id1
1280: AND sll.rule_information_category = 'LASLL'
1281: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
1282:
1283: l_rent_sll c_rent_slls%ROWTYPE;
1284:
1285: -- bug 2992184. Added where condition for multi-gaap reporting streams.

Line 1331: SELECT TRUNC(FND_DATE.canonical_to_date(crl.rule_information2))

1327: CURSOR c_date_pay_stub(p_khr_id NUMBER,
1328: p_kle_id NUMBER,
1329: p_date date)
1330: IS
1331: SELECT TRUNC(FND_DATE.canonical_to_date(crl.rule_information2))
1332: FROM okc_rule_groups_b crg,
1333: okc_rules_b crl
1334: WHERE crl.rgp_id = crg.id
1335: AND crg.rgd_code = 'LALEVL'

Line 1339: AND TRUNC(FND_DATE.canonical_to_date(crl.rule_information2)) > TRUNC(p_date)

1335: AND crg.rgd_code = 'LALEVL'
1336: AND crl.rule_information_category = 'LASLL'
1337: AND crg.dnz_chr_id = p_khr_id
1338: AND crg.cle_id = p_kle_id
1339: AND TRUNC(FND_DATE.canonical_to_date(crl.rule_information2)) > TRUNC(p_date)
1340: AND crl.rule_information2 IS NOT NULL
1341: AND crl.rule_information6 IS NOT NULL
1342: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
1343:

Line 1342: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);

1338: AND crg.cle_id = p_kle_id
1339: AND TRUNC(FND_DATE.canonical_to_date(crl.rule_information2)) > TRUNC(p_date)
1340: AND crl.rule_information2 IS NOT NULL
1341: AND crl.rule_information6 IS NOT NULL
1342: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
1343:
1344: l_stub_id NUMBER;
1345:
1346: TYPE loan_rec IS RECORD (se_amount NUMBER,

Line 1446: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);

1442: AND sty.id = styt.id
1443: AND STYT.LANGUAGE = USERENV('LANG') -- Bug 4626837
1444: AND TO_CHAR(slh.id) = sll.object2_id1
1445: AND sll.rule_information_category = 'LASLL'
1446: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
1447:
1448: CURSOR l_terminated_line_csr is
1449: SELECT kle.ID,
1450: sts.STE_CODE,

Line 2718: SELECT trunc(FND_DATE.canonical_to_date(rul_sll.rule_information2)) start_date,

2714: CURSOR c_rent_slls(p_khr_id okc_k_headers_b.id%TYPE,
2715: p_Kle_id okc_k_lines_b.id%TYPE,
2716: p_line_type VARCHAR2)
2717: IS
2718: SELECT trunc(FND_DATE.canonical_to_date(rul_sll.rule_information2)) start_date,
2719: NVL(rul_sll.rule_information10, 'Y') arrears_yn,
2720: khr_so.term_duration
2721: FROM okc_k_headers_b chr_so,
2722: okl_k_headers khr_so,

Line 4739: SELECT FND_DATE.canonical_to_date(rule_information5)

4735: AND slh.object1_id1 = TO_CHAR(styt.id)
4736: AND styt.stream_type_purpose = 'RENT';
4737:
4738: CURSOR c_deposit_date IS
4739: SELECT FND_DATE.canonical_to_date(rule_information5)
4740: FROM okc_rules_b
4741: WHERE dnz_chr_id = p_khr_id
4742: AND rule_information_category = 'LASDEP';
4743:

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

6224:
6225: l_hdr c_hdr%ROWTYPE;
6226:
6227: CURSOR c_rent_slls IS
6228: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
6229: TO_NUMBER(SLL.rule_information3) periods,
6230: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
6231: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6232: NVL(sll.rule_information10, 'N') arrears_yn,

Line 6248: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);

6244: AND sty.version = '1.0'
6245: AND sty.stream_type_purpose = 'RENT'
6246: AND TO_CHAR(slh.id) = sll.object2_id1
6247: AND sll.rule_information_category = 'LASLL'
6248: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
6249:
6250: l_rent_sll c_rent_slls%ROWTYPE;
6251:
6252: -- bug 2992184. Added where condition for multi-gaap reporting streams.

Line 7535: FND_DATE.canonical_to_date(sll.rule_information2) start_date,

7531: cle.id kleId,
7532: stm.id styId,
7533: sll.object1_id1 frequency,
7534: TO_NUMBER(sll.rule_information3) periods,
7535: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
7536: sll.rule_information5 structure,
7537: sll.rule_information10 advance_arrears,
7538: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
7539: TO_NUMBER(sll.rule_information7) stub_days,

Line 7564: order by stm.id, FND_DATE.canonical_to_date(sll.rule_information2);

7560: AND slh.rule_information_category = 'LASLH'
7561: AND TO_NUMBER(slh.object1_id1) = stm.id
7562: AND TO_CHAR(slh.id) = sll.object2_id1
7563: AND sll.rule_information_category = 'LASLL'
7564: order by stm.id, FND_DATE.canonical_to_date(sll.rule_information2);
7565:
7566: r_fee c_fee%ROWTYPE;
7567: i BINARY_INTEGER;
7568: j BINARY_INTEGER;

Line 8710: SELECT FND_DATE.canonical_to_date(rule_information5)

8706: AND slh.object1_id1 = TO_CHAR(sty.id)
8707: AND sty.stream_type_purpose = 'RENT';
8708:
8709: CURSOR c_deposit_date IS
8710: SELECT FND_DATE.canonical_to_date(rule_information5)
8711: FROM okc_rules_b
8712: WHERE dnz_chr_id = p_khr_id
8713: AND rule_information_category = 'LASDEP';
8714:

Line 10037: FND_DATE.canonical_to_date(sll.rule_information2) start_date,

10033: cle.id kleId,
10034: stm.id styId,
10035: sll.object1_id1 frequency,
10036: TO_NUMBER(sll.rule_information3) periods,
10037: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
10038: sll.rule_information5 structure,
10039: sll.rule_information10 advance_arrears,
10040: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
10041: TO_NUMBER(sll.rule_information7) stub_days,

Line 10076: FND_DATE.canonical_to_date(sll.rule_information2) start_date,

10072: cle.id kleId,
10073: stm.id styId,
10074: sll.object1_id1 frequency,
10075: TO_NUMBER(sll.rule_information3) periods,
10076: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
10077: sll.rule_information5 structure,
10078: sll.rule_information10 advance_arrears,
10079: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
10080: TO_NUMBER(sll.rule_information7) stub_days,

Line 10105: order by stm.id, FND_DATE.canonical_to_date(sll.rule_information2);

10101: AND slh.rule_information_category = 'LASLH'
10102: AND slh.object1_id1 = TO_CHAR(stm.id)
10103: AND TO_CHAR(slh.id) = sll.object2_id1
10104: AND sll.rule_information_category = 'LASLL'
10105: order by stm.id, FND_DATE.canonical_to_date(sll.rule_information2);
10106:
10107: r_fee c_fee%ROWTYPE;
10108: i BINARY_INTEGER;
10109: j BINARY_INTEGER;

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

11135:
11136:
11137: -- cursor to get the start date and arrears flag
11138: CURSOR c_rent_slls IS
11139: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
11140: TO_NUMBER(SLL.rule_information3) periods,
11141: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
11142: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
11143: NVL(sll.rule_information10, 'N') arrears_yn,

Line 11160: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);

11156: AND sty.id = styt.id
11157: AND STYT.LANGUAGE = USERENV('LANG')
11158: AND TO_CHAR(slh.id) = sll.object2_id1
11159: AND sll.rule_information_category = 'LASLL'
11160: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
11161:
11162: l_rent_sll c_rent_slls%ROWTYPE;
11163:
11164: -- cursor to get the payment streams