APPS.PQH_SS_HISTORY dependencies on FND_DATE

Line 554: 'DATE' , fnd_date.date_to_canonical(date_value),

550: select transaction_value_id ,
551: datatype ,
552: name ,
553: decode( datatype, 'VARCHAR2', varchar2_value,
554: 'DATE' , fnd_date.date_to_canonical(date_value),
555: 'NUMBER' , to_char(number_value) , '' ) value ,
556: decode( datatype, 'VARCHAR2', original_varchar2_value,
557: 'DATE' , fnd_date.date_to_canonical(original_date_value),
558: 'NUMBER' , to_char(original_number_value) , '' ) original_value ,

Line 557: 'DATE' , fnd_date.date_to_canonical(original_date_value),

553: decode( datatype, 'VARCHAR2', varchar2_value,
554: 'DATE' , fnd_date.date_to_canonical(date_value),
555: 'NUMBER' , to_char(number_value) , '' ) value ,
556: decode( datatype, 'VARCHAR2', original_varchar2_value,
557: 'DATE' , fnd_date.date_to_canonical(original_date_value),
558: 'NUMBER' , to_char(original_number_value) , '' ) original_value ,
559: created_by ,
560: creation_date ,
561: last_update_date ,

Line 786: 'DATE' , fnd_date.date_to_canonical(date_value),

782: select transaction_value_id ,
783: datatype ,
784: name ,
785: decode( datatype, 'VARCHAR2', varchar2_value,
786: 'DATE' , fnd_date.date_to_canonical(date_value),
787: 'NUMBER' , to_char(number_value) , '' ) value ,
788: decode( datatype, 'VARCHAR2', original_varchar2_value,
789: 'DATE' , fnd_date.date_to_canonical(original_date_value),
790: 'NUMBER' , to_char(original_number_value) , '' ) original_value ,

Line 789: 'DATE' , fnd_date.date_to_canonical(original_date_value),

785: decode( datatype, 'VARCHAR2', varchar2_value,
786: 'DATE' , fnd_date.date_to_canonical(date_value),
787: 'NUMBER' , to_char(number_value) , '' ) value ,
788: decode( datatype, 'VARCHAR2', original_varchar2_value,
789: 'DATE' , fnd_date.date_to_canonical(original_date_value),
790: 'NUMBER' , to_char(original_number_value) , '' ) original_value ,
791: created_by ,
792: creation_date ,
793: last_update_date ,

Line 1082: 'DATE' , fnd_date.date_to_canonical(date_value),

1078: -1 ,
1079: datatype ,
1080: name ,
1081: decode( datatype, 'VARCHAR2', varchar2_value,
1082: 'DATE' , fnd_date.date_to_canonical(date_value),
1083: 'NUMBER' , number_value , '' ) value ,
1084: decode( datatype, 'VARCHAR2', original_varchar2_value,
1085: 'DATE' , fnd_date.date_to_canonical(original_date_value),
1086: 'NUMBER' , original_number_value , '' ) original_value ,

Line 1085: 'DATE' , fnd_date.date_to_canonical(original_date_value),

1081: decode( datatype, 'VARCHAR2', varchar2_value,
1082: 'DATE' , fnd_date.date_to_canonical(date_value),
1083: 'NUMBER' , number_value , '' ) value ,
1084: decode( datatype, 'VARCHAR2', original_varchar2_value,
1085: 'DATE' , fnd_date.date_to_canonical(original_date_value),
1086: 'NUMBER' , original_number_value , '' ) original_value ,
1087: created_by ,
1088: creation_date ,
1089: last_update_date ,

Line 1289: decode(datatype,'DATE',fnd_date.canonical_to_date(value)),

1285: datatype,
1286: name,
1287: decode(datatype,'VARCHAR2',value),
1288: decode(datatype,'NUMBER',to_number(value)),
1289: decode(datatype,'DATE',fnd_date.canonical_to_date(value)),
1290: decode(datatype,'VARCHAR2',original_value),
1291: decode(datatype,'NUMBER',to_number(original_value)),
1292: decode(datatype,'DATE',fnd_date.canonical_to_date(original_value)),
1293: created_by,

Line 1292: decode(datatype,'DATE',fnd_date.canonical_to_date(original_value)),

1288: decode(datatype,'NUMBER',to_number(value)),
1289: decode(datatype,'DATE',fnd_date.canonical_to_date(value)),
1290: decode(datatype,'VARCHAR2',original_value),
1291: decode(datatype,'NUMBER',to_number(original_value)),
1292: decode(datatype,'DATE',fnd_date.canonical_to_date(original_value)),
1293: created_by,
1294: creation_date,
1295: last_update_date,
1296: last_updated_by,