DBA Data[Home] [Help]

APPS.CSM_HZ_LOCATION_PKG dependencies on CSM_TASKS_INQ

Line 219: UPDATE CSM_TASKS_INQ

215: CSM_UTIL_PKG.log( 'New Party Site_id: ' ||l_party_site_id ,'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
216:
217: --Update the Task when the Party site id
218: --This has to be done for all cases as Client is providing only Location id
219: UPDATE CSM_TASKS_INQ
220: SET LOCATION_ID = l_party_site_id
221: WHERE tranid$$ = p_record.tranid$$
222: AND clid$$cs = p_record.CLID$$CS
223: AND location_id = p_record.location_id;

Line 340: FROM CSM_TASKS_INQ

336: CSM_UTIL_PKG.log( 'Deferring dependent records for Locaton ID ' || p_loc_id ,'CSM_HZ_LOCATION_PKG.DEFER_DEPENDENT_RECORDS',FND_LOG.LEVEL_PROCEDURE);
337:
338: --PERSONAL Tasks
339: FOR rec in (SELECT TASK_ID ,SEQNO$$,DMLTYPE$$
340: FROM CSM_TASKS_INQ
341: WHERE tranid$$ = p_tranid
342: AND clid$$cs = p_user_name
343: AND location_id = p_loc_id)
344: LOOP