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 396: , fnd_date.date_to_canonical(origination_date)

392: l_wms_installed BOOLEAN;
393:
394: CURSOR serial_temp_csr(p_transaction_temp_id NUMBER) IS
395: SELECT serial_attribute_category
396: , fnd_date.date_to_canonical(origination_date)
397: , c_attribute1
398: , c_attribute2
399: , c_attribute3
400: , c_attribute4

Line 417: , fnd_date.date_to_canonical(d_attribute1)

413: , c_attribute17
414: , c_attribute18
415: , c_attribute19
416: , c_attribute20
417: , fnd_date.date_to_canonical(d_attribute1)
418: , fnd_date.date_to_canonical(d_attribute2)
419: , fnd_date.date_to_canonical(d_attribute3)
420: , fnd_date.date_to_canonical(d_attribute4)
421: , fnd_date.date_to_canonical(d_attribute5)

Line 418: , fnd_date.date_to_canonical(d_attribute2)

414: , c_attribute18
415: , c_attribute19
416: , c_attribute20
417: , fnd_date.date_to_canonical(d_attribute1)
418: , fnd_date.date_to_canonical(d_attribute2)
419: , fnd_date.date_to_canonical(d_attribute3)
420: , fnd_date.date_to_canonical(d_attribute4)
421: , fnd_date.date_to_canonical(d_attribute5)
422: , fnd_date.date_to_canonical(d_attribute6)

Line 419: , fnd_date.date_to_canonical(d_attribute3)

415: , c_attribute19
416: , c_attribute20
417: , fnd_date.date_to_canonical(d_attribute1)
418: , fnd_date.date_to_canonical(d_attribute2)
419: , fnd_date.date_to_canonical(d_attribute3)
420: , fnd_date.date_to_canonical(d_attribute4)
421: , fnd_date.date_to_canonical(d_attribute5)
422: , fnd_date.date_to_canonical(d_attribute6)
423: , fnd_date.date_to_canonical(d_attribute7)

Line 420: , fnd_date.date_to_canonical(d_attribute4)

416: , c_attribute20
417: , fnd_date.date_to_canonical(d_attribute1)
418: , fnd_date.date_to_canonical(d_attribute2)
419: , fnd_date.date_to_canonical(d_attribute3)
420: , fnd_date.date_to_canonical(d_attribute4)
421: , fnd_date.date_to_canonical(d_attribute5)
422: , fnd_date.date_to_canonical(d_attribute6)
423: , fnd_date.date_to_canonical(d_attribute7)
424: , fnd_date.date_to_canonical(d_attribute8)

Line 421: , fnd_date.date_to_canonical(d_attribute5)

417: , fnd_date.date_to_canonical(d_attribute1)
418: , fnd_date.date_to_canonical(d_attribute2)
419: , fnd_date.date_to_canonical(d_attribute3)
420: , fnd_date.date_to_canonical(d_attribute4)
421: , fnd_date.date_to_canonical(d_attribute5)
422: , fnd_date.date_to_canonical(d_attribute6)
423: , fnd_date.date_to_canonical(d_attribute7)
424: , fnd_date.date_to_canonical(d_attribute8)
425: , fnd_date.date_to_canonical(d_attribute9)

Line 422: , fnd_date.date_to_canonical(d_attribute6)

418: , fnd_date.date_to_canonical(d_attribute2)
419: , fnd_date.date_to_canonical(d_attribute3)
420: , fnd_date.date_to_canonical(d_attribute4)
421: , fnd_date.date_to_canonical(d_attribute5)
422: , fnd_date.date_to_canonical(d_attribute6)
423: , fnd_date.date_to_canonical(d_attribute7)
424: , fnd_date.date_to_canonical(d_attribute8)
425: , fnd_date.date_to_canonical(d_attribute9)
426: , fnd_date.date_to_canonical(d_attribute10)

Line 423: , fnd_date.date_to_canonical(d_attribute7)

419: , fnd_date.date_to_canonical(d_attribute3)
420: , fnd_date.date_to_canonical(d_attribute4)
421: , fnd_date.date_to_canonical(d_attribute5)
422: , fnd_date.date_to_canonical(d_attribute6)
423: , fnd_date.date_to_canonical(d_attribute7)
424: , fnd_date.date_to_canonical(d_attribute8)
425: , fnd_date.date_to_canonical(d_attribute9)
426: , fnd_date.date_to_canonical(d_attribute10)
427: , TO_CHAR(n_attribute1)

