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_UNDO_PKG dependencies on ASG_DOWNLOAD

Line 302: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => 'CSM_TASK_ASSIGNMENTS',

298: g_object_name || '.APPLY_UNDO',FND_LOG.LEVEL_ERROR );
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300: ELSE
301: --Task Assignment Markdirty
302: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => 'CSM_TASK_ASSIGNMENTS',
303: p_accessid => l_access_id,
304: p_userid => l_user_id,
305: p_dml => asg_download.upd,
306: p_timestamp => sysdate);

Line 305: p_dml => asg_download.upd,

301: --Task Assignment Markdirty
302: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => 'CSM_TASK_ASSIGNMENTS',
303: p_accessid => l_access_id,
304: p_userid => l_user_id,
305: p_dml => asg_download.upd,
306: p_timestamp => sysdate);
307:
308: END IF;
309: CSM_UTIL_PKG.REJECT_RECORD

Line 380: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_task_pub_name,

376: FETCH c_get_task_from_acc INTO l_access_id;
377: CLOSE c_get_task_from_acc;
378: --Check if the task assignment has been changed to another user before this UNDO
379: IF l_markdirty_all = 'Y' AND l_access_id IS NOT NULL THEN
380: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_task_pub_name,
381: p_accessid => l_access_id,
382: p_userid => l_user_id,
383: p_dml => asg_download.upd,
384: p_timestamp => sysdate);

Line 383: p_dml => asg_download.upd,

379: IF l_markdirty_all = 'Y' AND l_access_id IS NOT NULL THEN
380: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_task_pub_name,
381: p_accessid => l_access_id,
382: p_userid => l_user_id,
383: p_dml => asg_download.upd,
384: p_timestamp => sysdate);
385: END IF; --Task Markdirty
386: CSM_UTIL_PKG.REJECT_RECORD
387: ( l_user_name

Line 430: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_sr_pub_name,

426: FETCH c_get_incident_from_acc INTO l_access_id;
427: CLOSE c_get_incident_from_acc;
428:
429: IF l_markdirty_all = 'Y' AND l_access_id IS NOT NULL THEN
430: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_sr_pub_name,
431: p_accessid => l_access_id,
432: p_userid => l_user_id,
433: p_dml => asg_download.upd,
434: p_timestamp => sysdate);

Line 433: p_dml => asg_download.upd,

429: IF l_markdirty_all = 'Y' AND l_access_id IS NOT NULL THEN
430: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_sr_pub_name,
431: p_accessid => l_access_id,
432: p_userid => l_user_id,
433: p_dml => asg_download.upd,
434: p_timestamp => sysdate);
435: END IF;
436: --Reject the record as it not needed for upload anymore
437: CSM_UTIL_PKG.REJECT_RECORD

Line 472: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_dbh_pub_name,

468: FETCH c_get_debrief_header INTO l_access_id,l_debrief_header_id,l_tran_id,l_sequence;
469: CLOSE c_get_debrief_header;
470: IF l_debrief_header_id IS NOT NULL THEN
471: IF l_markdirty_all = 'Y' AND l_access_id IS NOT NULL THEN
472: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_dbh_pub_name,
473: p_accessid => l_access_id,
474: p_userid => l_user_id,
475: p_dml => asg_download.upd,
476: p_timestamp => sysdate);

Line 475: p_dml => asg_download.upd,

471: IF l_markdirty_all = 'Y' AND l_access_id IS NOT NULL THEN
472: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_dbh_pub_name,
473: p_accessid => l_access_id,
474: p_userid => l_user_id,
475: p_dml => asg_download.upd,
476: p_timestamp => sysdate);
477: END IF;
478: --Reject the record as it not needed for upload anymore
479: CSM_UTIL_PKG.REJECT_RECORD

Line 496: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_dble_pub_name,

