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.PQP_GB_MILEAGE_CLAIM_PKG dependencies on FND_DATE

Line 1282: l_st_dt :=FND_DATE.CHARDATE_TO_DATE(p_start_date);

1278: l_businesss_group_id:= fnd_profile.value('PER_BUSINESS_GROUP_ID');
1279: l_session_id := fnd_profile.value('USER_ID');
1280:
1281:
1282: l_st_dt :=FND_DATE.CHARDATE_TO_DATE(p_start_date);
1283: l_ed_dt :=FND_DATE.CHARDATE_TO_DATE(p_end_date);
1284: l_canonical_st_dt :=fnd_date.date_to_canonical(l_st_dt);
1285: l_canonical_ed_dt :=fnd_date.date_to_canonical(l_ed_dt);
1286: -- l_canonical_st_dt :=fnd_date.date_to_displaydt(p_start_date);

Line 1283: l_ed_dt :=FND_DATE.CHARDATE_TO_DATE(p_end_date);

1279: l_session_id := fnd_profile.value('USER_ID');
1280:
1281:
1282: l_st_dt :=FND_DATE.CHARDATE_TO_DATE(p_start_date);
1283: l_ed_dt :=FND_DATE.CHARDATE_TO_DATE(p_end_date);
1284: l_canonical_st_dt :=fnd_date.date_to_canonical(l_st_dt);
1285: l_canonical_ed_dt :=fnd_date.date_to_canonical(l_ed_dt);
1286: -- l_canonical_st_dt :=fnd_date.date_to_displaydt(p_start_date);
1287: -- l_canonical_ed_dt :=fnd_date.date_to_displaydt(p_end_date);

Line 1284: l_canonical_st_dt :=fnd_date.date_to_canonical(l_st_dt);

1280:
1281:
1282: l_st_dt :=FND_DATE.CHARDATE_TO_DATE(p_start_date);
1283: l_ed_dt :=FND_DATE.CHARDATE_TO_DATE(p_end_date);
1284: l_canonical_st_dt :=fnd_date.date_to_canonical(l_st_dt);
1285: l_canonical_ed_dt :=fnd_date.date_to_canonical(l_ed_dt);
1286: -- l_canonical_st_dt :=fnd_date.date_to_displaydt(p_start_date);
1287: -- l_canonical_ed_dt :=fnd_date.date_to_displaydt(p_end_date);
1288:

Line 1285: l_canonical_ed_dt :=fnd_date.date_to_canonical(l_ed_dt);

1281:
1282: l_st_dt :=FND_DATE.CHARDATE_TO_DATE(p_start_date);
1283: l_ed_dt :=FND_DATE.CHARDATE_TO_DATE(p_end_date);
1284: l_canonical_st_dt :=fnd_date.date_to_canonical(l_st_dt);
1285: l_canonical_ed_dt :=fnd_date.date_to_canonical(l_ed_dt);
1286: -- l_canonical_st_dt :=fnd_date.date_to_displaydt(p_start_date);
1287: -- l_canonical_ed_dt :=fnd_date.date_to_displaydt(p_end_date);
1288:
1289: INSERT INTO pay_us_rpt_totals

Line 1286: -- l_canonical_st_dt :=fnd_date.date_to_displaydt(p_start_date);

