[Home] [Help]
PACKAGE: APPS.RG_REPORT_STANDARD_AXES_PKG
Source
1 PACKAGE RG_REPORT_STANDARD_AXES_PKG AS
2 /* $Header: rgirstds.pls 120.3 2003/08/13 10:42:10 nkasu ship $ */
3 --
4 -- Name
5 -- rg_report_standard_axes_pkg
6 -- Purpose
7 -- to include all sever side procedures and packages for table
8 -- rg_report_standard_axes
9 -- Notes
10 --
11 -- History
12 -- 11/01/93 A Chen Created
13 --
14 --
15 -- Procedures
16
17 -- Name
18 -- select_row
19 -- Purpose
20 -- querying a row
21 -- Arguments
22 -- recinfo record inforation
23 --
24 PROCEDURE select_row(recinfo in out NOCOPY rg_report_standard_axes_tl%ROWTYPE);
25
26 -- Name
27 -- select_columns
28 -- Purpose
29 -- querying columns from a row for populating non-database fields
30 -- in POST-QUERY
31 -- Arguments
32 -- recinfo record inforation
33 PROCEDURE select_columns(X_standard_axis_id NUMBER,
34 X_name IN OUT NOCOPY VARCHAR2);
35
36 --
37 -- Name
38 -- insert_row
39 -- Purpose
40 -- Insert a row into RG_REPORT_STANDARD_AXES
41 --
42 PROCEDURE insert_row( X_rowid IN OUT NOCOPY VARCHAR2,
43 X_application_id NUMBER,
44 X_last_update_date DATE,
45 X_last_updated_by NUMBER,
46 X_last_update_login NUMBER,
47 X_creation_date DATE,
48 X_created_by NUMBER,
49 X_standard_axis_id NUMBER,
50 X_standard_axis_name VARCHAR2,
51 X_class VARCHAR2,
52 X_display_in_std_list_flag VARCHAR2,
53 X_precedence_level NUMBER,
54 X_database_column VARCHAR2,
55 X_simple_where_name VARCHAR2,
56 X_period_query VARCHAR2,
57 X_standard_axis1_id NUMBER,
58 X_axis1_operator VARCHAR2,
59 X_standard_axis2_id NUMBER,
60 X_axis2_operator VARCHAR2,
61 X_constant NUMBER,
62 X_variance_flag VARCHAR2,
63 X_sign_flag VARCHAR2,
64 X_description VARCHAR2 );
65
66 --
67 -- Name
68 -- update_row
69 -- Purpose
70 -- Update a row in RG_REPORT_STANDARD_AXES
71 --
72 PROCEDURE update_row( X_rowid IN OUT NOCOPY VARCHAR2,
73 X_application_id NUMBER,
74 X_standard_axis_id NUMBER,
75 X_standard_axis_name VARCHAR2,
76 X_last_update_date DATE,
77 X_last_updated_by NUMBER,
78 X_last_update_login NUMBER,
79 X_class VARCHAR2,
80 X_display_in_std_list_flag VARCHAR2,
81 X_precedence_level NUMBER,
82 X_database_column VARCHAR2,
83 X_simple_where_name VARCHAR2,
84 X_period_query VARCHAR2,
85 X_standard_axis1_id NUMBER,
86 X_axis1_operator VARCHAR2,
87 X_standard_axis2_id NUMBER,
88 X_axis2_operator VARCHAR2,
89 X_constant NUMBER,
90 X_variance_flag VARCHAR2,
91 X_sign_flag VARCHAR2,
92 X_description VARCHAR2 );
93
94 --
95 -- Name
96 -- Load_Row
97 -- Purpose
98 -- Load a row in RG_REPORT_STANDARD_AXES for NLS support
99 --
100
101 PROCEDURE Load_Row ( X_Application_Id NUMBER,
102 X_Standard_Axis_Id NUMBER,
103 X_Class VARCHAR2,
104 X_Display_In_Std_List_Flag VARCHAR2,
105 X_Precedence_Level NUMBER,
106 X_Database_Column VARCHAR2,
107 X_Simple_Where_Name VARCHAR2,
108 X_Period_Query VARCHAR2,
109 X_Standard_Axis1_Id NUMBER,
110 X_Axis1_Operator VARCHAR2,
111 X_Standard_Axis2_Id NUMBER,
112 X_Axis2_Operator VARCHAR2,
113 X_Constant NUMBER,
114 X_Variance_Flag VARCHAR2,
115 X_Sign_Flag VARCHAR2,
116 X_Standard_Axis_Name VARCHAR2,
117 X_Description VARCHAR2,
118 X_Owner VARCHAR2,
119 X_Force_Edits VARCHAR2 );
120
121 --
122 -- Name
123 -- Translate_Row
124 -- Purpose
125 -- Translate a row in RG_REPORT_STANDARD_AXES for NLS support
126 --
127 PROCEDURE Translate_Row (
128 X_Standard_Axis_Name VARCHAR2,
129 X_Description VARCHAR2,
130 X_Standard_Axis_Id NUMBER,
131 X_Owner VARCHAR2,
132 X_Force_Edits VARCHAR2 );
133
134 --
135 -- Procedure
136 -- Add_Language
137 -- Purpose
138 -- To add a new language row to the rg_report_standrad_axes_b
139 -- History
140 -- 29-JUL-03 N Kasu Created
141 -- Arguments
142 -- None
143 -- Example
144 -- rg_report_standard_axes_pkg.Add_Language(....;
145 -- Notes
146 --
147 procedure ADD_LANGUAGE;
148
149 END RG_REPORT_STANDARD_AXES_PKG;