Line 424: , fnd_date.date_to_canonical(d_attribute8)

420: , fnd_date.date_to_canonical(d_attribute4)
421: , fnd_date.date_to_canonical(d_attribute5)
422: , fnd_date.date_to_canonical(d_attribute6)
423: , fnd_date.date_to_canonical(d_attribute7)
424: , fnd_date.date_to_canonical(d_attribute8)
425: , fnd_date.date_to_canonical(d_attribute9)
426: , fnd_date.date_to_canonical(d_attribute10)
427: , TO_CHAR(n_attribute1)
428: , TO_CHAR(n_attribute2)

Line 425: , fnd_date.date_to_canonical(d_attribute9)

421: , fnd_date.date_to_canonical(d_attribute5)
422: , fnd_date.date_to_canonical(d_attribute6)
423: , fnd_date.date_to_canonical(d_attribute7)
424: , fnd_date.date_to_canonical(d_attribute8)
425: , fnd_date.date_to_canonical(d_attribute9)
426: , fnd_date.date_to_canonical(d_attribute10)
427: , TO_CHAR(n_attribute1)
428: , TO_CHAR(n_attribute2)
429: , TO_CHAR(n_attribute3)

Line 426: , fnd_date.date_to_canonical(d_attribute10)

422: , fnd_date.date_to_canonical(d_attribute6)
423: , fnd_date.date_to_canonical(d_attribute7)
424: , fnd_date.date_to_canonical(d_attribute8)
425: , fnd_date.date_to_canonical(d_attribute9)
426: , fnd_date.date_to_canonical(d_attribute10)
427: , TO_CHAR(n_attribute1)
428: , TO_CHAR(n_attribute2)
429: , TO_CHAR(n_attribute3)
430: , TO_CHAR(n_attribute4)

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

1070: , NULL
1071: , NULL
1072: , x_object_id
1073: , g_serial_attributes_tbl(1).column_value
1074: , fnd_date.canonical_to_date(g_serial_attributes_tbl(2).column_value)
1075: , g_serial_attributes_tbl(3).column_value
1076: , g_serial_attributes_tbl(4).column_value
1077: , g_serial_attributes_tbl(5).column_value
1078: , g_serial_attributes_tbl(6).column_value

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

1091: , g_serial_attributes_tbl(19).column_value
1092: , g_serial_attributes_tbl(20).column_value
1093: , g_serial_attributes_tbl(21).column_value
1094: , g_serial_attributes_tbl(22).column_value
1095: , fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value)
1096: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)
1097: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1098: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1099: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)

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

1092: , g_serial_attributes_tbl(20).column_value
1093: , g_serial_attributes_tbl(21).column_value
1094: , g_serial_attributes_tbl(22).column_value
1095: , fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value)
1096: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)
1097: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1098: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1099: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1100: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)

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

1093: , g_serial_attributes_tbl(21).column_value
1094: , g_serial_attributes_tbl(22).column_value
1095: , fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value)
1096: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)
1097: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1098: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1099: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1100: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1101: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)

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

1094: , g_serial_attributes_tbl(22).column_value
1095: , fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value)
1096: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)
1097: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1098: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1099: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1100: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1101: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1102: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)

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

1095: , fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value)
1096: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)
1097: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1098: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1099: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1100: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1101: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1102: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)
1103: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)

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

1096: , fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value)
1097: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1098: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1099: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1100: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1101: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1102: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)
1103: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)
1104: , fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value)

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

1097: , fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value)
1098: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1099: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1100: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1101: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1102: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)
1103: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)
1104: , fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value)
1105: , TO_NUMBER(g_serial_attributes_tbl(33).column_value)

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

1098: , fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value)
1099: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1100: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1101: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1102: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)
1103: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)
1104: , fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value)
1105: , TO_NUMBER(g_serial_attributes_tbl(33).column_value)
1106: , TO_NUMBER(g_serial_attributes_tbl(34).column_value)

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

1099: , fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value)
1100: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1101: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1102: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)
1103: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)
1104: , fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value)
1105: , TO_NUMBER(g_serial_attributes_tbl(33).column_value)
1106: , TO_NUMBER(g_serial_attributes_tbl(34).column_value)
1107: , TO_NUMBER(g_serial_attributes_tbl(35).column_value)

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

