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.QLTNINRB dependencies on QLTDATE

Line 761: return qltdate.date_to_canon_dt(table_rec.TRANSACTION_DATE);

757:
758: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
759: -- modified to date_to_canon_dt
760: IF X_COL_NAME = 'TRANSACTION_DATE' THEN
761: return qltdate.date_to_canon_dt(table_rec.TRANSACTION_DATE);
762: END IF;
763:
764: IF X_COL_NAME = 'ASSET_GROUP_ID' THEN
765: return(to_char(table_rec.ASSET_GROUP_ID));

Line 1020: return qltdate.date_to_canon_dt(table_rec.DATE_OPENED);

1016:
1017: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
1018: -- added date_to_canon_dt
1019: IF X_COL_NAME = 'DATE_OPENED' THEN
1020: return qltdate.date_to_canon_dt(table_rec.DATE_OPENED);
1021: END IF;
1022:
1023: IF X_COL_NAME = 'DATE_CLOSED' THEN
1024: return qltdate.date_to_canon_dt(table_rec.DATE_CLOSED);

Line 1024: return qltdate.date_to_canon_dt(table_rec.DATE_CLOSED);

1020: return qltdate.date_to_canon_dt(table_rec.DATE_OPENED);
1021: END IF;
1022:
1023: IF X_COL_NAME = 'DATE_CLOSED' THEN
1024: return qltdate.date_to_canon_dt(table_rec.DATE_CLOSED);
1025: END IF;
1026:
1027: IF X_COL_NAME = 'DAYS_TO_CLOSE' THEN
1028: return(to_char(table_rec.DAYS_TO_CLOSE));

Line 1577: table_rec.LAST_UPDATE_DATE:=qltdate.any_to_date(return_value);

1573: table_rec.OCCURRENCE:=to_number(return_value);
1574: END IF;
1575:
1576: IF X_COL_NAME = 'LAST_UPDATE_DATE' THEN
1577: table_rec.LAST_UPDATE_DATE:=qltdate.any_to_date(return_value);
1578: END IF;
1579:
1580: IF X_COL_NAME = 'QA_LAST_UPDATE_DATE' THEN
1581: table_rec.QA_LAST_UPDATE_DATE:=(return_value);

Line 1593: table_rec.CREATION_DATE:=qltdate.any_to_date(return_value);

1589: table_rec.QA_LAST_UPDATED_BY:=to_number(return_value);
1590: END IF;
1591:
1592: IF X_COL_NAME = 'CREATION_DATE' THEN
1593: table_rec.CREATION_DATE:=qltdate.any_to_date(return_value);
1594: END IF;
1595:
1596: IF X_COL_NAME = 'QA_CREATION_DATE' THEN
1597: table_rec.QA_CREATION_DATE:=qltdate.any_to_date(return_value);

Line 1597: table_rec.QA_CREATION_DATE:=qltdate.any_to_date(return_value);

1593: table_rec.CREATION_DATE:=qltdate.any_to_date(return_value);
1594: END IF;
1595:
1596: IF X_COL_NAME = 'QA_CREATION_DATE' THEN
1597: table_rec.QA_CREATION_DATE:=qltdate.any_to_date(return_value);
1598: END IF;
1599:
1600: IF X_COL_NAME = 'CREATED_BY' THEN
1601: table_rec.CREATED_BY:=to_number(return_value);

Line 1757: table_rec.TRANSACTION_DATE:=qltdate.any_to_date(return_value);

1753: table_rec.XFR_LPN_ID:=to_number(return_value);
1754: END IF;
1755:
1756: IF X_COL_NAME = 'TRANSACTION_DATE' THEN
1757: table_rec.TRANSACTION_DATE:=qltdate.any_to_date(return_value);
1758: END IF;
1759:
1760: IF X_COL_NAME = 'ASSET_GROUP_ID' THEN
1761: table_rec.ASSET_GROUP_ID:=to_number(return_value);

Line 1973: table_rec.DATE_OPENED:=qltdate.any_to_date(return_value);

1969: table_rec.NONCONFORMANCE_STATUS:=to_char(return_value);
1970: END IF;
1971:
1972: IF X_COL_NAME = 'DATE_OPENED' THEN
1973: table_rec.DATE_OPENED:=qltdate.any_to_date(return_value);
1974: END IF;
1975:
1976: IF X_COL_NAME = 'DATE_CLOSED' THEN
1977: table_rec.DATE_CLOSED:=qltdate.any_to_date(return_value);

Line 1977: table_rec.DATE_CLOSED:=qltdate.any_to_date(return_value);

1973: table_rec.DATE_OPENED:=qltdate.any_to_date(return_value);
1974: END IF;
1975:
1976: IF X_COL_NAME = 'DATE_CLOSED' THEN
1977: table_rec.DATE_CLOSED:=qltdate.any_to_date(return_value);
1978: END IF;
1979:
1980: IF X_COL_NAME = 'DAYS_TO_CLOSE' THEN
1981: table_rec.DAYS_TO_CLOSE:=to_char(return_value);