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.PQP_HRTCA_INTEGRATION dependencies on PER_PEOPLE_EXTRA_INFO

Line 258: -- hook for the table per_people_extra_info.

254: -- Description: Use this API to create/update the Passport details in OSS when
255: -- a Passport info. is being created/updated in HRMS for a person who is also a
256: -- OSS Person, based on the Person EIT PQP_OSS_PERSON_DETAILS and
257: -- Synchronize OSS Data, must equal to Y. This API is called from the Row-Handler
258: -- hook for the table per_people_extra_info.
259: --
260: -- Prerequisites:
261: -- Person must exits
262: -- Person Information Type must already exist

Line 269: -- p_pei_info_rec_old Yes per_people_extra_info%ROWTYPE

265: -- Name Reqd Type Description
266: -- p_person_id Yes Number per_all_people_f.person_id
267: -- p_party_id Yes Number per_all_people_f.party_id
268: -- p_action Yes Date Effective Date for the EIT
269: -- p_pei_info_rec_old Yes per_people_extra_info%ROWTYPE
270: -- p_pei_info_rec_new Yes per_people_extra_info%ROWTYPE
271: -- Post Success:
272: -- The passport details for the OSS person is created/updated based on the
273: -- old and new value for the Person EIT in HRMS

Line 270: -- p_pei_info_rec_new Yes per_people_extra_info%ROWTYPE

266: -- p_person_id Yes Number per_all_people_f.person_id
267: -- p_party_id Yes Number per_all_people_f.party_id
268: -- p_action Yes Date Effective Date for the EIT
269: -- p_pei_info_rec_old Yes per_people_extra_info%ROWTYPE
270: -- p_pei_info_rec_new Yes per_people_extra_info%ROWTYPE
271: -- Post Success:
272: -- The passport details for the OSS person is created/updated based on the
273: -- old and new value for the Person EIT in HRMS
274: --

Line 287: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE

283: PROCEDURE InsUpd_OSS_PassPort
284: (p_person_id IN Number
285: ,p_party_id IN Number
286: ,p_action IN Varchar2
287: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE
288: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE
289: );
290: -- ===========================================================================
291: -- ~ InsUpd_OSS_Visa: Insert or update Visa details in OSS

Line 288: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE

284: (p_person_id IN Number
285: ,p_party_id IN Number
286: ,p_action IN Varchar2
287: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE
288: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE
289: );
290: -- ===========================================================================
291: -- ~ InsUpd_OSS_Visa: Insert or update Visa details in OSS
292: -- ===========================================================================

Line 299: -- hook for the table per_people_extra_info.

295: -- Description: Use this API to create/update the Visa details in OSS when
296: -- a Visit info. is being created/updated in HRMS for a person who is also a
297: -- OSS Person, based on the Person EIT PQP_OSS_PERSON_DETAILS and
298: -- Synchronize OSS Data, must equal to Y. This API is called from the Row-Handler
299: -- hook for the table per_people_extra_info.
300: --
301: -- Prerequisites:
302: -- Person must exits
303: -- Person Information Type must already exist

Line 310: -- p_pei_info_rec_old Yes per_people_extra_info%ROWTYPE

306: -- Name Reqd Type Description
307: -- p_person_id Yes Number per_all_people_f.person_id
308: -- p_party_id Yes Number per_all_people_f.party_id
309: -- p_action Yes Date Effective Date for the EIT
310: -- p_pei_info_rec_old Yes per_people_extra_info%ROWTYPE
311: -- p_pei_info_rec_new Yes per_people_extra_info%ROWTYPE
312: -- Post Success:
313: -- The Visa details for the OSS person is created/updated based on the
314: -- old and new value for the Person Visa EIT in HRMS

Line 311: -- p_pei_info_rec_new Yes per_people_extra_info%ROWTYPE

307: -- p_person_id Yes Number per_all_people_f.person_id
308: -- p_party_id Yes Number per_all_people_f.party_id
309: -- p_action Yes Date Effective Date for the EIT
310: -- p_pei_info_rec_old Yes per_people_extra_info%ROWTYPE
311: -- p_pei_info_rec_new Yes per_people_extra_info%ROWTYPE
312: -- Post Success:
313: -- The Visa details for the OSS person is created/updated based on the
314: -- old and new value for the Person Visa EIT in HRMS
315: --

