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 474: l_user_id_lst asg_download.user_list;

470: TYPE instance_idTab IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
471: TYPE rel_idTab IS TABLE OF csm_ii_relationships_acc.relationship_id%TYPE INDEX BY BINARY_INTEGER;
472: TYPE ver_lab_Tab IS TABLE OF csi_i_version_labels.version_label%TYPE INDEX BY BINARY_INTEGER;
473: l_rel_id_lst rel_idTab;
474: l_user_id_lst asg_download.user_list;
475: l_user_id2_lst asg_download.user_list;
476: l_acc_id_lst asg_download.access_list;
477: l_instance_id_lst instance_idTab;
478: l_dummy BOOLEAN;

Line 475: l_user_id2_lst asg_download.user_list;

471: TYPE rel_idTab IS TABLE OF csm_ii_relationships_acc.relationship_id%TYPE INDEX BY BINARY_INTEGER;
472: TYPE ver_lab_Tab IS TABLE OF csi_i_version_labels.version_label%TYPE INDEX BY BINARY_INTEGER;
473: l_rel_id_lst rel_idTab;
474: l_user_id_lst asg_download.user_list;
475: l_user_id2_lst asg_download.user_list;
476: l_acc_id_lst asg_download.access_list;
477: l_instance_id_lst instance_idTab;
478: l_dummy BOOLEAN;
479: l_ver_label_lst ver_lab_Tab;

Line 476: l_acc_id_lst asg_download.access_list;

472: TYPE ver_lab_Tab IS TABLE OF csi_i_version_labels.version_label%TYPE INDEX BY BINARY_INTEGER;
473: l_rel_id_lst rel_idTab;
474: l_user_id_lst asg_download.user_list;
475: l_user_id2_lst asg_download.user_list;
476: l_acc_id_lst asg_download.access_list;
477: l_instance_id_lst instance_idTab;
478: l_dummy BOOLEAN;
479: l_ver_label_lst ver_lab_Tab;
480: l_parent_inst_id_lst instance_idTab;

