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

Line 471: l_user_id_lst asg_download.user_list;

467: TYPE instance_idTab IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
468: TYPE rel_idTab IS TABLE OF csm_ii_relationships_acc.relationship_id%TYPE INDEX BY BINARY_INTEGER;
469: TYPE ver_lab_Tab IS TABLE OF csi_i_version_labels.version_label%TYPE INDEX BY BINARY_INTEGER;
470: l_rel_id_lst rel_idTab;
471: l_user_id_lst asg_download.user_list;
472: l_acc_id_lst asg_download.access_list;
473: l_instance_id_lst instance_idTab;
474: l_inst_id_lst_bkp instance_idTab;
475: l_user_id_lst_bkp asg_download.user_list;

Line 472: l_acc_id_lst asg_download.access_list;

468: TYPE rel_idTab IS TABLE OF csm_ii_relationships_acc.relationship_id%TYPE INDEX BY BINARY_INTEGER;
469: TYPE ver_lab_Tab IS TABLE OF csi_i_version_labels.version_label%TYPE INDEX BY BINARY_INTEGER;
470: l_rel_id_lst rel_idTab;
471: l_user_id_lst asg_download.user_list;
472: l_acc_id_lst asg_download.access_list;
473: l_instance_id_lst instance_idTab;
474: l_inst_id_lst_bkp instance_idTab;
475: l_user_id_lst_bkp asg_download.user_list;
476: l_dummy BOOLEAN;

Line 475: l_user_id_lst_bkp asg_download.user_list;

471: l_user_id_lst asg_download.user_list;
472: l_acc_id_lst asg_download.access_list;
473: l_instance_id_lst instance_idTab;
474: l_inst_id_lst_bkp instance_idTab;
475: l_user_id_lst_bkp asg_download.user_list;
476: l_dummy BOOLEAN;
477: l_ver_label_lst ver_lab_Tab;
478: l_parent_inst_id_lst instance_idTab;
479: BEGIN

Line 506: l_dummy := asg_download.mark_dirty(

502: FETCH l_expiredinstances_del_csr BULK COLLECT INTO l_acc_id_lst, l_user_id_lst LIMIT 500;
503: EXIT WHEN l_acc_id_lst.COUNT = 0;
504: -- post deletes to olite
505: -- do bulk makedirty
506: l_dummy := asg_download.mark_dirty(
507: P_PUB_ITEM => g_pub_item1
508: , p_accessList => l_acc_id_lst
509: , p_userid_list => l_user_id_lst
510: , p_dml_type => 'D'

Line 547: l_dummy := asg_download.mark_dirty(

543:
544: -- post deletes to olite
545: IF l_acc_id_lst.COUNT > 0 THEN
546: -- do bulk makedirty
547: l_dummy := asg_download.mark_dirty(
548: P_PUB_ITEM => g_pub_item1
549: , p_accessList => l_acc_id_lst
550: , p_userid_list => l_user_id_lst
551: , p_dml_type => 'D'

Line 570: l_dummy := asg_download.mark_dirty(

566: FETCH l_iteminstances_upd_csr BULK COLLECT INTO l_user_id_lst, l_acc_id_lst LIMIT 1000;
567: EXIT WHEN l_acc_id_lst.COUNT = 0 ;
568: -- post updates to olite
569: -- do bulk makedirty
570: l_dummy := asg_download.mark_dirty(
571: P_PUB_ITEM => g_pub_item1
572: , p_accessList => l_acc_id_lst
573: , p_userid_list => l_user_id_lst
574: , p_dml_type => 'U'

Line 628: l_dummy := asg_download.mark_dirty(

624: 1, 1, l_current_run_date,1,l_current_run_date,
625: 1,l_ver_label_lst(i), l_parent_inst_id_lst(i));
626:
627: -- do bulk makedirty
628: l_dummy := asg_download.mark_dirty(
629: P_PUB_ITEM => g_pub_item1
630: , p_accessList => l_acc_id_lst
631: , p_userid_list => l_user_id_lst
632: , p_dml_type => 'I'

Line 670: l_dummy := asg_download.mark_dirty(

666:
667: -- post deletes to olite
668: IF l_acc_id_lst.COUNT > 0 THEN
669: -- do bulk makedirty
670: l_dummy := asg_download.mark_dirty(
671: P_PUB_ITEM => g_pub_item2
672: , p_accessList => l_acc_id_lst
673: , p_userid_list => l_user_id_lst
674: , p_dml_type => 'D'

Line 701: l_dummy := asg_download.mark_dirty(

697:
698: -- post deletes to olite
699: IF l_acc_id_lst.COUNT > 0 THEN
700: -- do bulk makedirty
701: l_dummy := asg_download.mark_dirty(
702: P_PUB_ITEM => g_pub_item2
703: , p_accessList => l_acc_id_lst
704: , p_userid_list => l_user_id_lst
705: , p_dml_type => 'D'

Line 736: l_dummy := asg_download.mark_dirty(

732:
733: -- post updates to olite
734: IF l_acc_id_lst.COUNT > 0 THEN
735: -- do bulk makedirty for relationship change
736: l_dummy := asg_download.mark_dirty(
737: P_PUB_ITEM => g_pub_item2
738: , p_accessList => l_acc_id_lst
739: , p_userid_list => l_user_id_lst
740: , p_dml_type => 'U'

Line 757: l_dummy := asg_download.mark_dirty(

753: AND INSTANCE_ID = l_instance_id_lst(i)
754: RETURNING access_id BULK COLLECT INTO l_acc_id_lst ;
755:
756: -- do bulk makedirty for Instances
757: l_dummy := asg_download.mark_dirty(
758: P_PUB_ITEM => g_pub_item1
759: , p_accessList => l_acc_id_lst
760: , p_userid_list => l_user_id_lst
761: , p_dml_type => 'U'

Line 803: l_dummy := asg_download.mark_dirty(

799: COUNTER,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
800: VALUES (l_acc_id_lst(j), l_user_id_lst_bkp(I), l_rel_id_lst(j), 1, 1, l_current_run_date,1,l_current_run_date,1);
801:
802: -- do bulk makedirty
803: l_dummy := asg_download.mark_dirty(
804: P_PUB_ITEM => g_pub_item2
805: , p_accessList => l_acc_id_lst
806: , p_userid_list => l_user_id_lst
807: , p_dml_type => 'I'

Line 1191: l_user_id_lst asg_download.user_list;

1187: l_dummy BOOLEAN;
1188:
1189: TYPE instance_idTab IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
1190: l_instance_id_lst instance_idTab;
1191: l_user_id_lst asg_download.user_list;
1192: l_acc_id_lst asg_download.access_list;
1193:
1194:
1195: CURSOR l_instances_del_csr

Line 1192: l_acc_id_lst asg_download.access_list;

1188:
1189: TYPE instance_idTab IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
1190: l_instance_id_lst instance_idTab;
1191: l_user_id_lst asg_download.user_list;
1192: l_acc_id_lst asg_download.access_list;
1193:
1194:
1195: CURSOR l_instances_del_csr
1196: IS

Line 1231: l_dummy := asg_download.mark_dirty(

1227:
1228: -- post deletes to olite
1229: IF l_acc_id_lst.COUNT > 0 THEN
1230: -- do bulk makedirty
1231: l_dummy := asg_download.mark_dirty(
1232: P_PUB_ITEM => 'CSF_M_ITEM_INSTANCES'
1233: , p_accessList => l_acc_id_lst
1234: , p_userid_list => l_user_id_lst
1235: , p_dml_type => 'D'