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

Line 429: , fnd_date.date_to_canonical(origination_date)

425: l_wms_installed BOOLEAN;
426:
427: CURSOR serial_temp_csr(p_transaction_temp_id NUMBER) IS
428: SELECT serial_attribute_category
429: , fnd_date.date_to_canonical(origination_date)
430: , c_attribute1
431: , c_attribute2
432: , c_attribute3
433: , c_attribute4

Line 450: , fnd_date.date_to_canonical(d_attribute1)

446: , c_attribute17
447: , c_attribute18
448: , c_attribute19
449: , c_attribute20
450: , fnd_date.date_to_canonical(d_attribute1)
451: , fnd_date.date_to_canonical(d_attribute2)
452: , fnd_date.date_to_canonical(d_attribute3)
453: , fnd_date.date_to_canonical(d_attribute4)
454: , fnd_date.date_to_canonical(d_attribute5)

Line 451: , fnd_date.date_to_canonical(d_attribute2)

447: , c_attribute18
448: , c_attribute19
449: , c_attribute20
450: , fnd_date.date_to_canonical(d_attribute1)
451: , fnd_date.date_to_canonical(d_attribute2)
452: , fnd_date.date_to_canonical(d_attribute3)
453: , fnd_date.date_to_canonical(d_attribute4)
454: , fnd_date.date_to_canonical(d_attribute5)
455: , fnd_date.date_to_canonical(d_attribute6)

Line 452: , fnd_date.date_to_canonical(d_attribute3)

448: , c_attribute19
449: , c_attribute20
450: , fnd_date.date_to_canonical(d_attribute1)
451: , fnd_date.date_to_canonical(d_attribute2)
452: , fnd_date.date_to_canonical(d_attribute3)
453: , fnd_date.date_to_canonical(d_attribute4)
454: , fnd_date.date_to_canonical(d_attribute5)
455: , fnd_date.date_to_canonical(d_attribute6)
456: , fnd_date.date_to_canonical(d_attribute7)

Line 453: , fnd_date.date_to_canonical(d_attribute4)

449: , c_attribute20
450: , fnd_date.date_to_canonical(d_attribute1)
451: , fnd_date.date_to_canonical(d_attribute2)
452: , fnd_date.date_to_canonical(d_attribute3)
453: , fnd_date.date_to_canonical(d_attribute4)
454: , fnd_date.date_to_canonical(d_attribute5)
455: , fnd_date.date_to_canonical(d_attribute6)
456: , fnd_date.date_to_canonical(d_attribute7)
457: , fnd_date.date_to_canonical(d_attribute8)

Line 454: , fnd_date.date_to_canonical(d_attribute5)

450: , fnd_date.date_to_canonical(d_attribute1)
451: , fnd_date.date_to_canonical(d_attribute2)
452: , fnd_date.date_to_canonical(d_attribute3)
453: , fnd_date.date_to_canonical(d_attribute4)
454: , fnd_date.date_to_canonical(d_attribute5)
455: , fnd_date.date_to_canonical(d_attribute6)
456: , fnd_date.date_to_canonical(d_attribute7)
457: , fnd_date.date_to_canonical(d_attribute8)
458: , fnd_date.date_to_canonical(d_attribute9)

Line 455: , fnd_date.date_to_canonical(d_attribute6)

451: , fnd_date.date_to_canonical(d_attribute2)
452: , fnd_date.date_to_canonical(d_attribute3)
453: , fnd_date.date_to_canonical(d_attribute4)
454: , fnd_date.date_to_canonical(d_attribute5)
455: , fnd_date.date_to_canonical(d_attribute6)
456: , fnd_date.date_to_canonical(d_attribute7)
457: , fnd_date.date_to_canonical(d_attribute8)
458: , fnd_date.date_to_canonical(d_attribute9)
459: , fnd_date.date_to_canonical(d_attribute10)

Line 456: , fnd_date.date_to_canonical(d_attribute7)

452: , fnd_date.date_to_canonical(d_attribute3)
453: , fnd_date.date_to_canonical(d_attribute4)
454: , fnd_date.date_to_canonical(d_attribute5)
455: , fnd_date.date_to_canonical(d_attribute6)
456: , fnd_date.date_to_canonical(d_attribute7)
457: , fnd_date.date_to_canonical(d_attribute8)
458: , fnd_date.date_to_canonical(d_attribute9)
459: , fnd_date.date_to_canonical(d_attribute10)
460: , TO_CHAR(n_attribute1)

