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

Line 1217: 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);

1213: l_pmnt_tab_counter := l_pmnt_tab_counter + 1;
1214: l_payment_details_counter := 1;
1215: l_pmnt_tab(l_pmnt_tab_counter).kle_id := l_payment_table(i).kle_id;
1216:
1217: 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);
1218: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).number_of_periods := l_payment_table(i).number_of_periods;
1219: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_days := l_payment_table(i).stub_days;
1220: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_amount := l_payment_table(i).stub_amount;
1221: 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 1226: 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);

1222:
1223: l_prev_kle_id := l_payment_table(i).kle_id;
1224: l_payment_details_counter := l_payment_details_counter + 1;
1225: ELSE
1226: 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);
1227: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).number_of_periods := l_payment_table(i).number_of_periods;
1228: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_days := l_payment_table(i).stub_days;
1229: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_amount := l_payment_table(i).stub_amount;
1230: 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 1265: 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

1261: l_stub_days := l_pmnt_tab(1).l_payment_details(j).stub_days;
1262: l_advance_or_arrears := l_pmnt_tab(1).l_payment_details(j).advance_or_arrears;
1263: FOR i IN 2..l_pmnt_tab.LAST
1264: LOOP
1265: 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
1266: (NVL(l_number_of_periods,0) <> NVL(l_pmnt_tab(i).l_payment_details(j).number_of_periods,0)) OR
1267: (NVL(l_stub_days,0) <> NVL(l_pmnt_tab(i).l_payment_details(j).stub_days,0)) OR
1268: (NVL(l_advance_or_arrears,'N') <> NVL(l_pmnt_tab(i).l_payment_details(j).advance_or_arrears,'N')) THEN
1269:

Line 1666: l_rent_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1662: END IF;
1663: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1664: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before assigning l_rent_start_date....');
1665: END IF;
1666: l_rent_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1667: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1668: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_start_date=' || l_rent_start_date);
1669: END IF;
1670: l_rent_periods := l_pmnt_lns_in_hdr_rec.rule_information3;

Line 1680: l_principal_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1676: IF (NVL(l_pmnt_lns_in_hdr_rec.rule_information10,'N') = 'N') THEN
1677: l_payment_in_advance := TRUE;
1678: l_prin_payment_in_advance := TRUE;
1679: END IF;
1680: l_principal_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1681: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1682: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_start_date=' || l_principal_start_date);
1683: END IF;
1684: l_principal_periods := l_pmnt_lns_in_hdr_rec.rule_information3;

Line 1689: l_loan_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1685: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1686: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_periods=' || l_principal_periods);
1687: END IF;
1688: ELSIF ( l_pmnt_strm_hdr_rec.stream_type_purpose = 'LOAN_PAYMENT' ) THEN
1689: l_loan_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1690: l_loan_periods := l_hdrrl_rec.rule_information3;
1691: ELSIF ( l_pmnt_strm_hdr_rec.stream_type_purpose = 'VARIABLE_INTEREST_SCHEDULE' ) THEN
1692: l_var_int_schedule_defined := TRUE;
1693: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1696: l_variable_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1692: l_var_int_schedule_defined := TRUE;
1693: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1694: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before assigning l_variable_start_date....');
1695: END IF;
1696: l_variable_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1697: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1698: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_variable_start_date = ' || l_variable_start_date);
1699: END IF;
1700: l_variable_periods := l_pmnt_lns_in_hdr_rec.rule_information3;

Line 1946: l_payment_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1942: l_line_ind := 0;
1943: FOR l_pmnt_lns_in_hdr_rec IN l_pmnt_lns_in_hdr(l_pmnt_strm_check_rec.id ,p_chr_id)
1944: Loop
1945: If ( l_line_ind = 0 ) Then
1946: l_payment_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1947: print('l_payment_date=' || l_payment_date);
1948: l_line_ind := 1;
1949: ELSE
1950: l_payment_date2 := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

