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.PQH_ROLE_INFO_TYPES_PKG dependencies on PQH_ROLE_INFO_TYPES

Line 1: PACKAGE BODY PQH_ROLE_INFO_TYPES_PKG as

1: PACKAGE BODY PQH_ROLE_INFO_TYPES_PKG as
2: /* $Header: pqhrlsit.pkb 120.3 2005/10/12 20:18:37 srajakum noship $ */
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 PQH_ROLE_INFO_TYPES t

14: IS
15: L_DUMMY1 number;
16: CURSOR C1 IS
17: select 1
18: from PQH_ROLE_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 PQH_ROLE_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 PQH_ROLE_INFO_TYPES
52: where INFORMATION_TYPE = X_INFORMATION_TYPE
53: ;
54: begin
55: insert into PQH_ROLE_INFO_TYPES (

Line 55: insert into PQH_ROLE_INFO_TYPES (

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

Line 108: from PQH_ROLE_INFO_TYPES

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

Line 153: update PQH_ROLE_INFO_TYPES set

149: X_LAST_UPDATED_BY in NUMBER,
150: X_LAST_UPDATE_LOGIN in NUMBER
151: ) is
152: begin
153: update PQH_ROLE_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 177: delete from PQH_ROLE_INFO_TYPES

173: X_INFORMATION_TYPE in VARCHAR2
174: ) is
175: begin
176:
177: delete from PQH_ROLE_INFO_TYPES
178: where INFORMATION_TYPE = X_INFORMATION_TYPE;
179:
180: if (sql%notfound) then
181: raise no_data_found;

Line 204: pqh_role_info_types_pkg.translate_row

200: l_data_migrator_mode := hr_general.g_data_migrator_mode ;
201: hr_general.g_data_migrator_mode := 'Y';
202: --
203: if (x_upload_mode = 'NLS') then
204: pqh_role_info_types_pkg.translate_row
205: (x_information_type => X_INFORMATION_TYPE,
206: x_description => X_DESCRIPTION ,
207: x_owner => X_OWNER);
208: else

Line 209: pqh_role_info_types_pkg.LOAD_ROW (

205: (x_information_type => X_INFORMATION_TYPE,
206: x_description => X_DESCRIPTION ,
207: x_owner => X_OWNER);
208: else
209: pqh_role_info_types_pkg.LOAD_ROW (
210: x_information_type => X_INFORMATION_TYPE,
211: x_active_inactive_flag => X_ACTIVE_INACTIVE_FLAG,
212: x_multiple_occurences_flag => X_MULTIPLE_OCCURENCES_FLAG,
213: x_legislation_code => X_LEGISLATION_CODE,

Line 233: l_proc VARCHAR2(61) := 'PQH_ROLE_INFO_TYPES_PKG.LOAD_ROW';

229: ,X_OWNER in varchar2
230: ,X_LAST_UPDATE_DATE in varchar2
231: )
232: is
233: l_proc VARCHAR2(61) := 'PQH_ROLE_INFO_TYPES_PKG.LOAD_ROW';
234: l_rowid rowid;
235: l_request_id PQH_ROLE_INFO_TYPES.request_id%TYPE;
236: l_progam_application_id PQH_ROLE_INFO_TYPES.program_application_id%TYPE;
237: l_program_id PQH_ROLE_INFO_TYPES.program_id%TYPE;

Line 235: l_request_id PQH_ROLE_INFO_TYPES.request_id%TYPE;

231: )
232: is
233: l_proc VARCHAR2(61) := 'PQH_ROLE_INFO_TYPES_PKG.LOAD_ROW';
234: l_rowid rowid;
235: l_request_id PQH_ROLE_INFO_TYPES.request_id%TYPE;
236: l_progam_application_id PQH_ROLE_INFO_TYPES.program_application_id%TYPE;
237: l_program_id PQH_ROLE_INFO_TYPES.program_id%TYPE;
238: l_program_update_date PQH_ROLE_INFO_TYPES.program_update_date%TYPE;
239: l_created_by PQH_ROLE_INFO_TYPES.created_by%TYPE := 0;

Line 236: l_progam_application_id PQH_ROLE_INFO_TYPES.program_application_id%TYPE;