Line 457: , fnd_date.date_to_canonical(d_attribute8)

453: , fnd_date.date_to_canonical(d_attribute4)
454: , fnd_date.date_to_canonical(d_attribute5)
455: , fnd_date.date_to_canonical(d_attribute6)
456: , fnd_date.date_to_canonical(d_attribute7)
457: , fnd_date.date_to_canonical(d_attribute8)
458: , fnd_date.date_to_canonical(d_attribute9)
459: , fnd_date.date_to_canonical(d_attribute10)
460: , TO_CHAR(n_attribute1)
461: , TO_CHAR(n_attribute2)

Line 458: , fnd_date.date_to_canonical(d_attribute9)

454: , fnd_date.date_to_canonical(d_attribute5)
455: , fnd_date.date_to_canonical(d_attribute6)
456: , fnd_date.date_to_canonical(d_attribute7)
457: , fnd_date.date_to_canonical(d_attribute8)
458: , fnd_date.date_to_canonical(d_attribute9)
459: , fnd_date.date_to_canonical(d_attribute10)
460: , TO_CHAR(n_attribute1)
461: , TO_CHAR(n_attribute2)
462: , TO_CHAR(n_attribute3)

Line 459: , fnd_date.date_to_canonical(d_attribute10)

455: , fnd_date.date_to_canonical(d_attribute6)
456: , fnd_date.date_to_canonical(d_attribute7)
457: , fnd_date.date_to_canonical(d_attribute8)
458: , fnd_date.date_to_canonical(d_attribute9)
459: , fnd_date.date_to_canonical(d_attribute10)
460: , TO_CHAR(n_attribute1)
461: , TO_CHAR(n_attribute2)
462: , TO_CHAR(n_attribute3)
463: , TO_CHAR(n_attribute4)

Line 1108: , fnd_date.canonical_to_date(g_serial_attributes_tbl(2).column_value)

1104: , NULL
1105: , NULL
1106: , x_object_id
1107: , g_serial_attributes_tbl(1).column_value
1108: , fnd_date.canonical_to_date(g_serial_attributes_tbl(2).column_value)
1109: , g_serial_attributes_tbl(3).column_value
1110: , g_serial_attributes_tbl(4).column_value
1111: , g_serial_attributes_tbl(5).column_value
1112: , g_serial_attributes_tbl(6).column_value

Line 1129: , fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value)

1125: , g_serial_attributes_tbl(19).column_value
1126: , g_serial_attributes_tbl(20).column_value
1127: , g_serial_attributes_tbl(21).column_value
1128: , g_serial_attributes_tbl(22).column_value
1129: , fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value)
1130: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)
1131: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1132: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1133: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)

Line 1130: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)

1126: , g_serial_attributes_tbl(20).column_value
1127: , g_serial_attributes_tbl(21).column_value
1128: , g_serial_attributes_tbl(22).column_value
1129: , fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value)
1130: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)
1131: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1132: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1133: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1134: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)

Line 1131: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)

1127: , g_serial_attributes_tbl(21).column_value
1128: , g_serial_attributes_tbl(22).column_value
1129: , fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value)
1130: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)
1131: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1132: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1133: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1134: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1135: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)

Line 1132: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)

1128: , g_serial_attributes_tbl(22).column_value
1129: , fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value)
1130: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)
1131: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1132: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1133: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1134: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1135: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1136: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)

Line 1133: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)

1129: , fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value)
1130: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)
1131: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1132: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1133: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1134: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1135: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1136: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)
1137: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)

Line 1134: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)

1130: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)
1131: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1132: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1133: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1134: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1135: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1136: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)
1137: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)
1138: , fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value)

Line 1135: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)

1131: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1132: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1133: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1134: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1135: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1136: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)
1137: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)
1138: , fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value)
1139: , TO_NUMBER(g_serial_attributes_tbl(33).column_value)

Line 1136: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)

1132: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1133: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1134: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1135: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1136: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)
1137: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)
1138: , fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value)
1139: , TO_NUMBER(g_serial_attributes_tbl(33).column_value)
1140: , TO_NUMBER(g_serial_attributes_tbl(34).column_value)

Line 1137: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)

