eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LOCATION_INFO_TYPES_PKG dependencies on HR_LOCATION_INFO_TYPES

Line 1: PACKAGE BODY HR_LOCATION_INFO_TYPES_PKG as

1: PACKAGE BODY HR_LOCATION_INFO_TYPES_PKG as
2: /* $Header: perlocit.pkb 120.1 2011/04/28 09:55:23 sidsaxen ship $ */
3: --------------------------------------------------------------------------------
4: g_dummy number(1); -- Dummy for cursor returns which are not needed
5: g_business_group_id number(15); -- For validating translation;

Line 18: from HR_LOCATION_INFO_types t

14: IS
15: L_DUMMY1 number;
16: CURSOR C1 IS
17: select 1
18: from HR_LOCATION_INFO_types t
19: where upper(t.description) = upper(P_DESCRIPTION)
20: and nvl(t.legislation_code, nvl(P_LEGISLATION_CODE, 'XXX') )
21: = nvl(P_LEGISLATION_CODE, 'XXX')
22: and (P_ROWID is null

Line 51: cursor C is select ROWID from HR_LOCATION_INFO_TYPES

47: X_LAST_UPDATE_DATE in DATE,
48: X_LAST_UPDATED_BY in NUMBER,
49: X_LAST_UPDATE_LOGIN in NUMBER
50: ) is
51: cursor C is select ROWID from HR_LOCATION_INFO_TYPES
52: where INFORMATION_TYPE = X_INFORMATION_TYPE
53: ;
54: begin
55: insert into HR_LOCATION_INFO_TYPES (

Line 55: insert into HR_LOCATION_INFO_TYPES (

51: cursor C is select ROWID from HR_LOCATION_INFO_TYPES
52: where INFORMATION_TYPE = X_INFORMATION_TYPE
53: ;
54: begin
55: insert into HR_LOCATION_INFO_TYPES (
56: INFORMATION_TYPE,
57: ACTIVE_INACTIVE_FLAG,
58: MULTIPLE_OCCURENCES_FLAG,
59: LEGISLATION_CODE,

Line 108: from HR_LOCATION_INFO_TYPES

104: MULTIPLE_OCCURENCES_FLAG,
105: LEGISLATION_CODE,
106: REQUEST_ID,
107: OBJECT_VERSION_NUMBER
108: from HR_LOCATION_INFO_TYPES
109: where INFORMATION_TYPE = X_INFORMATION_TYPE
110: for update of INFORMATION_TYPE nowait;
111: recinfo c%rowtype;
112:

Line 153: update HR_LOCATION_INFO_TYPES set

149: X_LAST_UPDATED_BY in NUMBER,
150: X_LAST_UPDATE_LOGIN in NUMBER
151: ) is
152: begin
153: update HR_LOCATION_INFO_TYPES set
154: ACTIVE_INACTIVE_FLAG = X_ACTIVE_INACTIVE_FLAG,
155: MULTIPLE_OCCURENCES_FLAG = X_MULTIPLE_OCCURENCES_FLAG,
156: LEGISLATION_CODE = X_LEGISLATION_CODE,
157: REQUEST_ID = X_REQUEST_ID,

Line 180: p_entity_name=>'HR_LOCATION_INFO_TYPES',

176: -- Added the following code as a part of Zero Downtime Patching Project.
177: -- Code Starts Here.
178: --
179: per_ric_pkg.Chk_integrity(
180: p_entity_name=>'HR_LOCATION_INFO_TYPES',
181: p_ref_entity=>'HR_LOCATION_EXTRA_INFO',
182: p_ref_column_name=>'INFORMATION_TYPE',
183: p_ref_col_value_varchar=> X_INFORMATION_TYPE,
184: p_ref_col_value_number=> NULL,

Line 190: delete from HR_LOCATION_INFO_TYPES

186: p_ref_type=>'DEL');
187: --
188: -- Code Ends Here
189: --
190: delete from HR_LOCATION_INFO_TYPES
191: where INFORMATION_TYPE = X_INFORMATION_TYPE;
192:
193: if (sql%notfound) then
194: raise no_data_found;

Line 208: l_proc VARCHAR2(61) := 'HR_LOCATION_INFO_TYPES_PKG.LOAD_ROW';

204: ,X_OBJECT_VERSION_NUMBER in number
205: ,X_OWNER in varchar2
206: )
207: is
208: l_proc VARCHAR2(61) := 'HR_LOCATION_INFO_TYPES_PKG.LOAD_ROW';
209: l_rowid rowid;
210: l_request_id HR_LOCATION_INFO_types.request_id%TYPE;
211: l_progam_application_id HR_LOCATION_INFO_types.program_application_id%TYPE;
212: l_program_id HR_LOCATION_INFO_types.program_id%TYPE;

Line 210: l_request_id HR_LOCATION_INFO_types.request_id%TYPE;

206: )
207: is
208: l_proc VARCHAR2(61) := 'HR_LOCATION_INFO_TYPES_PKG.LOAD_ROW';
209: l_rowid rowid;
210: l_request_id HR_LOCATION_INFO_types.request_id%TYPE;
211: l_progam_application_id HR_LOCATION_INFO_types.program_application_id%TYPE;
212: l_program_id HR_LOCATION_INFO_types.program_id%TYPE;
213: l_program_update_date HR_LOCATION_INFO_types.program_update_date%TYPE;
214: l_created_by HR_LOCATION_INFO_types.created_by%TYPE := 0;

