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

Line 145: asg_download.ins,

141: FOR i IN 1..l_access_id_tbl.count LOOP
142: l_markdirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
143: l_access_id_tbl(i),
144: p_resource_id,
145: asg_download.ins,
146: l_run_date);
147: END LOOP;
148: END IF;
149:

Line 186: asg_download.ins,

182: FOR i IN 1..l_access_id_tbl.count LOOP
183: l_markdirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
184: l_access_id_tbl(i),
185: p_resource_id,
186: asg_download.ins,
187: l_run_date);
188: END LOOP;
189: END IF;
190:

Line 336: asg_download.upd,

332: FOR i IN 1..l_access_id_tbl.count LOOP
333: l_markdirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
334: l_access_id_tbl(i),
335: p_resource_id,
336: asg_download.upd,
337: l_run_date);
338: END LOOP;
339:
340: l_access_id_tbl.DELETE;

Line 382: asg_download.del,

378: FOR i IN 1..l_access_id_tbl.count LOOP
379: l_markdirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
380: l_access_id_tbl(i),
381: p_resource_id,
382: asg_download.del,
383: l_run_date);
384: END LOOP;
385:
386: FORALL i IN 1..l_access_id_tbl.count

Line 409: l_all_omfs_palm_resource_list asg_download.user_list;

405: p_message OUT NOCOPY VARCHAR2)
406: IS
407: PRAGMA AUTONOMOUS_TRANSACTION;
408: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
409: l_all_omfs_palm_resource_list asg_download.user_list;
410: l_valid_omfs_resource_list asg_download.user_list;
411: l_null_palm_omfs_resource_list asg_download.user_list;
412: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
413: l_usr_list_for_serial asg_download.user_list;

Line 410: l_valid_omfs_resource_list asg_download.user_list;

406: IS
407: PRAGMA AUTONOMOUS_TRANSACTION;
408: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
409: l_all_omfs_palm_resource_list asg_download.user_list;
410: l_valid_omfs_resource_list asg_download.user_list;
411: l_null_palm_omfs_resource_list asg_download.user_list;
412: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
413: l_usr_list_for_serial asg_download.user_list;
414: l_rsrc_list_for_serial asg_download.user_list;

Line 411: l_null_palm_omfs_resource_list asg_download.user_list;

407: PRAGMA AUTONOMOUS_TRANSACTION;
408: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
409: l_all_omfs_palm_resource_list asg_download.user_list;
410: l_valid_omfs_resource_list asg_download.user_list;
411: l_null_palm_omfs_resource_list asg_download.user_list;
412: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
413: l_usr_list_for_serial asg_download.user_list;
414: l_rsrc_list_for_serial asg_download.user_list;
415: l_last_run_date jtm_con_request_data.last_run_date%TYPE;

Line 413: l_usr_list_for_serial asg_download.user_list;

409: l_all_omfs_palm_resource_list asg_download.user_list;
410: l_valid_omfs_resource_list asg_download.user_list;
411: l_null_palm_omfs_resource_list asg_download.user_list;
412: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
413: l_usr_list_for_serial asg_download.user_list;
414: l_rsrc_list_for_serial asg_download.user_list;
415: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
416: l_run_date DATE;
417: l_user_id fnd_user.user_id%TYPE;

Line 414: l_rsrc_list_for_serial asg_download.user_list;

410: l_valid_omfs_resource_list asg_download.user_list;
411: l_null_palm_omfs_resource_list asg_download.user_list;
412: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
413: l_usr_list_for_serial asg_download.user_list;
414: l_rsrc_list_for_serial asg_download.user_list;
415: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
416: l_run_date DATE;
417: l_user_id fnd_user.user_id%TYPE;
418: l_sqlerrno varchar2(20);

Line 664: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

660: SELECT inventory_item_id, serial_number, current_organization_id
661: FROM csm_mtl_serial_numbers_acc
662: WHERE user_id = au.user_id );
663:
664: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
665: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
666: l_tab_item_id ASG_DOWNLOAD.ACCESS_LIST;
667: l_tab_org_id ASG_DOWNLOAD.ACCESS_LIST;
668: l_markdirty BOOLEAN;

Line 665: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

661: FROM csm_mtl_serial_numbers_acc
662: WHERE user_id = au.user_id );
663:
664: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
665: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
666: l_tab_item_id ASG_DOWNLOAD.ACCESS_LIST;
667: l_tab_org_id ASG_DOWNLOAD.ACCESS_LIST;
668: l_markdirty BOOLEAN;
669:

Line 666: l_tab_item_id ASG_DOWNLOAD.ACCESS_LIST;

662: WHERE user_id = au.user_id );
663:
664: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
665: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
666: l_tab_item_id ASG_DOWNLOAD.ACCESS_LIST;
667: l_tab_org_id ASG_DOWNLOAD.ACCESS_LIST;
668: l_markdirty BOOLEAN;
669:
670: TYPE serial_numbers_tbl_typ IS TABLE OF mtl_serial_numbers.serial_number%TYPE INDEX BY binary_integer;

Line 667: l_tab_org_id ASG_DOWNLOAD.ACCESS_LIST;

663:
664: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
665: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
666: l_tab_item_id ASG_DOWNLOAD.ACCESS_LIST;
667: l_tab_org_id ASG_DOWNLOAD.ACCESS_LIST;
668: l_markdirty BOOLEAN;
669:
670: TYPE serial_numbers_tbl_typ IS TABLE OF mtl_serial_numbers.serial_number%TYPE INDEX BY binary_integer;
671: l_tab_srl serial_numbers_tbl_typ;

Line 691: l_markdirty := asg_download.mark_dirty(

687:
688: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_mtl_serial_numbers_acc ',
689: 'CSM_SERIAL_NUMBERS_EVENT_PKG.RECEIVED_MTL_SERIAL_NUM',FND_LOG.LEVEL_STATEMENT);
690:
691: l_markdirty := asg_download.mark_dirty(
692: P_PUB_ITEM => g_pub_item
693: , p_accessList => l_tab_access_id
694: , p_userid_list => l_tab_user_id
695: , p_dml_type => 'I'