1 package FND_FLEX_VALUE_RULES_PKG as
2 /* $Header: AFFFVLRS.pls 120.2.12010000.1 2008/07/25 14:14:54 appldev ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID IN OUT NOCOPY VARCHAR2,
6 X_FLEX_VALUE_RULE_ID in NUMBER,
7 X_FLEX_VALUE_RULE_NAME in VARCHAR2,
8 X_FLEX_VALUE_SET_ID in NUMBER,
9 X_PARENT_FLEX_VALUE_LOW in VARCHAR2,
10 X_PARENT_FLEX_VALUE_HIGH in VARCHAR2,
11 X_ERROR_MESSAGE in VARCHAR2,
12 X_DESCRIPTION in VARCHAR2,
13 X_CREATION_DATE in DATE,
14 X_CREATED_BY in NUMBER,
15 X_LAST_UPDATE_DATE in DATE,
16 X_LAST_UPDATED_BY in NUMBER,
17 X_LAST_UPDATE_LOGIN in NUMBER);
18 procedure LOCK_ROW (
19 X_FLEX_VALUE_RULE_ID in NUMBER,
20 X_FLEX_VALUE_RULE_NAME in VARCHAR2,
21 X_FLEX_VALUE_SET_ID in NUMBER,
22 X_PARENT_FLEX_VALUE_LOW in VARCHAR2,
23 X_PARENT_FLEX_VALUE_HIGH in VARCHAR2,
24 X_ERROR_MESSAGE in VARCHAR2,
25 X_DESCRIPTION in VARCHAR2
26 );
27 procedure UPDATE_ROW (
28 X_FLEX_VALUE_RULE_ID in NUMBER,
29 X_FLEX_VALUE_RULE_NAME in VARCHAR2,
30 X_FLEX_VALUE_SET_ID in NUMBER,
31 X_PARENT_FLEX_VALUE_LOW in VARCHAR2,
32 X_PARENT_FLEX_VALUE_HIGH in VARCHAR2,
33 X_ERROR_MESSAGE in VARCHAR2,
34 X_DESCRIPTION in VARCHAR2,
35 X_LAST_UPDATE_DATE in DATE,
36 X_LAST_UPDATED_BY in NUMBER,
37 X_LAST_UPDATE_LOGIN in NUMBER
38 );
39 procedure DELETE_ROW (
40 X_FLEX_VALUE_RULE_ID in NUMBER
41 );
42 procedure ADD_LANGUAGE;
43
44 PROCEDURE load_row
45 (x_flex_value_set_name IN VARCHAR2,
46 x_parent_flex_value_low IN VARCHAR2,
47 x_flex_value_rule_name IN VARCHAR2,
48 x_who IN fnd_flex_loader_apis.who_type,
49 x_parent_flex_value_high IN VARCHAR2,
50 x_error_message IN VARCHAR2,
51 x_description IN VARCHAR2);
52
53 PROCEDURE translate_row
54 (x_flex_value_set_name IN VARCHAR2,
55 x_parent_flex_value_low IN VARCHAR2,
56 x_flex_value_rule_name IN VARCHAR2,
57 x_who IN fnd_flex_loader_apis.who_type,
58 x_error_message IN VARCHAR2,
59 x_description IN VARCHAR2);
60
61 end FND_FLEX_VALUE_RULES_PKG;