1100: , fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value)
1101: , fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value)
1102: , fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value)
1103: , fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value)
1104: , fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value)
1105: , TO_NUMBER(g_serial_attributes_tbl(33).column_value)
1106: , TO_NUMBER(g_serial_attributes_tbl(34).column_value)
1107: , TO_NUMBER(g_serial_attributes_tbl(35).column_value)
1108: , TO_NUMBER(g_serial_attributes_tbl(36).column_value)

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

1165: -- invtrace('lot_linemark_id is NULL');
1166: -- invtrace('end item unit number is NULL');
1167: -- invtrace('gen_object_id is ' ||x_object_id);
1168: -- invtrace('serial attribute category is ' || g_serial_attributes_tbl(1).column_value);
1169: -- invtrace('origination date is ' || fnd_date.canonical_to_date(g_serial_attributes_tbl(2).column_value));
1170: -- invtrace('c_attribute1 '|| g_serial_attributes_tbl(3).column_value);
1171: -- invtrace('cattribute2 ' || g_serial_attributes_tbl(4).column_value);
1172: -- invtrace('cattribute3 ' ||g_serial_attributes_tbl(5).column_value);
1173: -- invtrace('cattribute4 ' ||g_serial_attributes_tbl(6).column_value);

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

1186: -- invtrace('cattribute17 ' ||g_serial_attributes_tbl(19).column_value);
1187: -- invtrace('cattribute18 ' ||g_serial_attributes_tbl(20).column_value);
1188: -- invtrace('cattribute19 ' ||g_serial_attributes_tbl(21).column_value);
1189: -- invtrace('cattribute20 ' ||g_serial_attributes_tbl(22).column_value);
1190: -- invtrace('dattribute1 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value));
1191: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));
1192: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1193: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1194: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));

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

1187: -- invtrace('cattribute18 ' ||g_serial_attributes_tbl(20).column_value);
1188: -- invtrace('cattribute19 ' ||g_serial_attributes_tbl(21).column_value);
1189: -- invtrace('cattribute20 ' ||g_serial_attributes_tbl(22).column_value);
1190: -- invtrace('dattribute1 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value));
1191: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));
1192: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1193: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1194: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1195: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));

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

1188: -- invtrace('cattribute19 ' ||g_serial_attributes_tbl(21).column_value);
1189: -- invtrace('cattribute20 ' ||g_serial_attributes_tbl(22).column_value);
1190: -- invtrace('dattribute1 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value));
1191: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));
1192: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1193: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1194: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1195: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1196: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));

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

1189: -- invtrace('cattribute20 ' ||g_serial_attributes_tbl(22).column_value);
1190: -- invtrace('dattribute1 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value));
1191: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));
1192: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1193: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1194: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1195: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1196: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1197: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));

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

1190: -- invtrace('dattribute1 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(23).column_value));
1191: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));
1192: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1193: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1194: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1195: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1196: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1197: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));
1198: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));

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

