[Home] [Help]
169: SELECT acc.user_id
170: , res.reservation_id
171: FROM csm_req_lines_acc acc
172: , CSP_REQ_LINE_DETAILS crld
173: , MTL_RESERVATIONS res
174: WHERE acc.requirement_line_id = crld.requirement_line_id
175: AND crld.source_id = res.RESERVATION_ID
176: AND crld.SOURCE_TYPE='RES'
177: AND res.LAST_UPDATE_DATE >= b_last_run_date ;
249: FOR i IN 1..l_tab_res_id.COUNT
250: LOOP
251: -- mark dirty the record
252: l_dummy := asg_download.mark_dirty(
253: p_pub_item => 'CSM_MTL_RESERVATIONS'
254: , p_accessid => l_tab_res_id(i)
255: , p_userid => l_tab_user_id(i)
256: , p_dml => 'U'
257: , p_timestamp => l_current_run_date
348: and b.req_line_detail_id=l_req_line_detail_id
349: and au.user_id=a.user_id
350: UNION ALL
351: select b.req_line_detail_id,a.user_id,c.inventory_item_id,b.requirement_line_id,b.source_id
352: from csm_req_lines_acc a, csp_req_line_details b , mtl_reservations c,asg_user au
353: where a.requirement_line_id=b.requirement_line_id
354: and b.source_type= 'RES' and b.source_id=c.reservation_id
355: and b.req_line_detail_id=l_req_line_detail_id
356: and au.user_id=a.user_id ) b,
399: CSM_UTIL_PKG.LOG('Update Acc src and Mark Delete for old '||l_src||':'||l_tab_old_src_id(I)||' for user_id'||l_tab_user_id(I),
400: 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD',FND_LOG.LEVEL_PROCEDURE);
401:
402: IF l_src='RES' THEN
403: doMarkDirty('CSM_MTL_RESERVATIONS',l_tab_old_src_id(I),l_tab_user_id(I),'D');
404: ELSIF l_src='IO' THEN
405: doMarkDirty('CSM_ORDER_LINES',l_tab_old_src_id(I),l_tab_user_id(I),'D');
406:
407: OPEN c_hdr_id(l_tab_old_src_id(I));
418: END IF;
419:
420: IF l_src='RES' THEN
421:
422: doMarkDirty('CSM_MTL_RESERVATIONS',l_src_id,l_tab_user_id(I),l_upd_dml_t);
423:
424: ELSIF l_src='IO' THEN
425:
426: doMarkDirty('CSM_ORDER_LINES',l_src_id,l_tab_user_id(I),l_upd_dml_t);