DBA Data[Home] [Help]

APPS.WMS_RESTRICTIONS_PKG dependencies on FND_NUMBER

Line 484: l_rule_id := fnd_number.canonical_to_number(x_rule_id);

480: l_user_id := 1;
481: END IF;
482: --
483: SELECT Sysdate INTO l_sysdate FROM dual;
484: l_rule_id := fnd_number.canonical_to_number(x_rule_id);
485: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id );
486: l_sequence_number :=
487: fnd_number.canonical_to_number(x_sequence_number);
488: l_operator_code :=

Line 485: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id );

481: END IF;
482: --
483: SELECT Sysdate INTO l_sysdate FROM dual;
484: l_rule_id := fnd_number.canonical_to_number(x_rule_id);
485: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id );
486: l_sequence_number :=
487: fnd_number.canonical_to_number(x_sequence_number);
488: l_operator_code :=
489: fnd_number.canonical_to_number(x_operator_code );

Line 487: fnd_number.canonical_to_number(x_sequence_number);

483: SELECT Sysdate INTO l_sysdate FROM dual;
484: l_rule_id := fnd_number.canonical_to_number(x_rule_id);
485: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id );
486: l_sequence_number :=
487: fnd_number.canonical_to_number(x_sequence_number);
488: l_operator_code :=
489: fnd_number.canonical_to_number(x_operator_code );
490: l_operand_type_code :=
491: fnd_number.canonical_to_number(x_operand_type_code );

Line 489: fnd_number.canonical_to_number(x_operator_code );

485: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id );
486: l_sequence_number :=
487: fnd_number.canonical_to_number(x_sequence_number);
488: l_operator_code :=
489: fnd_number.canonical_to_number(x_operator_code );
490: l_operand_type_code :=
491: fnd_number.canonical_to_number(x_operand_type_code );
492: l_operand_constant_number :=
493: fnd_number.canonical_to_number(x_operand_constant_number );

Line 491: fnd_number.canonical_to_number(x_operand_type_code );

487: fnd_number.canonical_to_number(x_sequence_number);
488: l_operator_code :=
489: fnd_number.canonical_to_number(x_operator_code );
490: l_operand_type_code :=
491: fnd_number.canonical_to_number(x_operand_type_code );
492: l_operand_constant_number :=
493: fnd_number.canonical_to_number(x_operand_constant_number );
494: l_operand_flex_value_set_id :=
495: fnd_number.canonical_to_number(x_operand_flex_value_set_id );

Line 493: fnd_number.canonical_to_number(x_operand_constant_number );

489: fnd_number.canonical_to_number(x_operator_code );
490: l_operand_type_code :=
491: fnd_number.canonical_to_number(x_operand_type_code );
492: l_operand_constant_number :=
493: fnd_number.canonical_to_number(x_operand_constant_number );
494: l_operand_flex_value_set_id :=
495: fnd_number.canonical_to_number(x_operand_flex_value_set_id );
496: l_logical_operator_code :=
497: fnd_number.canonical_to_number(x_logical_operator_code );

Line 495: fnd_number.canonical_to_number(x_operand_flex_value_set_id );

491: fnd_number.canonical_to_number(x_operand_type_code );
492: l_operand_constant_number :=
493: fnd_number.canonical_to_number(x_operand_constant_number );
494: l_operand_flex_value_set_id :=
495: fnd_number.canonical_to_number(x_operand_flex_value_set_id );
496: l_logical_operator_code :=
497: fnd_number.canonical_to_number(x_logical_operator_code );
498: l_operand_parameter_id :=
499: fnd_number.canonical_to_number(x_operand_parameter_id );

Line 497: fnd_number.canonical_to_number(x_logical_operator_code );

493: fnd_number.canonical_to_number(x_operand_constant_number );
494: l_operand_flex_value_set_id :=
495: fnd_number.canonical_to_number(x_operand_flex_value_set_id );
496: l_logical_operator_code :=
497: fnd_number.canonical_to_number(x_logical_operator_code );
498: l_operand_parameter_id :=
499: fnd_number.canonical_to_number(x_operand_parameter_id );
500:
501: l_operand_constant_date := to_date(x_operand_constant_date, 'YYYY/MM/DD');

Line 499: fnd_number.canonical_to_number(x_operand_parameter_id );

495: fnd_number.canonical_to_number(x_operand_flex_value_set_id );
496: l_logical_operator_code :=
497: fnd_number.canonical_to_number(x_logical_operator_code );
498: l_operand_parameter_id :=
499: fnd_number.canonical_to_number(x_operand_parameter_id );
500:
501: l_operand_constant_date := to_date(x_operand_constant_date, 'YYYY/MM/DD');
502:
503: wms_restrictions_pkg.update_row