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.CSM_PARTY_DATA_EVENT_PKG dependencies on CSM_HZ_RELATIONSHIPS_ACC

Line 74: g_acc_table_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC';

70: g_pk1_name10 CONSTANT VARCHAR2(30) := 'COUNTER_PROPERTY_ID';
71: g_publication_item_name10 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
72: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROPERTIES');
73:
74: g_acc_table_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC';
75: g_acc_sequence_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC_S';
76: g_pk1_name11 CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
77: g_pk2_name11 CONSTANT VARCHAR2(30) := 'DIRECTIONAL_FLAG';
78: g_publication_item_name11 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 75: g_acc_sequence_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC_S';

71: g_publication_item_name10 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
72: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROPERTIES');
73:
74: g_acc_table_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC';
75: g_acc_sequence_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC_S';
76: g_pk1_name11 CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
77: g_pk2_name11 CONSTANT VARCHAR2(30) := 'DIRECTIONAL_FLAG';
78: g_publication_item_name11 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
79: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_RELATIONSHIPS');

Line 348: FROM csm_hz_relationships_acc chra

344: AND hcp.primary_flag = 'Y'
345: AND tcpa.deleted_flag = 'N'
346: AND tcpa.party_site_id IN (-1,-2)
347: AND NOT EXISTS ( SELECT 1
348: FROM csm_hz_relationships_acc chra
349: WHERE chra.relationship_id = hpr.relationship_id
350: AND chra.user_id = tcpa.user_id
351: );
352:

Line 553: FROM csm_hz_relationships_acc chra

549: AND hcp.primary_flag = 'Y'
550: AND tcpa.deleted_flag = 'Y'
551: AND tcpa.party_site_id IN (-1,-2)
552: AND EXISTS ( SELECT 1
553: FROM csm_hz_relationships_acc chra
554: WHERE chra.relationship_id = hpr.relationship_id
555: AND chra.user_id = tcpa.user_id
556: );
557:

Line 685: --call the CSM_ACC_PKG to delete the record from csm_hz_relationships_acc table

681: ,P_PK1_NUM_VALUE => l_contacts_id_tbl(i)
682: ,P_USER_ID => l_user_id_tbl(i)
683: );
684:
685: --call the CSM_ACC_PKG to delete the record from csm_hz_relationships_acc table
686:
687: CSM_ACC_PKG.Delete_Acc
688: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name11
689: ,P_ACC_TABLE_NAME => g_acc_table_name11

Line 1604: --call the CSM_ACC_PKG to insert into csm_hz_relationships_acc table

1600: ,P_PK1_NUM_VALUE => l_contacts_id_tbl(i)
1601: ,P_USER_ID => l_user_id_tbl(i)
1602: );
1603:
1604: --call the CSM_ACC_PKG to insert into csm_hz_relationships_acc table
1605:
1606: CSM_ACC_PKG.Insert_Acc
1607: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name11
1608: ,P_ACC_TABLE_NAME => g_acc_table_name11