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

Line 47: l_all_omfs_palm_resource_list asg_download.user_list;

43: PRAGMA AUTONOMOUS_TRANSACTION;
44: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
45: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
46: l_mark_dirty boolean;
47: l_all_omfs_palm_resource_list asg_download.user_list;
48: l_null_resource_list asg_download.user_list;
49: l_single_access_id_list asg_download.access_list;
50: l_null_access_list asg_download.access_list;
51: l_sqlerrno varchar2(20);

Line 48: l_null_resource_list asg_download.user_list;

44: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
45: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
46: l_mark_dirty boolean;
47: l_all_omfs_palm_resource_list asg_download.user_list;
48: l_null_resource_list asg_download.user_list;
49: l_single_access_id_list asg_download.access_list;
50: l_null_access_list asg_download.access_list;
51: l_sqlerrno varchar2(20);
52: l_sqlerrmsg varchar2(4000);

Line 49: l_single_access_id_list asg_download.access_list;

45: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
46: l_mark_dirty boolean;
47: l_all_omfs_palm_resource_list asg_download.user_list;
48: l_null_resource_list asg_download.user_list;
49: l_single_access_id_list asg_download.access_list;
50: l_null_access_list asg_download.access_list;
51: l_sqlerrno varchar2(20);
52: l_sqlerrmsg varchar2(4000);
53:

Line 50: l_null_access_list asg_download.access_list;

46: l_mark_dirty boolean;
47: l_all_omfs_palm_resource_list asg_download.user_list;
48: l_null_resource_list asg_download.user_list;
49: l_single_access_id_list asg_download.access_list;
50: l_null_access_list asg_download.access_list;
51: l_sqlerrno varchar2(20);
52: l_sqlerrmsg varchar2(4000);
53:
54: CURSOR l_last_run_date_csr

Line 118: ASG_DOWNLOAD.DEL, sysdate);

114: --mark dirty the SDQ for all users
115: IF l_single_access_id_list.count > 0 THEN
116: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSM_MTL_PARAMETERS',
117: l_single_access_id_list, l_all_omfs_palm_resource_list,
118: ASG_DOWNLOAD.DEL, sysdate);
119: END IF;
120:
121: -- delete from acc table
122: DELETE FROM csm_mtl_parameters_acc WHERE access_id = l_access_id;

Line 144: ASG_DOWNLOAD.UPD, sysdate);

140: --mark dirty the SDQ for all users
141: IF l_single_access_id_list.count > 0 THEN
142: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSM_MTL_PARAMETERS',
143: l_single_access_id_list, l_all_omfs_palm_resource_list,
144: ASG_DOWNLOAD.UPD, sysdate);
145: END IF;
146:
147: END LOOP;
148:

Line 170: ASG_DOWNLOAD.INS, sysdate);

