[Home] [Help]
PACKAGE: APPS.FF_GLOBALS_F_PKG
Source
1 PACKAGE FF_GLOBALS_F_PKG as
2 /* $Header: ffglb01t.pkh 120.1 2006/06/22 16:23:48 mseshadr ship $ */
3 --
4 /*===========================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +============================================================================+
9 Name
10 ff_globals_f_pkg
11 Purpose
12 Supports the GLB block in the form FFWSDGLB (Define Globals).
13 Notes
14
15 History
16 11-Mar-94 J.S.Hobbs 40.0 Date created.
17 31-Jan-95 J.S.Hobbs 40.2 Removed aol WHO columns.
18 12-Apr-05 Shisriva -- Version 115.3,115.4 for MLS of FF_GLOBALS_F.
19 05-May-05 Shisriva 115.5 Fixes for bug 4350976. Removed the Base
20 Parameters from insert_row procedure.
21 05-May-05 Shisriva 115.6 Fixes for bug 4350976. Changed defualting
22 of parameters in update_row and lock_row.
23 22-Jun-06 mseshadr 115.7 Added procedure LOAD_ROW and global
24 variables for lct support.
25 ============================================================================*/
26 --
27 -----------------------------------------------------------------------------
28 -- Name --
29 -- Insert_Row --
30 -- Purpose --
31 -- Table handler procedure that supports the insert of a global via the --
32 -- Define Global form. --
33 -- Arguments --
34 -- See below. --
35 -- Notes --
36 -- None. --
37 -----------------------------------------------------------------------------
38 --
39 -- ----------------------------------------------------------------------------
40 -- | Package Header Variable |
41 -- ----------------------------------------------------------------------------
42 --
43 g_dml_status boolean := FALSE; -- Global package variable
44
45
46 --used by load_row procedure
47 Type glb_record is record(global_id ff_globals_f.global_id%TYPE,
48 global_name ff_globals_f.GLOBAL_NAME%TYPE,
49 legislation_code ff_globals_f.LEGISLATION_CODE%TYPE,
50 created_by ff_globals_f.created_by%TYPE,
51 creation_date ff_globals_f.creation_date%type,
52 global_upload_flag boolean);
53 g_glb_record glb_record;
54 g_leg_view_exists boolean;--used in hrglobal for caching LEG_VIEW's presence
55 --
56
57 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
58 X_Global_Id IN OUT NOCOPY NUMBER,
59 X_Effective_Start_Date DATE,
60 X_Effective_End_Date DATE,
61 X_Business_Group_Id NUMBER,
62 X_Legislation_Code VARCHAR2,
63 X_Data_Type VARCHAR2,
64 X_Global_Name IN OUT NOCOPY VARCHAR2,
65 X_Global_Description VARCHAR2,
66 X_Global_Value VARCHAR2);
67 --
68 -----------------------------------------------------------------------------
69 -- Name --
70 -- Lock_Row --
71 -- Purpose --
72 -- Table handler procedure that supports the insert , update and delete --
73 -- of a formula by applying a lock on a global in the Define Global form.--
74 -- Arguments --
75 -- See below. --
76 -- Notes --
77 -- None. --
78 -----------------------------------------------------------------------------
79 --
80 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
81 X_Global_Id NUMBER,
82 X_Effective_Start_Date DATE,
83 X_Effective_End_Date DATE,
84 X_Business_Group_Id NUMBER,
85 X_Legislation_Code VARCHAR2,
86 X_Data_Type VARCHAR2,
87 X_Global_Name VARCHAR2,
88 X_Global_Description VARCHAR2,
89 X_Global_Value VARCHAR2,
90 X_Base_Global_Name VARCHAR2 default NULL,
91 X_Base_Global_Description VARCHAR2 default NULL);
92 --
93 -----------------------------------------------------------------------------
94 -- Name --
95 -- Lock_Row --
96 -- Purpose --
97 -- Table handler procedure that supports the update of a global via the --
98 -- Define Global form. --
99 -- Arguments --
100 -- See below. --
101 -- Notes --
102 -- None. --
103 -----------------------------------------------------------------------------
104 --
105 PROCEDURE Update_Row(X_Rowid VARCHAR2,
106 X_Global_Id NUMBER,
107 X_Effective_Start_Date DATE,
108 X_Effective_End_Date DATE,
109 X_Business_Group_Id NUMBER,
110 X_Legislation_Code VARCHAR2,
111 X_Data_Type VARCHAR2,
112 X_Global_Name VARCHAR2,
113 X_Global_Description VARCHAR2,
114 X_Global_Value VARCHAR2,
115 X_Base_Global_Name VARCHAR2 default hr_api.g_varchar2,
116 X_Base_Global_Description VARCHAR2 default hr_api.g_varchar2);
117 --
118 -----------------------------------------------------------------------------
119 -- Name --
120 -- Delete_Row --
121 -- Purpose --
122 -- Table handler procedure that supports the delete of a global via the --
123 -- Define Global form. --
124 -- Arguments --
125 -- See below. --
126 -- Notes --
127 -- None. --
128 -----------------------------------------------------------------------------
129 --
130 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
131 -- X_Global_Id NUMBER, -- Extra Columns
132 X_Global_Name VARCHAR2,
133 X_Business_Group_Id NUMBER,
134 X_Legislation_Code VARCHAR2);
135 --For MLS-----------------------------------------------------------------------
136 PROCEDURE set_translation_globals(p_business_group_id NUMBER,
137 p_legislation_code VARCHAR2);
138 procedure ADD_LANGUAGE;
139 procedure TRANSLATE_ROW ( X_B_GLOBAL_NAME VARCHAR2,
140 X_B_LEGISLATION_CODE VARCHAR2,
141 X_GLOBAL_NAME VARCHAR2,
142 X_GLOBAL_DESCRIPTION VARCHAR2,
143 X_OWNER VARCHAR2);
144
145 procedure validate_translation(global_id IN NUMBER,
146 language IN VARCHAR2,
147 global_name IN VARCHAR2,
148 global_description IN VARCHAR2);
149
150 function return_dml_status return boolean;
151 --------------------------------------------------------------------------------
152 --
153
154
155 --To be called from ffglbs1.lct
156 Procedure Load_Row ( P_BASE_GLOBAL_NAME VARCHAR2
157 ,P_EFFECTIVE_START_DATE DATE
158 ,P_EFFECTIVE_END_DATE DATE
159 ,P_GLOBAL_VALUE VARCHAR2
160 ,P_DATA_TYPE VARCHAR2
161 ,P_LEGISLATION_CODE VARCHAR2
162 ,P_BASE_GLOBAL_DESCRIPTION VARCHAR2
163 ,P_GLOBAL_NAME_TL VARCHAR2
164 ,P_GLOBAL_DESCRIPTION_TL VARCHAR2
165 ,P_MAX_UPDATE_DATE DATE);
166
167
168
169 END FF_GLOBALS_F_PKG;