APPS.WMS_ASN_LOT_ATT dependencies on FND_DATE

Line 256: , fnd_date.date_to_canonical(ORIGINATION_DATE)

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)

Line 259: , fnd_date.date_to_canonical(CHANGE_DATE)

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

Line 261: , fnd_date.date_to_canonical(RETEST_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
264: , to_char(ITEM_SIZE)
265: , COLOR

Line 262: , fnd_date.date_to_canonical(MATURITY_DATE)

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 )

Line 269: , fnd_date.date_to_canonical(BEST_BY_DATE )

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 )

Line 298: , fnd_date.date_to_canonical(D_ATTRIBUTE1)

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)

Line 299: , fnd_date.date_to_canonical(D_ATTRIBUTE2)

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)

Line 300: , fnd_date.date_to_canonical(D_ATTRIBUTE3)

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)

Line 301: , fnd_date.date_to_canonical(D_ATTRIBUTE4)

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)

Line 302: , fnd_date.date_to_canonical(D_ATTRIBUTE5)

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)

Line 303: , fnd_date.date_to_canonical(D_ATTRIBUTE6)

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)

Line 304: , fnd_date.date_to_canonical(D_ATTRIBUTE7)

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)

Line 305: , fnd_date.date_to_canonical(D_ATTRIBUTE8)

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)

Line 306: , fnd_date.date_to_canonical(D_ATTRIBUTE9)

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)

Line 307: , fnd_date.date_to_canonical(D_ATTRIBUTE10)

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)

Line 783: fnd_date.canonical_to_date(g_lot_attributes_tbl(k).column_value));

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

Line 1000: fnd_date.canonical_to_date(g_lot_attributes_tbl(2).COLUMN_VALUE),

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),

Line 1003: fnd_date.canonical_to_date(g_lot_attributes_tbl(5).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,

Line 1005: fnd_date.canonical_to_date(g_lot_attributes_tbl(7).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,

Line 1006: fnd_date.canonical_to_date(g_lot_attributes_tbl(8).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),

Line 1013: fnd_date.canonical_to_date(g_lot_attributes_tbl(15).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),

Line 1042: fnd_date.canonical_to_date(g_lot_attributes_tbl(44).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),

Line 1043: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).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),

Line 1044: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).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),

Line 1045: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).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),

Line 1046: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).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),

Line 1047: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).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),

Line 1048: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).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),

Line 1049: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).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),

Line 1050: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).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),

Line 1051: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).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),

Line 1370: , fnd_date.date_to_canonical(ORIGINATION_DATE )

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

Line 1391: , fnd_date.date_to_canonical(D_ATTRIBUTE1 )

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 )

Line 1392: , fnd_date.date_to_canonical(D_ATTRIBUTE2 )

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 )

Line 1393: , fnd_date.date_to_canonical(D_ATTRIBUTE3 )

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)

Line 1394: , fnd_date.date_to_canonical(D_ATTRIBUTE4 )

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)

Line 1395: , fnd_date.date_to_canonical(D_ATTRIBUTE5 )

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)

Line 1396: , fnd_date.date_to_canonical(D_ATTRIBUTE6 )

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 )

Line 1397: , fnd_date.date_to_canonical(D_ATTRIBUTE7)

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 )

Line 1398: , fnd_date.date_to_canonical(D_ATTRIBUTE8)

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)

Line 1399: , fnd_date.date_to_canonical( D_ATTRIBUTE9)

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)

Line 1400: , fnd_date.date_to_canonical(D_ATTRIBUTE10 )

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)

Line 1760: fnd_date.canonical_to_date(g_serial_attributes_tbl(k).column_value));

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

Line 2004: fnd_date.canonical_to_date(g_serial_attributes_tbl(2).COLUMN_VALUE),

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,

Line 2025: fnd_date.canonical_to_date(g_serial_attributes_tbl(23).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),

Line 2026: fnd_date.canonical_to_date(g_serial_attributes_tbl(24).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),

Line 2027: fnd_date.canonical_to_date(g_serial_attributes_tbl(25).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),

Line 2028: fnd_date.canonical_to_date(g_serial_attributes_tbl(26).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),

Line 2029: fnd_date.canonical_to_date(g_serial_attributes_tbl(27).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),

Line 2030: fnd_date.canonical_to_date(g_serial_attributes_tbl(28).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),

Line 2031: fnd_date.canonical_to_date(g_serial_attributes_tbl(29).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),

Line 2032: fnd_date.canonical_to_date(g_serial_attributes_tbl(30).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),

Line 2033: fnd_date.canonical_to_date(g_serial_attributes_tbl(31).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),

Line 2034: fnd_date.canonical_to_date(g_serial_attributes_tbl(32).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),