DBA Data[Home] [Help]

APPS.CSL_JTF_TASKS_ACC_PKG dependencies on CSL_HZ_PARTY_SITES_ACC_PKG

Line 273: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE( p_party_site_id => r_task.address_id

269: IF c_task%FOUND THEN
270: --PARTY_SITE
271: --fix for bug 2472668: check if address_id is null
272: IF r_task.address_id IS NOT NULL THEN
273: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE( p_party_site_id => r_task.address_id
274: , p_resource_id => p_resource_id );
275: END IF;
276:
277:

Line 397: CSL_HZ_PARTY_SITES_ACC_PKG.DELETE_PARTY_SITE( p_party_site_id => r_task.ADDRESS_ID

393: FETCH c_task INTO r_task;
394: IF c_task%FOUND THEN
395: --fix for bug 2472668: check if address_id is null
396: IF r_task.address_id IS NOT NULL THEN
397: CSL_HZ_PARTY_SITES_ACC_PKG.DELETE_PARTY_SITE( p_party_site_id => r_task.ADDRESS_ID
398: , p_resource_id => p_resource_id );
399: END IF;
400:
401: --Bug 3724142

Line 774: CSL_HZ_PARTY_SITES_ACC_PKG.CHANGE_PARTY_SITE( g_cached_task_address_id

770: );
771: IF l_address_changed = TRUE THEN
772: /*Address changed check if there was an address*/
773: IF g_cached_task_address_id IS NOT NULL THEN
774: CSL_HZ_PARTY_SITES_ACC_PKG.CHANGE_PARTY_SITE( g_cached_task_address_id
775: , l_address_id
776: , l_tab_resource_id(i));
777: ELSE
778: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE( l_address_id

Line 778: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE( l_address_id

774: CSL_HZ_PARTY_SITES_ACC_PKG.CHANGE_PARTY_SITE( g_cached_task_address_id
775: , l_address_id
776: , l_tab_resource_id(i));
777: ELSE
778: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE( l_address_id
779: , l_tab_resource_id(i));
780: END IF;--g_cached not null
781: END IF;--addess changed
782: END LOOP;