1 PACKAGE xla_sources_f_pkg AS
2 /* $Header: xlathsou.pkh 120.19 2006/03/13 22:09:45 svjoshi ship $ */
3 /*======================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_sources |
10 | |
11 | DESCRIPTION |
12 | Forms PL/SQL Wrapper for xla_sources |
13 | |
14 | HISTORY |
15 | Generated from XLAUTB. |
16 | |
17 +======================================================================*/
18
19
20
21 PROCEDURE insert_row
22 (x_rowid IN OUT NOCOPY VARCHAR2
23 ,x_application_id IN NUMBER
24 ,x_source_code IN VARCHAR2
25 ,x_source_type_code IN VARCHAR2
26 ,x_plsql_function_name IN VARCHAR2
27 ,x_flex_value_set_id IN NUMBER
28 ,x_sum_flag IN VARCHAR2
29 ,x_visible_flag IN VARCHAR2
30 ,x_translated_flag IN VARCHAR2
31 ,x_lookup_type IN VARCHAR2
32 ,x_view_application_id IN NUMBER
33 ,x_datatype_code IN VARCHAR2
34 ,x_enabled_flag IN VARCHAR2
35 ,x_key_flexfield_flag IN VARCHAR2
36 ,x_segment_code IN VARCHAR2
37 ,x_flexfield_application_id IN NUMBER
38 ,x_id_flex_code IN VARCHAR2
39 ,x_name IN VARCHAR2
40 ,x_description IN VARCHAR2
41 ,x_source_column_name IN VARCHAR2
42 ,x_source_table_name IN VARCHAR2
43 ,x_creation_date IN DATE
44 ,x_created_by IN NUMBER
45 ,x_last_update_date IN DATE
46 ,x_last_updated_by IN NUMBER
47 ,x_last_update_login IN NUMBER);
48
49 PROCEDURE lock_row
50 (x_application_id IN NUMBER
51 ,x_source_code IN VARCHAR2
52 ,x_source_type_code IN VARCHAR2
53 ,x_plsql_function_name IN VARCHAR2
54 ,x_flex_value_set_id IN NUMBER
55 ,x_sum_flag IN VARCHAR2
56 ,x_visible_flag IN VARCHAR2
57 ,x_translated_flag IN VARCHAR2
58 ,x_lookup_type IN VARCHAR2
59 ,x_view_application_id IN NUMBER
60 ,x_datatype_code IN VARCHAR2
61 ,x_enabled_flag IN VARCHAR2
62 ,x_key_flexfield_flag IN VARCHAR2
63 ,x_segment_code IN VARCHAR2
64 ,x_flexfield_application_id IN NUMBER
65 ,x_id_flex_code IN VARCHAR2
66 ,x_name IN VARCHAR2
67 ,x_description IN VARCHAR2);
68
69 PROCEDURE update_row
70 (x_application_id IN NUMBER
71 ,x_source_code IN VARCHAR2
72 ,x_source_type_code IN VARCHAR2
73 ,x_plsql_function_name IN VARCHAR2
74 ,x_flex_value_set_id IN NUMBER
75 ,x_sum_flag IN VARCHAR2
76 ,x_visible_flag IN VARCHAR2
77 ,x_translated_flag IN VARCHAR2
78 ,x_lookup_type IN VARCHAR2
79 ,x_view_application_id IN NUMBER
80 ,x_datatype_code IN VARCHAR2
81 ,x_enabled_flag IN VARCHAR2
82 ,x_key_flexfield_flag IN VARCHAR2
83 ,x_segment_code IN VARCHAR2
84 ,x_flexfield_application_id IN NUMBER
85 ,x_id_flex_code IN VARCHAR2
86 ,x_name IN VARCHAR2
87 ,x_description IN VARCHAR2
88 ,x_source_column_name IN VARCHAR2
89 ,x_source_table_name IN VARCHAR2
90 ,x_last_update_date IN DATE
91 ,x_last_updated_by IN NUMBER
92 ,x_last_update_login IN NUMBER);
93
94 PROCEDURE delete_row
95 (x_application_id IN NUMBER
96 ,x_source_code IN VARCHAR2
97 ,x_source_type_code IN VARCHAR2);
98 PROCEDURE add_language;
99
100 PROCEDURE load_row
101 (p_appl_short_name IN VARCHAR2
102 ,p_source_code IN VARCHAR2
103 ,p_source_type_code IN VARCHAR2
104 ,p_datatype_code IN VARCHAR2
105 ,p_plsql_function_name IN VARCHAR2
106 ,p_flex_value_set_name IN VARCHAR2
107 ,p_sum_flag IN VARCHAR2
108 ,p_visible_flag IN VARCHAR2
109 ,p_translated_flag IN VARCHAR2
110 ,p_enabled_flag IN VARCHAR2
111 ,p_view_appl_short_name IN VARCHAR2
112 ,p_lookup_type IN VARCHAR2
113 ,p_key_flexfield_flag IN VARCHAR2
114 ,p_segment_code IN VARCHAR2
115 ,p_flex_appl_short_name IN VARCHAR2
116 ,p_id_flex_code IN VARCHAR2
117 ,p_name IN VARCHAR2
118 ,p_description IN VARCHAR2
119 ,p_owner IN VARCHAR2
120 ,p_source_column_name IN VARCHAR2
121 ,p_source_table_name IN VARCHAR2
122 ,p_last_update_date IN VARCHAR2
123 ,p_custom_mode IN VARCHAR2);
124
125 PROCEDURE translate_row
126 (p_appl_short_name IN VARCHAR2
127 ,p_source_code IN VARCHAR2
128 ,p_source_type_code IN VARCHAR2
129 ,p_name IN VARCHAR2
130 ,p_description IN VARCHAR2
131 ,p_owner IN VARCHAR2
132 ,p_last_update_date IN VARCHAR2
133 ,p_custom_mode IN VARCHAR2);
134
135 END xla_sources_f_pkg;