252:
253:
254: CURSOR c_lot_cursor IS
255: select GRADE_CODE
256: , fnd_date.date_to_canonical(ORIGINATION_DATE)
257: , DATE_CODE
258: , to_char(STATUS_ID)
259: , fnd_date.date_to_canonical(CHANGE_DATE)
260: , to_number(AGE)
255: select GRADE_CODE
256: , fnd_date.date_to_canonical(ORIGINATION_DATE)
257: , DATE_CODE
258: , to_char(STATUS_ID)
259: , fnd_date.date_to_canonical(CHANGE_DATE)
260: , to_number(AGE)
261: , fnd_date.date_to_canonical(RETEST_DATE)
262: , fnd_date.date_to_canonical(MATURITY_DATE)
263: , LOT_ATTRIBUTE_CATEGORY
257: , DATE_CODE
258: , to_char(STATUS_ID)
259: , fnd_date.date_to_canonical(CHANGE_DATE)
260: , to_number(AGE)
261: , fnd_date.date_to_canonical(RETEST_DATE)
262: , fnd_date.date_to_canonical(MATURITY_DATE)
263: , LOT_ATTRIBUTE_CATEGORY
264: , to_char(ITEM_SIZE)
265: , COLOR
258: , to_char(STATUS_ID)
259: , fnd_date.date_to_canonical(CHANGE_DATE)
260: , to_number(AGE)
261: , fnd_date.date_to_canonical(RETEST_DATE)
262: , fnd_date.date_to_canonical(MATURITY_DATE)
263: , LOT_ATTRIBUTE_CATEGORY
264: , to_char(ITEM_SIZE)
265: , COLOR
266: , to_char(VOLUME )
265: , COLOR
266: , to_char(VOLUME )
267: , VOLUME_UOM_CODE
268: , PLACE_OF_ORIGIN
269: , fnd_date.date_to_canonical(BEST_BY_DATE )
270: , to_char(LENGTH )
271: , LENGTH_UOM_CODE
272: , to_char(RECYCLED_CONTENT )
273: , to_char(THICKNESS )
294: , C_ATTRIBUTE17
295: , C_ATTRIBUTE18
296: , C_ATTRIBUTE19
297: , C_ATTRIBUTE20
298: , fnd_date.date_to_canonical(D_ATTRIBUTE1)
299: , fnd_date.date_to_canonical(D_ATTRIBUTE2)
300: , fnd_date.date_to_canonical(D_ATTRIBUTE3)
301: , fnd_date.date_to_canonical(D_ATTRIBUTE4)
302: , fnd_date.date_to_canonical(D_ATTRIBUTE5)
295: , C_ATTRIBUTE18
296: , C_ATTRIBUTE19
297: , C_ATTRIBUTE20
298: , fnd_date.date_to_canonical(D_ATTRIBUTE1)
299: , fnd_date.date_to_canonical(D_ATTRIBUTE2)
300: , fnd_date.date_to_canonical(D_ATTRIBUTE3)
301: , fnd_date.date_to_canonical(D_ATTRIBUTE4)
302: , fnd_date.date_to_canonical(D_ATTRIBUTE5)
303: , fnd_date.date_to_canonical(D_ATTRIBUTE6)
296: , C_ATTRIBUTE19
297: , C_ATTRIBUTE20
298: , fnd_date.date_to_canonical(D_ATTRIBUTE1)
299: , fnd_date.date_to_canonical(D_ATTRIBUTE2)
300: , fnd_date.date_to_canonical(D_ATTRIBUTE3)
301: , fnd_date.date_to_canonical(D_ATTRIBUTE4)
302: , fnd_date.date_to_canonical(D_ATTRIBUTE5)
303: , fnd_date.date_to_canonical(D_ATTRIBUTE6)
304: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
297: , C_ATTRIBUTE20
298: , fnd_date.date_to_canonical(D_ATTRIBUTE1)
299: , fnd_date.date_to_canonical(D_ATTRIBUTE2)
300: , fnd_date.date_to_canonical(D_ATTRIBUTE3)
301: , fnd_date.date_to_canonical(D_ATTRIBUTE4)
302: , fnd_date.date_to_canonical(D_ATTRIBUTE5)
303: , fnd_date.date_to_canonical(D_ATTRIBUTE6)
304: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
305: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
298: , fnd_date.date_to_canonical(D_ATTRIBUTE1)
299: , fnd_date.date_to_canonical(D_ATTRIBUTE2)
300: , fnd_date.date_to_canonical(D_ATTRIBUTE3)
301: , fnd_date.date_to_canonical(D_ATTRIBUTE4)
302: , fnd_date.date_to_canonical(D_ATTRIBUTE5)
303: , fnd_date.date_to_canonical(D_ATTRIBUTE6)
304: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
305: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
306: , fnd_date.date_to_canonical(D_ATTRIBUTE9)
299: , fnd_date.date_to_canonical(D_ATTRIBUTE2)
300: , fnd_date.date_to_canonical(D_ATTRIBUTE3)
301: , fnd_date.date_to_canonical(D_ATTRIBUTE4)
302: , fnd_date.date_to_canonical(D_ATTRIBUTE5)
303: , fnd_date.date_to_canonical(D_ATTRIBUTE6)
304: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
305: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
306: , fnd_date.date_to_canonical(D_ATTRIBUTE9)
307: , fnd_date.date_to_canonical(D_ATTRIBUTE10)
300: , fnd_date.date_to_canonical(D_ATTRIBUTE3)
301: , fnd_date.date_to_canonical(D_ATTRIBUTE4)
302: , fnd_date.date_to_canonical(D_ATTRIBUTE5)
303: , fnd_date.date_to_canonical(D_ATTRIBUTE6)
304: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
305: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
306: , fnd_date.date_to_canonical(D_ATTRIBUTE9)
307: , fnd_date.date_to_canonical(D_ATTRIBUTE10)
308: , to_char(N_ATTRIBUTE1)
301: , fnd_date.date_to_canonical(D_ATTRIBUTE4)
302: , fnd_date.date_to_canonical(D_ATTRIBUTE5)
303: , fnd_date.date_to_canonical(D_ATTRIBUTE6)
304: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
305: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
306: , fnd_date.date_to_canonical(D_ATTRIBUTE9)
307: , fnd_date.date_to_canonical(D_ATTRIBUTE10)
308: , to_char(N_ATTRIBUTE1)
309: , to_char(N_ATTRIBUTE2)
302: , fnd_date.date_to_canonical(D_ATTRIBUTE5)
303: , fnd_date.date_to_canonical(D_ATTRIBUTE6)
304: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
305: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
306: , fnd_date.date_to_canonical(D_ATTRIBUTE9)
307: , fnd_date.date_to_canonical(D_ATTRIBUTE10)
308: , to_char(N_ATTRIBUTE1)
309: , to_char(N_ATTRIBUTE2)
310: , to_char(N_ATTRIBUTE3)
303: , fnd_date.date_to_canonical(D_ATTRIBUTE6)
304: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
305: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
306: , fnd_date.date_to_canonical(D_ATTRIBUTE9)
307: , fnd_date.date_to_canonical(D_ATTRIBUTE10)
308: , to_char(N_ATTRIBUTE1)
309: , to_char(N_ATTRIBUTE2)
310: , to_char(N_ATTRIBUTE3)
311: , to_char(N_ATTRIBUTE4)
779: IF (l_debug = 1) THEN
780: print_debug('Setting the columns for validation -- Date' , 4);
781: END IF;
782: fnd_flex_descval.set_column_value(g_lot_attributes_tbl(k).column_name,
783: fnd_date.canonical_to_date(g_lot_attributes_tbl(k).column_value));
784: end if;
785:
786: if g_lot_attributes_tbl(k).column_type = 'NUMBER' then
787: IF (l_debug = 1) THEN
996: l_object_id,
997: null,
998: to_number(null), -- Vendor ID currently Set as Null
999: g_lot_attributes_tbl(1).COLUMN_VALUE,
1000: fnd_date.canonical_to_date(g_lot_attributes_tbl(2).COLUMN_VALUE),
1001: g_lot_attributes_tbl(3).COLUMN_VALUE,
1002: to_number(g_lot_attributes_tbl(4).COLUMN_VALUE),
1003: fnd_date.canonical_to_date(g_lot_attributes_tbl(5).COLUMN_VALUE),
1004: to_number(g_lot_attributes_tbl(6).COLUMN_VALUE),
999: g_lot_attributes_tbl(1).COLUMN_VALUE,
1000: fnd_date.canonical_to_date(g_lot_attributes_tbl(2).COLUMN_VALUE),
1001: g_lot_attributes_tbl(3).COLUMN_VALUE,
1002: to_number(g_lot_attributes_tbl(4).COLUMN_VALUE),
1003: fnd_date.canonical_to_date(g_lot_attributes_tbl(5).COLUMN_VALUE),
1004: to_number(g_lot_attributes_tbl(6).COLUMN_VALUE),
1005: fnd_date.canonical_to_date(g_lot_attributes_tbl(7).COLUMN_VALUE),
1006: fnd_date.canonical_to_date(g_lot_attributes_tbl(8).COLUMN_VALUE),
1007: g_lot_attributes_tbl(9).COLUMN_VALUE,
1001: g_lot_attributes_tbl(3).COLUMN_VALUE,
1002: to_number(g_lot_attributes_tbl(4).COLUMN_VALUE),
1003: fnd_date.canonical_to_date(g_lot_attributes_tbl(5).COLUMN_VALUE),
1004: to_number(g_lot_attributes_tbl(6).COLUMN_VALUE),
1005: fnd_date.canonical_to_date(g_lot_attributes_tbl(7).COLUMN_VALUE),
1006: fnd_date.canonical_to_date(g_lot_attributes_tbl(8).COLUMN_VALUE),
1007: g_lot_attributes_tbl(9).COLUMN_VALUE,
1008: to_number(g_lot_attributes_tbl(10).COLUMN_VALUE),
1009: g_lot_attributes_tbl(11).COLUMN_VALUE,
1002: to_number(g_lot_attributes_tbl(4).COLUMN_VALUE),
1003: fnd_date.canonical_to_date(g_lot_attributes_tbl(5).COLUMN_VALUE),
1004: to_number(g_lot_attributes_tbl(6).COLUMN_VALUE),
1005: fnd_date.canonical_to_date(g_lot_attributes_tbl(7).COLUMN_VALUE),
1006: fnd_date.canonical_to_date(g_lot_attributes_tbl(8).COLUMN_VALUE),
1007: g_lot_attributes_tbl(9).COLUMN_VALUE,
1008: to_number(g_lot_attributes_tbl(10).COLUMN_VALUE),
1009: g_lot_attributes_tbl(11).COLUMN_VALUE,
1010: to_number(g_lot_attributes_tbl(12).COLUMN_VALUE),
1009: g_lot_attributes_tbl(11).COLUMN_VALUE,
1010: to_number(g_lot_attributes_tbl(12).COLUMN_VALUE),
1011: g_lot_attributes_tbl(13).COLUMN_VALUE,
1012: g_lot_attributes_tbl(14).COLUMN_VALUE,
1013: fnd_date.canonical_to_date(g_lot_attributes_tbl(15).COLUMN_VALUE),
1014: to_number(g_lot_attributes_tbl(16).COLUMN_VALUE),
1015: g_lot_attributes_tbl(17).COLUMN_VALUE,
1016: to_number(g_lot_attributes_tbl(18).COLUMN_VALUE),
1017: to_number(g_lot_attributes_tbl(19).COLUMN_VALUE),
1038: g_lot_attributes_tbl(40).COLUMN_VALUE,
1039: g_lot_attributes_tbl(41).COLUMN_VALUE,
1040: g_lot_attributes_tbl(42).COLUMN_VALUE,
1041: g_lot_attributes_tbl(43).COLUMN_VALUE,
1042: fnd_date.canonical_to_date(g_lot_attributes_tbl(44).COLUMN_VALUE),
1043: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).COLUMN_VALUE),
1044: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).COLUMN_VALUE),
1045: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).COLUMN_VALUE),
1046: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).COLUMN_VALUE),
1039: g_lot_attributes_tbl(41).COLUMN_VALUE,
1040: g_lot_attributes_tbl(42).COLUMN_VALUE,
1041: g_lot_attributes_tbl(43).COLUMN_VALUE,
1042: fnd_date.canonical_to_date(g_lot_attributes_tbl(44).COLUMN_VALUE),
1043: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).COLUMN_VALUE),
1044: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).COLUMN_VALUE),
1045: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).COLUMN_VALUE),
1046: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).COLUMN_VALUE),
1047: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).COLUMN_VALUE),
1040: g_lot_attributes_tbl(42).COLUMN_VALUE,
1041: g_lot_attributes_tbl(43).COLUMN_VALUE,
1042: fnd_date.canonical_to_date(g_lot_attributes_tbl(44).COLUMN_VALUE),
1043: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).COLUMN_VALUE),
1044: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).COLUMN_VALUE),
1045: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).COLUMN_VALUE),
1046: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).COLUMN_VALUE),
1047: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).COLUMN_VALUE),
1048: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).COLUMN_VALUE),
1041: g_lot_attributes_tbl(43).COLUMN_VALUE,
1042: fnd_date.canonical_to_date(g_lot_attributes_tbl(44).COLUMN_VALUE),
1043: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).COLUMN_VALUE),
1044: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).COLUMN_VALUE),
1045: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).COLUMN_VALUE),
1046: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).COLUMN_VALUE),
1047: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).COLUMN_VALUE),
1048: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).COLUMN_VALUE),
1049: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).COLUMN_VALUE),
1042: fnd_date.canonical_to_date(g_lot_attributes_tbl(44).COLUMN_VALUE),
1043: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).COLUMN_VALUE),
1044: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).COLUMN_VALUE),
1045: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).COLUMN_VALUE),
1046: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).COLUMN_VALUE),
1047: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).COLUMN_VALUE),
1048: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).COLUMN_VALUE),
1049: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).COLUMN_VALUE),
1050: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).COLUMN_VALUE),
1043: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).COLUMN_VALUE),
1044: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).COLUMN_VALUE),
1045: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).COLUMN_VALUE),
1046: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).COLUMN_VALUE),
1047: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).COLUMN_VALUE),
1048: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).COLUMN_VALUE),
1049: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).COLUMN_VALUE),
1050: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).COLUMN_VALUE),
1051: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).COLUMN_VALUE),
1044: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).COLUMN_VALUE),
1045: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).COLUMN_VALUE),
1046: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).COLUMN_VALUE),
1047: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).COLUMN_VALUE),
1048: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).COLUMN_VALUE),
1049: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).COLUMN_VALUE),
1050: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).COLUMN_VALUE),
1051: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).COLUMN_VALUE),
1052: to_number(g_lot_attributes_tbl(54).COLUMN_VALUE),
1045: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).COLUMN_VALUE),
1046: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).COLUMN_VALUE),
1047: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).COLUMN_VALUE),
1048: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).COLUMN_VALUE),
1049: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).COLUMN_VALUE),
1050: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).COLUMN_VALUE),
1051: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).COLUMN_VALUE),
1052: to_number(g_lot_attributes_tbl(54).COLUMN_VALUE),
1053: to_number(g_lot_attributes_tbl(55).COLUMN_VALUE),
1046: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).COLUMN_VALUE),
1047: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).COLUMN_VALUE),
1048: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).COLUMN_VALUE),
1049: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).COLUMN_VALUE),
1050: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).COLUMN_VALUE),
1051: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).COLUMN_VALUE),
1052: to_number(g_lot_attributes_tbl(54).COLUMN_VALUE),
1053: to_number(g_lot_attributes_tbl(55).COLUMN_VALUE),
1054: to_number(g_lot_attributes_tbl(56).COLUMN_VALUE),
1047: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).COLUMN_VALUE),
1048: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).COLUMN_VALUE),
1049: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).COLUMN_VALUE),
1050: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).COLUMN_VALUE),
1051: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).COLUMN_VALUE),
1052: to_number(g_lot_attributes_tbl(54).COLUMN_VALUE),
1053: to_number(g_lot_attributes_tbl(55).COLUMN_VALUE),
1054: to_number(g_lot_attributes_tbl(56).COLUMN_VALUE),
1055: to_number(g_lot_attributes_tbl(57).COLUMN_VALUE),
1366:
1367:
1368: cursor serial_intf_csr(P_SERIAL_TRANSACTION_INTF_ID NUMBER) is
1369: select SERIAL_ATTRIBUTE_CATEGORY
1370: , fnd_date.date_to_canonical(ORIGINATION_DATE )
1371: , C_ATTRIBUTE1
1372: , C_ATTRIBUTE2
1373: , C_ATTRIBUTE3
1374: , C_ATTRIBUTE4
1387: , C_ATTRIBUTE17
1388: , C_ATTRIBUTE18
1389: , C_ATTRIBUTE19
1390: , C_ATTRIBUTE20
1391: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
1392: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
1393: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
1394: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
1395: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
1388: , C_ATTRIBUTE18
1389: , C_ATTRIBUTE19
1390: , C_ATTRIBUTE20
1391: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
1392: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
1393: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
1394: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
1395: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
1396: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
1389: , C_ATTRIBUTE19
1390: , C_ATTRIBUTE20
1391: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
1392: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
1393: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
1394: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
1395: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
1396: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
1397: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
1390: , C_ATTRIBUTE20
1391: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
1392: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
1393: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
1394: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
1395: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
1396: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
1397: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
1398: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
1391: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )
1392: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
1393: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
1394: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
1395: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
1396: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
1397: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
1398: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
1399: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
1392: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )
1393: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
1394: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
1395: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
1396: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
1397: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
1398: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
1399: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
1400: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
1393: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )
1394: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
1395: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
1396: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
1397: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
1398: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
1399: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
1400: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
1401: , to_char(N_ATTRIBUTE1 )
1394: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )
1395: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
1396: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
1397: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
1398: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
1399: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
1400: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
1401: , to_char(N_ATTRIBUTE1 )
1402: , to_char(N_ATTRIBUTE2)
1395: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )
1396: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
1397: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
1398: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
1399: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
1400: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
1401: , to_char(N_ATTRIBUTE1 )
1402: , to_char(N_ATTRIBUTE2)
1403: , to_char(N_ATTRIBUTE3)
1396: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )
1397: , fnd_date.date_to_canonical(D_ATTRIBUTE7)
1398: , fnd_date.date_to_canonical(D_ATTRIBUTE8)
1399: , fnd_date.date_to_canonical( D_ATTRIBUTE9)
1400: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )
1401: , to_char(N_ATTRIBUTE1 )
1402: , to_char(N_ATTRIBUTE2)
1403: , to_char(N_ATTRIBUTE3)
1404: , to_char(N_ATTRIBUTE4)
1756: IF (l_debug = 1) THEN
1757: print_debug('Setting the columns for validation -- Date' , 4);
1758: END IF;
1759: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,
1760: fnd_date.canonical_to_date(g_serial_attributes_tbl(k).column_value));
1761: end if;
1762:
1763: if g_serial_attributes_tbl(k).column_type = 'NUMBER' then
1764: IF (l_debug = 1) THEN
2000: null,
2001: null,
2002: x_object_id,
2003: g_serial_attributes_tbl(1).COLUMN_VALUE,
2004: fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE),
2005: g_serial_attributes_tbl(3).COLUMN_VALUE,
2006: g_serial_attributes_tbl(4).COLUMN_VALUE,
2007: g_serial_attributes_tbl(5).COLUMN_VALUE,
2008: g_serial_attributes_tbl(6).COLUMN_VALUE,
2021: g_serial_attributes_tbl(19).COLUMN_VALUE,
2022: g_serial_attributes_tbl(20).COLUMN_VALUE,
2023: g_serial_attributes_tbl(21).COLUMN_VALUE,
2024: g_serial_attributes_tbl(22).COLUMN_VALUE,
2025: fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE),
2026: fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE),
2027: fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE),
2028: fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE),
2029: fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE),
2022: g_serial_attributes_tbl(20).COLUMN_VALUE,
2023: g_serial_attributes_tbl(21).COLUMN_VALUE,
2024: g_serial_attributes_tbl(22).COLUMN_VALUE,
2025: fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE),
2026: fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE),
2027: fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE),
2028: fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE),
2029: fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE),
2030: fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE),
2023: g_serial_attributes_tbl(21).COLUMN_VALUE,
2024: g_serial_attributes_tbl(22).COLUMN_VALUE,
2025: fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE),
2026: fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE),
2027: fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE),
2028: fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE),
2029: fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE),
2030: fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE),
2031: fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE),
2024: g_serial_attributes_tbl(22).COLUMN_VALUE,
2025: fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE),
2026: fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE),
2027: fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE),
2028: fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE),
2029: fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE),
2030: fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE),
2031: fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE),
2032: fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE),
2025: fnd_date.canonical_to_date(g_serial_attributes_tbl(23).COLUMN_VALUE),
2026: fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE),
2027: fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE),
2028: fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE),
2029: fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE),
2030: fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE),
2031: fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE),
2032: fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE),
2033: fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE),
2026: fnd_date.canonical_to_date(g_serial_attributes_tbl(24).COLUMN_VALUE),
2027: fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE),
2028: fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE),
2029: fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE),
2030: fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE),
2031: fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE),
2032: fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE),
2033: fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE),
2034: fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE),
2027: fnd_date.canonical_to_date(g_serial_attributes_tbl(25).COLUMN_VALUE),
2028: fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE),
2029: fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE),
2030: fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE),
2031: fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE),
2032: fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE),
2033: fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE),
2034: fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE),
2035: to_number(g_serial_attributes_tbl(33).COLUMN_VALUE),
2028: fnd_date.canonical_to_date(g_serial_attributes_tbl(26).COLUMN_VALUE),
2029: fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE),
2030: fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE),
2031: fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE),
2032: fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE),
2033: fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE),
2034: fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE),
2035: to_number(g_serial_attributes_tbl(33).COLUMN_VALUE),
2036: to_number(g_serial_attributes_tbl(34).COLUMN_VALUE),
2029: fnd_date.canonical_to_date(g_serial_attributes_tbl(27).COLUMN_VALUE),
2030: fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE),
2031: fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE),
2032: fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE),
2033: fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE),
2034: fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE),
2035: to_number(g_serial_attributes_tbl(33).COLUMN_VALUE),
2036: to_number(g_serial_attributes_tbl(34).COLUMN_VALUE),
2037: to_number(g_serial_attributes_tbl(35).COLUMN_VALUE),
2030: fnd_date.canonical_to_date(g_serial_attributes_tbl(28).COLUMN_VALUE),
2031: fnd_date.canonical_to_date(g_serial_attributes_tbl(29).COLUMN_VALUE),
2032: fnd_date.canonical_to_date(g_serial_attributes_tbl(30).COLUMN_VALUE),
2033: fnd_date.canonical_to_date(g_serial_attributes_tbl(31).COLUMN_VALUE),
2034: fnd_date.canonical_to_date(g_serial_attributes_tbl(32).COLUMN_VALUE),
2035: to_number(g_serial_attributes_tbl(33).COLUMN_VALUE),
2036: to_number(g_serial_attributes_tbl(34).COLUMN_VALUE),
2037: to_number(g_serial_attributes_tbl(35).COLUMN_VALUE),
2038: to_number(g_serial_attributes_tbl(36).COLUMN_VALUE),