166: --mark dirty the SDQ for all users
167: IF l_single_access_id_list.count > 0 THEN
168: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSM_MTL_PARAMETERS',
169: l_single_access_id_list, l_all_omfs_palm_resource_list,
170: ASG_DOWNLOAD.INS, sysdate);
171: END IF;
172:
173: INSERT INTO csm_mtl_parameters_acc (access_id,
174: organization_id,

Line 223: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

219: l_markdirty boolean;
220: l_sqlerrno varchar2(20);
221: l_sqlerrmsg varchar2(4000);
222:
223: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
224: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
225: l_tab_from_org l_num_tab_type;
226: l_tab_to_org l_num_tab_type;
227: l_tab_io_req l_num_tab_type;

Line 224: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

220: l_sqlerrno varchar2(20);
221: l_sqlerrmsg varchar2(4000);
222:
223: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
224: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
225: l_tab_from_org l_num_tab_type;
226: l_tab_to_org l_num_tab_type;
227: l_tab_io_req l_num_tab_type;
228: l_tab_in_trans l_num_tab_type;

Line 300: l_markdirty := asg_download.mark_dirty(

296:
297: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from CSM_INTERORG_PARAMETERS_ACC' ,
298: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC',FND_LOG.LEVEL_EVENT);
299:
300: l_markdirty := asg_download.mark_dirty(
301: P_PUB_ITEM => 'CSM_MTL_INTERORG_PARAMS'
302: , p_accessList => l_tab_access_id
303: , p_userid_list => l_tab_user_id
304: , p_dml_type => 'D'

Line 330: l_markdirty := asg_download.mark_dirty(

326:
327: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in CSM_INTERORG_PARAMETERS_ACC' ,
328: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC',FND_LOG.LEVEL_EVENT);
329:
330: l_markdirty := asg_download.mark_dirty(
331: P_PUB_ITEM => 'CSM_MTL_INTERORG_PARAMS'
332: , p_accessList => l_tab_access_id
333: , p_userid_list => l_tab_user_id
334: , p_dml_type => 'U'

Line 366: /* push to oLite using asg_download */

362: counter, created_by, creation_date, last_updated_by, last_update_date )
363: VALUES (l_tab_access_id(i), l_tab_user_id(i),l_tab_from_org(i),l_tab_to_org(i),
364: 1,fnd_global.user_id, sysdate, fnd_global.user_id, sysdate);
365:
366: /*** push to oLite using asg_download ***/
367: -- do bulk makedirty
368: l_markdirty := asg_download.mark_dirty(
369: P_PUB_ITEM => 'CSM_MTL_INTERORG_PARAMS'
370: , p_accessList => l_tab_access_id

Line 368: l_markdirty := asg_download.mark_dirty(

364: 1,fnd_global.user_id, sysdate, fnd_global.user_id, sysdate);
365:
366: /*** push to oLite using asg_download ***/
367: -- do bulk makedirty
368: l_markdirty := asg_download.mark_dirty(
369: P_PUB_ITEM => 'CSM_MTL_INTERORG_PARAMS'
370: , p_accessList => l_tab_access_id
371: , p_userid_list => l_tab_user_id
372: , p_dml_type => 'I'

Line 418: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

414: FROM jtm_con_request_data
415: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
416: AND procedure_name = 'REFRESH_FREIGHTS_ACC';
417:
418: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
419: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
420: l_tab_org l_num_tab_type;
421: l_tab_freight l_char_tab_type;
422: l_tab_shipM l_char_tab_type;

Line 419: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

415: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
416: AND procedure_name = 'REFRESH_FREIGHTS_ACC';
417:
418: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
419: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
420: l_tab_org l_num_tab_type;
421: l_tab_freight l_char_tab_type;
422: l_tab_shipM l_char_tab_type;
423: l_markdirty boolean;

Line 518: l_markdirty := asg_download.mark_dirty(

514:
515: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from CSM_INTERORG_FREIGHTS_ACC' ,
516: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC',FND_LOG.LEVEL_EVENT);
517:
518: l_markdirty := asg_download.mark_dirty(
519: P_PUB_ITEM => 'CSM_INV_ORG_FREIGHTS'
520: , p_accessList => l_tab_access_id
521: , p_userid_list => l_tab_user_id
522: , p_dml_type => 'D'

Line 547: l_markdirty := asg_download.mark_dirty(

543:
544: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in CSM_INTERORG_FREIGHTS_ACC' ,
545: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC',FND_LOG.LEVEL_EVENT);
546:
547: l_markdirty := asg_download.mark_dirty(
548: P_PUB_ITEM => 'CSM_INV_ORG_FREIGHTS'
549: , p_accessList => l_tab_access_id
550: , p_userid_list => l_tab_user_id
551: , p_dml_type => 'U'

Line 582: /* push to oLite using asg_download */

578: created_by, creation_date, last_updated_by, last_update_date )
579: VALUES (l_tab_access_id(i), l_tab_user_id(i),l_tab_org(i),l_tab_freight(i),l_tab_shipM(i),
580: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate);
581:
582: /*** push to oLite using asg_download ***/
583: -- do bulk makedirty
584: l_markdirty := asg_download.mark_dirty(
585: P_PUB_ITEM => 'CSM_INV_ORG_FREIGHTS'
586: , p_accessList => l_tab_access_id

Line 584: l_markdirty := asg_download.mark_dirty(

580: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate);
581:
582: /*** push to oLite using asg_download ***/
583: -- do bulk makedirty
584: l_markdirty := asg_download.mark_dirty(
585: P_PUB_ITEM => 'CSM_INV_ORG_FREIGHTS'
586: , p_accessList => l_tab_access_id
587: , p_userid_list => l_tab_user_id
588: , p_dml_type => 'I'