232: is
233: l_proc VARCHAR2(61) := 'PQH_ROLE_INFO_TYPES_PKG.LOAD_ROW';
234: l_rowid rowid;
235: l_request_id PQH_ROLE_INFO_TYPES.request_id%TYPE;
236: l_progam_application_id PQH_ROLE_INFO_TYPES.program_application_id%TYPE;
237: l_program_id PQH_ROLE_INFO_TYPES.program_id%TYPE;
238: l_program_update_date PQH_ROLE_INFO_TYPES.program_update_date%TYPE;
239: l_created_by PQH_ROLE_INFO_TYPES.created_by%TYPE := 0;
240: l_creation_date PQH_ROLE_INFO_TYPES.creation_date%TYPE := SYSDATE;

Line 237: l_program_id PQH_ROLE_INFO_TYPES.program_id%TYPE;

233: l_proc VARCHAR2(61) := 'PQH_ROLE_INFO_TYPES_PKG.LOAD_ROW';
234: l_rowid rowid;
235: l_request_id PQH_ROLE_INFO_TYPES.request_id%TYPE;
236: l_progam_application_id PQH_ROLE_INFO_TYPES.program_application_id%TYPE;
237: l_program_id PQH_ROLE_INFO_TYPES.program_id%TYPE;
238: l_program_update_date PQH_ROLE_INFO_TYPES.program_update_date%TYPE;
239: l_created_by PQH_ROLE_INFO_TYPES.created_by%TYPE := 0;
240: l_creation_date PQH_ROLE_INFO_TYPES.creation_date%TYPE := SYSDATE;
241: l_last_update_date PQH_ROLE_INFO_TYPES.last_update_date%TYPE := SYSDATE;

Line 238: l_program_update_date PQH_ROLE_INFO_TYPES.program_update_date%TYPE;

234: l_rowid rowid;
235: l_request_id PQH_ROLE_INFO_TYPES.request_id%TYPE;
236: l_progam_application_id PQH_ROLE_INFO_TYPES.program_application_id%TYPE;
237: l_program_id PQH_ROLE_INFO_TYPES.program_id%TYPE;
238: l_program_update_date PQH_ROLE_INFO_TYPES.program_update_date%TYPE;
239: l_created_by PQH_ROLE_INFO_TYPES.created_by%TYPE := 0;
240: l_creation_date PQH_ROLE_INFO_TYPES.creation_date%TYPE := SYSDATE;
241: l_last_update_date PQH_ROLE_INFO_TYPES.last_update_date%TYPE := SYSDATE;
242: l_last_updated_by PQH_ROLE_INFO_TYPES.last_updated_by%TYPE := 0;

Line 239: l_created_by PQH_ROLE_INFO_TYPES.created_by%TYPE := 0;

235: l_request_id PQH_ROLE_INFO_TYPES.request_id%TYPE;
236: l_progam_application_id PQH_ROLE_INFO_TYPES.program_application_id%TYPE;
237: l_program_id PQH_ROLE_INFO_TYPES.program_id%TYPE;
238: l_program_update_date PQH_ROLE_INFO_TYPES.program_update_date%TYPE;
239: l_created_by PQH_ROLE_INFO_TYPES.created_by%TYPE := 0;
240: l_creation_date PQH_ROLE_INFO_TYPES.creation_date%TYPE := SYSDATE;
241: l_last_update_date PQH_ROLE_INFO_TYPES.last_update_date%TYPE := SYSDATE;
242: l_last_updated_by PQH_ROLE_INFO_TYPES.last_updated_by%TYPE := 0;
243: l_last_update_login PQH_ROLE_INFO_TYPES.last_update_login%TYPE := 0;

Line 240: l_creation_date PQH_ROLE_INFO_TYPES.creation_date%TYPE := SYSDATE;

236: l_progam_application_id PQH_ROLE_INFO_TYPES.program_application_id%TYPE;
237: l_program_id PQH_ROLE_INFO_TYPES.program_id%TYPE;
238: l_program_update_date PQH_ROLE_INFO_TYPES.program_update_date%TYPE;
239: l_created_by PQH_ROLE_INFO_TYPES.created_by%TYPE := 0;
240: l_creation_date PQH_ROLE_INFO_TYPES.creation_date%TYPE := SYSDATE;
241: l_last_update_date PQH_ROLE_INFO_TYPES.last_update_date%TYPE := SYSDATE;
242: l_last_updated_by PQH_ROLE_INFO_TYPES.last_updated_by%TYPE := 0;
243: l_last_update_login PQH_ROLE_INFO_TYPES.last_update_login%TYPE := 0;
244: l_dummy varchar2(10);

