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

Line 619: -- The fnd function fnd_date.chardt_to_date has a bug because of which it gives

615: -- get collection id, creation date, spec id and plan id
616: X_COLLECTION_ID := to_number(QLTNINRB.NAME_IN('COLLECTION_ID'));
617: --
618: -- bug 12605910
619: -- The fnd function fnd_date.chardt_to_date has a bug because of which it gives
620: -- an error for Non gregorian dates. This was reported in bug 12813897.
621: -- So bypassing it to use the SQL to_date function
622: --
623: -- X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);

Line 623: -- X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);

619: -- The fnd function fnd_date.chardt_to_date has a bug because of which it gives
620: -- an error for Non gregorian dates. This was reported in bug 12813897.
621: -- So bypassing it to use the SQL to_date function
622: --
623: -- X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);
624: X_CREATION_DATE := to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'),
625: l_user_date_mask ||' HH24:MI:SS',
626: 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
627: Y_SPEC_ID := to_number(QLTNINRB.NAME_IN('SPEC_ID'));

Line 626: 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');

622: --
623: -- X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);
624: X_CREATION_DATE := to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'),
625: l_user_date_mask ||' HH24:MI:SS',
626: 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
627: Y_SPEC_ID := to_number(QLTNINRB.NAME_IN('SPEC_ID'));
628: Y_PLAN_ID := to_number(QLTNINRB.NAME_IN('PLAN_ID'));
629:
630: -- Bug 5111269.

Line 1931: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);

1927: l_followup_activity_id := QLTNINRB.NAME_IN('FOLLOWUP_ACTIVITY_ID');
1928: --dgupta: End R12 EAM Integration. Bug 4345492
1929: l_work_order_rec.primary_item_id := l_followup_activity_id;
1930:
1931: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);
1932: l_work_order_rec.last_updated_by := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1933: l_work_order_rec.creation_date := x_creation_date;
1934: l_work_order_rec.created_by := QLTNINRB.NAME_IN('CREATED_BY');
1935: l_work_order_rec.last_update_login := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');

Line 2269: avalue => fnd_date.canonical_to_date(token_value));

2265: WF_ENGINE.SetItemAttrDate(
2266: itemtype => X_WF_ITEMTYPE,
2267: itemkey => l_wf_itemkey,
2268: aname => prec.token_name,
2269: avalue => fnd_date.canonical_to_date(token_value));
2270: END IF;
2271:
2272: exit;
2273: END IF;