1 package FND_VAL_ATTRIBUTE_TYPES_PKG as
2 /* $Header: AFFFVATS.pls 120.2.12010000.1 2008/07/25 14:14:46 appldev ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID IN OUT NOCOPY VARCHAR2,
6 X_APPLICATION_ID in NUMBER,
7 X_ID_FLEX_CODE in VARCHAR2,
8 X_SEGMENT_ATTRIBUTE_TYPE in VARCHAR2,
9 X_VALUE_ATTRIBUTE_TYPE in VARCHAR2,
10 X_REQUIRED_FLAG in VARCHAR2,
11 X_APPLICATION_COLUMN_NAME in VARCHAR2,
12 X_DEFAULT_VALUE in VARCHAR2,
13 X_LOOKUP_TYPE in VARCHAR2,
14 X_DERIVATION_RULE_CODE in VARCHAR2,
15 X_DERIVATION_RULE_VALUE1 in VARCHAR2,
16 X_DERIVATION_RULE_VALUE2 in VARCHAR2,
17 X_PROMPT in VARCHAR2,
18 X_DESCRIPTION in VARCHAR2,
19 X_CREATION_DATE in DATE,
20 X_CREATED_BY in NUMBER,
21 X_LAST_UPDATE_DATE in DATE,
22 X_LAST_UPDATED_BY in NUMBER,
23 X_LAST_UPDATE_LOGIN in NUMBER);
24 procedure LOCK_ROW (
25 X_APPLICATION_ID in NUMBER,
26 X_ID_FLEX_CODE in VARCHAR2,
27 X_SEGMENT_ATTRIBUTE_TYPE in VARCHAR2,
28 X_VALUE_ATTRIBUTE_TYPE in VARCHAR2,
29 X_REQUIRED_FLAG in VARCHAR2,
30 X_APPLICATION_COLUMN_NAME in VARCHAR2,
31 X_DEFAULT_VALUE in VARCHAR2,
32 X_LOOKUP_TYPE in VARCHAR2,
33 X_DERIVATION_RULE_CODE in VARCHAR2,
34 X_DERIVATION_RULE_VALUE1 in VARCHAR2,
35 X_DERIVATION_RULE_VALUE2 in VARCHAR2,
36 X_PROMPT in VARCHAR2,
37 X_DESCRIPTION in VARCHAR2
38 );
39 procedure UPDATE_ROW (
40 X_APPLICATION_ID in NUMBER,
41 X_ID_FLEX_CODE in VARCHAR2,
42 X_SEGMENT_ATTRIBUTE_TYPE in VARCHAR2,
43 X_VALUE_ATTRIBUTE_TYPE in VARCHAR2,
44 X_REQUIRED_FLAG in VARCHAR2,
45 X_APPLICATION_COLUMN_NAME in VARCHAR2,
46 X_DEFAULT_VALUE in VARCHAR2,
47 X_LOOKUP_TYPE in VARCHAR2,
48 X_DERIVATION_RULE_CODE in VARCHAR2,
49 X_DERIVATION_RULE_VALUE1 in VARCHAR2,
50 X_DERIVATION_RULE_VALUE2 in VARCHAR2,
51 X_PROMPT in VARCHAR2,
52 X_DESCRIPTION in VARCHAR2,
53 X_LAST_UPDATE_DATE in DATE,
54 X_LAST_UPDATED_BY in NUMBER,
55 X_LAST_UPDATE_LOGIN in NUMBER
56 );
57 procedure DELETE_ROW (
58 X_APPLICATION_ID in NUMBER,
59 X_ID_FLEX_CODE in VARCHAR2,
60 X_SEGMENT_ATTRIBUTE_TYPE in VARCHAR2,
61 X_VALUE_ATTRIBUTE_TYPE in VARCHAR2
62 );
63 procedure ADD_LANGUAGE;
64
65 PROCEDURE load_row
66 (x_application_short_name IN VARCHAR2,
67 x_id_flex_code IN VARCHAR2,
68 x_segment_attribute_type IN VARCHAR2,
69 x_value_attribute_type IN VARCHAR2,
70 x_who IN fnd_flex_loader_apis.who_type,
71 x_required_flag IN VARCHAR2,
72 x_application_column_name IN VARCHAR2,
73 x_default_value IN VARCHAR2,
74 x_lookup_type IN VARCHAR2,
75 x_derivation_rule_code IN VARCHAR2,
76 x_derivation_rule_value1 IN VARCHAR2,
77 x_derivation_rule_value2 IN VARCHAR2,
78 x_prompt IN VARCHAR2,
79 x_description IN VARCHAR2);
80
81 PROCEDURE translate_row
82 (x_application_short_name IN VARCHAR2,
83 x_id_flex_code IN VARCHAR2,
84 x_segment_attribute_type IN VARCHAR2,
85 x_value_attribute_type IN VARCHAR2,
86 x_who IN fnd_flex_loader_apis.who_type,
87 x_prompt IN VARCHAR2,
88 x_description IN VARCHAR2);
89
90 end FND_VAL_ATTRIBUTE_TYPES_PKG;