492: --Debrief Expense Markdirty
493: FOR r_get_debrief_expenses IN c_get_debrief_expenses(l_task_assignment_id, l_user_id,l_user_name) LOOP
494: IF r_get_debrief_expenses.DEBRIEF_LINE_ID IS NOT NULL THEN
495: IF l_markdirty_all = 'Y' AND r_get_debrief_expenses.ACCESS_ID IS NOT NULL THEN
496: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_dble_pub_name,
497: p_accessid => r_get_debrief_expenses.ACCESS_ID,
498: p_userid => l_user_id,
499: p_dml => asg_download.upd,
500: p_timestamp => sysdate);

Line 499: p_dml => asg_download.upd,

495: IF l_markdirty_all = 'Y' AND r_get_debrief_expenses.ACCESS_ID IS NOT NULL THEN
496: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_dble_pub_name,
497: p_accessid => r_get_debrief_expenses.ACCESS_ID,
498: p_userid => l_user_id,
499: p_dml => asg_download.upd,
500: p_timestamp => sysdate);
501: END IF;
502: --Reject the record as it not needed for upload anymore
503: CSM_UTIL_PKG.REJECT_RECORD

Line 521: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_dbll_pub_name,

517: --Debrief Labor Markdirty
518: FOR r_get_debrief_labor IN c_get_debrief_labor(l_task_assignment_id, l_user_id,l_user_name) LOOP
519: IF r_get_debrief_labor.DEBRIEF_LINE_ID IS NOT NULL THEN
520: IF l_markdirty_all = 'Y' AND r_get_debrief_labor.ACCESS_ID IS NOT NULL THEN
521: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_dbll_pub_name,
522: p_accessid => r_get_debrief_labor.ACCESS_ID,
523: p_userid => l_user_id,
524: p_dml => asg_download.upd,
525: p_timestamp => sysdate);

Line 524: p_dml => asg_download.upd,

520: IF l_markdirty_all = 'Y' AND r_get_debrief_labor.ACCESS_ID IS NOT NULL THEN
521: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_dbll_pub_name,
522: p_accessid => r_get_debrief_labor.ACCESS_ID,
523: p_userid => l_user_id,
524: p_dml => asg_download.upd,
525: p_timestamp => sysdate);
526: END IF;
527: --Reject the record as it not needed for upload anymore
528: CSM_UTIL_PKG.REJECT_RECORD

Line 546: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_dblp_pub_name,

542: --Debrief Parts Markdirty
543: FOR r_get_debrief_parts IN c_get_debrief_parts(l_task_assignment_id, l_user_id,l_user_name) LOOP
544: IF r_get_debrief_parts.DEBRIEF_LINE_ID IS NOT NULL THEN
545: IF l_markdirty_all = 'Y' AND r_get_debrief_parts.ACCESS_ID IS NOT NULL THEN
546: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_dblp_pub_name,
547: p_accessid => r_get_debrief_parts.ACCESS_ID,
548: p_userid => l_user_id,
549: p_dml => asg_download.upd,
550: p_timestamp => sysdate);

Line 549: p_dml => asg_download.upd,

545: IF l_markdirty_all = 'Y' AND r_get_debrief_parts.ACCESS_ID IS NOT NULL THEN
546: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_dblp_pub_name,
547: p_accessid => r_get_debrief_parts.ACCESS_ID,
548: p_userid => l_user_id,
549: p_dml => asg_download.upd,
550: p_timestamp => sysdate);
551: END IF;
552: --Reject the record as it not needed for upload anymore
553: CSM_UTIL_PKG.REJECT_RECORD

Line 577: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_reqh_pub_name,

573: FETCH c_get_req_header INTO l_access_id,l_req_header_id,l_tran_id,l_sequence;
574: CLOSE c_get_req_header;
575: IF l_req_header_id IS NOT NULL THEN
576: IF l_markdirty_all = 'Y' AND l_access_id IS NOT NULL THEN
577: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_reqh_pub_name,
578: p_accessid => l_access_id,
579: p_userid => l_user_id,
580: p_dml => asg_download.upd,
581: p_timestamp => sysdate);

