APPS.OKL_AM_VENDOR_RES_SHARE_PVT dependencies on FND_DATE

Line 1885: lp_disp_date_from := FND_DATE.CANONICAL_TO_DATE(p_disp_date_from);

1881: l_total_sql := l_total_sql || l_condition_1;
1882: END IF;
1883:
1884: IF p_disp_date_from IS NOT NULL THEN
1885: lp_disp_date_from := FND_DATE.CANONICAL_TO_DATE(p_disp_date_from);
1886: l_condition_2 := ' AND trunc(TAL.fa_trx_date) >= to_date('''||lp_disp_date_from||''',''DD-MON-YY'')';
1887: l_total_sql := l_total_sql || l_condition_2;
1888: END IF;
1889:

Line 1891: lp_disp_date_to := FND_DATE.CANONICAL_TO_DATE(p_disp_date_to);

1887: l_total_sql := l_total_sql || l_condition_2;
1888: END IF;
1889:
1890: IF p_disp_date_to IS NOT NULL THEN
1891: lp_disp_date_to := FND_DATE.CANONICAL_TO_DATE(p_disp_date_to);
1892: l_condition_3 := ' AND trunc(TAL.fa_trx_date) <= to_date('''||lp_disp_date_to||''',''DD-MON-YY'')';
1893: l_total_sql := l_total_sql || l_condition_3;
1894: END IF;
1895:

Line 1902: lp_asst_end_dt_from := FND_DATE.CANONICAL_TO_DATE(p_asst_end_dt_from);

1898: l_total_sql := l_total_sql || l_condition_4;
1899: END IF;
1900:
1901: IF p_asst_end_dt_from IS NOT NULL THEN
1902: lp_asst_end_dt_from := FND_DATE.CANONICAL_TO_DATE(p_asst_end_dt_from);
1903: l_condition_5 := ' AND trunc(CLE.date_terminated) >= to_date('''||lp_asst_end_dt_from||''',''DD-MON-YY'')';
1904: l_total_sql := l_total_sql || l_condition_5;
1905: END IF;
1906:

Line 1908: lp_asst_end_dt_to := FND_DATE.CANONICAL_TO_DATE(p_asst_end_dt_to);

1904: l_total_sql := l_total_sql || l_condition_5;
1905: END IF;
1906:
1907: IF p_asst_end_dt_to IS NOT NULL THEN
1908: lp_asst_end_dt_to := FND_DATE.CANONICAL_TO_DATE(p_asst_end_dt_to);
1909: l_condition_6 := ' AND trunc(CLE.date_terminated) <= to_date('''||lp_asst_end_dt_to||''',''DD-MON-YY'')';
1910: l_total_sql := l_total_sql || l_condition_6;
1911: END IF;
1912:

Line 2010: lp_disp_date_from := FND_DATE.CANONICAL_TO_DATE(P_DISP_DATE_FROM);

2006: WHERE_CLAUSE := WHERE_CLAUSE || l_condition_1;
2007: END IF;
2008:
2009: IF P_DISP_DATE_FROM IS NOT NULL THEN
2010: lp_disp_date_from := FND_DATE.CANONICAL_TO_DATE(P_DISP_DATE_FROM);
2011: l_condition_2 := ' AND trunc(TAL.fa_trx_date) >= to_date('''||lp_disp_date_from||''',''DD-MON-YY'')';
2012: WHERE_CLAUSE := WHERE_CLAUSE || l_condition_2;
2013: END IF;
2014:

Line 2016: lp_disp_date_to := FND_DATE.CANONICAL_TO_DATE(P_DISP_DATE_TO);

2012: WHERE_CLAUSE := WHERE_CLAUSE || l_condition_2;
2013: END IF;
2014:
2015: IF P_DISP_DATE_TO IS NOT NULL THEN
2016: lp_disp_date_to := FND_DATE.CANONICAL_TO_DATE(P_DISP_DATE_TO);
2017: l_condition_3 := ' AND trunc(TAL.fa_trx_date) <= to_date('''||lp_disp_date_to||''',''DD-MON-YY'')';
2018: WHERE_CLAUSE := WHERE_CLAUSE || l_condition_3;
2019: END IF;
2020:

Line 2027: lp_asst_end_dt_from := FND_DATE.CANONICAL_TO_DATE(P_ASST_END_DT_FROM);

2023: WHERE_CLAUSE := WHERE_CLAUSE || l_condition_4;
2024: END IF;
2025:
2026: IF P_ASST_END_DT_FROM IS NOT NULL THEN
2027: lp_asst_end_dt_from := FND_DATE.CANONICAL_TO_DATE(P_ASST_END_DT_FROM);
2028: l_condition_5 := ' AND trunc(CLE.date_terminated) >= to_date('''||lp_asst_end_dt_from||''',''DD-MON-YY'')';
2029: WHERE_CLAUSE := WHERE_CLAUSE || l_condition_5;
2030: END IF;
2031:

Line 2033: lp_asst_end_dt_to := FND_DATE.CANONICAL_TO_DATE(P_ASST_END_DT_TO);

2029: WHERE_CLAUSE := WHERE_CLAUSE || l_condition_5;
2030: END IF;
2031:
2032: IF P_ASST_END_DT_TO IS NOT NULL THEN
2033: lp_asst_end_dt_to := FND_DATE.CANONICAL_TO_DATE(P_ASST_END_DT_TO);
2034: l_condition_6 := ' AND trunc(CLE.date_terminated) <= to_date('''||lp_asst_end_dt_to||''',''DD-MON-YY'')';
2035: WHERE_CLAUSE := WHERE_CLAUSE || l_condition_6;
2036: END IF;
2037: