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.PER_PEOPLE_INFO_TYPES_PKG dependencies on PER_PEOPLE_INFO_TYPES

Line 1: PACKAGE BODY PER_PEOPLE_INFO_TYPES_PKG as

1: PACKAGE BODY PER_PEOPLE_INFO_TYPES_PKG as
2: /* $Header: perperit.pkb 115.3 2002/12/06 15:20:29 eumenyio 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 PER_PEOPLE_INFO_types t

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

Line 55: insert into PER_PEOPLE_INFO_TYPES (

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

Line 108: from PER_PEOPLE_INFO_TYPES

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

Line 153: update PER_PEOPLE_INFO_TYPES set

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

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

Line 194: l_proc VARCHAR2(61) := 'PER_PEOPLE_INFO_TYPES_PKG.LOAD_ROW';

190: ,X_OBJECT_VERSION_NUMBER in number
191: ,X_OWNER in varchar2
192: )
193: is
194: l_proc VARCHAR2(61) := 'PER_PEOPLE_INFO_TYPES_PKG.LOAD_ROW';
195: l_rowid rowid;
196: l_request_id PER_PEOPLE_INFO_types.request_id%TYPE;
197: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;
198: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;

Line 196: l_request_id PER_PEOPLE_INFO_types.request_id%TYPE;

192: )
193: is
194: l_proc VARCHAR2(61) := 'PER_PEOPLE_INFO_TYPES_PKG.LOAD_ROW';
195: l_rowid rowid;
196: l_request_id PER_PEOPLE_INFO_types.request_id%TYPE;
197: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;
198: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
199: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
200: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;

Line 197: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;

193: is
194: l_proc VARCHAR2(61) := 'PER_PEOPLE_INFO_TYPES_PKG.LOAD_ROW';
195: l_rowid rowid;
196: l_request_id PER_PEOPLE_INFO_types.request_id%TYPE;
197: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;
198: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
199: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
200: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
201: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;

Line 198: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;

194: l_proc VARCHAR2(61) := 'PER_PEOPLE_INFO_TYPES_PKG.LOAD_ROW';
195: l_rowid rowid;
196: l_request_id PER_PEOPLE_INFO_types.request_id%TYPE;
197: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;
198: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
199: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
200: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
201: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
202: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;

Line 199: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;

195: l_rowid rowid;
196: l_request_id PER_PEOPLE_INFO_types.request_id%TYPE;
197: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;
198: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
199: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
200: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
201: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
202: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;
203: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;

Line 200: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;

196: l_request_id PER_PEOPLE_INFO_types.request_id%TYPE;
197: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;
198: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
199: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
200: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
201: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
202: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;
203: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;
204: l_last_update_login PER_PEOPLE_INFO_types.last_update_login%TYPE := 0;

Line 201: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;

197: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;
198: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
199: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
200: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
201: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
202: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;
203: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;
204: l_last_update_login PER_PEOPLE_INFO_types.last_update_login%TYPE := 0;
205: begin

Line 202: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;

198: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
199: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
200: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
201: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
202: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;
203: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;
204: l_last_update_login PER_PEOPLE_INFO_types.last_update_login%TYPE := 0;
205: begin
206: -- Translate developer keys to internal parameters

Line 203: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;

199: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
200: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
201: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
202: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;
203: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;
204: l_last_update_login PER_PEOPLE_INFO_types.last_update_login%TYPE := 0;
205: begin
206: -- Translate developer keys to internal parameters
207: if X_OWNER = 'SEED' then

Line 204: l_last_update_login PER_PEOPLE_INFO_types.last_update_login%TYPE := 0;

200: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
201: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
202: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;
203: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;
204: l_last_update_login PER_PEOPLE_INFO_types.last_update_login%TYPE := 0;
205: begin
206: -- Translate developer keys to internal parameters
207: if X_OWNER = 'SEED' then
208: l_created_by := 1;

Line 253: UPDATE per_people_info_types

249: ,X_OWNER in varchar2
250: )
251: is
252: begin
253: UPDATE per_people_info_types
254: SET description = X_DESCRIPTION
255: ,last_update_date = SYSDATE
256: ,last_updated_by = DECODE(X_OWNER,'SEED',1,0)
257: ,last_update_login = 0

Line 264: END PER_PEOPLE_INFO_TYPES_PKG;

260: AND information_type = X_INFORMATION_TYPE;
261: end TRANSLATE_ROW;
262:
263:
264: END PER_PEOPLE_INFO_TYPES_PKG;