1191: -- invtrace('dattribute2 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(24).column_value));
1192: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1193: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1194: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1195: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1196: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1197: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));
1198: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));
1199: -- invtrace('dattribute10 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value));

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

1192: -- invtrace('dattribute3 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(25).column_value));
1193: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1194: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1195: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1196: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1197: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));
1198: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));
1199: -- invtrace('dattribute10 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value));
1200: -- invtrace('nattribute1 ' ||TO_NUMBER(g_serial_attributes_tbl(33).column_value));

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

1193: -- invtrace('dattribute4 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(26).column_value));
1194: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1195: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1196: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1197: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));
1198: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));
1199: -- invtrace('dattribute10 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value));
1200: -- invtrace('nattribute1 ' ||TO_NUMBER(g_serial_attributes_tbl(33).column_value));
1201: -- invtrace('nattribute2 ' ||TO_NUMBER(g_serial_attributes_tbl(34).column_value));

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

1194: -- invtrace('dattribute5 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(27).column_value));
1195: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1196: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1197: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));
1198: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));
1199: -- invtrace('dattribute10 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value));
1200: -- invtrace('nattribute1 ' ||TO_NUMBER(g_serial_attributes_tbl(33).column_value));
1201: -- invtrace('nattribute2 ' ||TO_NUMBER(g_serial_attributes_tbl(34).column_value));
1202: -- invtrace('nattribute3 ' ||TO_NUMBER(g_serial_attributes_tbl(35).column_value));

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

1195: -- invtrace('dattribute6 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(28).column_value));
1196: -- invtrace('dattribute7 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(29).column_value));
1197: -- invtrace('dattribute8 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(30).column_value));
1198: -- invtrace('dattribute9 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(31).column_value));
1199: -- invtrace('dattribute10 ' ||fnd_date.canonical_to_date(g_serial_attributes_tbl(32).column_value));
1200: -- invtrace('nattribute1 ' ||TO_NUMBER(g_serial_attributes_tbl(33).column_value));
1201: -- invtrace('nattribute2 ' ||TO_NUMBER(g_serial_attributes_tbl(34).column_value));
1202: -- invtrace('nattribute3 ' ||TO_NUMBER(g_serial_attributes_tbl(35).column_value));
1203: -- invtrace('nattribute4 ' ||TO_NUMBER(g_serial_attributes_tbl(36).column_value));

Line 2122: , fnd_date.date_to_canonical(origination_date)

2118: l_num42 NUMBER := NULL;
2119:
2120: CURSOR serial_temp_csr(p_transaction_temp_id NUMBER) IS
2121: SELECT serial_attribute_category
2122: , fnd_date.date_to_canonical(origination_date)
2123: , c_attribute1
2124: , c_attribute2
2125: , c_attribute3
2126: , c_attribute4

Line 2143: , fnd_date.date_to_canonical(d_attribute1)

2139: , c_attribute17
2140: , c_attribute18
2141: , c_attribute19
2142: , c_attribute20
2143: , fnd_date.date_to_canonical(d_attribute1)
2144: , fnd_date.date_to_canonical(d_attribute2)
2145: , fnd_date.date_to_canonical(d_attribute3)
2146: , fnd_date.date_to_canonical(d_attribute4)
2147: , fnd_date.date_to_canonical(d_attribute5)

Line 2144: , fnd_date.date_to_canonical(d_attribute2)

2140: , c_attribute18
2141: , c_attribute19
2142: , c_attribute20
2143: , fnd_date.date_to_canonical(d_attribute1)
2144: , fnd_date.date_to_canonical(d_attribute2)
2145: , fnd_date.date_to_canonical(d_attribute3)
2146: , fnd_date.date_to_canonical(d_attribute4)
2147: , fnd_date.date_to_canonical(d_attribute5)
2148: , fnd_date.date_to_canonical(d_attribute6)

Line 2145: , fnd_date.date_to_canonical(d_attribute3)

2141: , c_attribute19
2142: , c_attribute20
2143: , fnd_date.date_to_canonical(d_attribute1)
2144: , fnd_date.date_to_canonical(d_attribute2)
2145: , fnd_date.date_to_canonical(d_attribute3)
2146: , fnd_date.date_to_canonical(d_attribute4)
2147: , fnd_date.date_to_canonical(d_attribute5)
2148: , fnd_date.date_to_canonical(d_attribute6)
2149: , fnd_date.date_to_canonical(d_attribute7)

Line 2146: , fnd_date.date_to_canonical(d_attribute4)

2142: , c_attribute20
2143: , fnd_date.date_to_canonical(d_attribute1)
2144: , fnd_date.date_to_canonical(d_attribute2)
2145: , fnd_date.date_to_canonical(d_attribute3)
2146: , fnd_date.date_to_canonical(d_attribute4)
2147: , fnd_date.date_to_canonical(d_attribute5)
2148: , fnd_date.date_to_canonical(d_attribute6)
2149: , fnd_date.date_to_canonical(d_attribute7)
2150: , fnd_date.date_to_canonical(d_attribute8)

Line 2147: , fnd_date.date_to_canonical(d_attribute5)

2143: , fnd_date.date_to_canonical(d_attribute1)
2144: , fnd_date.date_to_canonical(d_attribute2)
2145: , fnd_date.date_to_canonical(d_attribute3)
2146: , fnd_date.date_to_canonical(d_attribute4)
2147: , fnd_date.date_to_canonical(d_attribute5)
2148: , fnd_date.date_to_canonical(d_attribute6)
2149: , fnd_date.date_to_canonical(d_attribute7)
2150: , fnd_date.date_to_canonical(d_attribute8)
2151: , fnd_date.date_to_canonical(d_attribute9)

Line 2148: , fnd_date.date_to_canonical(d_attribute6)

2144: , fnd_date.date_to_canonical(d_attribute2)
2145: , fnd_date.date_to_canonical(d_attribute3)
2146: , fnd_date.date_to_canonical(d_attribute4)
2147: , fnd_date.date_to_canonical(d_attribute5)
2148: , fnd_date.date_to_canonical(d_attribute6)
2149: , fnd_date.date_to_canonical(d_attribute7)
2150: , fnd_date.date_to_canonical(d_attribute8)
2151: , fnd_date.date_to_canonical(d_attribute9)
2152: , fnd_date.date_to_canonical(d_attribute10)

Line 2149: , fnd_date.date_to_canonical(d_attribute7)

2145: , fnd_date.date_to_canonical(d_attribute3)
2146: , fnd_date.date_to_canonical(d_attribute4)
2147: , fnd_date.date_to_canonical(d_attribute5)
2148: , fnd_date.date_to_canonical(d_attribute6)
2149: , fnd_date.date_to_canonical(d_attribute7)
2150: , fnd_date.date_to_canonical(d_attribute8)
2151: , fnd_date.date_to_canonical(d_attribute9)
2152: , fnd_date.date_to_canonical(d_attribute10)
2153: , TO_CHAR(n_attribute1)

Line 2150: , fnd_date.date_to_canonical(d_attribute8)

2146: , fnd_date.date_to_canonical(d_attribute4)
2147: , fnd_date.date_to_canonical(d_attribute5)
2148: , fnd_date.date_to_canonical(d_attribute6)
2149: , fnd_date.date_to_canonical(d_attribute7)
2150: , fnd_date.date_to_canonical(d_attribute8)
2151: , fnd_date.date_to_canonical(d_attribute9)
2152: , fnd_date.date_to_canonical(d_attribute10)
2153: , TO_CHAR(n_attribute1)
2154: , TO_CHAR(n_attribute2)

Line 2151: , fnd_date.date_to_canonical(d_attribute9)

2147: , fnd_date.date_to_canonical(d_attribute5)
2148: , fnd_date.date_to_canonical(d_attribute6)
2149: , fnd_date.date_to_canonical(d_attribute7)
2150: , fnd_date.date_to_canonical(d_attribute8)
2151: , fnd_date.date_to_canonical(d_attribute9)
2152: , fnd_date.date_to_canonical(d_attribute10)
2153: , TO_CHAR(n_attribute1)
2154: , TO_CHAR(n_attribute2)
2155: , TO_CHAR(n_attribute3)

Line 2152: , fnd_date.date_to_canonical(d_attribute10)

2148: , fnd_date.date_to_canonical(d_attribute6)
2149: , fnd_date.date_to_canonical(d_attribute7)
2150: , fnd_date.date_to_canonical(d_attribute8)
2151: , fnd_date.date_to_canonical(d_attribute9)
2152: , fnd_date.date_to_canonical(d_attribute10)
2153: , TO_CHAR(n_attribute1)
2154: , TO_CHAR(n_attribute2)
2155: , TO_CHAR(n_attribute3)
2156: , TO_CHAR(n_attribute4)

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

2492: ELSE
2493: g_serial_attributes_tbl(1).column_value := NULL;
2494: END IF;
2495:
2496: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
2497: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
2498: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2499: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2500: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);

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

2493: g_serial_attributes_tbl(1).column_value := NULL;
2494: END IF;
2495:
2496: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
2497: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
2498: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2499: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2500: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2501: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);

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

2494: END IF;
2495:
2496: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
2497: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
2498: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2499: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2500: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2501: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2502: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);

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

2495:
2496: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
2497: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
2498: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2499: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2500: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2501: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2502: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2503: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);

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

2496: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
2497: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
2498: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2499: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2500: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2501: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2502: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2503: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2504: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);

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

