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.CSL_PARTY_CONTACTS_ACC_PKG dependencies on PER_ALL_PEOPLE_F

Line 342: -- Call procedure for per_all_people_f

338: INSERT_HZ_RELATIONSHIP( r_contact.PARTY_ID, p_resource_id );
339: END IF; --PARTY_RELATIONSHIP
340:
341: IF r_contact.CONTACT_TYPE = 'EMPLOYEE' THEN
342: -- Call procedure for per_all_people_f
343: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
344: jtm_message_log_pkg.Log_Msg
345: ( r_contact.SR_CONTACT_POINT_ID
346: , l_table_name

Line 348: 'Calling INSERT_PER_ALL_PEOPLE_F'

344: jtm_message_log_pkg.Log_Msg
345: ( r_contact.SR_CONTACT_POINT_ID
346: , l_table_name
347: , 'Contact is of type ''EMPLOYEE'''||fnd_global.local_chr(10)||
348: 'Calling INSERT_PER_ALL_PEOPLE_F'
349: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
350: END IF;
351: INSERT_PER_ALL_PEOPLE_F( r_contact.PARTY_ID, p_resource_id );
352: END IF; --EMPLOYEE

Line 351: INSERT_PER_ALL_PEOPLE_F( r_contact.PARTY_ID, p_resource_id );

347: , 'Contact is of type ''EMPLOYEE'''||fnd_global.local_chr(10)||
348: 'Calling INSERT_PER_ALL_PEOPLE_F'
349: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
350: END IF;
351: INSERT_PER_ALL_PEOPLE_F( r_contact.PARTY_ID, p_resource_id );
352: END IF; --EMPLOYEE
353:
354: IF r_contact.CONTACT_TYPE = 'ORGANIZATION' THEN
355: -- Call procedure for ...

Line 460: DELETE_PER_ALL_PEOPLE_F( r_contact.PARTY_ID, p_resource_id );

456: DELETE_HZ_RELATIONSHIP( r_contact.PARTY_ID, p_resource_id );
457: END IF; --PARTY_RELATIONSHIP
458:
459: IF r_contact.CONTACT_TYPE = 'EMPLOYEE' THEN
460: DELETE_PER_ALL_PEOPLE_F( r_contact.PARTY_ID, p_resource_id );
461: END IF; --EMPLOYEE
462:
463: IF r_contact.CONTACT_TYPE = 'ORGANIZATION' THEN
464: NULL;

Line 482: PROCEDURE INSERT_PER_ALL_PEOPLE_F( p_person_id IN NUMBER

478:
479: /**
480: *
481: */
482: PROCEDURE INSERT_PER_ALL_PEOPLE_F( p_person_id IN NUMBER
483: , p_resource_id IN NUMBER )
484: IS
485:
486: CURSOR c_per_all_people(b_person_id NUMBER) IS

Line 488: FROM PER_ALL_PEOPLE_F

484: IS
485:
486: CURSOR c_per_all_people(b_person_id NUMBER) IS
487: SELECT EFFECTIVE_START_DATE , EFFECTIVE_END_DATE
488: FROM PER_ALL_PEOPLE_F
489: WHERE PERSON_ID = b_person_id;
490: l_table_name CONSTANT VARCHAR2(30) := 'PER_ALL_PEOPLE_F';
491: l_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_PER_ALL_PEOPLE_F_ACC';
492: l_pk1_name CONSTANT VARCHAR2(30) := 'PERSON_ID';

Line 490: l_table_name CONSTANT VARCHAR2(30) := 'PER_ALL_PEOPLE_F';

486: CURSOR c_per_all_people(b_person_id NUMBER) IS
487: SELECT EFFECTIVE_START_DATE , EFFECTIVE_END_DATE
488: FROM PER_ALL_PEOPLE_F
489: WHERE PERSON_ID = b_person_id;
490: l_table_name CONSTANT VARCHAR2(30) := 'PER_ALL_PEOPLE_F';
491: l_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_PER_ALL_PEOPLE_F_ACC';
492: l_pk1_name CONSTANT VARCHAR2(30) := 'PERSON_ID';
493: l_pk2_name CONSTANT VARCHAR2(30) := 'EFFECTIVE_START_DATE';
494: l_pk3_name CONSTANT VARCHAR2(30) := 'EFFECTIVE_END_DATE';

Line 491: l_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_PER_ALL_PEOPLE_F_ACC';

487: SELECT EFFECTIVE_START_DATE , EFFECTIVE_END_DATE
488: FROM PER_ALL_PEOPLE_F
489: WHERE PERSON_ID = b_person_id;
490: l_table_name CONSTANT VARCHAR2(30) := 'PER_ALL_PEOPLE_F';
491: l_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_PER_ALL_PEOPLE_F_ACC';
492: l_pk1_name CONSTANT VARCHAR2(30) := 'PERSON_ID';
493: l_pk2_name CONSTANT VARCHAR2(30) := 'EFFECTIVE_START_DATE';
494: l_pk3_name CONSTANT VARCHAR2(30) := 'EFFECTIVE_END_DATE';
495: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

Line 496: JTM_HOOK_UTIL_PKG.t_publication_item_list('PER_ALL_PEOPLE_F');

492: l_pk1_name CONSTANT VARCHAR2(30) := 'PERSON_ID';
493: l_pk2_name CONSTANT VARCHAR2(30) := 'EFFECTIVE_START_DATE';
494: l_pk3_name CONSTANT VARCHAR2(30) := 'EFFECTIVE_END_DATE';
495: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
496: JTM_HOOK_UTIL_PKG.t_publication_item_list('PER_ALL_PEOPLE_F');
497:
498: BEGIN
499: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
500: jtm_message_log_pkg.Log_Msg

Line 503: , 'Entering INSERT_PER_ALL_PEOPLE_F'

499: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
500: jtm_message_log_pkg.Log_Msg
501: ( p_person_id
502: , l_table_name
503: , 'Entering INSERT_PER_ALL_PEOPLE_F'
504: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
505: END IF;
506:
507: FOR r_per_all_people IN c_per_all_people(b_person_id => p_person_id) LOOP

Line 533: , 'Leaving INSERT_PER_ALL_PEOPLE_F'

529: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
530: jtm_message_log_pkg.Log_Msg
531: ( p_person_id
532: , l_table_name
533: , 'Leaving INSERT_PER_ALL_PEOPLE_F'
534: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
535: END IF;
536: END INSERT_PER_ALL_PEOPLE_F;
537:

Line 536: END INSERT_PER_ALL_PEOPLE_F;

532: , l_table_name
533: , 'Leaving INSERT_PER_ALL_PEOPLE_F'
534: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
535: END IF;
536: END INSERT_PER_ALL_PEOPLE_F;
537:
538: /**
539: *
540: */

Line 541: PROCEDURE DELETE_PER_ALL_PEOPLE_F ( p_person_id IN NUMBER

537:
538: /**
539: *
540: */
541: PROCEDURE DELETE_PER_ALL_PEOPLE_F ( p_person_id IN NUMBER
542: , p_resource_id IN NUMBER )
543: IS
544: CURSOR c_per_all_people(b_person_id NUMBER) IS
545: SELECT EFFECTIVE_START_DATE , EFFECTIVE_END_DATE

Line 546: FROM PER_ALL_PEOPLE_F

542: , p_resource_id IN NUMBER )
543: IS
544: CURSOR c_per_all_people(b_person_id NUMBER) IS
545: SELECT EFFECTIVE_START_DATE , EFFECTIVE_END_DATE
546: FROM PER_ALL_PEOPLE_F
547: WHERE PERSON_ID = b_person_id;
548: l_table_name CONSTANT VARCHAR2(30) := 'PER_ALL_PEOPLE_F';
549: l_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_PER_ALL_PEOPLE_F_ACC';
550: l_pk1_name CONSTANT VARCHAR2(30) := 'PERSON_ID';

Line 548: l_table_name CONSTANT VARCHAR2(30) := 'PER_ALL_PEOPLE_F';

544: CURSOR c_per_all_people(b_person_id NUMBER) IS
545: SELECT EFFECTIVE_START_DATE , EFFECTIVE_END_DATE
546: FROM PER_ALL_PEOPLE_F
547: WHERE PERSON_ID = b_person_id;
548: l_table_name CONSTANT VARCHAR2(30) := 'PER_ALL_PEOPLE_F';
549: l_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_PER_ALL_PEOPLE_F_ACC';
550: l_pk1_name CONSTANT VARCHAR2(30) := 'PERSON_ID';
551: l_pk2_name CONSTANT VARCHAR2(30) := 'EFFECTIVE_START_DATE';
552: l_pk3_name CONSTANT VARCHAR2(30) := 'EFFECTIVE_END_DATE';

Line 549: l_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_PER_ALL_PEOPLE_F_ACC';

545: SELECT EFFECTIVE_START_DATE , EFFECTIVE_END_DATE
546: FROM PER_ALL_PEOPLE_F
547: WHERE PERSON_ID = b_person_id;
548: l_table_name CONSTANT VARCHAR2(30) := 'PER_ALL_PEOPLE_F';
549: l_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_PER_ALL_PEOPLE_F_ACC';
550: l_pk1_name CONSTANT VARCHAR2(30) := 'PERSON_ID';
551: l_pk2_name CONSTANT VARCHAR2(30) := 'EFFECTIVE_START_DATE';
552: l_pk3_name CONSTANT VARCHAR2(30) := 'EFFECTIVE_END_DATE';
553: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

Line 554: JTM_HOOK_UTIL_PKG.t_publication_item_list('PER_ALL_PEOPLE_F');

550: l_pk1_name CONSTANT VARCHAR2(30) := 'PERSON_ID';
551: l_pk2_name CONSTANT VARCHAR2(30) := 'EFFECTIVE_START_DATE';
552: l_pk3_name CONSTANT VARCHAR2(30) := 'EFFECTIVE_END_DATE';
553: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
554: JTM_HOOK_UTIL_PKG.t_publication_item_list('PER_ALL_PEOPLE_F');
555:
556: BEGIN
557: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
558: jtm_message_log_pkg.Log_Msg

Line 561: , 'Entering DELETE_PER_ALL_PEOPLE_F'

557: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
558: jtm_message_log_pkg.Log_Msg
559: ( p_person_id
560: , l_table_name
561: , 'Entering DELETE_PER_ALL_PEOPLE_F'
562: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
563: END IF;
564:
565: FOR r_per_all_people IN c_per_all_people(b_person_id => p_person_id) LOOP

Line 591: , 'Leaving DELETE_PER_ALL_PEOPLE_F'

587: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
588: jtm_message_log_pkg.Log_Msg
589: ( p_person_id
590: , l_table_name
591: , 'Leaving DELETE_PER_ALL_PEOPLE_F'
592: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
593: END IF;
594:
595: END DELETE_PER_ALL_PEOPLE_F;

Line 595: END DELETE_PER_ALL_PEOPLE_F;

591: , 'Leaving DELETE_PER_ALL_PEOPLE_F'
592: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
593: END IF;
594:
595: END DELETE_PER_ALL_PEOPLE_F;
596:
597: FUNCTION UPDATE_CONTACT_POINT_WFSUB( p_subscription_guid in raw
598: , p_event in out NOCOPY wf_event_t)
599: return varchar2