Line 211: l_progam_application_id HR_LOCATION_INFO_types.program_application_id%TYPE;

207: is
208: l_proc VARCHAR2(61) := 'HR_LOCATION_INFO_TYPES_PKG.LOAD_ROW';
209: l_rowid rowid;
210: l_request_id HR_LOCATION_INFO_types.request_id%TYPE;
211: l_progam_application_id HR_LOCATION_INFO_types.program_application_id%TYPE;
212: l_program_id HR_LOCATION_INFO_types.program_id%TYPE;
213: l_program_update_date HR_LOCATION_INFO_types.program_update_date%TYPE;
214: l_created_by HR_LOCATION_INFO_types.created_by%TYPE := 0;
215: l_creation_date HR_LOCATION_INFO_types.creation_date%TYPE := SYSDATE;

Line 212: l_program_id HR_LOCATION_INFO_types.program_id%TYPE;

208: l_proc VARCHAR2(61) := 'HR_LOCATION_INFO_TYPES_PKG.LOAD_ROW';
209: l_rowid rowid;
210: l_request_id HR_LOCATION_INFO_types.request_id%TYPE;
211: l_progam_application_id HR_LOCATION_INFO_types.program_application_id%TYPE;
212: l_program_id HR_LOCATION_INFO_types.program_id%TYPE;
213: l_program_update_date HR_LOCATION_INFO_types.program_update_date%TYPE;
214: l_created_by HR_LOCATION_INFO_types.created_by%TYPE := 0;
215: l_creation_date HR_LOCATION_INFO_types.creation_date%TYPE := SYSDATE;
216: l_last_update_date HR_LOCATION_INFO_types.last_update_date%TYPE := SYSDATE;

Line 213: l_program_update_date HR_LOCATION_INFO_types.program_update_date%TYPE;

209: l_rowid rowid;
210: l_request_id HR_LOCATION_INFO_types.request_id%TYPE;
211: l_progam_application_id HR_LOCATION_INFO_types.program_application_id%TYPE;
212: l_program_id HR_LOCATION_INFO_types.program_id%TYPE;
213: l_program_update_date HR_LOCATION_INFO_types.program_update_date%TYPE;
214: l_created_by HR_LOCATION_INFO_types.created_by%TYPE := 0;
215: l_creation_date HR_LOCATION_INFO_types.creation_date%TYPE := SYSDATE;
216: l_last_update_date HR_LOCATION_INFO_types.last_update_date%TYPE := SYSDATE;
217: l_last_updated_by HR_LOCATION_INFO_types.last_updated_by%TYPE := 0;

Line 214: l_created_by HR_LOCATION_INFO_types.created_by%TYPE := 0;

210: l_request_id HR_LOCATION_INFO_types.request_id%TYPE;
211: l_progam_application_id HR_LOCATION_INFO_types.program_application_id%TYPE;
212: l_program_id HR_LOCATION_INFO_types.program_id%TYPE;
213: l_program_update_date HR_LOCATION_INFO_types.program_update_date%TYPE;
214: l_created_by HR_LOCATION_INFO_types.created_by%TYPE := 0;
215: l_creation_date HR_LOCATION_INFO_types.creation_date%TYPE := SYSDATE;
216: l_last_update_date HR_LOCATION_INFO_types.last_update_date%TYPE := SYSDATE;
217: l_last_updated_by HR_LOCATION_INFO_types.last_updated_by%TYPE := 0;
218: l_last_update_login HR_LOCATION_INFO_types.last_update_login%TYPE := 0;

