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 1280: l_st_dt :=FND_DATE.CHARDATE_TO_DATE(p_start_date);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1987: AND pva.assignment_id= p_assignment_id
1988: AND pvr.business_group_id = p_business_group_id
1989: AND pvr.vehicle_repository_id=pva.vehicle_repository_id
1990: AND pvr.business_group_id=pva.business_group_id
1991: AND FND_DATE.CHARDATE_TO_DATE(p_start_date) BETWEEN pvr.effective_start_date
1992: AND pvr.effective_end_date
1993: AND pva.usage_type IN ('P','S');
1994:
1995: l_validate_comp_veh c_validate_comp_veh%ROWTYPE;

Line 2110: IF FND_DATE.CHARDT_TO_DATE(p_end_date) <

2106: fnd_message.set_name('PQP', 'PQP_230732_VLD_MLG_ELE_FAIL');
2107: l_retvalue :='N';
2108: END IF;
2109:
2110: IF FND_DATE.CHARDT_TO_DATE(p_end_date) <
2111: FND_DATE.CHARDT_TO_DATE(p_start_date) THEN
2112: hr_utility.set_location( l_proc,160);
2113: fnd_message.set_name('PER','HR_289262_ST_DATE_BEFORE_EDATE');
2114: l_retvalue :='N';

Line 2111: FND_DATE.CHARDT_TO_DATE(p_start_date) THEN

2107: l_retvalue :='N';
2108: END IF;
2109:
2110: IF FND_DATE.CHARDT_TO_DATE(p_end_date) <
2111: FND_DATE.CHARDT_TO_DATE(p_start_date) THEN
2112: hr_utility.set_location( l_proc,160);
2113: fnd_message.set_name('PER','HR_289262_ST_DATE_BEFORE_EDATE');
2114: l_retvalue :='N';
2115: END IF;

Line 2181: AND fnd_date.CHARDATE_TO_DATE(cp_start_date) BETWEEN

2177: WHERE pva.assignment_id =cp_assignment_id
2178: AND pva.business_group_id =cp_business_group_id
2179: AND pva.vehicle_repository_id=pvr.vehicle_repository_id
2180: AND pva.business_group_id=pvr.business_group_id
2181: AND fnd_date.CHARDATE_TO_DATE(cp_start_date) BETWEEN
2182: pva.effective_start_date AND
2183: pva.effective_end_date
2184: AND fnd_date.CHARDATE_TO_DATE(cp_start_date) BETWEEN
2185: pvr.effective_start_date AND

Line 2184: AND fnd_date.CHARDATE_TO_DATE(cp_start_date) BETWEEN

2180: AND pva.business_group_id=pvr.business_group_id
2181: AND fnd_date.CHARDATE_TO_DATE(cp_start_date) BETWEEN
2182: pva.effective_start_date AND
2183: pva.effective_end_date
2184: AND fnd_date.CHARDATE_TO_DATE(cp_start_date) BETWEEN
2185: pvr.effective_start_date AND
2186: pvr.effective_end_date
2187: AND pvr.vehicle_ownership='C';
2188:

Line 2208: IF fnd_date.CHARDATE_TO_DATE(p_start_date) <

2204:
2205: --Check if the claim is made for last tax
2206: --year after the cut off date.
2207: IF l_get_config_info.prev_tax_yr_valid IS NOT NULL THEN
2208: IF fnd_date.CHARDATE_TO_DATE(p_start_date) <
2209: TO_DATE(TO_CHAR
2210: (p_effective_date, 'YYYY')||'04/06','YYYY/MM/DD')
2211: THEN
2212: --checking the effective date is greater than previous tax year sumit

Line 2214: IF p_effective_date > fnd_date.CHARDATE_TO_DATE

2210: (p_effective_date, 'YYYY')||'04/06','YYYY/MM/DD')
2211: THEN
2212: --checking the effective date is greater than previous tax year sumit
2213: --valid untill date,so user cannot sumit claim after previous tax year
2214: IF p_effective_date > fnd_date.CHARDATE_TO_DATE
2215: (l_get_config_info.prev_tax_yr_valid||
2216: TO_CHAR(p_effective_date,'YYYY'))
2217: THEN
2218: --Error handling missing

Line 2349: fnd_date.DATE_TO_CANONICAL(cp_start_date)

2345: AND pev1.element_entry_id=pev2.element_entry_id
2346: AND pev1.input_value_id =cp_ipvalue1
2347: AND pev2.input_value_id=cp_ipvalue2
2348: AND pev1.screen_entry_value =
2349: fnd_date.DATE_TO_CANONICAL(cp_start_date)
2350: AND pev2.SCREEN_ENTRY_VALUE =
2351: fnd_date.DATE_TO_CANONICAL(cp_end_date);
2352:
2353:

Line 2351: fnd_date.DATE_TO_CANONICAL(cp_end_date);

2347: AND pev2.input_value_id=cp_ipvalue2
2348: AND pev1.screen_entry_value =
2349: fnd_date.DATE_TO_CANONICAL(cp_start_date)
2350: AND pev2.SCREEN_ENTRY_VALUE =
2351: fnd_date.DATE_TO_CANONICAL(cp_end_date);
2352:
2353:
2354: l_get_ele_details c_get_ele_details%ROWTYPE;
2355: l_get_input_val c_get_input_val%ROWTYPE;

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

2359: l_exist VARCHAR2(1):='N';
2360: l_start_date DATE;
2361: l_end_date DATE;
2362: BEGIN
2363: l_start_date:= fnd_date.chardt_to_date (p_start_date);
2364: l_end_date :=fnd_date.chardt_to_date(p_end_date);
2365: OPEN c_get_ele_details( p_vehicle_type
2366: ,p_business_group_id
2367: );

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

2360: l_start_date DATE;
2361: l_end_date DATE;
2362: BEGIN
2363: l_start_date:= fnd_date.chardt_to_date (p_start_date);
2364: l_end_date :=fnd_date.chardt_to_date(p_end_date);
2365: OPEN c_get_ele_details( p_vehicle_type
2366: ,p_business_group_id
2367: );
2368: LOOP