1133: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1134: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1135: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1136: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)
1137: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)
1138: , fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value)
1139: , TO_NUMBER(g_serial_attributes_tbl(33).column_value)
1140: , TO_NUMBER(g_serial_attributes_tbl(34).column_value)
1141: , TO_NUMBER(g_serial_attributes_tbl(35).column_value)

Line 1138: , fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value)

1134: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1135: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1136: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)
1137: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)
1138: , fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value)
1139: , TO_NUMBER(g_serial_attributes_tbl(33).column_value)
1140: , TO_NUMBER(g_serial_attributes_tbl(34).column_value)
1141: , TO_NUMBER(g_serial_attributes_tbl(35).column_value)
1142: , TO_NUMBER(g_serial_attributes_tbl(36).column_value)

Line 1203: -- invtrace('origination date is ' || fnd_date.canonical_to_date(g_serial_attributes_tbl(2).column_value));

1199: -- invtrace('lot_linemark_id is NULL');
1200: -- invtrace('end item unit number is NULL');
1201: -- invtrace('gen_object_id is ' ||x_object_id);
1202: -- invtrace('serial attribute category is ' || g_serial_attributes_tbl(1).column_value);
1203: -- invtrace('origination date is ' || fnd_date.canonical_to_date(g_serial_attributes_tbl(2).column_value));
1204: -- invtrace('c_attribute1 '|| g_serial_attributes_tbl(3).column_value);
1205: -- invtrace('cattribute2 ' || g_serial_attributes_tbl(4).column_value);
1206: -- invtrace('cattribute3 ' ||g_serial_attributes_tbl(5).column_value);
1207: -- invtrace('cattribute4 ' ||g_serial_attributes_tbl(6).column_value);

Line 1224: -- invtrace('dattribute1 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value));

1220: -- invtrace('cattribute17 ' ||g_serial_attributes_tbl(19).column_value);
1221: -- invtrace('cattribute18 ' ||g_serial_attributes_tbl(20).column_value);
1222: -- invtrace('cattribute19 ' ||g_serial_attributes_tbl(21).column_value);
1223: -- invtrace('cattribute20 ' ||g_serial_attributes_tbl(22).column_value);
1224: -- invtrace('dattribute1 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value));
1225: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));
1226: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1227: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1228: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));

Line 1225: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));

1221: -- invtrace('cattribute18 ' ||g_serial_attributes_tbl(20).column_value);
1222: -- invtrace('cattribute19 ' ||g_serial_attributes_tbl(21).column_value);
1223: -- invtrace('cattribute20 ' ||g_serial_attributes_tbl(22).column_value);
1224: -- invtrace('dattribute1 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value));
1225: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));
1226: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1227: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1228: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1229: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));

Line 1226: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));

1222: -- invtrace('cattribute19 ' ||g_serial_attributes_tbl(21).column_value);
1223: -- invtrace('cattribute20 ' ||g_serial_attributes_tbl(22).column_value);
1224: -- invtrace('dattribute1 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value));
1225: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));
1226: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1227: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1228: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1229: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1230: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));

Line 1227: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));

1223: -- invtrace('cattribute20 ' ||g_serial_attributes_tbl(22).column_value);
1224: -- invtrace('dattribute1 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value));
1225: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));
1226: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1227: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1228: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1229: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1230: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1231: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));

Line 1228: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));

1224: -- invtrace('dattribute1 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value));
1225: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));
1226: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1227: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1228: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1229: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1230: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1231: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));
1232: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));

Line 1229: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));

1225: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));
1226: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1227: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1228: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1229: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1230: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1231: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));
1232: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));
1233: -- invtrace('dattribute10 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value));

Line 1230: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));

1226: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1227: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1228: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1229: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1230: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1231: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));
1232: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));
1233: -- invtrace('dattribute10 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value));
1234: -- invtrace('nattribute1 ' ||TO_NUMBER(g_serial_attributes_tbl(33).column_value));

Line 1231: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));

1227: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1228: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1229: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1230: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1231: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));
1232: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));
1233: -- invtrace('dattribute10 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value));
1234: -- invtrace('nattribute1 ' ||TO_NUMBER(g_serial_attributes_tbl(33).column_value));
1235: -- invtrace('nattribute2 ' ||TO_NUMBER(g_serial_attributes_tbl(34).column_value));

Line 1232: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));

