DBA Data[Home] [Help]

APPS.WMS_RULES_PKG dependencies on FND_NUMBER

Line 482: WHERE rule_id = fnd_number.canonical_to_number(x_rule_id)

478: last_update_date = Sysdate,
479: last_updated_by = Decode(x_owner, 'SEED', 1, 0),
480: last_update_login = 0,
481: source_lang = userenv('LANG')
482: WHERE rule_id = fnd_number.canonical_to_number(x_rule_id)
483: AND userenv('LANG') IN (language, source_lang);
484: END translate_row;
485: --
486: procedure LOAD_ROW (

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

537: /* SELECT parameter_id INTO l_qty_func_para_id
538: FROM wms_parameters
539: WHERE name = x_qty_function_parameter_name; */
540: --
541: l_rule_id := fnd_number.canonical_to_number(x_rule_id);
542: l_qty_func_para_id := fnd_number.canonical_to_number(x_qty_function_parameter_id);
543: wms_rules_pkg.update_row
544: (
545: X_RULE_ID => l_rule_id

Line 542: l_qty_func_para_id := fnd_number.canonical_to_number(x_qty_function_parameter_id);

538: FROM wms_parameters
539: WHERE name = x_qty_function_parameter_name; */
540: --
541: l_rule_id := fnd_number.canonical_to_number(x_rule_id);
542: l_qty_func_para_id := fnd_number.canonical_to_number(x_qty_function_parameter_id);
543: wms_rules_pkg.update_row
544: (
545: X_RULE_ID => l_rule_id
546: ,X_ATTRIBUTE11 => x_attribute11

Line 549: ,X_TYPE_CODE => fnd_number.canonical_to_number(x_type_code)

545: X_RULE_ID => l_rule_id
546: ,X_ATTRIBUTE11 => x_attribute11
547: ,X_ATTRIBUTE12 => x_attribute12
548: ,X_ORGANIZATION_ID => l_organization_id
549: ,X_TYPE_CODE => fnd_number.canonical_to_number(x_type_code)
550: ,X_QTY_FUNCTION_PARAMETER_ID => l_qty_func_para_id
551: ,X_ENABLED_FLAG => x_enabled_flag
552: ,X_USER_DEFINED_FLAG => x_user_defined_flag
553: ,X_MIN_PICK_TASKS_FLAG => x_min_pick_tasks_flag

Line 589: ,X_TYPE_CODE => fnd_number.canonical_to_number(x_type_code)

585: ,X_RULE_ID => l_rule_id
586: ,X_ATTRIBUTE11 => x_attribute11
587: ,X_ATTRIBUTE12 => x_attribute12
588: ,X_ORGANIZATION_ID => l_organization_id
589: ,X_TYPE_CODE => fnd_number.canonical_to_number(x_type_code)
590: ,X_QTY_FUNCTION_PARAMETER_ID => l_qty_func_para_id
591: ,X_ENABLED_FLAG => x_enabled_flag
592: ,X_USER_DEFINED_FLAG => x_user_defined_flag
593: ,X_MIN_PICK_TASKS_FLAG => x_min_pick_tasks_flag