2497: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
2498: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2499: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2500: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2501: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2502: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2503: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2504: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
2505: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);

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

2498: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
2499: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2500: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2501: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2502: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2503: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2504: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
2505: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
2506: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);

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

2499: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
2500: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2501: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2502: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2503: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2504: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
2505: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
2506: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
2507: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);

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

2500: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
2501: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2502: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2503: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2504: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
2505: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
2506: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
2507: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);
2508: l_num34 := to_number(g_serial_attributes_tbl(34).COLUMN_VALUE);

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

2501: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
2502: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2503: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2504: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
2505: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
2506: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
2507: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);
2508: l_num34 := to_number(g_serial_attributes_tbl(34).COLUMN_VALUE);
2509: l_num35 := to_number(g_serial_attributes_tbl(35).COLUMN_VALUE);

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

2502: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
2503: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
2504: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
2505: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
2506: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
2507: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);
2508: l_num34 := to_number(g_serial_attributes_tbl(34).COLUMN_VALUE);
2509: l_num35 := to_number(g_serial_attributes_tbl(35).COLUMN_VALUE);
2510: l_num36 := to_number(g_serial_attributes_tbl(36).COLUMN_VALUE);

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

3558: IF (l_debug = 1) THEN
3559: invtrace('VALIDATE_UPDATE_SERIAL_ATT:set_column_value='||g_serial_attributes_tbl(k).column_value);
3560: END IF;
3561: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,
3562: fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(k).column_value)));
3563: END IF;
3564:
3565: IF g_serial_attributes_tbl(k).column_type = 'NUMBER' THEN
3566: IF (l_debug = 1) THEN

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