Line 328: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE

324: PROCEDURE InsUpd_OSS_Visa
325: (p_person_id IN Number
326: ,p_party_id IN Number
327: ,p_action IN Varchar2
328: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE
329: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE
330: );
331: -- =============================================================================
332: -- ~ InsUpd_OSS_VisitHstry: Insert or update Visa details in OSS

Line 329: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE

325: (p_person_id IN Number
326: ,p_party_id IN Number
327: ,p_action IN Varchar2
328: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE
329: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE
330: );
331: -- =============================================================================
332: -- ~ InsUpd_OSS_VisitHstry: Insert or update Visa details in OSS
333: -- =============================================================================

Line 340: -- hook for the table per_people_extra_info.

336: -- Description: Use this API to create/update the Visa Visit history in OSS when
337: -- a Visit history info. is being created/updated in HRMS for a person who is
338: -- also an OSS Person, based on the Person EIT PQP_OSS_PERSON_DETAILS and
339: -- Synchronize OSS Data, must equal to Y. This API is called from the Row-Handler
340: -- hook for the table per_people_extra_info.
341: --
342: -- Prerequisites:
343: -- Person must exits
344: -- Person Information Type must already exist

Line 351: -- p_pei_info_rec_old Yes per_people_extra_info%ROWTYPE

347: -- Name Reqd Type Description
348: -- p_person_id Yes Number per_all_people_f.person_id
349: -- p_party_id Yes Number per_all_people_f.party_id
350: -- p_action Yes Date Effective Date for the EIT
351: -- p_pei_info_rec_old Yes per_people_extra_info%ROWTYPE
352: -- p_pei_info_rec_new Yes per_people_extra_info%ROWTYPE
353: -- Post Success:
354: -- The Visa Visit history details for the OSS person is created/updated based
355: -- on the old and new value for the Person Visa EIT in HRMS

Line 352: -- p_pei_info_rec_new Yes per_people_extra_info%ROWTYPE

348: -- p_person_id Yes Number per_all_people_f.person_id
349: -- p_party_id Yes Number per_all_people_f.party_id
350: -- p_action Yes Date Effective Date for the EIT
351: -- p_pei_info_rec_old Yes per_people_extra_info%ROWTYPE
352: -- p_pei_info_rec_new Yes per_people_extra_info%ROWTYPE
353: -- Post Success:
354: -- The Visa Visit history details for the OSS person is created/updated based
355: -- on the old and new value for the Person Visa EIT in HRMS
356: --

Line 369: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE

365: PROCEDURE InsUpd_OSS_VisitHistory
366: (p_person_id IN Number
367: ,p_party_id IN Number
368: ,p_action IN Varchar2
369: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE
370: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE
371: );
372: -- =============================================================================
373: -- ~ InsUpd_Asg_Extra_info: Insert, Update or Delete Assignment Extra Info.

Line 370: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE

366: (p_person_id IN Number
367: ,p_party_id IN Number
368: ,p_action IN Varchar2
369: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE
370: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE
371: );
372: -- =============================================================================
373: -- ~ InsUpd_Asg_Extra_info: Insert, Update or Delete Assignment Extra Info.
374: -- =============================================================================

Line 429: -- p_extra_info_rec Yes per_people_extra_info%ROWTYPE

425: -- p_person_id Yes Number per_all_people_f.person_id
426: -- p_business_group_id Yes Number per_all_people_f.business_group_id
427: -- p_validate Yes Boolean Default false
428: -- p_action Yes Varchar2 INSERT, UPDATE, DELETE
429: -- p_extra_info_rec Yes per_people_extra_info%ROWTYPE
430: -- Post Success:
431: -- The Person Extra Information for the person is created/updated/deleted
432: -- based on the value of p_action(INSERT,UPDATE,DELETE) and the values must be
433: -- populated for the record structure.

Line 446: ,p_extra_info_rec IN OUT NOCOPY per_people_extra_info%ROWTYPE

442: (p_person_id IN Number
443: ,p_business_group_id IN Number
444: ,p_validate IN Boolean DEFAULT FALSE
445: ,p_action IN Varchar2
446: ,p_extra_info_rec IN OUT NOCOPY per_people_extra_info%ROWTYPE
447: );
448: -- =============================================================================
449: -- ~ InsUpd_SIT_info:
450: -- =============================================================================