Line 1950: l_payment_date2 := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1946: l_payment_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1947: print('l_payment_date=' || l_payment_date);
1948: l_line_ind := 1;
1949: ELSE
1950: l_payment_date2 := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1951: print('l_payment_date2=' || l_payment_date2);
1952: IF (l_payment_date <> l_payment_date2) THEN
1953: OKL_API.set_message(
1954: p_app_name => G_APP_NAME,

Line 1999: l_global_min_start_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1995: If ( ind = 0 ) Then
1996: ind := 1;
1997: l_pmnt_lns_in_hdr_rec_comp := l_pmnt_lns_in_hdr_rec;
1998: -- global min start date is start date for first payment line for that SLH
1999: l_global_min_start_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2000: print('l_global_min_start_date=' || l_global_min_start_date);
2001: End If;
2002: If (line_ind = 0) Then
2003: l_min_start_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

Line 2003: l_min_start_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1999: l_global_min_start_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2000: print('l_global_min_start_date=' || l_global_min_start_date);
2001: End If;
2002: If (line_ind = 0) Then
2003: l_min_start_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2004: print('l_min_start_date=' || l_min_start_date);
2005: line_ind := 1;
2006: l_line_total_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
2007: Else

Line 2115: l_payment_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

2111: /*
2112: IF (l_deal_type = 'LOAN' AND
2113: l_interest_calculation_basis = 'REAMORT') THEN
2114: If ( l_line_ind = 0 ) Then
2115: l_payment_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2116: l_line_ind := 1;
2117: ELSE
2118: l_payment_date2 := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2119: IF (l_payment_date <> l_payment_date2) THEN

Line 2118: l_payment_date2 := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

2114: If ( l_line_ind = 0 ) Then
2115: l_payment_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2116: l_line_ind := 1;
2117: ELSE
2118: l_payment_date2 := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2119: IF (l_payment_date <> l_payment_date2) THEN
2120: OKL_API.set_message(
2121: p_app_name => G_APP_NAME,
2122: p_msg_name => 'OKL_LLA_VAR_RATE_PAYMENT_DATE',

Line 2808: l_global_min_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

2804: IF ( ind = 0 ) THEN
2805: ind := 1;
2806: l_pmnt_lns_in_hdr_rec_comp := l_pmnt_lns_in_hdr_rec;
2807: -- global min start date is start date for first payment line for that SLH
2808: l_global_min_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2809: END IF;
2810: IF (line_ind = 0) THEN
2811: l_min_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2812: line_ind := 1;

Line 2811: l_min_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

2807: -- global min start date is start date for first payment line for that SLH
2808: l_global_min_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2809: END IF;
2810: IF (line_ind = 0) THEN
2811: l_min_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2812: line_ind := 1;
2813: l_line_total_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
2814: ELSE
2815: l_line_total_periods := l_line_total_periods + l_pmnt_lns_in_hdr_rec.rule_information3;

Line 2927: > TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.rule_information4)) )

2923: FETCH l_hdr_csr1 INTO l_hdr_rec1;
2924: CLOSE l_hdr_csr1;
2925:
2926: IF ( TRUNC(l_hdr_rec1.start_date)
2927: > TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.rule_information4)) )
2928: OR
2929: ( TRUNC(l_hdr_rec1.end_date)
2930: < TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.rule_information4)) ) THEN
2931: Okl_Api.set_message(

Line 2930: < TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.rule_information4)) ) THEN

2926: IF ( TRUNC(l_hdr_rec1.start_date)
2927: > TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.rule_information4)) )
2928: OR
2929: ( TRUNC(l_hdr_rec1.end_date)
2930: < TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.rule_information4)) ) THEN
2931: Okl_Api.set_message(
2932: p_app_name => G_APP_NAME,
2933: p_msg_name => 'OKL_QA_INT_START_DATE_EFF');
2934: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 2937: /*If ( l_hdr_rec.start_date < FND_DATE.canonical_to_date(l_hdrrl_rec.rule_information4) ) Then

2933: p_msg_name => 'OKL_QA_INT_START_DATE_EFF');
2934: x_return_status := Okl_Api.G_RET_STS_ERROR;
2935: END IF;
2936:
2937: /*If ( l_hdr_rec.start_date < FND_DATE.canonical_to_date(l_hdrrl_rec.rule_information4) ) Then
2938: OKL_API.set_message(
2939: p_app_name => G_APP_NAME,
2940: p_msg_name => 'OKL_QA_CLCDATE');
2941: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 3182: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,

3178: AND pph.cle_id = p_cle_id;
3179:
3180: --Find out the payment info for contract line
3181: CURSOR pymnt_amt_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3182: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
3183: DECODE(sll.rule_information7, NULL,
3184: (ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
3185: NVL(TO_NUMBER(sll.rule_information3),1) *
3186: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),

Line 3184: (ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),

3180: --Find out the payment info for contract line
3181: CURSOR pymnt_amt_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3182: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
3183: DECODE(sll.rule_information7, NULL,
3184: (ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
3185: NVL(TO_NUMBER(sll.rule_information3),1) *
3186: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3187: Fnd_Date.canonical_to_date(sll.rule_information2) +
3188: TO_NUMBER(sll.rule_information7) - 1) end_date,

Line 3187: Fnd_Date.canonical_to_date(sll.rule_information2) +

3183: DECODE(sll.rule_information7, NULL,
3184: (ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
3185: NVL(TO_NUMBER(sll.rule_information3),1) *
3186: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3187: Fnd_Date.canonical_to_date(sll.rule_information2) +
3188: TO_NUMBER(sll.rule_information7) - 1) end_date,
3189: TO_NUMBER(sll.rule_information6) amount
3190: FROM okc_rules_b sll,
3191: okc_rules_b slh,

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

4784: --AND styt.LANGUAGE = USERENV('LANG')
4785: --AND sty.id = styt.id
4786: AND TO_CHAR(slh.id) = sll.object2_id1
4787: AND sll.rule_information_category = 'LASLL';
4788: --ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
4789:
4790: /*
4791: CURSOR c_strm_sll_ext (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
4792: p_kle_id OKC_K_LINES_B.ID%TYPE) IS

Line 4950: l_strm_sll_start_date := Fnd_Date.canonical_to_date(l_strm_sll.start_date);

4946: FOR l_strm_sll IN c_strm_sll(p_chr_id,
4947: l_fin_fee.id)
4948: LOOP
4949:
4950: l_strm_sll_start_date := Fnd_Date.canonical_to_date(l_strm_sll.start_date);
4951: l_strm_sll_periods := TO_NUMBER(l_strm_sll.periods);
4952:
4953: IF(l_strm_sll_start_date IS NULL) THEN
4954:

Line 5039: l_pmnt_end_date := Fnd_Date.canonical_to_date(l_strm_sll_ext.start_date);

5035: l_strm_sll_ext_mpp := l_strm_sll_ext.mpp;
5036: l_strm_sll_ext_stub_day := TO_NUMBER(NVL(l_strm_sll_ext.stub_day,0)) + l_strm_sll_ext_stub_day;
5037: */
5038: -- 5189866
5039: l_pmnt_end_date := Fnd_Date.canonical_to_date(l_strm_sll_ext.start_date);
5040: IF l_sll_count > 1 THEN
5041: l_start_day := TO_CHAR(l_pmnt_end_date,'DD');
5042: END IF;
5043:

Line 5831: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),

