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

Line 93: l_userlist asg_download.user_list;

89: --Variable Declarations
90: l_jtf_note_id jtf_notes_b.jtf_note_id%TYPE;
91: l_user_found boolean;
92: l_source_object_code jtf_notes_b.source_object_code%TYPE;
93: l_userlist asg_download.user_list;
94: l_countlist asg_download.user_list;
95: l_source_object_id jtf_notes_b.source_object_id%TYPE;
96:
97:

Line 94: l_countlist asg_download.user_list;

90: l_jtf_note_id jtf_notes_b.jtf_note_id%TYPE;
91: l_user_found boolean;
92: l_source_object_code jtf_notes_b.source_object_code%TYPE;
93: l_userlist asg_download.user_list;
94: l_countlist asg_download.user_list;
95: l_source_object_id jtf_notes_b.source_object_id%TYPE;
96:
97:
98: --Cursor Declarations

Line 357: l_omfs_palm_user_list asg_download.user_list;

353: l_sqlerrmsg VARCHAR2(4000);
354: l_error_msg VARCHAR2(4000);
355: l_return_status VARCHAR2(2000);
356: l_markdirty BOOLEAN;
357: l_omfs_palm_user_list asg_download.user_list;
358: l_null_user_list asg_download.user_list;
359: l_single_access_id_list asg_download.access_list;
360: l_null_access_list asg_download.access_list;
361:

Line 358: l_null_user_list asg_download.user_list;

354: l_error_msg VARCHAR2(4000);
355: l_return_status VARCHAR2(2000);
356: l_markdirty BOOLEAN;
357: l_omfs_palm_user_list asg_download.user_list;
358: l_null_user_list asg_download.user_list;
359: l_single_access_id_list asg_download.access_list;
360: l_null_access_list asg_download.access_list;
361:
362: CURSOR l_mappings_csr

Line 359: l_single_access_id_list asg_download.access_list;

355: l_return_status VARCHAR2(2000);
356: l_markdirty BOOLEAN;
357: l_omfs_palm_user_list asg_download.user_list;
358: l_null_user_list asg_download.user_list;
359: l_single_access_id_list asg_download.access_list;
360: l_null_access_list asg_download.access_list;
361:
362: CURSOR l_mappings_csr
363: IS

Line 360: l_null_access_list asg_download.access_list;

356: l_markdirty BOOLEAN;
357: l_omfs_palm_user_list asg_download.user_list;
358: l_null_user_list asg_download.user_list;
359: l_single_access_id_list asg_download.access_list;
360: l_null_access_list asg_download.access_list;
361:
362: CURSOR l_mappings_csr
363: IS
364: SELECT CSM_OBJECT_MAPPINGS_ACC_S.NEXTVAL access_id, jom.mapping_id

Line 393: ASG_DOWNLOAD.INS, sysdate);

389: --mark dirty the SDQ for all users
390: IF l_single_access_id_list.count > 0 THEN
391: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_OBJECT_MAPPINGS',
392: l_single_access_id_list, l_omfs_palm_user_list,
393: ASG_DOWNLOAD.INS, sysdate);
394: END IF;
395: END LOOP;
396:
397: EXCEPTION