1282: l_st_dt :=FND_DATE.CHARDATE_TO_DATE(p_start_date);
1283: l_ed_dt :=FND_DATE.CHARDATE_TO_DATE(p_end_date);
1284: l_canonical_st_dt :=fnd_date.date_to_canonical(l_st_dt);
1285: l_canonical_ed_dt :=fnd_date.date_to_canonical(l_ed_dt);
1286: -- l_canonical_st_dt :=fnd_date.date_to_displaydt(p_start_date);
1287: -- l_canonical_ed_dt :=fnd_date.date_to_displaydt(p_end_date);
1288:
1289: INSERT INTO pay_us_rpt_totals
1290: (gre_name , -- Stores session id

Line 1287: -- l_canonical_ed_dt :=fnd_date.date_to_displaydt(p_end_date);

1283: l_ed_dt :=FND_DATE.CHARDATE_TO_DATE(p_end_date);
1284: l_canonical_st_dt :=fnd_date.date_to_canonical(l_st_dt);
1285: l_canonical_ed_dt :=fnd_date.date_to_canonical(l_ed_dt);
1286: -- l_canonical_st_dt :=fnd_date.date_to_displaydt(p_start_date);
1287: -- l_canonical_ed_dt :=fnd_date.date_to_displaydt(p_end_date);
1288:
1289: INSERT INTO pay_us_rpt_totals
1290: (gre_name , -- Stores session id
1291: state_name, -- Stores timestamp

Line 1349: AND (p_effective_date-fnd_date.canonical_to_date(state_name))>1;

1345: --Deleting all rows which are older than a day
1346: DELETE
1347: FROM pay_us_rpt_totals
1348: WHERE STATE_ABBREV ='ADI'
1349: AND (p_effective_date-fnd_date.canonical_to_date(state_name))>1;
1350:
1351: COMMIT;
1352: p_return_status := 'S';
1353: hr_utility.set_location('Leaving delete mileage:' || l_proc,170);

Line 2005: AND FND_DATE.CHARDATE_TO_DATE(p_start_date) BETWEEN pvr.effective_start_date

2001: AND pva.assignment_id= p_assignment_id
2002: AND pvr.business_group_id = p_business_group_id
2003: AND pvr.vehicle_repository_id=pva.vehicle_repository_id
2004: AND pvr.business_group_id=pva.business_group_id
2005: AND FND_DATE.CHARDATE_TO_DATE(p_start_date) BETWEEN pvr.effective_start_date
2006: AND pvr.effective_end_date
2007: AND pva.usage_type IN ('P','S');
2008:
2009: l_validate_comp_veh c_validate_comp_veh%ROWTYPE;

Line 2124: IF FND_DATE.CHARDT_TO_DATE(p_end_date) <

2120: fnd_message.set_name('PQP', 'PQP_230732_VLD_MLG_ELE_FAIL');
2121: l_retvalue :='N';
2122: END IF;
2123:
2124: IF FND_DATE.CHARDT_TO_DATE(p_end_date) <
2125: FND_DATE.CHARDT_TO_DATE(p_start_date) THEN
2126: hr_utility.set_location( l_proc,160);
2127: fnd_message.set_name('PER','HR_289262_ST_DATE_BEFORE_EDATE');
2128: l_retvalue :='N';

Line 2125: FND_DATE.CHARDT_TO_DATE(p_start_date) THEN

2121: l_retvalue :='N';
2122: END IF;
2123:
2124: IF FND_DATE.CHARDT_TO_DATE(p_end_date) <
2125: FND_DATE.CHARDT_TO_DATE(p_start_date) THEN
2126: hr_utility.set_location( l_proc,160);
2127: fnd_message.set_name('PER','HR_289262_ST_DATE_BEFORE_EDATE');
2128: l_retvalue :='N';
2129: END IF;

Line 2195: AND fnd_date.CHARDATE_TO_DATE(cp_start_date) BETWEEN

2191: WHERE pva.assignment_id =cp_assignment_id
2192: AND pva.business_group_id =cp_business_group_id
2193: AND pva.vehicle_repository_id=pvr.vehicle_repository_id
2194: AND pva.business_group_id=pvr.business_group_id
2195: AND fnd_date.CHARDATE_TO_DATE(cp_start_date) BETWEEN
2196: pva.effective_start_date AND
2197: pva.effective_end_date
2198: AND fnd_date.CHARDATE_TO_DATE(cp_start_date) BETWEEN
2199: pvr.effective_start_date AND

Line 2198: AND fnd_date.CHARDATE_TO_DATE(cp_start_date) BETWEEN

2194: AND pva.business_group_id=pvr.business_group_id
2195: AND fnd_date.CHARDATE_TO_DATE(cp_start_date) BETWEEN
2196: pva.effective_start_date AND
2197: pva.effective_end_date
2198: AND fnd_date.CHARDATE_TO_DATE(cp_start_date) BETWEEN
2199: pvr.effective_start_date AND
2200: pvr.effective_end_date
2201: AND pvr.vehicle_ownership='C';
2202:

Line 2222: IF fnd_date.CHARDATE_TO_DATE(p_start_date) <

2218:
2219: --Check if the claim is made for last tax
2220: --year after the cut off date.
2221: IF l_get_config_info.prev_tax_yr_valid IS NOT NULL THEN
2222: IF fnd_date.CHARDATE_TO_DATE(p_start_date) <
2223: TO_DATE(TO_CHAR
2224: (p_effective_date, 'YYYY')||'04/06','YYYY/MM/DD')
2225: THEN
2226: --checking the effective date is greater than previous tax year sumit

Line 2228: IF p_effective_date > fnd_date.CHARDATE_TO_DATE

2224: (p_effective_date, 'YYYY')||'04/06','YYYY/MM/DD')
2225: THEN
2226: --checking the effective date is greater than previous tax year sumit
2227: --valid untill date,so user cannot sumit claim after previous tax year
2228: IF p_effective_date > fnd_date.CHARDATE_TO_DATE
2229: (l_get_config_info.prev_tax_yr_valid||
2230: TO_CHAR(p_effective_date,'YYYY'))
2231: THEN
2232: --Error handling missing

Line 2363: fnd_date.DATE_TO_CANONICAL(cp_start_date)

2359: AND pev1.element_entry_id=pev2.element_entry_id
2360: AND pev1.input_value_id =cp_ipvalue1
2361: AND pev2.input_value_id=cp_ipvalue2
2362: AND pev1.screen_entry_value =
2363: fnd_date.DATE_TO_CANONICAL(cp_start_date)
2364: AND pev2.SCREEN_ENTRY_VALUE =
2365: fnd_date.DATE_TO_CANONICAL(cp_end_date);
2366:
2367:

Line 2365: fnd_date.DATE_TO_CANONICAL(cp_end_date);

2361: AND pev2.input_value_id=cp_ipvalue2
2362: AND pev1.screen_entry_value =
2363: fnd_date.DATE_TO_CANONICAL(cp_start_date)
2364: AND pev2.SCREEN_ENTRY_VALUE =
2365: fnd_date.DATE_TO_CANONICAL(cp_end_date);
2366:
2367:
2368: l_get_ele_details c_get_ele_details%ROWTYPE;
2369: l_get_input_val c_get_input_val%ROWTYPE;

Line 2377: l_start_date:= fnd_date.chardt_to_date (p_start_date);

2373: l_exist VARCHAR2(1):='N';
2374: l_start_date DATE;
2375: l_end_date DATE;
2376: BEGIN
2377: l_start_date:= fnd_date.chardt_to_date (p_start_date);
2378: l_end_date :=fnd_date.chardt_to_date(p_end_date);
2379: OPEN c_get_ele_details( p_vehicle_type
2380: ,p_business_group_id
2381: );

Line 2378: l_end_date :=fnd_date.chardt_to_date(p_end_date);

2374: l_start_date DATE;
2375: l_end_date DATE;
2376: BEGIN
2377: l_start_date:= fnd_date.chardt_to_date (p_start_date);
2378: l_end_date :=fnd_date.chardt_to_date(p_end_date);
2379: OPEN c_get_ele_details( p_vehicle_type
2380: ,p_business_group_id
2381: );
2382: LOOP