APPS.CSI_ACCT_MERGE_PKG dependencies on HZ_PARTY_SITES

Line 385: IF l_install_location_type_code = 'HZ_PARTY_SITES' THEN

381: FROM CSI_ITEM_INSTANCES WHERE INSTANCE_ID=INSTANCE_ID_LIST(I);
382:
383: IF NUM_COL5_ORIG_LIST(I) IS NOT NULL THEN
384:
385: IF l_install_location_type_code = 'HZ_PARTY_SITES' THEN
386:
387: csi_t_gen_utility_pvt.add('INSTALL_CUSTOMER_SITE_ID_LIST - ' || INSTALL_CUSTOMER_SITE_ID_LIST(I));
388:
389: SELECT CUST_ACCT_SITE_ID

Line 397: IF l_location_type_code = 'HZ_PARTY_SITES' THEN

393: SELECT PARTY_SITE_ID INTO NUM_COL5_NEW_LIST(I)
394: FROM HZ_CUST_ACCT_SITES_ALL
395: WHERE CUST_ACCT_SITE_ID= NUM_COL6_NEW_LIST(I);
396:
397: IF l_location_type_code = 'HZ_PARTY_SITES' THEN
398:
399: NUM_COL4_NEW_LIST(I):= NUM_COL5_NEW_LIST(I);
400:
401: ELSIF l_location_type_code = 'HZ_LOCATIONS' THEN

Line 404: FROM HZ_PARTY_SITES

400:
401: ELSIF l_location_type_code = 'HZ_LOCATIONS' THEN
402: csi_t_gen_utility_pvt.add('NUM_COL5_NEW_LIST - ' || NUM_COL5_NEW_LIST(I));
403: SELECT LOCATION_ID INTO NUM_COL4_NEW_LIST(I)
404: FROM HZ_PARTY_SITES
405: WHERE PARTY_SITE_ID = NUM_COL5_NEW_LIST(I);
406:
407: END IF;
408:

Line 423: IF l_location_type_code = 'HZ_PARTY_SITES' THEN

419: WHERE CUST_ACCT_SITE_ID= NUM_COL6_NEW_LIST(I);
420:
421: csi_t_gen_utility_pvt.add('Party Site Id : ' || l_party_site_id);
422: csi_t_gen_utility_pvt.add('Location Type Code : ' || l_location_type_code);
423: IF l_location_type_code = 'HZ_PARTY_SITES' THEN
424:
425: NUM_COL4_NEW_LIST(I):= l_party_site_id;
426: csi_t_gen_utility_pvt.add('l_party_site_id 2 : ' || l_party_site_id);
427: SELECT LOCATION_ID INTO NUM_COL5_NEW_LIST(I)

Line 428: FROM HZ_PARTY_SITES

424:
425: NUM_COL4_NEW_LIST(I):= l_party_site_id;
426: csi_t_gen_utility_pvt.add('l_party_site_id 2 : ' || l_party_site_id);
427: SELECT LOCATION_ID INTO NUM_COL5_NEW_LIST(I)
428: FROM HZ_PARTY_SITES
429: WHERE PARTY_SITE_ID = l_party_site_id;
430:
431: ELSIF l_location_type_code = 'HZ_LOCATIONS' THEN
432: csi_t_gen_utility_pvt.add('l_party_site_id 3 : ' || l_party_site_id);

Line 435: FROM HZ_PARTY_SITES

431: ELSIF l_location_type_code = 'HZ_LOCATIONS' THEN
432: csi_t_gen_utility_pvt.add('l_party_site_id 3 : ' || l_party_site_id);
433: SELECT LOCATION_ID,LOCATION_ID
434: INTO NUM_COL5_NEW_LIST(I), NUM_COL4_NEW_LIST(I)
435: FROM HZ_PARTY_SITES
436: WHERE PARTY_SITE_ID = l_party_site_id;
437:
438: END IF;
439: csi_t_gen_utility_pvt.add('NUM_COL4_NEW_LIST : ' || NUM_COL4_NEW_LIST(I));