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 179: asg_download.ins,

175: FOR i IN 1..l_access_id_tbl.count LOOP
176: l_markdirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
177: l_access_id_tbl(i),
178: p_resource_id,
179: asg_download.ins,
180: l_run_date);
181: END LOOP;
182: END IF;
183:

Line 303: asg_download.upd,

299: FOR i IN 1..l_access_id_tbl.count LOOP
300: l_markdirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
301: l_access_id_tbl(i),
302: p_resource_id,
303: asg_download.upd,
304: l_run_date);
305: END LOOP;
306:
307: l_access_id_tbl.DELETE;

Line 341: asg_download.del,

337: FOR i IN 1..l_access_id_tbl.count LOOP
338: l_markdirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
339: l_access_id_tbl(i),
340: p_resource_id,
341: asg_download.del,
342: l_run_date);
343: END LOOP;
344:
345: FORALL i IN 1..l_access_id_tbl.count

Line 367: l_all_omfs_palm_resource_list asg_download.user_list;

363: PROCEDURE refresh_mtl_serial_numbers_acc
364: IS
365: PRAGMA AUTONOMOUS_TRANSACTION;
366: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
367: l_all_omfs_palm_resource_list asg_download.user_list;
368: l_valid_omfs_resource_list asg_download.user_list;
369: l_null_palm_omfs_resource_list asg_download.user_list;
370: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
371: l_usr_list_for_serial asg_download.user_list;

Line 368: l_valid_omfs_resource_list asg_download.user_list;

364: IS
365: PRAGMA AUTONOMOUS_TRANSACTION;
366: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
367: l_all_omfs_palm_resource_list asg_download.user_list;
368: l_valid_omfs_resource_list asg_download.user_list;
369: l_null_palm_omfs_resource_list asg_download.user_list;
370: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
371: l_usr_list_for_serial asg_download.user_list;
372: l_rsrc_list_for_serial asg_download.user_list;

Line 369: l_null_palm_omfs_resource_list asg_download.user_list;

365: PRAGMA AUTONOMOUS_TRANSACTION;
366: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
367: l_all_omfs_palm_resource_list asg_download.user_list;
368: l_valid_omfs_resource_list asg_download.user_list;
369: l_null_palm_omfs_resource_list asg_download.user_list;
370: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
371: l_usr_list_for_serial asg_download.user_list;
372: l_rsrc_list_for_serial asg_download.user_list;
373: l_last_run_date jtm_con_request_data.last_run_date%TYPE;

Line 371: l_usr_list_for_serial asg_download.user_list;

367: l_all_omfs_palm_resource_list asg_download.user_list;
368: l_valid_omfs_resource_list asg_download.user_list;
369: l_null_palm_omfs_resource_list asg_download.user_list;
370: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
371: l_usr_list_for_serial asg_download.user_list;
372: l_rsrc_list_for_serial asg_download.user_list;
373: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
374: l_run_date DATE;
375: l_user_id fnd_user.user_id%TYPE;

Line 372: l_rsrc_list_for_serial asg_download.user_list;

368: l_valid_omfs_resource_list asg_download.user_list;
369: l_null_palm_omfs_resource_list asg_download.user_list;
370: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
371: l_usr_list_for_serial asg_download.user_list;
372: l_rsrc_list_for_serial asg_download.user_list;
373: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
374: l_run_date DATE;
375: l_user_id fnd_user.user_id%TYPE;
376: l_sqlerrno varchar2(20);