3635: IF l_validation_status = 'Y' THEN
3636: IF NOT p_validate_only THEN
3637: UPDATE mtl_serial_numbers
3638: SET serial_attribute_category = g_serial_attributes_tbl(1).COLUMN_VALUE
3639: , origination_date = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(2).COLUMN_VALUE))
3640: , c_attribute1 = g_serial_attributes_tbl(3).COLUMN_VALUE
3641: , c_attribute2 = g_serial_attributes_tbl(4).COLUMN_VALUE
3642: , c_attribute3 = g_serial_attributes_tbl(5).COLUMN_VALUE
3643: , c_attribute4 = g_serial_attributes_tbl(6).COLUMN_VALUE

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

3656: , c_attribute17 = g_serial_attributes_tbl(19).COLUMN_VALUE
3657: , c_attribute18 = g_serial_attributes_tbl(20).COLUMN_VALUE
3658: , c_attribute19 = g_serial_attributes_tbl(21).COLUMN_VALUE
3659: , c_attribute20 = g_serial_attributes_tbl(22).COLUMN_VALUE
3660: , d_attribute1 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(23).COLUMN_VALUE))
3661: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))
3662: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
3663: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
3664: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))

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

3657: , c_attribute18 = g_serial_attributes_tbl(20).COLUMN_VALUE
3658: , c_attribute19 = g_serial_attributes_tbl(21).COLUMN_VALUE
3659: , c_attribute20 = g_serial_attributes_tbl(22).COLUMN_VALUE
3660: , d_attribute1 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(23).COLUMN_VALUE))
3661: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))
3662: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
3663: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
3664: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
3665: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))

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

3658: , c_attribute19 = g_serial_attributes_tbl(21).COLUMN_VALUE
3659: , c_attribute20 = g_serial_attributes_tbl(22).COLUMN_VALUE
3660: , d_attribute1 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(23).COLUMN_VALUE))
3661: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))
3662: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
3663: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
3664: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
3665: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
3666: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))

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

3659: , c_attribute20 = g_serial_attributes_tbl(22).COLUMN_VALUE
3660: , d_attribute1 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(23).COLUMN_VALUE))
3661: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))
3662: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
3663: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
3664: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
3665: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
3666: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
3667: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))

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

3660: , d_attribute1 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(23).COLUMN_VALUE))
3661: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))
3662: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
3663: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
3664: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
3665: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
3666: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
3667: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))
3668: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))

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

3661: , d_attribute2 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(24).COLUMN_VALUE))
3662: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
3663: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
3664: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
3665: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
3666: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
3667: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))
3668: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))
3669: , d_attribute10 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(32).COLUMN_VALUE))

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

3662: , d_attribute3 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(25).COLUMN_VALUE))
3663: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
3664: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
3665: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
3666: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
3667: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))
3668: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))
3669: , d_attribute10 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(32).COLUMN_VALUE))
3670: , n_attribute1 = to_number(g_serial_attributes_tbl(33).COLUMN_VALUE)

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