Line 580: p_dml => asg_download.upd,

576: IF l_markdirty_all = 'Y' AND l_access_id IS NOT NULL THEN
577: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_reqh_pub_name,
578: p_accessid => l_access_id,
579: p_userid => l_user_id,
580: p_dml => asg_download.upd,
581: p_timestamp => sysdate);
582: END IF;
583: --Reject the record as it not needed for upload anymore
584: CSM_UTIL_PKG.REJECT_RECORD

Line 601: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_reql_pub_name,

597: --Debrief Requriement line Markdirty
598: FOR r_get_req_line IN c_get_req_line(l_req_header_id , l_user_id,l_user_name) LOOP
599: IF r_get_req_line.requirement_line_id IS NOT NULL THEN
600: IF l_markdirty_all = 'Y' AND r_get_req_line.ACCESS_ID IS NOT NULL THEN
601: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_reql_pub_name,
602: p_accessid => r_get_req_line.ACCESS_ID,
603: p_userid => l_user_id,
604: p_dml => asg_download.upd,
605: p_timestamp => sysdate);

Line 604: p_dml => asg_download.upd,

600: IF l_markdirty_all = 'Y' AND r_get_req_line.ACCESS_ID IS NOT NULL THEN
601: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_reql_pub_name,
602: p_accessid => r_get_req_line.ACCESS_ID,
603: p_userid => l_user_id,
604: p_dml => asg_download.upd,
605: p_timestamp => sysdate);
606: END IF;
607: --Reject the record as it not needed for upload anymore
608: CSM_UTIL_PKG.REJECT_RECORD

Line 626: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_notes_pub_name,

622: --Notes Markdirty
623: FOR r_get_notes IN c_get_notes(l_task_id, l_incident_id, l_debrief_header_id, l_user_id,l_user_name) LOOP
624: IF r_get_notes.jtf_note_id IS NOT NULL THEN
625: IF l_markdirty_all = 'Y' AND r_get_notes.access_id IS NOT NULL THEN
626: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_notes_pub_name,
627: p_accessid => r_get_notes.access_id,
628: p_userid => l_user_id,
629: p_dml => asg_download.upd,
630: p_timestamp => sysdate);

Line 629: p_dml => asg_download.upd,

625: IF l_markdirty_all = 'Y' AND r_get_notes.access_id IS NOT NULL THEN
626: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_notes_pub_name,
627: p_accessid => r_get_notes.access_id,
628: p_userid => l_user_id,
629: p_dml => asg_download.upd,
630: p_timestamp => sysdate);
631: END IF;
632: --Reject the record as it not needed for upload anymore
633: CSM_UTIL_PKG.REJECT_RECORD

Line 651: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_lobs_pub_name,

647: --Notes Markdirty
648: FOR r_get_lobs IN c_get_lobs(l_task_id, l_incident_id, l_user_id,l_user_name) LOOP
649: IF r_get_lobs.file_id IS NOT NULL THEN
650: IF l_markdirty_all = 'Y' AND r_get_lobs.access_id IS NOT NULL THEN
651: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_lobs_pub_name,
652: p_accessid => r_get_lobs.access_id,
653: p_userid => l_user_id,
654: p_dml => asg_download.upd,
655: p_timestamp => sysdate);

Line 654: p_dml => asg_download.upd,

650: IF l_markdirty_all = 'Y' AND r_get_lobs.access_id IS NOT NULL THEN
651: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => l_lobs_pub_name,
652: p_accessid => r_get_lobs.access_id,
653: p_userid => l_user_id,
654: p_dml => asg_download.upd,
655: p_timestamp => sysdate);
656: END IF;
657: --Reject the record as it not needed for upload anymore
658: CSM_UTIL_PKG.REJECT_RECORD