1 package FND_ID_FLEX_STRUCTURES_PKG as
2 /* $Header: AFFFSTRS.pls 120.2.12010000.1 2008/07/25 14:14:23 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_ID_FLEX_NUM in NUMBER,
9 X_ID_FLEX_STRUCTURE_CODE in VARCHAR2,
10 X_CONCATENATED_SEGMENT_DELIMIT in VARCHAR2,
11 X_CROSS_SEGMENT_VALIDATION_FLA in VARCHAR2,
12 X_DYNAMIC_INSERTS_ALLOWED_FLAG in VARCHAR2,
13 X_ENABLED_FLAG in VARCHAR2,
14 X_FREEZE_FLEX_DEFINITION_FLAG in VARCHAR2,
15 X_FREEZE_STRUCTURED_HIER_FLAG in VARCHAR2,
16 X_SHORTHAND_ENABLED_FLAG in VARCHAR2,
17 X_SHORTHAND_LENGTH in NUMBER,
18 X_STRUCTURE_VIEW_NAME in VARCHAR2,
19 X_ID_FLEX_STRUCTURE_NAME in VARCHAR2,
20 X_DESCRIPTION in VARCHAR2,
21 X_SHORTHAND_PROMPT in VARCHAR2,
22 X_CREATION_DATE in DATE,
23 X_CREATED_BY in NUMBER,
24 X_LAST_UPDATE_DATE in DATE,
25 X_LAST_UPDATED_BY in NUMBER,
26 X_LAST_UPDATE_LOGIN in NUMBER);
27 procedure LOCK_ROW (
28 X_APPLICATION_ID in NUMBER,
29 X_ID_FLEX_CODE in VARCHAR2,
30 X_ID_FLEX_NUM in NUMBER,
31 X_ID_FLEX_STRUCTURE_CODE in VARCHAR2,
32 X_CONCATENATED_SEGMENT_DELIMIT in VARCHAR2,
33 X_CROSS_SEGMENT_VALIDATION_FLA in VARCHAR2,
34 X_DYNAMIC_INSERTS_ALLOWED_FLAG in VARCHAR2,
35 X_ENABLED_FLAG in VARCHAR2,
36 X_FREEZE_FLEX_DEFINITION_FLAG in VARCHAR2,
37 X_FREEZE_STRUCTURED_HIER_FLAG in VARCHAR2,
38 X_SHORTHAND_ENABLED_FLAG in VARCHAR2,
39 X_SHORTHAND_LENGTH in NUMBER,
40 X_STRUCTURE_VIEW_NAME in VARCHAR2,
41 X_ID_FLEX_STRUCTURE_NAME in VARCHAR2,
42 X_DESCRIPTION in VARCHAR2,
43 X_SHORTHAND_PROMPT in VARCHAR2
44 );
45 procedure UPDATE_ROW (
46 X_APPLICATION_ID in NUMBER,
47 X_ID_FLEX_CODE in VARCHAR2,
48 X_ID_FLEX_NUM in NUMBER,
49 X_ID_FLEX_STRUCTURE_CODE in VARCHAR2,
50 X_CONCATENATED_SEGMENT_DELIMIT in VARCHAR2,
51 X_CROSS_SEGMENT_VALIDATION_FLA in VARCHAR2,
52 X_DYNAMIC_INSERTS_ALLOWED_FLAG in VARCHAR2,
53 X_ENABLED_FLAG in VARCHAR2,
54 X_FREEZE_FLEX_DEFINITION_FLAG in VARCHAR2,
55 X_FREEZE_STRUCTURED_HIER_FLAG in VARCHAR2,
56 X_SHORTHAND_ENABLED_FLAG in VARCHAR2,
57 X_SHORTHAND_LENGTH in NUMBER,
58 X_STRUCTURE_VIEW_NAME in VARCHAR2,
59 X_ID_FLEX_STRUCTURE_NAME in VARCHAR2,
60 X_DESCRIPTION in VARCHAR2,
61 X_SHORTHAND_PROMPT in VARCHAR2,
62 X_LAST_UPDATE_DATE in DATE,
63 X_LAST_UPDATED_BY in NUMBER,
64 X_LAST_UPDATE_LOGIN in NUMBER
65 );
66 procedure DELETE_ROW (
67 X_APPLICATION_ID in NUMBER,
68 X_ID_FLEX_CODE in VARCHAR2,
69 X_ID_FLEX_NUM in NUMBER
70 );
71 procedure ADD_LANGUAGE;
72
73 PROCEDURE load_row
74 (x_application_short_name IN VARCHAR2,
75 x_id_flex_code IN VARCHAR2,
76 x_id_flex_structure_code IN VARCHAR2,
77 x_who IN fnd_flex_loader_apis.who_type,
78 x_concatenated_segment_delimit IN VARCHAR2,
79 x_cross_segment_validation_fla IN VARCHAR2,
80 x_dynamic_inserts_allowed_flag IN VARCHAR2,
81 x_enabled_flag IN VARCHAR2,
82 x_freeze_flex_definition_flag IN VARCHAR2,
83 x_freeze_structured_hier_flag IN VARCHAR2,
84 x_shorthand_enabled_flag IN VARCHAR2,
85 x_shorthand_length IN NUMBER,
86 x_structure_view_name IN VARCHAR2,
87 x_id_flex_structure_name IN VARCHAR2,
88 x_description IN VARCHAR2,
89 x_shorthand_prompt IN VARCHAR2);
90
91 PROCEDURE translate_row
92 (x_application_short_name IN VARCHAR2,
93 x_id_flex_code IN VARCHAR2,
94 x_id_flex_structure_code IN VARCHAR2,
95 x_who IN fnd_flex_loader_apis.who_type,
96 x_id_flex_structure_name IN VARCHAR2,
97 x_description IN VARCHAR2,
98 x_shorthand_prompt IN VARCHAR2);
99
100 end FND_ID_FLEX_STRUCTURES_PKG;