1228: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1229: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1230: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1231: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));
1232: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));
1233: -- invtrace('dattribute10 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value));
1234: -- invtrace('nattribute1 ' ||TO_NUMBER(g_serial_attributes_tbl(33).column_value));
1235: -- invtrace('nattribute2 ' ||TO_NUMBER(g_serial_attributes_tbl(34).column_value));
1236: -- invtrace('nattribute3 ' ||TO_NUMBER(g_serial_attributes_tbl(35).column_value));

Line 1233: -- invtrace('dattribute10 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value));

1229: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1230: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1231: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));
1232: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));
1233: -- invtrace('dattribute10 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value));
1234: -- invtrace('nattribute1 ' ||TO_NUMBER(g_serial_attributes_tbl(33).column_value));
1235: -- invtrace('nattribute2 ' ||TO_NUMBER(g_serial_attributes_tbl(34).column_value));
1236: -- invtrace('nattribute3 ' ||TO_NUMBER(g_serial_attributes_tbl(35).column_value));
1237: -- invtrace('nattribute4 ' ||TO_NUMBER(g_serial_attributes_tbl(36).column_value));

Line 2453: , fnd_date.date_to_canonical(origination_date)

2449: l_num42 NUMBER := NULL;
2450:
2451: CURSOR serial_temp_csr(p_transaction_temp_id NUMBER) IS
2452: SELECT serial_attribute_category
2453: , fnd_date.date_to_canonical(origination_date)
2454: , c_attribute1
2455: , c_attribute2
2456: , c_attribute3
2457: , c_attribute4

Line 2474: , fnd_date.date_to_canonical(d_attribute1)

2470: , c_attribute17
2471: , c_attribute18
2472: , c_attribute19
2473: , c_attribute20
2474: , fnd_date.date_to_canonical(d_attribute1)
2475: , fnd_date.date_to_canonical(d_attribute2)
2476: , fnd_date.date_to_canonical(d_attribute3)
2477: , fnd_date.date_to_canonical(d_attribute4)
2478: , fnd_date.date_to_canonical(d_attribute5)

Line 2475: , fnd_date.date_to_canonical(d_attribute2)

2471: , c_attribute18
2472: , c_attribute19
2473: , c_attribute20
2474: , fnd_date.date_to_canonical(d_attribute1)
2475: , fnd_date.date_to_canonical(d_attribute2)
2476: , fnd_date.date_to_canonical(d_attribute3)
2477: , fnd_date.date_to_canonical(d_attribute4)
2478: , fnd_date.date_to_canonical(d_attribute5)
2479: , fnd_date.date_to_canonical(d_attribute6)

Line 2476: , fnd_date.date_to_canonical(d_attribute3)

2472: , c_attribute19
2473: , c_attribute20
2474: , fnd_date.date_to_canonical(d_attribute1)
2475: , fnd_date.date_to_canonical(d_attribute2)
2476: , fnd_date.date_to_canonical(d_attribute3)
2477: , fnd_date.date_to_canonical(d_attribute4)
2478: , fnd_date.date_to_canonical(d_attribute5)
2479: , fnd_date.date_to_canonical(d_attribute6)
2480: , fnd_date.date_to_canonical(d_attribute7)

Line 2477: , fnd_date.date_to_canonical(d_attribute4)

2473: , c_attribute20
2474: , fnd_date.date_to_canonical(d_attribute1)
2475: , fnd_date.date_to_canonical(d_attribute2)
2476: , fnd_date.date_to_canonical(d_attribute3)
2477: , fnd_date.date_to_canonical(d_attribute4)
2478: , fnd_date.date_to_canonical(d_attribute5)
2479: , fnd_date.date_to_canonical(d_attribute6)
2480: , fnd_date.date_to_canonical(d_attribute7)
2481: , fnd_date.date_to_canonical(d_attribute8)

Line 2478: , fnd_date.date_to_canonical(d_attribute5)

2474: , fnd_date.date_to_canonical(d_attribute1)
2475: , fnd_date.date_to_canonical(d_attribute2)
2476: , fnd_date.date_to_canonical(d_attribute3)
2477: , fnd_date.date_to_canonical(d_attribute4)
2478: , fnd_date.date_to_canonical(d_attribute5)
2479: , fnd_date.date_to_canonical(d_attribute6)
2480: , fnd_date.date_to_canonical(d_attribute7)
2481: , fnd_date.date_to_canonical(d_attribute8)
2482: , fnd_date.date_to_canonical(d_attribute9)

Line 2479: , fnd_date.date_to_canonical(d_attribute6)

2475: , fnd_date.date_to_canonical(d_attribute2)
2476: , fnd_date.date_to_canonical(d_attribute3)
2477: , fnd_date.date_to_canonical(d_attribute4)
2478: , fnd_date.date_to_canonical(d_attribute5)
2479: , fnd_date.date_to_canonical(d_attribute6)
2480: , fnd_date.date_to_canonical(d_attribute7)
2481: , fnd_date.date_to_canonical(d_attribute8)
2482: , fnd_date.date_to_canonical(d_attribute9)
2483: , fnd_date.date_to_canonical(d_attribute10)

Line 2480: , fnd_date.date_to_canonical(d_attribute7)

2476: , fnd_date.date_to_canonical(d_attribute3)
2477: , fnd_date.date_to_canonical(d_attribute4)
2478: , fnd_date.date_to_canonical(d_attribute5)
2479: , fnd_date.date_to_canonical(d_attribute6)
2480: , fnd_date.date_to_canonical(d_attribute7)
2481: , fnd_date.date_to_canonical(d_attribute8)
2482: , fnd_date.date_to_canonical(d_attribute9)
2483: , fnd_date.date_to_canonical(d_attribute10)
2484: , TO_CHAR(n_attribute1)

Line 2481: , fnd_date.date_to_canonical(d_attribute8)

2477: , fnd_date.date_to_canonical(d_attribute4)
2478: , fnd_date.date_to_canonical(d_attribute5)
2479: , fnd_date.date_to_canonical(d_attribute6)
2480: , fnd_date.date_to_canonical(d_attribute7)
2481: , fnd_date.date_to_canonical(d_attribute8)
2482: , fnd_date.date_to_canonical(d_attribute9)
2483: , fnd_date.date_to_canonical(d_attribute10)
2484: , TO_CHAR(n_attribute1)
2485: , TO_CHAR(n_attribute2)

Line 2482: , fnd_date.date_to_canonical(d_attribute9)

2478: , fnd_date.date_to_canonical(d_attribute5)
2479: , fnd_date.date_to_canonical(d_attribute6)
2480: , fnd_date.date_to_canonical(d_attribute7)
2481: , fnd_date.date_to_canonical(d_attribute8)
2482: , fnd_date.date_to_canonical(d_attribute9)
2483: , fnd_date.date_to_canonical(d_attribute10)
2484: , TO_CHAR(n_attribute1)
2485: , TO_CHAR(n_attribute2)
2486: , TO_CHAR(n_attribute3)

Line 2483: , fnd_date.date_to_canonical(d_attribute10)

2479: , fnd_date.date_to_canonical(d_attribute6)
2480: , fnd_date.date_to_canonical(d_attribute7)
2481: , fnd_date.date_to_canonical(d_attribute8)
2482: , fnd_date.date_to_canonical(d_attribute9)
2483: , fnd_date.date_to_canonical(d_attribute10)
2484: , TO_CHAR(n_attribute1)
2485: , TO_CHAR(n_attribute2)
2486: , TO_CHAR(n_attribute3)
2487: , TO_CHAR(n_attribute4)

Line 2827: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);

