eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 179: l_tab_rqmt_line_id ASG_DOWNLOAD.ACCESS_LIST;

175: AND crld.source_id = res.RESERVATION_ID
176: AND crld.SOURCE_TYPE='RES'
177: AND res.LAST_UPDATE_DATE >= b_last_run_date ;
178:
179: l_tab_rqmt_line_id ASG_DOWNLOAD.ACCESS_LIST;
180: l_tab_oe_line_id ASG_DOWNLOAD.ACCESS_LIST;
181: l_tab_res_id ASG_DOWNLOAD.ACCESS_LIST;
182: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
183: g_debug_level NUMBER;

Line 180: l_tab_oe_line_id ASG_DOWNLOAD.ACCESS_LIST;

176: AND crld.SOURCE_TYPE='RES'
177: AND res.LAST_UPDATE_DATE >= b_last_run_date ;
178:
179: l_tab_rqmt_line_id ASG_DOWNLOAD.ACCESS_LIST;
180: l_tab_oe_line_id ASG_DOWNLOAD.ACCESS_LIST;
181: l_tab_res_id ASG_DOWNLOAD.ACCESS_LIST;
182: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
183: g_debug_level NUMBER;
184: l_dummy BOOLEAN;

Line 181: l_tab_res_id ASG_DOWNLOAD.ACCESS_LIST;

177: AND res.LAST_UPDATE_DATE >= b_last_run_date ;
178:
179: l_tab_rqmt_line_id ASG_DOWNLOAD.ACCESS_LIST;
180: l_tab_oe_line_id ASG_DOWNLOAD.ACCESS_LIST;
181: l_tab_res_id ASG_DOWNLOAD.ACCESS_LIST;
182: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
183: g_debug_level NUMBER;
184: l_dummy BOOLEAN;
185: l_current_run_date DATE;

Line 182: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

178:
179: l_tab_rqmt_line_id ASG_DOWNLOAD.ACCESS_LIST;
180: l_tab_oe_line_id ASG_DOWNLOAD.ACCESS_LIST;
181: l_tab_res_id ASG_DOWNLOAD.ACCESS_LIST;
182: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
183: g_debug_level NUMBER;
184: l_dummy BOOLEAN;
185: l_current_run_date DATE;
186:

Line 214: l_dummy := asg_download.mark_dirty(

210:
211: FOR i IN 1..l_tab_oe_line_id.COUNT
212: LOOP
213: -- mark dirty the record
214: l_dummy := asg_download.mark_dirty(
215: p_pub_item => 'CSM_ORDER_LINES'
216: , p_accessid => l_tab_oe_line_id(i)
217: , p_userid => l_tab_user_id(i)
218: , p_dml => 'U'

Line 225: l_dummy := asg_download.mark_dirty(

221:
222: OPEN c_hdr_id(l_tab_oe_line_id(i));
223: FETCH c_hdr_id INTO l_hrd_id;
224: CLOSE c_hdr_id;
225: l_dummy := asg_download.mark_dirty(
226: p_pub_item => 'CSM_ORDER_HEADERS'
227: , p_accessid => l_hrd_id
228: , p_userid => l_tab_user_id(i)
229: , p_dml => 'U'

Line 252: l_dummy := asg_download.mark_dirty(

248:
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'

Line 293: l_dummy := asg_download.mark_dirty(

289: PROCEDURE doMarkDirty(p_pi IN VARCHAR2,p_a IN NUMBER,p_u IN NUMBER,p_d IN VARCHAR2)
290: IS
291: l_dummy BOOLEAN;
292: BEGIN
293: l_dummy := asg_download.mark_dirty(
294: p_pub_item => p_pi
295: , p_accessid => p_a
296: , p_userid => p_u
297: , p_dml => p_d

Line 319: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

315: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE :=p_rld;
316: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
317: l_found BOOLEAN:=false;
318: l_access_id NUMBER;
319: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
320: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
321: l_tab_item_id ASG_DOWNLOAD.ACCESS_LIST;
322: l_tab_org_id ASG_DOWNLOAD.ACCESS_LIST;
323: l_tab_old_src_id ASG_DOWNLOAD.ACCESS_LIST;

Line 320: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

316: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
317: l_found BOOLEAN:=false;
318: l_access_id NUMBER;
319: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
320: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
321: l_tab_item_id ASG_DOWNLOAD.ACCESS_LIST;
322: l_tab_org_id ASG_DOWNLOAD.ACCESS_LIST;
323: l_tab_old_src_id ASG_DOWNLOAD.ACCESS_LIST;
324: l_upd_dml_t VARCHAR2(10):=p_DML_t;

Line 321: l_tab_item_id ASG_DOWNLOAD.ACCESS_LIST;

317: l_found BOOLEAN:=false;
318: l_access_id NUMBER;
319: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
320: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
321: l_tab_item_id ASG_DOWNLOAD.ACCESS_LIST;
322: l_tab_org_id ASG_DOWNLOAD.ACCESS_LIST;
323: l_tab_old_src_id ASG_DOWNLOAD.ACCESS_LIST;
324: l_upd_dml_t VARCHAR2(10):=p_DML_t;
325: l_header_id NUMBER;

Line 322: l_tab_org_id ASG_DOWNLOAD.ACCESS_LIST;

318: l_access_id NUMBER;
319: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
320: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
321: l_tab_item_id ASG_DOWNLOAD.ACCESS_LIST;
322: l_tab_org_id ASG_DOWNLOAD.ACCESS_LIST;
323: l_tab_old_src_id ASG_DOWNLOAD.ACCESS_LIST;
324: l_upd_dml_t VARCHAR2(10):=p_DML_t;
325: l_header_id NUMBER;
326: BEGIN

Line 323: l_tab_old_src_id ASG_DOWNLOAD.ACCESS_LIST;

319: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
320: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
321: l_tab_item_id ASG_DOWNLOAD.ACCESS_LIST;
322: l_tab_org_id ASG_DOWNLOAD.ACCESS_LIST;
323: l_tab_old_src_id ASG_DOWNLOAD.ACCESS_LIST;
324: l_upd_dml_t VARCHAR2(10):=p_DML_t;
325: l_header_id NUMBER;
326: BEGIN
327: CSM_UTIL_PKG.LOG('Entering REQ_LINE_DTL_IUD for req_line_dtl_id:' || p_rld||' with DML:'||p_DML_t,

Line 373: l_dummy := asg_download.mark_dirty(

369:
370: SELECT ACCESS_ID,USER_ID,ITEM_ID,ORG_ID BULK COLLECT INTO l_tab_access_id,l_tab_user_id,l_tab_item_id,l_tab_org_id
371: FROM CSM_REQ_LINE_DETAILS_ACC WHERE req_line_detail_id=l_req_line_detail_id;
372:
373: l_dummy := asg_download.mark_dirty(
374: P_PUB_ITEM => 'CSM_REQ_LINE_DETAILS'
375: , p_accessList => l_tab_access_id
376: , p_userid_list => l_tab_user_id
377: , p_dml_type => 'I'