1 Package AR_CMGT_DP_TABLE_HANDLER AS
2 /* $Header: ARCMGDTS.pls 120.12 2006/06/29 17:33:39 bsarkar noship $ */
3
4 procedure INSERT_ROW
5 ( p_data_point_name IN VARCHAR2,
6 p_description IN VARCHAR2,
7 p_data_point_category IN VARCHAR2,
8 p_user_defined_flag IN VARCHAR2,
9 p_scorable_flag IN VARCHAR2,
10 p_display_on_checklist IN VARCHAR2,
11 p_created_by IN NUMBER,
12 p_last_updated_by IN NUMBER,
13 p_last_update_login IN NUMBER,
14 p_data_point_id IN NUMBER,
15 p_return_data_type IN VARCHAR2,
16 p_return_date_format IN VARCHAR2,
17 p_application_id IN NUMBER,
18 p_parent_data_point_id IN NUMBER,
19 p_enabled_flag IN VARCHAR2,
20 p_package_name IN VARCHAR2,
21 p_function_name IN VARCHAR2,
22 p_data_point_sub_category IN VARCHAR2,
23 p_data_point_code IN VARCHAR2
24 );
25
26 PROCEDURE insert_adp_row(
27 p_data_point_code IN VARCHAR2,
28 p_data_point_name IN VARCHAR2,
29 p_description IN VARCHAR2,
30 p_data_point_sub_category IN VARCHAR2,
31 p_data_point_category IN VARCHAR2,
32 p_user_defined_flag IN VARCHAR2,
33 p_scorable_flag IN VARCHAR2,
34 p_display_on_checklist IN VARCHAR2,
35 p_created_by IN NUMBER,
36 p_last_updated_by IN NUMBER,
37 p_last_update_login IN NUMBER,
38 p_data_point_id IN NUMBER,
39 p_application_id IN NUMBER,
40 p_parent_data_point_id IN NUMBER,
41 p_enabled_flag IN VARCHAR2,
42 p_package_name IN VARCHAR2,
43 p_function_name IN VARCHAR2,
44 p_function_type IN VARCHAR2,
45 p_return_data_type IN VARCHAR2,
46 p_return_date_format IN VARCHAR2);
47
48 procedure UPDATE_ROW
49 ( p_data_point_id IN NUMBER,
50 p_data_point_name IN VARCHAR2,
51 p_description IN VARCHAR2,
52 p_data_point_category IN VARCHAR2,
53 p_user_defined_flag IN VARCHAR2,
54 p_scorable_flag IN VARCHAR2,
55 p_display_on_checklist IN VARCHAR2,
56 p_application_id IN NUMBER,
57 p_parent_data_point_id IN NUMBER,
58 p_enabled_flag IN VARCHAR2,
59 p_package_name IN VARCHAR2,
60 p_function_name IN VARCHAR2,
61 p_data_point_sub_category IN VARCHAR2,
62 p_return_data_type IN VARCHAR2,
63 p_return_date_format IN VARCHAR2,
64 p_last_updated_by IN NUMBER,
65 p_last_update_login IN NUMBER,
66 p_data_point_code IN VARCHAR2) ;
67
68
69 PROCEDURE update_adp_row(
70 p_data_point_code IN VARCHAR2,
71 p_data_point_name IN VARCHAR2,
72 p_description IN VARCHAR2,
73 p_data_point_sub_category IN VARCHAR2,
74 p_scorable_flag IN VARCHAR2,
75 p_data_point_id IN NUMBER,
76 p_application_id IN NUMBER,
77 p_parent_data_point_id IN NUMBER,
78 p_enabled_flag IN VARCHAR2,
79 p_package_name IN VARCHAR2,
80 p_function_name IN VARCHAR2,
81 p_function_type IN VARCHAR2,
82 p_return_data_type In VARCHAR2,
83 p_return_date_format IN VARCHAR2,
84 p_last_updated_by IN NUMBER,
85 p_last_update_login IN NUMBER);
86
87 procedure DELETE_ROW (
88 p_data_point_id IN NUMBER
89 );
90
91 procedure ADD_LANGUAGE;
92
93 procedure TRANSLATE_ROW (
94 P_DATA_POINT_ID IN NUMBER,
95 P_DESCRIPTION IN VARCHAR2,
96 P_DATA_POINT_NAME IN VARCHAR2,
97 P_OWNER IN VARCHAR2);
98
99
100 procedure LOAD_ROW
101 ( p_data_point_id IN VARCHAR2,
102 p_data_point_name IN VARCHAR2,
103 p_description IN VARCHAR2,
104 p_data_point_category IN VARCHAR2,
105 p_user_defined_flag IN VARCHAR2,
106 p_scorable_flag IN VARCHAR2,
107 p_display_on_checklist IN VARCHAR2,
108 p_application_id IN NUMBER,
109 p_parent_data_point_id IN NUMBER,
110 p_enabled_flag IN VARCHAR2,
111 p_package_name IN VARCHAR2,
112 p_function_name IN VARCHAR2,
113 p_data_point_sub_category IN VARCHAR2,
114 p_return_data_type IN VARCHAR2,
115 p_return_date_format IN VARCHAR2,
116 p_created_by IN NUMBER,
117 p_last_updated_by IN NUMBER,
118 p_last_update_login IN NUMBER,
119 p_data_point_code IN VARCHAR2
120 );
121
122
123 procedure LOAD_ADP_ROW
124 ( p_data_point_code IN VARCHAR2,
125 p_data_point_name IN VARCHAR2,
126 p_description IN VARCHAR2,
127 p_data_point_category IN VARCHAR2,
128 p_user_defined_flag IN VARCHAR2,
129 p_scorable_flag IN VARCHAR2,
130 p_display_on_checklist IN VARCHAR2,
131 p_application_id IN NUMBER,
132 p_parent_data_point_code IN VARCHAR2,
133 p_enabled_flag IN VARCHAR2,
134 p_package_name IN VARCHAR2,
135 p_function_name IN VARCHAR2,
136 p_function_type IN VARCHAR2,
137 p_data_point_sub_category IN VARCHAR2,
138 p_return_data_type IN VARCHAR2,
139 p_return_date_format IN VARCHAR2,
140 p_created_by IN NUMBER,
141 p_last_updated_by IN NUMBER,
142 p_last_update_login IN NUMBER
143 );
144
145 procedure TRANSLATE_ADP_ROW (
146 P_DATA_POINT_CODE IN VARCHAR2,
147 P_DESCRIPTION IN VARCHAR2,
148 P_DATA_POINT_NAME IN VARCHAR2,
149 P_APPLICATION_ID IN NUMBER,
150 P_OWNER IN VARCHAR2);
151
152 END AR_CMGT_DP_TABLE_HANDLER;
153