2823: ELSE
2824: g_serial_attributes_tbl(1).column_value := NULL;
2825: END IF;
2826:
2827: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
2828: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
2829: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2830: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2831: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);

Line 2828: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);

2824: g_serial_attributes_tbl(1).column_value := NULL;
2825: END IF;
2826:
2827: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
2828: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
2829: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2830: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2831: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2832: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);

Line 2829: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);

2825: END IF;
2826:
2827: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
2828: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
2829: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2830: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2831: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2832: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2833: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);

Line 2830: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);

2826:
2827: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
2828: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
2829: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2830: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2831: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2832: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2833: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2834: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);

Line 2831: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);

2827: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
2828: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
2829: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2830: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2831: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2832: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2833: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2834: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2835: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);

Line 2832: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);

2828: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
2829: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2830: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2831: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2832: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2833: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2834: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2835: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
2836: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);

Line 2833: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);

2829: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2830: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2831: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2832: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2833: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2834: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2835: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
2836: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
2837: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);

Line 2834: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);

2830: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2831: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2832: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2833: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2834: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2835: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
2836: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
2837: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
2838: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);

Line 2835: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);

2831: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2832: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2833: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2834: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2835: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
2836: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
2837: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
2838: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);
2839: l_num34 := to_number(g_serial_attributes_tbl(34).COLUMN_VALUE);

