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_PREV_JOB_INFO_TYPES_PKG dependencies on PER_PEOPLE_INFO_TYPES

Line 187: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;

183: )
184: is
185: l_proc VARCHAR2(61) := 'PER_PREV_JOB_INFO_TYPES_PKG.LOAD_ROW';
186: l_rowid rowid;
187: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;
188: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
189: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
190: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
191: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;

Line 188: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;

184: is
185: l_proc VARCHAR2(61) := 'PER_PREV_JOB_INFO_TYPES_PKG.LOAD_ROW';
186: l_rowid rowid;
187: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;
188: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
189: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
190: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
191: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
192: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;

Line 189: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;

185: l_proc VARCHAR2(61) := 'PER_PREV_JOB_INFO_TYPES_PKG.LOAD_ROW';
186: l_rowid rowid;
187: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;
188: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
189: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
190: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
191: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
192: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;
193: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;

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

186: l_rowid rowid;
187: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;
188: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
189: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
190: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
191: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
192: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;
193: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;
194: l_last_update_login PER_PEOPLE_INFO_types.last_update_login%TYPE := 0;

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

187: l_progam_application_id PER_PEOPLE_INFO_types.program_application_id%TYPE;
188: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
189: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
190: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
191: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
192: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;
193: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;
194: l_last_update_login PER_PEOPLE_INFO_types.last_update_login%TYPE := 0;
195: begin

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

188: l_program_id PER_PEOPLE_INFO_types.program_id%TYPE;
189: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
190: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
191: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
192: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;
193: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;
194: l_last_update_login PER_PEOPLE_INFO_types.last_update_login%TYPE := 0;
195: begin
196: -- Translate developer keys to internal parameters

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

189: l_program_update_date PER_PEOPLE_INFO_types.program_update_date%TYPE;
190: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
191: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
192: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;
193: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;
194: l_last_update_login PER_PEOPLE_INFO_types.last_update_login%TYPE := 0;
195: begin
196: -- Translate developer keys to internal parameters
197: if X_OWNER = 'SEED' then

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

190: l_created_by PER_PEOPLE_INFO_types.created_by%TYPE := 0;
191: l_creation_date PER_PEOPLE_INFO_types.creation_date%TYPE := SYSDATE;
192: l_last_update_date PER_PEOPLE_INFO_types.last_update_date%TYPE := SYSDATE;
193: l_last_updated_by PER_PEOPLE_INFO_types.last_updated_by%TYPE := 0;
194: l_last_update_login PER_PEOPLE_INFO_types.last_update_login%TYPE := 0;
195: begin
196: -- Translate developer keys to internal parameters
197: if X_OWNER = 'SEED' then
198: l_created_by := 1;

Line 241: UPDATE per_people_info_types

237: ,X_OWNER in varchar2
238: )
239: is
240: begin
241: UPDATE per_people_info_types
242: SET description = X_DESCRIPTION
243: ,last_update_date = SYSDATE
244: ,last_updated_by = DECODE(X_OWNER,'SEED',1,0)
245: ,last_update_login = 0