DBA Data[Home] [Help]

APPS.CSM_PARTY_DATA_EVENT_PKG dependencies on HZ_LOCATIONS

Line 18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC';

14: g_pk2_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';
15: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
16: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');
17:
18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC';
19: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';
20: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LOCATION_ID';
21: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
22: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');

Line 19: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';

15: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
16: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');
17:
18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC';
19: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';
20: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LOCATION_ID';
21: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
22: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');
23:

Line 22: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');

18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC';
19: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';
20: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LOCATION_ID';
21: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
22: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');
23:
24: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
25: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
26: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';

Line 91: TYPE l_location_id_tbl_type IS TABLE OF csm_hz_locations_acc.location_id%TYPE INDEX BY BINARY_INTEGER;

87:
88: TYPE l_party_id_tbl_type IS TABLE OF csm_parties_acc.party_id%TYPE INDEX BY BINARY_INTEGER;
89: TYPE l_user_id_tbl_type IS TABLE OF csm_parties_acc.user_id%TYPE INDEX BY BINARY_INTEGER;
90: TYPE l_party_site_id_tbl_type IS TABLE OF csm_party_sites_acc.party_site_id%TYPE INDEX BY BINARY_INTEGER;
91: TYPE l_location_id_tbl_type IS TABLE OF csm_hz_locations_acc.location_id%TYPE INDEX BY BINARY_INTEGER;
92: TYPE l_instance_id_tbl_type IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
93: TYPE l_contacts_id_tbl_type IS TABLE OF csm_sr_contacts_acc.sr_contact_point_id%TYPE INDEX BY BINARY_INTEGER;
94: TYPE l_cust_acct_id_tbl_type IS TABLE OF csm_hz_cust_accounts_acc.cust_account_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;

Line 172: FROM csm_hz_locations_acc chla

168: WHERE cpsa.party_site_id = hps.party_site_id
169: AND cpsa.user_id = tcpa.user_id
170: )
171: AND NOT EXISTS ( SELECT 1
172: FROM csm_hz_locations_acc chla
173: WHERE chla.location_id = hps.location_id
174: AND chla.user_id = tcpa.user_id
175: );
176:

Line 220: , hz_locations hz

216: , civ.version_label
217: , CIR.OBJECT_ID
218: FROM csi_item_instances cii
219: , csm_party_assignment cpa
220: , hz_locations hz
221: , csi_i_version_labels civ
222: , CSI_II_RELATIONSHIPS CIR
223: WHERE cii.owner_party_id = cpa.party_id
224: AND cii.location_id = hz.location_id

Line 225: AND cii.location_type_code = 'HZ_LOCATIONS'

221: , csi_i_version_labels civ
222: , CSI_II_RELATIONSHIPS CIR
223: WHERE cii.owner_party_id = cpa.party_id
224: AND cii.location_id = hz.location_id
225: AND cii.location_type_code = 'HZ_LOCATIONS'
226: AND cpa.party_site_id IN (-1,-2)
227: AND cpa.deleted_flag = 'N'
228: AND cii.instance_id = civ.instance_id(+)
229: AND (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(civ.active_start_date,SYSDATE))

Line 411: FROM csm_hz_locations_acc chla

407: WHERE cpsa.party_site_id = hps.party_site_id
408: AND cpsa.user_id = tcpa.user_id
409: )
410: AND EXISTS ( SELECT 1
411: FROM csm_hz_locations_acc chla
412: WHERE chla.location_id = hps.location_id
413: AND chla.user_id = tcpa.user_id
414: );
415:

Line 448: , hz_locations hz

444: , cii.inventory_item_id
445: , cii.last_vld_organization_id
446: FROM csi_item_instances cii
447: , csm_party_assignment cpa
448: , hz_locations hz
449: WHERE cii.owner_party_id = cpa.party_id
450: AND cii.location_id = hz.location_id
451: AND cii.location_type_code = 'HZ_LOCATIONS'
452: AND cpa.party_site_id IN (-1,-2)

Line 451: AND cii.location_type_code = 'HZ_LOCATIONS'

447: , csm_party_assignment cpa
448: , hz_locations hz
449: WHERE cii.owner_party_id = cpa.party_id
450: AND cii.location_id = hz.location_id
451: AND cii.location_type_code = 'HZ_LOCATIONS'
452: AND cpa.party_site_id IN (-1,-2)
453: AND cpa.deleted_flag = 'Y'
454: AND EXISTS ( SELECT 1
455: FROM csm_item_instances_acc ciia

Line 990: CSM_UTIL_PKG.LOG('Deleting Party Sites and HZ Locations -START ', 'CSM_PARTY_DATA_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);

986: END LOOP;
987:
988: CLOSE l_counter_prop_value_del_csr;
989: CSM_UTIL_PKG.LOG('Deleting Counter Property Values-END ', 'CSM_PARTY_DATA_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
990: CSM_UTIL_PKG.LOG('Deleting Party Sites and HZ Locations -START ', 'CSM_PARTY_DATA_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
991: OPEN l_party_sites_del_csr;
992:
993: LOOP
994:

Line 1056: --call the CSM_ACC_PKG to delete the record from csm_hz_locations_acc table

1052: COMMIT;
1053:
1054: FOR i IN l_location_id_tbl.FIRST..l_location_id_tbl.LAST LOOP
1055:
1056: --call the CSM_ACC_PKG to delete the record from csm_hz_locations_acc table
1057:
1058: CSM_ACC_PKG.Delete_Acc
1059: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
1060: ,P_ACC_TABLE_NAME => g_acc_table_name2

Line 1077: CSM_UTIL_PKG.LOG('Deleting Party Sites and HZ Locations -END ', 'CSM_PARTY_DATA_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);

1073:
1074: END LOOP;
1075:
1076: CLOSE l_party_sites_del_csr;
1077: CSM_UTIL_PKG.LOG('Deleting Party Sites and HZ Locations -END ', 'CSM_PARTY_DATA_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
1078: CSM_UTIL_PKG.LOG('Deleting Parties -START ', 'CSM_PARTY_DATA_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
1079: OPEN l_party_del_csr;
1080:
1081: LOOP

Line 1240: --call the CSM_ACC_PKG to insert into csm_hz_locations_acc table

1236: COMMIT;
1237:
1238: FOR i IN l_location_id_tbl.FIRST..l_location_id_tbl.LAST LOOP
1239:
1240: --call the CSM_ACC_PKG to insert into csm_hz_locations_acc table
1241:
1242: CSM_ACC_PKG.Insert_Acc
1243: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
1244: ,P_ACC_TABLE_NAME => g_acc_table_name2