Line 215: l_creation_date HR_LOCATION_INFO_types.creation_date%TYPE := SYSDATE;

211: l_progam_application_id HR_LOCATION_INFO_types.program_application_id%TYPE;
212: l_program_id HR_LOCATION_INFO_types.program_id%TYPE;
213: l_program_update_date HR_LOCATION_INFO_types.program_update_date%TYPE;
214: l_created_by HR_LOCATION_INFO_types.created_by%TYPE := 0;
215: l_creation_date HR_LOCATION_INFO_types.creation_date%TYPE := SYSDATE;
216: l_last_update_date HR_LOCATION_INFO_types.last_update_date%TYPE := SYSDATE;
217: l_last_updated_by HR_LOCATION_INFO_types.last_updated_by%TYPE := 0;
218: l_last_update_login HR_LOCATION_INFO_types.last_update_login%TYPE := 0;
219: begin

Line 216: l_last_update_date HR_LOCATION_INFO_types.last_update_date%TYPE := SYSDATE;

212: l_program_id HR_LOCATION_INFO_types.program_id%TYPE;
213: l_program_update_date HR_LOCATION_INFO_types.program_update_date%TYPE;
214: l_created_by HR_LOCATION_INFO_types.created_by%TYPE := 0;
215: l_creation_date HR_LOCATION_INFO_types.creation_date%TYPE := SYSDATE;
216: l_last_update_date HR_LOCATION_INFO_types.last_update_date%TYPE := SYSDATE;
217: l_last_updated_by HR_LOCATION_INFO_types.last_updated_by%TYPE := 0;
218: l_last_update_login HR_LOCATION_INFO_types.last_update_login%TYPE := 0;
219: begin
220: -- Translate developer keys to internal parameters

Line 217: l_last_updated_by HR_LOCATION_INFO_types.last_updated_by%TYPE := 0;

213: l_program_update_date HR_LOCATION_INFO_types.program_update_date%TYPE;
214: l_created_by HR_LOCATION_INFO_types.created_by%TYPE := 0;
215: l_creation_date HR_LOCATION_INFO_types.creation_date%TYPE := SYSDATE;
216: l_last_update_date HR_LOCATION_INFO_types.last_update_date%TYPE := SYSDATE;
217: l_last_updated_by HR_LOCATION_INFO_types.last_updated_by%TYPE := 0;
218: l_last_update_login HR_LOCATION_INFO_types.last_update_login%TYPE := 0;
219: begin
220: -- Translate developer keys to internal parameters
221: if X_OWNER = 'SEED' then

Line 218: l_last_update_login HR_LOCATION_INFO_types.last_update_login%TYPE := 0;

214: l_created_by HR_LOCATION_INFO_types.created_by%TYPE := 0;
215: l_creation_date HR_LOCATION_INFO_types.creation_date%TYPE := SYSDATE;
216: l_last_update_date HR_LOCATION_INFO_types.last_update_date%TYPE := SYSDATE;
217: l_last_updated_by HR_LOCATION_INFO_types.last_updated_by%TYPE := 0;
218: l_last_update_login HR_LOCATION_INFO_types.last_update_login%TYPE := 0;
219: begin
220: -- Translate developer keys to internal parameters
221: if X_OWNER = 'SEED' then
222: l_created_by := 1;

Line 267: UPDATE hr_location_info_types

263: ,X_OWNER in varchar2
264: )
265: is
266: begin
267: UPDATE hr_location_info_types
268: SET description = X_DESCRIPTION
269: ,last_update_date = SYSDATE
270: ,last_updated_by = DECODE(X_OWNER,'SEED',1,0)
271: ,last_update_login = 0

Line 278: END HR_LOCATION_INFO_TYPES_PKG;

274: AND information_type = X_INFORMATION_TYPE;
275: end TRANSLATE_ROW;
276:
277:
278: END HR_LOCATION_INFO_TYPES_PKG;