Line 2836: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);

2832: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2833: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2834: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2835: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
2836: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
2837: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
2838: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);
2839: l_num34 := to_number(g_serial_attributes_tbl(34).COLUMN_VALUE);
2840: l_num35 := to_number(g_serial_attributes_tbl(35).COLUMN_VALUE);

Line 2837: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);

2833: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2834: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2835: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
2836: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
2837: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
2838: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);
2839: l_num34 := to_number(g_serial_attributes_tbl(34).COLUMN_VALUE);
2840: l_num35 := to_number(g_serial_attributes_tbl(35).COLUMN_VALUE);
2841: l_num36 := to_number(g_serial_attributes_tbl(36).COLUMN_VALUE);

Line 3927: fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(k).column_value)));

3923: IF (l_debug = 1) THEN
3924: invtrace('VALIDATE_UPDATE_SERIAL_ATT:set_column_value='||g_serial_attributes_tbl(k).column_value);
3925: END IF;
3926: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,
3927: fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(k).column_value)));
3928: END IF;
3929:
3930: IF g_serial_attributes_tbl(k).column_type = 'NUMBER' THEN
3931: IF (l_debug = 1) THEN

Line 4004: , origination_date = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(2).COLUMN_VALUE))

4000: IF l_validation_status = 'Y' THEN
4001: IF NOT p_validate_only THEN
4002: UPDATE mtl_serial_numbers
4003: SET serial_attribute_category = g_serial_attributes_tbl(1).COLUMN_VALUE
4004: , origination_date = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(2).COLUMN_VALUE))
4005: , c_attribute1 = g_serial_attributes_tbl(3).COLUMN_VALUE
4006: , c_attribute2 = g_serial_attributes_tbl(4).COLUMN_VALUE
4007: , c_attribute3 = g_serial_attributes_tbl(5).COLUMN_VALUE
4008: , c_attribute4 = g_serial_attributes_tbl(6).COLUMN_VALUE

Line 4025: , d_attribute1 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(23).COLUMN_VALUE))

4021: , c_attribute17 = g_serial_attributes_tbl(19).COLUMN_VALUE
4022: , c_attribute18 = g_serial_attributes_tbl(20).COLUMN_VALUE
4023: , c_attribute19 = g_serial_attributes_tbl(21).COLUMN_VALUE
4024: , c_attribute20 = g_serial_attributes_tbl(22).COLUMN_VALUE
4025: , d_attribute1 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(23).COLUMN_VALUE))
4026: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))
4027: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
4028: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
4029: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))

Line 4026: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))

4022: , c_attribute18 = g_serial_attributes_tbl(20).COLUMN_VALUE
4023: , c_attribute19 = g_serial_attributes_tbl(21).COLUMN_VALUE
4024: , c_attribute20 = g_serial_attributes_tbl(22).COLUMN_VALUE
4025: , d_attribute1 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(23).COLUMN_VALUE))
4026: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))
4027: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
4028: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
4029: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
4030: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))

Line 4027: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))

4023: , c_attribute19 = g_serial_attributes_tbl(21).COLUMN_VALUE
4024: , c_attribute20 = g_serial_attributes_tbl(22).COLUMN_VALUE
4025: , d_attribute1 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(23).COLUMN_VALUE))
4026: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))
4027: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
4028: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
4029: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
4030: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
4031: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))

Line 4028: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))

4024: , c_attribute20 = g_serial_attributes_tbl(22).COLUMN_VALUE
4025: , d_attribute1 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(23).COLUMN_VALUE))
4026: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))
4027: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
4028: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
4029: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
4030: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
4031: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
4032: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))

Line 4029: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))

4025: , d_attribute1 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(23).COLUMN_VALUE))
4026: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))
4027: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
4028: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
4029: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
4030: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
4031: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
4032: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))
4033: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))

Line 4030: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))

4026: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))
4027: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
4028: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
4029: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
4030: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
4031: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
4032: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))
4033: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))
4034: , d_attribute10 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(32).COLUMN_VALUE))

Line 4031: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))