Line 504: l_dummy := asg_download.mark_dirty(

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

Line 529: l_dummy := asg_download.mark_dirty(

525: FETCH l_iteminstances_upd_csr BULK COLLECT INTO l_user_id_lst, l_acc_id_lst LIMIT 1000;
526: EXIT WHEN l_acc_id_lst.COUNT = 0 ;
527: -- post updates to olite
528: -- do bulk makedirty
529: l_dummy := asg_download.mark_dirty(
530: P_PUB_ITEM => g_pub_item1
531: , p_accessList => l_acc_id_lst
532: , p_userid_list => l_user_id_lst
533: , p_dml_type => 'U'

Line 564: l_dummy := asg_download.mark_dirty(

560: 1, 1, l_current_run_date,1,l_current_run_date,
561: 1,l_ver_label_lst(i), l_parent_inst_id_lst(i));
562:
563: -- do bulk makedirty
564: l_dummy := asg_download.mark_dirty(
565: P_PUB_ITEM => g_pub_item1
566: , p_accessList => l_acc_id_lst
567: , p_userid_list => l_user_id_lst
568: , p_dml_type => 'I'

Line 589: l_dummy := asg_download.mark_dirty(

585:
586: -- post deletes to olite
587: IF l_acc_id_lst.COUNT > 0 THEN
588: -- do bulk makedirty
589: l_dummy := asg_download.mark_dirty(
590: P_PUB_ITEM => g_pub_item2
591: , p_accessList => l_acc_id_lst
592: , p_userid_list => l_user_id_lst
593: , p_dml_type => 'D'

Line 618: l_dummy := asg_download.mark_dirty(

614:
615: -- post deletes to olite
616: IF l_acc_id_lst.COUNT > 0 THEN
617: -- do bulk makedirty
618: l_dummy := asg_download.mark_dirty(
619: P_PUB_ITEM => g_pub_item2
620: , p_accessList => l_acc_id_lst
621: , p_userid_list => l_user_id_lst
622: , p_dml_type => 'D'

Line 642: l_dummy := asg_download.mark_dirty(

638: AND INSTANCE_ID = l_instance_id_lst(i)
639: RETURNING access_id,user_id BULK COLLECT INTO l_acc_id_lst,l_user_id2_lst ; --Bug 14345675
640:
641: -- do bulk makedirty for Instances
642: l_dummy := asg_download.mark_dirty(
643: P_PUB_ITEM => g_pub_item1
644: , p_accessList => l_acc_id_lst
645: , p_userid_list => l_user_id2_lst
646: , p_dml_type => 'U'

Line 668: l_dummy := asg_download.mark_dirty(

664:
665: -- post updates to olite
666: IF l_acc_id_lst.COUNT > 0 THEN
667: -- do bulk makedirty for relationship change
668: l_dummy := asg_download.mark_dirty(
669: P_PUB_ITEM => g_pub_item2
670: , p_accessList => l_acc_id_lst
671: , p_userid_list => l_user_id_lst
672: , p_dml_type => 'U'

Line 689: l_dummy := asg_download.mark_dirty(

685: AND INSTANCE_ID = l_instance_id_lst(i)
686: RETURNING access_id,user_id BULK COLLECT INTO l_acc_id_lst,l_user_id2_lst ; --Bug 14345675
687:
688: -- do bulk makedirty for Instances
689: l_dummy := asg_download.mark_dirty(
690: P_PUB_ITEM => g_pub_item1
691: , p_accessList => l_acc_id_lst
692: , p_userid_list => l_user_id2_lst
693: , p_dml_type => 'U'

Line 723: l_dummy := asg_download.mark_dirty(

719: COUNTER,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
720: VALUES (l_acc_id_lst(i), l_user_id_lst(i), l_rel_id_lst(i), 1, 1, l_current_run_date,1,l_current_run_date,1);
721:
722: -- do bulk makedirty
723: l_dummy := asg_download.mark_dirty(
724: P_PUB_ITEM => g_pub_item2
725: , p_accessList => l_acc_id_lst
726: , p_userid_list => l_user_id_lst
727: , p_dml_type => 'I'

Line 744: l_dummy := asg_download.mark_dirty(

740: AND INSTANCE_ID = l_instance_id_lst(i)
741: RETURNING access_id,user_id BULK COLLECT INTO l_acc_id_lst,l_user_id2_lst ; --Bug 14345675
742:
743: -- do bulk makedirty for Instances
744: l_dummy := asg_download.mark_dirty(
745: P_PUB_ITEM => g_pub_item1
746: , p_accessList => l_acc_id_lst
747: , p_userid_list => l_user_id2_lst
748: , p_dml_type => 'U'

Line 1144: l_user_id_lst asg_download.user_list;

1140: l_dummy BOOLEAN;
1141:
1142: TYPE instance_idTab IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
1143: l_instance_id_lst instance_idTab;
1144: l_user_id_lst asg_download.user_list;
1145: l_acc_id_lst asg_download.access_list;
1146:
1147:
1148: CURSOR l_instances_del_csr

Line 1145: l_acc_id_lst asg_download.access_list;

1141:
1142: TYPE instance_idTab IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
1143: l_instance_id_lst instance_idTab;
1144: l_user_id_lst asg_download.user_list;
1145: l_acc_id_lst asg_download.access_list;
1146:
1147:
1148: CURSOR l_instances_del_csr
1149: IS

Line 1184: l_dummy := asg_download.mark_dirty(

1180:
1181: -- post deletes to olite
1182: IF l_acc_id_lst.COUNT > 0 THEN
1183: -- do bulk makedirty
1184: l_dummy := asg_download.mark_dirty(
1185: P_PUB_ITEM => 'CSF_M_ITEM_INSTANCES'
1186: , p_accessList => l_acc_id_lst
1187: , p_userid_list => l_user_id_lst
1188: , p_dml_type => 'D'