3663: , d_attribute4 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(26).COLUMN_VALUE))
3664: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
3665: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
3666: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
3667: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))
3668: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))
3669: , d_attribute10 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(32).COLUMN_VALUE))
3670: , n_attribute1 = to_number(g_serial_attributes_tbl(33).COLUMN_VALUE)
3671: , n_attribute2 = to_number(g_serial_attributes_tbl(34).COLUMN_VALUE)

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

3664: , d_attribute5 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(27).COLUMN_VALUE))
3665: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
3666: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
3667: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))
3668: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))
3669: , d_attribute10 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(32).COLUMN_VALUE))
3670: , n_attribute1 = to_number(g_serial_attributes_tbl(33).COLUMN_VALUE)
3671: , n_attribute2 = to_number(g_serial_attributes_tbl(34).COLUMN_VALUE)
3672: , n_attribute3 = to_number(g_serial_attributes_tbl(35).COLUMN_VALUE)

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

3665: , d_attribute6 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(28).COLUMN_VALUE))
3666: , d_attribute7 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(29).COLUMN_VALUE))
3667: , d_attribute8 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(30).COLUMN_VALUE))
3668: , d_attribute9 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(31).COLUMN_VALUE))
3669: , d_attribute10 = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(32).COLUMN_VALUE))
3670: , n_attribute1 = to_number(g_serial_attributes_tbl(33).COLUMN_VALUE)
3671: , n_attribute2 = to_number(g_serial_attributes_tbl(34).COLUMN_VALUE)
3672: , n_attribute3 = to_number(g_serial_attributes_tbl(35).COLUMN_VALUE)
3673: , n_attribute4 = to_number(g_serial_attributes_tbl(36).COLUMN_VALUE)

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

3955: end if;
3956: end if;
3957:
3958: IF (l_debug = 1) THEN
3959: invtrace('About to call fnd_date.canonical_to_date');
3960: --l_canonical_trx_date := fnd_date.canonical_to_date(p_trxdate);
3961: invtrace('After call fnd_date.canonical_to_date');
3962: END IF;
3963:

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

3956: end if;
3957:
3958: IF (l_debug = 1) THEN
3959: invtrace('About to call fnd_date.canonical_to_date');
3960: --l_canonical_trx_date := fnd_date.canonical_to_date(p_trxdate);
3961: invtrace('After call fnd_date.canonical_to_date');
3962: END IF;
3963:
3964: if( l_to_status in (1, 6) ) THEN

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

3957:
3958: IF (l_debug = 1) THEN
3959: invtrace('About to call fnd_date.canonical_to_date');
3960: --l_canonical_trx_date := fnd_date.canonical_to_date(p_trxdate);
3961: invtrace('After call fnd_date.canonical_to_date');
3962: END IF;
3963:
3964: if( l_to_status in (1, 6) ) THEN
3965: UPDATE MTL_SERIAL_NUMBERS MSN

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

4026:
4027: ELSE /* To status not in 1,6 */
4028:
4029: -- l_canonical_trx_date := NULL;
4030: --l_canonical_trx_date := fnd_date.canonical_to_date( p_trxdate );
4031: --dbms_output.put_line('tostatus not in 1, 6');
4032: IF (l_debug = 1) THEN
4033: invtrace( 'To Status not in 1,6');
4034: END IF;

Line 4840: , fnd_date.date_to_canonical(ORIGINATION_DATE )

4836: l_num42 NUMBER := NULL;
4837:
4838: cursor serial_temp_csr(p_transaction_temp_id NUMBER) is
4839: select SERIAL_ATTRIBUTE_CATEGORY
4840: , fnd_date.date_to_canonical(ORIGINATION_DATE )
4841: , C_ATTRIBUTE1
4842: , C_ATTRIBUTE2
4843: , C_ATTRIBUTE3
4844: , C_ATTRIBUTE4

Line 4861: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )

4857: , C_ATTRIBUTE17
4858: , C_ATTRIBUTE18
4859: , C_ATTRIBUTE19
4860: , C_ATTRIBUTE20
4861: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
4862: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
4863: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
4864: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
4865: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )

Line 4862: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )

4858: , C_ATTRIBUTE18
4859: , C_ATTRIBUTE19
4860: , C_ATTRIBUTE20
4861: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
4862: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
4863: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
4864: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
4865: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
4866: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )

