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 768: return qltdate.date_to_canon_dt(table_rec.TRANSACTION_DATE);

764:
765: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
766: -- modified to date_to_canon_dt
767: IF X_COL_NAME = 'TRANSACTION_DATE' THEN
768: return qltdate.date_to_canon_dt(table_rec.TRANSACTION_DATE);
769: END IF;
770:
771: IF X_COL_NAME = 'ASSET_GROUP_ID' THEN
772: return(to_char(table_rec.ASSET_GROUP_ID));

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

1023:
1024: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
1025: -- added date_to_canon_dt
1026: IF X_COL_NAME = 'DATE_OPENED' THEN
1027: return qltdate.date_to_canon_dt(table_rec.DATE_OPENED);
1028: END IF;
1029:
1030: IF X_COL_NAME = 'DATE_CLOSED' THEN
1031: return qltdate.date_to_canon_dt(table_rec.DATE_CLOSED);

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

1027: return qltdate.date_to_canon_dt(table_rec.DATE_OPENED);
1028: END IF;
1029:
1030: IF X_COL_NAME = 'DATE_CLOSED' THEN
1031: return qltdate.date_to_canon_dt(table_rec.DATE_CLOSED);
1032: END IF;
1033:
1034: IF X_COL_NAME = 'DAYS_TO_CLOSE' THEN
1035: return(to_char(table_rec.DAYS_TO_CLOSE));

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

1580: table_rec.OCCURRENCE:=to_number(return_value);
1581: END IF;
1582:
1583: IF X_COL_NAME = 'LAST_UPDATE_DATE' THEN
1584: table_rec.LAST_UPDATE_DATE:=qltdate.any_to_date(return_value);
1585: END IF;
1586:
1587: IF X_COL_NAME = 'QA_LAST_UPDATE_DATE' THEN
1588: table_rec.QA_LAST_UPDATE_DATE:=(return_value);

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

1596: table_rec.QA_LAST_UPDATED_BY:=to_number(return_value);
1597: END IF;
1598:
1599: IF X_COL_NAME = 'CREATION_DATE' THEN
1600: table_rec.CREATION_DATE:=qltdate.any_to_date(return_value);
1601: END IF;
1602:
1603: IF X_COL_NAME = 'QA_CREATION_DATE' THEN
1604: table_rec.QA_CREATION_DATE:=qltdate.any_to_date(return_value);

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

1600: table_rec.CREATION_DATE:=qltdate.any_to_date(return_value);
1601: END IF;
1602:
1603: IF X_COL_NAME = 'QA_CREATION_DATE' THEN
1604: table_rec.QA_CREATION_DATE:=qltdate.any_to_date(return_value);
1605: END IF;
1606:
1607: IF X_COL_NAME = 'CREATED_BY' THEN
1608: table_rec.CREATED_BY:=to_number(return_value);

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

1760: table_rec.XFR_LPN_ID:=to_number(return_value);
1761: END IF;
1762:
1763: IF X_COL_NAME = 'TRANSACTION_DATE' THEN
1764: table_rec.TRANSACTION_DATE:=qltdate.any_to_date(return_value);
1765: END IF;
1766:
1767: IF X_COL_NAME = 'ASSET_GROUP_ID' THEN
1768: table_rec.ASSET_GROUP_ID:=to_number(return_value);

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

1976: table_rec.NONCONFORMANCE_STATUS:=to_char(return_value);
1977: END IF;
1978:
1979: IF X_COL_NAME = 'DATE_OPENED' THEN
1980: table_rec.DATE_OPENED:=qltdate.any_to_date(return_value);
1981: END IF;
1982:
1983: IF X_COL_NAME = 'DATE_CLOSED' THEN
1984: table_rec.DATE_CLOSED:=qltdate.any_to_date(return_value);

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

1980: table_rec.DATE_OPENED:=qltdate.any_to_date(return_value);
1981: END IF;
1982:
1983: IF X_COL_NAME = 'DATE_CLOSED' THEN
1984: table_rec.DATE_CLOSED:=qltdate.any_to_date(return_value);
1985: END IF;
1986:
1987: IF X_COL_NAME = 'DAYS_TO_CLOSE' THEN
1988: table_rec.DAYS_TO_CLOSE:=to_char(return_value);