DBA Data[Home] [Help]

APPS.MSC_PQ_UTILS dependencies on FND_DATE

Line 1328: low_value := 'fnd_date.displaydate_to_date('||''''||low||''''||')';

1324: IF operator = 12 THEN
1325: low_value := low;
1326: high_value := high;
1327: ELSE
1328: low_value := 'fnd_date.displaydate_to_date('||''''||low||''''||')';
1329: IF (operator = 9) OR (operator = 10) THEN
1330: high_value := 'fnd_date.displaydate_to_date('||''''||high||''''||')';
1331: ELSE
1332: high_value := high;

Line 1330: high_value := 'fnd_date.displaydate_to_date('||''''||high||''''||')';

1326: high_value := high;
1327: ELSE
1328: low_value := 'fnd_date.displaydate_to_date('||''''||low||''''||')';
1329: IF (operator = 9) OR (operator = 10) THEN
1330: high_value := 'fnd_date.displaydate_to_date('||''''||high||''''||')';
1331: ELSE
1332: high_value := high;
1333: END IF;
1334: END IF;

Line 1463: 'DATE', fnd_date.date_to_displaydate(

1459: mav.sequence,
1460: mav.object_sequence,
1461: mav.field_name,
1462: DECODE(msc.field_type,
1463: 'DATE', fnd_date.date_to_displaydate(
1464: fnd_date.canonical_to_date(mav.or_values)),
1465: 'NUMBER', DECODE(mc.lov_type,
1466: 1, TO_CHAR(
1467: fnd_number.canonical_to_number(mav.or_values)),

Line 1464: fnd_date.canonical_to_date(mav.or_values)),

1460: mav.object_sequence,
1461: mav.field_name,
1462: DECODE(msc.field_type,
1463: 'DATE', fnd_date.date_to_displaydate(
1464: fnd_date.canonical_to_date(mav.or_values)),
1465: 'NUMBER', DECODE(mc.lov_type,
1466: 1, TO_CHAR(
1467: fnd_number.canonical_to_number(mav.or_values)),
1468: mav.or_values),

Line 1566: 'fnd_date.displaydate_to_date('||''''||current_value||''''||')';

1562: --NVL(Get_Group_Char_Cell(or_rg_name||'.HIDDEN_VALUES', counter),
1563: -- Get_Group_Char_Cell(or_rg_name||'.OR_VALUES', counter));
1564: IF datatype='DATE' THEN
1565: current_value :=
1566: 'fnd_date.displaydate_to_date('||''''||current_value||''''||')';
1567: ELSIF datatype ='CHAR' THEN
1568: current_value :=''''||REPLACE(current_value, '''', '''''')||'''';
1569: ELSIF datatype = 'NUMBER' THEN
1570: current_value :=''''||current_value||'''';

Line 3734: low_value := 'fnd_date.displaydate_to_date('||''''||low||''''||')';

3730: IF operator = 12 THEN
3731: low_value := low;
3732: high_value := high;
3733: ELSE
3734: low_value := 'fnd_date.displaydate_to_date('||''''||low||''''||')';
3735: IF (operator = 9) OR (operator = 10) THEN
3736: high_value := 'fnd_date.displaydate_to_date('||''''||high||''''||')';
3737: ELSE
3738: high_value := high;

Line 3736: high_value := 'fnd_date.displaydate_to_date('||''''||high||''''||')';

3732: high_value := high;
3733: ELSE
3734: low_value := 'fnd_date.displaydate_to_date('||''''||low||''''||')';
3735: IF (operator = 9) OR (operator = 10) THEN
3736: high_value := 'fnd_date.displaydate_to_date('||''''||high||''''||')';
3737: ELSE
3738: high_value := high;
3739: END IF;
3740: END IF;