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 CSM_II_RELATIONSHIPS_ACC

Line 23: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_II_RELATIONSHIPS_ACC';

19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
20: g_pub_item CONSTANT VARCHAR2(30) := 'CSF_M_ITEM_INSTANCES';
21:
22: g_table_name2 CONSTANT VARCHAR2(30) := 'CSI_II_RELATIONSHIPS';
23: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_II_RELATIONSHIPS_ACC';
24: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_II_RELATIONSHIPS_ACC_S';
25: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
26: CSM_ACC_PKG.t_publication_item_list('CSF_M_II_RELATIONSHIPS');
27: g_pk1_name2 CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';

Line 24: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_II_RELATIONSHIPS_ACC_S';

20: g_pub_item CONSTANT VARCHAR2(30) := 'CSF_M_ITEM_INSTANCES';
21:
22: g_table_name2 CONSTANT VARCHAR2(30) := 'CSI_II_RELATIONSHIPS';
23: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_II_RELATIONSHIPS_ACC';
24: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_II_RELATIONSHIPS_ACC_S';
25: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
26: CSM_ACC_PKG.t_publication_item_list('CSF_M_II_RELATIONSHIPS');
27: g_pk1_name2 CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
28: g_pub_item2 CONSTANT VARCHAR2(30) := 'CSF_M_II_RELATIONSHIPS';

Line 416: FROM csm_ii_relationships_acc acc,

412: IS
413: SELECT /*+ index(cii CSI_II_RELATIONSHIPS_U01) */acc.access_id,
414: acc.user_id
415: --, acc.relationship_id
416: FROM csm_ii_relationships_acc acc,
417: csi_ii_relationships cii
418: WHERE cii.relationship_id = acc.relationship_id
419: AND NOT EXISTS
420: (SELECT 1

Line 429: SELECT /+ index(acc csm_ii_relationships_acc_u1) /acc.access_id,

425:
426: -- delete relationships that are dropped or end-dated from the backend
427: CURSOR l_itemrelationships_del2_csr
428: IS
429: SELECT /*+ index(acc csm_ii_relationships_acc_u1) */acc.access_id,
430: acc.user_id
431: --,acc.relationship_id
432: FROM csm_ii_relationships_acc acc
433: WHERE NOT EXISTS

Line 432: FROM csm_ii_relationships_acc acc

428: IS
429: SELECT /*+ index(acc csm_ii_relationships_acc_u1) */acc.access_id,
430: acc.user_id
431: --,acc.relationship_id
432: FROM csm_ii_relationships_acc acc
433: WHERE NOT EXISTS
434: (SELECT 1
435: FROM csi_ii_relationships cii
436: WHERE cii.relationship_id = acc.relationship_id

Line 443: SELECT /* index (acc CSM_II_RELATIONSHIPS_ACC_U1) */

439:
440: -- update existing relationships
441: CURSOR l_itemrelationships_upd_csr(p_last_run_date DATE)
442: IS
443: SELECT /* index (acc CSM_II_RELATIONSHIPS_ACC_U1) */
444: acc.user_id,
445: acc.access_id,
446: ii.subject_id,
447: ii.object_id

Line 448: FROM csm_ii_relationships_acc acc,

444: acc.user_id,
445: acc.access_id,
446: ii.subject_id,
447: ii.object_id
448: FROM csm_ii_relationships_acc acc,
449: csi_ii_relationships ii
450: WHERE ii.relationship_id = acc.relationship_id
451: AND ii.last_update_date >= p_last_run_date;
452:

Line 462: AND NOT EXISTS (SELECT 1 FROM CSM_II_RELATIONSHIPS_ACC ACC

458: FROM csi_ii_relationships cii
459: WHERE cii.relationship_type_code = 'COMPONENT-OF'
460: AND (cii.object_id = b_instance_id OR cii.subject_id = b_instance_id)
461: AND SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE)
462: AND NOT EXISTS (SELECT 1 FROM CSM_II_RELATIONSHIPS_ACC ACC
463: WHERE ACC.user_id = b_useR_id
464: AND ACC.relationship_id = cii.relationship_id);
465:
466:

Line 468: TYPE rel_idTab IS TABLE OF csm_ii_relationships_acc.relationship_id%TYPE INDEX BY BINARY_INTEGER;

464: AND ACC.relationship_id = cii.relationship_id);
465:
466:
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;

Line 680: DELETE CSM_II_RELATIONSHIPS_ACC WHERE ACCESS_ID = l_acc_id_lst(i);

676: );
677:
678: -- do a bulk delete
679: FORALL i IN l_acc_id_lst.FIRST..l_acc_id_lst.LAST
680: DELETE CSM_II_RELATIONSHIPS_ACC WHERE ACCESS_ID = l_acc_id_lst(i);
681:
682: END IF;
683:
684: COMMIT;--IB Relation Deletes are commited

Line 711: DELETE CSM_II_RELATIONSHIPS_ACC WHERE ACCESS_ID = l_acc_id_lst(i);

707: );
708:
709: -- do a bulk delete
710: FORALL i IN l_acc_id_lst.FIRST..l_acc_id_lst.LAST
711: DELETE CSM_II_RELATIONSHIPS_ACC WHERE ACCESS_ID = l_acc_id_lst(i);
712:
713: END IF;
714: COMMIT;--IB Relation Deletes are commited
715:

Line 791: SELECT CSM_II_RELATIONSHIPS_ACC_S.NEXTVAL

787: IF l_rel_id_lst.COUNT >0 THEN
788:
789: FOR J IN 1..l_rel_id_lst.COUNT
790: LOOP
791: SELECT CSM_II_RELATIONSHIPS_ACC_S.NEXTVAL
792: INTO l_acc_id_lst(J)
793: FROM dual;
794: l_user_id_lst(J):=l_user_id_lst_bkp(I);
795: END LOOP;

Line 798: INSERT INTO CSM_II_RELATIONSHIPS_ACC (ACCESS_ID, USER_ID, RELATIONSHIP_ID,

794: l_user_id_lst(J):=l_user_id_lst_bkp(I);
795: END LOOP;
796:
797: FORALL j IN 1..l_rel_id_lst.COUNT
798: INSERT INTO CSM_II_RELATIONSHIPS_ACC (ACCESS_ID, USER_ID, RELATIONSHIP_ID,
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