Line 4863: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )

4859: , C_ATTRIBUTE19
4860: , C_ATTRIBUTE20
4861: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
4862: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
4863: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
4864: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
4865: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
4866: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
4867: , fnd_date.date_to_canonical(D_ATTRIBUTE7)

Line 4864: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )

4860: , C_ATTRIBUTE20
4861: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
4862: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
4863: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
4864: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
4865: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
4866: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
4867: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
4868: , fnd_date.date_to_canonical(D_ATTRIBUTE8)

Line 4865: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )

4861: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
4862: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
4863: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
4864: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
4865: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
4866: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
4867: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
4868: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
4869: , fnd_date.date_to_canonical( D_ATTRIBUTE9)

Line 4866: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )

4862: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
4863: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
4864: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
4865: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
4866: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
4867: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
4868: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
4869: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
4870: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )

Line 4867: , fnd_date.date_to_canonical(D_ATTRIBUTE7)

4863: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
4864: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
4865: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
4866: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
4867: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
4868: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
4869: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
4870: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
4871: , to_char(N_ATTRIBUTE1 )

Line 4868: , fnd_date.date_to_canonical(D_ATTRIBUTE8)

4864: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
4865: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
4866: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
4867: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
4868: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
4869: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
4870: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
4871: , to_char(N_ATTRIBUTE1 )
4872: , to_char(N_ATTRIBUTE2)

Line 4869: , fnd_date.date_to_canonical( D_ATTRIBUTE9)

4865: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
4866: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
4867: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
4868: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
4869: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
4870: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
4871: , to_char(N_ATTRIBUTE1 )
4872: , to_char(N_ATTRIBUTE2)
4873: , to_char(N_ATTRIBUTE3)

Line 4870: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )

4866: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
4867: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
4868: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
4869: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
4870: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
4871: , to_char(N_ATTRIBUTE1 )
4872: , to_char(N_ATTRIBUTE2)
4873: , to_char(N_ATTRIBUTE3)
4874: , to_char(N_ATTRIBUTE4)

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

5268: ELSE
5269: g_serial_attributes_tbl(1).column_value := NULL;
5270: END IF;
5271:
5272: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
5273: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
5274: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5275: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5276: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);

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

5269: g_serial_attributes_tbl(1).column_value := NULL;
5270: END IF;
5271:
5272: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
5273: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
5274: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5275: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5276: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5277: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);

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

5270: END IF;
5271:
5272: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
5273: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
5274: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5275: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5276: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5277: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5278: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);

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

5271:
5272: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
5273: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
5274: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5275: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5276: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5277: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5278: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5279: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);

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

5272: l_date2 := fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE);
5273: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
5274: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5275: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5276: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5277: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5278: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5279: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5280: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);

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

5273: l_date23 := fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE);
5274: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5275: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5276: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5277: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5278: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5279: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5280: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
5281: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);

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

5274: l_date24 := fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE);
5275: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5276: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5277: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5278: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5279: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5280: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
5281: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
5282: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);

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

5275: l_date25 := fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE);
5276: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5277: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5278: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5279: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5280: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
5281: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
5282: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
5283: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);

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

5276: l_date26 := fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE);
5277: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5278: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5279: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5280: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
5281: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
5282: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
5283: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);
5284: l_num34 := to_number(g_serial_attributes_tbl(34).COLUMN_VALUE);

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

5277: l_date27 := fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE);
5278: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5279: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5280: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
5281: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
5282: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
5283: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);
5284: l_num34 := to_number(g_serial_attributes_tbl(34).COLUMN_VALUE);
5285: l_num35 := to_number(g_serial_attributes_tbl(35).COLUMN_VALUE);

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

5278: l_date28 := fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE);
5279: l_date29 := fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE);
5280: l_date30 := fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE);
5281: l_date31 := fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE);
5282: l_date32 := fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE);
5283: l_num33 := to_number(g_serial_attributes_tbl(33).COLUMN_VALUE);
5284: l_num34 := to_number(g_serial_attributes_tbl(34).COLUMN_VALUE);
5285: l_num35 := to_number(g_serial_attributes_tbl(35).COLUMN_VALUE);
5286: l_num36 := to_number(g_serial_attributes_tbl(36).COLUMN_VALUE);