DBA Data[Home] [Help]

APPS.MSC_PQ_UTILS dependencies on FND_DATE

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

1320: IF operator = 12 THEN
1321: low_value := low;
1322: high_value := high;
1323: ELSE
1324: low_value := 'fnd_date.displaydate_to_date('||''''||low||''''||')';
1325: IF (operator = 9) OR (operator = 10) THEN
1326: high_value := 'fnd_date.displaydate_to_date('||''''||high||''''||')';
1327: ELSE
1328: high_value := high;

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

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

Line 1446: 'DATE', fnd_date.date_to_displaydate(

1442: mav.sequence,
1443: mav.object_sequence,
1444: mav.field_name,
1445: DECODE(msc.field_type,
1446: 'DATE', fnd_date.date_to_displaydate(
1447: fnd_date.canonical_to_date(mav.or_values)),
1448: 'NUMBER', DECODE(mc.lov_type,
1449: 1, TO_CHAR(
1450: fnd_number.canonical_to_number(mav.or_values)),

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

1443: mav.object_sequence,
1444: mav.field_name,
1445: DECODE(msc.field_type,
1446: 'DATE', fnd_date.date_to_displaydate(
1447: fnd_date.canonical_to_date(mav.or_values)),
1448: 'NUMBER', DECODE(mc.lov_type,
1449: 1, TO_CHAR(
1450: fnd_number.canonical_to_number(mav.or_values)),
1451: mav.or_values),

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

1544: --NVL(Get_Group_Char_Cell(or_rg_name||'.HIDDEN_VALUES', counter),
1545: -- Get_Group_Char_Cell(or_rg_name||'.OR_VALUES', counter));
1546: IF datatype='DATE' THEN
1547: current_value :=
1548: 'fnd_date.displaydate_to_date('||''''||current_value||''''||')';
1549: ELSIF datatype ='CHAR' THEN
1550: current_value :=''''||REPLACE(current_value, '''', '''''')||'''';
1551: ELSIF datatype = 'NUMBER' THEN
1552: current_value :=''''||current_value||'''';