Line 241: l_last_update_date PQH_ROLE_INFO_TYPES.last_update_date%TYPE := SYSDATE;

237: l_program_id PQH_ROLE_INFO_TYPES.program_id%TYPE;
238: l_program_update_date PQH_ROLE_INFO_TYPES.program_update_date%TYPE;
239: l_created_by PQH_ROLE_INFO_TYPES.created_by%TYPE := 0;
240: l_creation_date PQH_ROLE_INFO_TYPES.creation_date%TYPE := SYSDATE;
241: l_last_update_date PQH_ROLE_INFO_TYPES.last_update_date%TYPE := SYSDATE;
242: l_last_updated_by PQH_ROLE_INFO_TYPES.last_updated_by%TYPE := 0;
243: l_last_update_login PQH_ROLE_INFO_TYPES.last_update_login%TYPE := 0;
244: l_dummy varchar2(10);
245: --

Line 242: l_last_updated_by PQH_ROLE_INFO_TYPES.last_updated_by%TYPE := 0;

238: l_program_update_date PQH_ROLE_INFO_TYPES.program_update_date%TYPE;
239: l_created_by PQH_ROLE_INFO_TYPES.created_by%TYPE := 0;
240: l_creation_date PQH_ROLE_INFO_TYPES.creation_date%TYPE := SYSDATE;
241: l_last_update_date PQH_ROLE_INFO_TYPES.last_update_date%TYPE := SYSDATE;
242: l_last_updated_by PQH_ROLE_INFO_TYPES.last_updated_by%TYPE := 0;
243: l_last_update_login PQH_ROLE_INFO_TYPES.last_update_login%TYPE := 0;
244: l_dummy varchar2(10);
245: --
246: Cursor csr_info_typ_exists is

Line 243: l_last_update_login PQH_ROLE_INFO_TYPES.last_update_login%TYPE := 0;

239: l_created_by PQH_ROLE_INFO_TYPES.created_by%TYPE := 0;
240: l_creation_date PQH_ROLE_INFO_TYPES.creation_date%TYPE := SYSDATE;
241: l_last_update_date PQH_ROLE_INFO_TYPES.last_update_date%TYPE := SYSDATE;
242: l_last_updated_by PQH_ROLE_INFO_TYPES.last_updated_by%TYPE := 0;
243: l_last_update_login PQH_ROLE_INFO_TYPES.last_update_login%TYPE := 0;
244: l_dummy varchar2(10);
245: --
246: Cursor csr_info_typ_exists is
247: Select 'x' from PQH_ROLE_INFO_TYPES

Line 247: Select 'x' from PQH_ROLE_INFO_TYPES

243: l_last_update_login PQH_ROLE_INFO_TYPES.last_update_login%TYPE := 0;
244: l_dummy varchar2(10);
245: --
246: Cursor csr_info_typ_exists is
247: Select 'x' from PQH_ROLE_INFO_TYPES
248: Where INFORMATION_TYPE = X_INFORMATION_TYPE;
249: --
250: begin
251: -- Translate developer keys to internal parameters

Line 342: l_last_updated_by PQH_ROLE_INFO_TYPES.last_updated_by%TYPE := 0;

338: ,X_DESCRIPTION in varchar2
339: ,X_OWNER in varchar2
340: )
341: is
342: l_last_updated_by PQH_ROLE_INFO_TYPES.last_updated_by%TYPE := 0;
343: begin
344: l_last_updated_by := fnd_load_util.owner_id(X_OWNER);
345: --
346: UPDATE PQH_ROLE_INFO_TYPES

Line 346: UPDATE PQH_ROLE_INFO_TYPES

342: l_last_updated_by PQH_ROLE_INFO_TYPES.last_updated_by%TYPE := 0;
343: begin
344: l_last_updated_by := fnd_load_util.owner_id(X_OWNER);
345: --
346: UPDATE PQH_ROLE_INFO_TYPES
347: SET description = X_DESCRIPTION
348: ,last_update_date = SYSDATE
349: ,last_updated_by = l_last_updated_by
350: ,last_update_login = 0

Line 357: END PQH_ROLE_INFO_TYPES_PKG;

353: AND information_type = X_INFORMATION_TYPE;
354: end TRANSLATE_ROW;
355:
356:
357: END PQH_ROLE_INFO_TYPES_PKG;