DBA Data[Home] [Help]

APPS.CSM_PARTY_DATA_EVENT_PKG dependencies on HZ_RELATIONSHIPS

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 79: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_RELATIONSHIPS');

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');
80:
81: PROCEDURE REFRESH_ACC ( x_return_status OUT NOCOPY VARCHAR2,
82: x_error_message OUT NOCOPY VARCHAR2
83: )

Line 99: TYPE l_relationship_id_tbl_type IS TABLE OF HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE INDEX BY BINARY_INTEGER;

95: TYPE l_counter_id_tbl_type IS TABLE OF csm_counters_acc.counter_id%TYPE INDEX BY BINARY_INTEGER;
96: TYPE l_counter_value_id_tbl_type IS TABLE OF csm_counter_values_acc.counter_value_id%TYPE INDEX BY BINARY_INTEGER;
97: TYPE l_counter_prop_val_tbl_type IS TABLE OF csm_counter_prop_values_acc.counter_prop_value_id%TYPE INDEX BY BINARY_INTEGER;
98: TYPE l_counter_prp_id_tbl_type IS TABLE OF csm_counter_properties_acc.counter_property_id%TYPE INDEX BY BINARY_INTEGER;
99: TYPE l_relationship_id_tbl_type IS TABLE OF HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE INDEX BY BINARY_INTEGER;
100: TYPE l_direct_flag_tbl_type IS TABLE OF HZ_RELATIONSHIPS.DIRECTIONAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
101: TYPE ver_lab_Tab IS TABLE OF csi_i_version_labels.version_label%TYPE INDEX BY BINARY_INTEGER;
102:
103: l_party_id_tbl l_party_id_tbl_type;

Line 100: TYPE l_direct_flag_tbl_type IS TABLE OF HZ_RELATIONSHIPS.DIRECTIONAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

96: TYPE l_counter_value_id_tbl_type IS TABLE OF csm_counter_values_acc.counter_value_id%TYPE INDEX BY BINARY_INTEGER;
97: TYPE l_counter_prop_val_tbl_type IS TABLE OF csm_counter_prop_values_acc.counter_prop_value_id%TYPE INDEX BY BINARY_INTEGER;
98: TYPE l_counter_prp_id_tbl_type IS TABLE OF csm_counter_properties_acc.counter_property_id%TYPE INDEX BY BINARY_INTEGER;
99: TYPE l_relationship_id_tbl_type IS TABLE OF HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE INDEX BY BINARY_INTEGER;
100: TYPE l_direct_flag_tbl_type IS TABLE OF HZ_RELATIONSHIPS.DIRECTIONAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
101: TYPE ver_lab_Tab IS TABLE OF csi_i_version_labels.version_label%TYPE INDEX BY BINARY_INTEGER;
102:
103: l_party_id_tbl l_party_id_tbl_type;
104: l_user_id_tbl l_user_id_tbl_type;

Line 338: FROM hz_relationships hpr

334: , tcpa.user_id
335: , hpr.relationship_id
336: , hpr.directional_flag
337: , hpr.subject_id
338: FROM hz_relationships hpr
339: , csm_party_assignment tcpa
340: , hz_contact_points hcp
341: WHERE hpr.object_id = tcpa.party_id
342: AND hpr.party_id = hcp.owner_table_id

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 543: FROM hz_relationships hpr

539: , tcpa.user_id
540: , hpr.relationship_id
541: , hpr.directional_flag
542: , hpr.subject_id
543: FROM hz_relationships hpr
544: , csm_party_assignment tcpa
545: , hz_contact_points hcp
546: WHERE hpr.object_id = tcpa.party_id
547: AND hpr.party_id = hcp.owner_table_id

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