5827:
5828: SELECT sll.rule_information2 start_date,
5829: SLL.rule_information3 periods,
5830: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
5831: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
5832: TO_NUMBER(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
5833: styt.name stream_type
5834: FROM okc_rules_b sll,
5835: okc_rules_b slh,

Line 6271: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date, -- formated for bug 5115701,

6267:
6268: CURSOR l_fn_fee_pmt_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6269: feeLine IN OKL_K_LINES.ID%TYPE) IS
6270:
6271: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date, -- formated for bug 5115701,
6272: SLL.rule_information3 periods,
6273: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6274: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
6275: TO_NUMBER(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,

Line 6274: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),

6270:
6271: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date, -- formated for bug 5115701,
6272: SLL.rule_information3 periods,
6273: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6274: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
6275: TO_NUMBER(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
6276: styt.name stream_type
6277: FROM okc_rules_b sll,
6278: okc_rules_b slh,

Line 9433: ( TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) THEN

9429: FETCH l_hdrrl_csr INTO l_hdrrl_rec;
9430:
9431: IF(( l_hdrrl_csr%FOUND ) AND
9432: (l_hdrrl_rec.RULE_INFORMATION1 IS NOT NULL) AND
9433: ( TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) THEN
9434: Okl_Api.set_message(
9435: p_app_name => G_APP_NAME,
9436: p_msg_name => 'OKL_QA_LATE_CH_DATE');
9437: -- notify caller of an error

Line 9448: (TRUNC( Fnd_Date.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) THEN

9444: FETCH l_hdrrl_csr INTO l_hdrrl_rec;
9445:
9446: IF(( l_hdrrl_csr%FOUND ) AND
9447: (l_hdrrl_rec.RULE_INFORMATION1 IS NOT NULL) AND
9448: (TRUNC( Fnd_Date.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) THEN
9449: Okl_Api.set_message(
9450: p_app_name => G_APP_NAME,
9451: p_msg_name => 'OKL_QA_LATE_INT_DATE');
9452: -- notify caller of an error

Line 9462: (TRUNC( Fnd_Date.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE))) THEN

9458: FETCH l_hdrrl_csr INTO l_hdrrl_rec;
9459:
9460: IF((l_hdrrl_csr%FOUND)AND
9461: (l_hdrrl_rec.RULE_INFORMATION1 IS NOT NULL) AND
9462: (TRUNC( Fnd_Date.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE))) THEN
9463: Okl_Api.set_message(
9464: p_app_name => G_APP_NAME,
9465: p_msg_name => 'OKL_QA_REBOOK_LMT_DATE');
9466: -- notify caller of an error

Line 10901: (TRUNC( Fnd_Date.canonical_to_date(l_rl_rec.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN

10897:
10898: FOR l_rl_rec IN l_rl_csr (l_rl_rec1.slh_id, 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_lne_pmnt.id )
10899: LOOP
10900: IF(( l_rl_rec.rule_information2 IS NOT NULL) AND
10901: (TRUNC( Fnd_Date.canonical_to_date(l_rl_rec.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN
10902:
10903: Okl_Api.set_message(
10904: p_app_name => G_APP_NAME,
10905: p_msg_name => 'OKL_QA_PMNT_LN_START_DT',

Line 10921: (TRUNC( Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN

10917: LOOP
10918: FOR l_rl_rec1 IN l_rl_csr1 ( 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_lne_pmnt.id )
10919: LOOP
10920: IF(( l_rl_rec1.rule_information2 IS NOT NULL) AND
10921: (TRUNC( Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN
10922: --( FND_DATE.canonical_to_date(l_rl_rec1.rule_information2) < l_hdr_rec.start_date))Then
10923:
10924: OPEN fee_strm_type_csr ( l_lne_pmnt.id, 'FEE' );
10925: FETCH fee_strm_type_csr INTO l_fee_strm_type_rec;

Line 10922: --( FND_DATE.canonical_to_date(l_rl_rec1.rule_information2) < l_hdr_rec.start_date))Then

10918: FOR l_rl_rec1 IN l_rl_csr1 ( 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_lne_pmnt.id )
10919: LOOP
10920: IF(( l_rl_rec1.rule_information2 IS NOT NULL) AND
10921: (TRUNC( Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN
10922: --( FND_DATE.canonical_to_date(l_rl_rec1.rule_information2) < l_hdr_rec.start_date))Then
10923:
10924: OPEN fee_strm_type_csr ( l_lne_pmnt.id, 'FEE' );
10925: FETCH fee_strm_type_csr INTO l_fee_strm_type_rec;
10926: CLOSE fee_strm_type_csr;

Line 10944: ( TRUNC(Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN

10940: LOOP
10941: FOR l_rl_rec1 IN l_rl_csr1 ( 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_lne_pmnt.id )
10942: LOOP
10943: IF(( l_rl_rec1.rule_information2 IS NOT NULL) AND
10944: ( TRUNC(Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN
10945: Okl_Api.set_message(
10946: p_app_name => G_APP_NAME,
10947: p_msg_name => 'OKL_QA_PMNT_LN_START_DT',
10948: p_token1 => 'line',

Line 10958: ( TRUNC(Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_hdr_rec.start_date)))THEN

10954:
10955: FOR l_rl_rec1 IN l_rl_csr1 ( 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), -1 )
10956: LOOP
10957: IF(( l_rl_rec1.rule_information2 IS NOT NULL) AND
10958: ( TRUNC(Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_hdr_rec.start_date)))THEN
10959: Okl_Api.set_message(
10960: p_app_name => G_APP_NAME,
10961: p_msg_name => 'OKL_QA_PMNT_START_DT');
10962: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 11849: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,

11845: AND sty.id = styt.id;
11846:
11847: CURSOR l_strm_sll_csr (p_rule_id OKC_RULES_B.ID%TYPE,
11848: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
11849: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
11850: sll.rule_information1 seq,
11851: sll.rule_information6 amt,
11852: sll.rule_information7 stub_day,
11853: sll.rule_information13 rate

Line 12243: (TRUNC( FND_DATE.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) Then

12239: FETCH l_hdrrl_csr into l_hdrrl_rec;
12240:
12241: If(( l_hdrrl_csr%FOUND ) AND
12242: (l_hdrrl_rec.RULE_INFORMATION1 IS NOT NULL) AND
12243: (TRUNC( FND_DATE.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) Then
12244: OKL_API.set_message(
12245: p_app_name => G_APP_NAME,
12246: p_msg_name => 'OKL_QA_LATE_INT_DATE');
12247: -- notify caller of an error

Line 12310: ( TRUNC(FND_DATE.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) Then

12306: FETCH l_hdrrl_csr into l_hdrrl_rec;
12307:
12308: If(( l_hdrrl_csr%FOUND ) AND
12309: (l_hdrrl_rec.RULE_INFORMATION1 IS NOT NULL) AND
12310: ( TRUNC(FND_DATE.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) Then
12311: OKL_API.set_message(
12312: p_app_name => G_APP_NAME,
12313: p_msg_name => 'OKL_QA_LATE_CH_DATE');
12314: -- notify caller of an error