DBA Data[Home] [Help]

APPS.WMS_RULES_PKG dependencies on FND_NUMBER

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

496: last_update_date = Sysdate,
497: last_updated_by = Decode(x_owner, 'SEED', 1, 0),
498: last_update_login = 0,
499: source_lang = userenv('LANG')
500: WHERE rule_id = fnd_number.canonical_to_number(x_rule_id)
501: AND userenv('LANG') IN (language, source_lang);
502: END translate_row;
503: --
504: procedure LOAD_ROW (

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

555: /* SELECT parameter_id INTO l_qty_func_para_id
556: FROM wms_parameters
557: WHERE name = x_qty_function_parameter_name; */
558: --
559: l_rule_id := fnd_number.canonical_to_number(x_rule_id);
560: l_qty_func_para_id := fnd_number.canonical_to_number(x_qty_function_parameter_id);
561: wms_rules_pkg.update_row
562: (
563: X_RULE_ID => l_rule_id

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

556: FROM wms_parameters
557: WHERE name = x_qty_function_parameter_name; */
558: --
559: l_rule_id := fnd_number.canonical_to_number(x_rule_id);
560: l_qty_func_para_id := fnd_number.canonical_to_number(x_qty_function_parameter_id);
561: wms_rules_pkg.update_row
562: (
563: X_RULE_ID => l_rule_id
564: ,X_ATTRIBUTE11 => x_attribute11

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

563: X_RULE_ID => l_rule_id
564: ,X_ATTRIBUTE11 => x_attribute11
565: ,X_ATTRIBUTE12 => x_attribute12
566: ,X_ORGANIZATION_ID => l_organization_id
567: ,X_TYPE_CODE => fnd_number.canonical_to_number(x_type_code)
568: ,X_QTY_FUNCTION_PARAMETER_ID => l_qty_func_para_id
569: ,X_ENABLED_FLAG => x_enabled_flag
570: ,X_USER_DEFINED_FLAG => x_user_defined_flag
571: ,X_MIN_PICK_TASKS_FLAG => x_min_pick_tasks_flag

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

603: ,X_RULE_ID => l_rule_id
604: ,X_ATTRIBUTE11 => x_attribute11
605: ,X_ATTRIBUTE12 => x_attribute12
606: ,X_ORGANIZATION_ID => l_organization_id
607: ,X_TYPE_CODE => fnd_number.canonical_to_number(x_type_code)
608: ,X_QTY_FUNCTION_PARAMETER_ID => l_qty_func_para_id
609: ,X_ENABLED_FLAG => x_enabled_flag
610: ,X_USER_DEFINED_FLAG => x_user_defined_flag
611: ,X_MIN_PICK_TASKS_FLAG => x_min_pick_tasks_flag