4027: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
4028: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
4029: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
4030: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
4031: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
4032: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))
4033: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))
4034: , d_attribute10 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(32).COLUMN_VALUE))
4035: , n_attribute1 = to_number(g_serial_attributes_tbl(33).COLUMN_VALUE)

Line 4032: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))

4028: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
4029: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
4030: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
4031: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
4032: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))
4033: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))
4034: , d_attribute10 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(32).COLUMN_VALUE))
4035: , n_attribute1 = to_number(g_serial_attributes_tbl(33).COLUMN_VALUE)
4036: , n_attribute2 = to_number(g_serial_attributes_tbl(34).COLUMN_VALUE)

Line 4033: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))

4029: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
4030: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
4031: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
4032: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))
4033: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))
4034: , d_attribute10 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(32).COLUMN_VALUE))
4035: , n_attribute1 = to_number(g_serial_attributes_tbl(33).COLUMN_VALUE)
4036: , n_attribute2 = to_number(g_serial_attributes_tbl(34).COLUMN_VALUE)
4037: , n_attribute3 = to_number(g_serial_attributes_tbl(35).COLUMN_VALUE)

Line 4034: , d_attribute10 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(32).COLUMN_VALUE))

4030: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
4031: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
4032: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))
4033: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))
4034: , d_attribute10 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(32).COLUMN_VALUE))
4035: , n_attribute1 = to_number(g_serial_attributes_tbl(33).COLUMN_VALUE)
4036: , n_attribute2 = to_number(g_serial_attributes_tbl(34).COLUMN_VALUE)
4037: , n_attribute3 = to_number(g_serial_attributes_tbl(35).COLUMN_VALUE)
4038: , n_attribute4 = to_number(g_serial_attributes_tbl(36).COLUMN_VALUE)

Line 4342: invtrace('About to call fnd_date.canonical_to_date');

4338: end if;
4339: end if;
4340:
4341: IF (l_debug = 1) THEN
4342: invtrace('About to call fnd_date.canonical_to_date');
4343: --l_canonical_trx_date := fnd_date.canonical_to_date(p_trxdate);
4344: invtrace('After call fnd_date.canonical_to_date');
4345: END IF;
4346:

Line 4343: --l_canonical_trx_date := fnd_date.canonical_to_date(p_trxdate);

4339: end if;
4340:
4341: IF (l_debug = 1) THEN
4342: invtrace('About to call fnd_date.canonical_to_date');
4343: --l_canonical_trx_date := fnd_date.canonical_to_date(p_trxdate);
4344: invtrace('After call fnd_date.canonical_to_date');
4345: END IF;
4346:
4347: if( l_to_status in (1, 6) ) THEN

Line 4344: invtrace('After call fnd_date.canonical_to_date');

4340:
4341: IF (l_debug = 1) THEN
4342: invtrace('About to call fnd_date.canonical_to_date');
4343: --l_canonical_trx_date := fnd_date.canonical_to_date(p_trxdate);
4344: invtrace('After call fnd_date.canonical_to_date');
4345: END IF;
4346:
4347: if( l_to_status in (1, 6) ) THEN
4348: UPDATE MTL_SERIAL_NUMBERS MSN

Line 4415: --l_canonical_trx_date := fnd_date.canonical_to_date( p_trxdate );

4411:
4412: ELSE /* To status not in 1,6 */
4413:
4414: -- l_canonical_trx_date := NULL;
4415: --l_canonical_trx_date := fnd_date.canonical_to_date( p_trxdate );
4416: --dbms_output.put_line('tostatus not in 1, 6');
4417: IF (l_debug = 1) THEN
4418: invtrace( 'To Status not in 1,6');
4419: END IF;

Line 5227: , fnd_date.date_to_canonical(ORIGINATION_DATE )

5223: l_num42 NUMBER := NULL;
5224:
5225: cursor serial_temp_csr(p_transaction_temp_id NUMBER) is
5226: select SERIAL_ATTRIBUTE_CATEGORY
5227: , fnd_date.date_to_canonical(ORIGINATION_DATE )
5228: , C_ATTRIBUTE1
5229: , C_ATTRIBUTE2
5230: , C_ATTRIBUTE3
5231: , C_ATTRIBUTE4

Line 5248: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )

5244: , C_ATTRIBUTE17
5245: , C_ATTRIBUTE18
5246: , C_ATTRIBUTE19
5247: , C_ATTRIBUTE20
5248: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
5249: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
5250: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
5251: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
5252: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )

Line 5249: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )

5245: , C_ATTRIBUTE18
5246: , C_ATTRIBUTE19
5247: , C_ATTRIBUTE20
5248: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
5249: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
5250: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
5251: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
5252: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
5253: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )

Line 5250: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )

5246: , C_ATTRIBUTE19
5247: , C_ATTRIBUTE20
5248: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
5249: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
5250: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
5251: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
5252: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
5253: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
5254: , fnd_date.date_to_canonical(D_ATTRIBUTE7)

Line 5251: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )

5247: , C_ATTRIBUTE20
5248: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
5249: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
5250: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
5251: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
5252: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
5253: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
5254: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
5255: , fnd_date.date_to_canonical(D_ATTRIBUTE8)

Line 5252: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )

5248: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
5249: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
5250: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
5251: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
5252: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
5253: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
5254: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
5255: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
5256: , fnd_date.date_to_canonical( D_ATTRIBUTE9)

Line 5253: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )

5249: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
5250: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
5251: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
5252: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
5253: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
5254: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
5255: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
5256: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
5257: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )

Line 5254: , fnd_date.date_to_canonical(D_ATTRIBUTE7)

5250: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
5251: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
5252: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
5253: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
5254: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
5255: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
5256: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
5257: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
5258: , to_char(N_ATTRIBUTE1 )

Line 5255: , fnd_date.date_to_canonical(D_ATTRIBUTE8)

5251: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
5252: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
5253: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
5254: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
5255: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
5256: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
5257: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
5258: , to_char(N_ATTRIBUTE1 )
5259: , to_char(N_ATTRIBUTE2)

Line 5256: , fnd_date.date_to_canonical( D_ATTRIBUTE9)

5252: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
5253: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
5254: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
5255: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
5256: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
5257: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
5258: , to_char(N_ATTRIBUTE1 )
5259: , to_char(N_ATTRIBUTE2)
5260: , to_char(N_ATTRIBUTE3)

Line 5257: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )

5253: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
5254: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
5255: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
5256: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
5257: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
5258: , to_char(N_ATTRIBUTE1 )
5259: , to_char(N_ATTRIBUTE2)
5260: , to_char(N_ATTRIBUTE3)
5261: , to_char(N_ATTRIBUTE4)

Line 5659: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);

5655: ELSE
5656: g_serial_attributes_tbl(1).column_value := NULL;
5657: END IF;
5658:
5659: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
5660: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
5661: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5662: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5663: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);

Line 5660: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);

5656: g_serial_attributes_tbl(1).column_value := NULL;
5657: END IF;
5658:
5659: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
5660: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
5661: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5662: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5663: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5664: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);

Line 5661: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);

5657: END IF;
5658:
5659: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
5660: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
5661: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5662: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5663: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5664: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5665: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);

Line 5662: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);

5658:
5659: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
5660: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
5661: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5662: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5663: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5664: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5665: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5666: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);

Line 5663: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);

5659: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
5660: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
5661: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5662: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5663: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5664: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5665: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5666: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5667: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);

Line 5664: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);

5660: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
5661: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5662: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5663: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5664: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5665: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5666: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5667: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
5668: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);

Line 5665: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);

5661: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5662: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5663: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5664: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5665: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5666: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5667: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
5668: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
5669: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);

Line 5666: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);

5662: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5663: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5664: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5665: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5666: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5667: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
5668: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
5669: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
5670: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);

Line 5667: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);

5663: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5664: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5665: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5666: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5667: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
5668: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
5669: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
5670: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);
5671: l_num34 := to_number(g_serial_attributes_tbl(34).COLUMN_VALUE);

Line 5668: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);

5664: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5665: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5666: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5667: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
5668: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
5669: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
5670: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);
5671: l_num34 := to_number(g_serial_attributes_tbl(34).COLUMN_VALUE);
5672: l_num35 := to_number(g_serial_attributes_tbl(35).COLUMN_VALUE);

Line 5669: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);

5665: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5666: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5667: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
5668: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
5669: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
5670: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);
5671: l_num34 := to_number(g_serial_attributes_tbl(34).COLUMN_VALUE);
5672: l_num35 := to_number(g_serial_attributes_tbl(35).COLUMN_VALUE);
5673: l_num36 := to_number(g_serial_attributes_tbl(36).COLUMN_VALUE);