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 418: FROM csm_ii_relationships_acc acc,

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

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

427:
428: -- delete relationships that are end-dated from the backend
429: CURSOR l_itemrelationships_del2_csr
430: IS
431: SELECT /*+ index(acc csm_ii_relationships_acc_u1) */acc.access_id,
432: acc.user_id,
433: cii.subject_id
434: --,acc.relationship_id
435: FROM csm_ii_relationships_acc acc,

Line 435: FROM csm_ii_relationships_acc acc,

431: SELECT /*+ index(acc csm_ii_relationships_acc_u1) */acc.access_id,
432: acc.user_id,
433: cii.subject_id
434: --,acc.relationship_id
435: FROM csm_ii_relationships_acc acc,
436: csi_ii_relationships cii
437: WHERE cii.relationship_id = acc.relationship_id
438: AND NVL(cii.active_end_date, SYSDATE) < SYSDATE;
439:

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 465: AND NOT EXISTS (SELECT 1 FROM CSM_II_RELATIONSHIPS_ACC ACC

461: csm_item_instances_acc iacc
462: WHERE cii.relationship_type_code = 'COMPONENT-OF'
463: AND cii.object_id = iacc.instance_id
464: AND SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE)
465: AND NOT EXISTS (SELECT 1 FROM CSM_II_RELATIONSHIPS_ACC ACC
466: WHERE ACC.user_id = iacc.user_id
467: AND ACC.relationship_id = cii.relationship_id);
468:
469:

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

467: AND ACC.relationship_id = cii.relationship_id);
468:
469:
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;

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

595: );
596:
597: -- do a bulk delete
598: FORALL i IN l_acc_id_lst.FIRST..l_acc_id_lst.LAST
599: DELETE CSM_II_RELATIONSHIPS_ACC WHERE ACCESS_ID = l_acc_id_lst(i);
600:
601: END IF;
602:
603: COMMIT;--IB Relation Deletes are commited

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

624: );
625:
626: -- do a bulk delete
627: FORALL i IN l_acc_id_lst.FIRST..l_acc_id_lst.LAST
628: DELETE CSM_II_RELATIONSHIPS_ACC WHERE ACCESS_ID = l_acc_id_lst(i);
629:
630: l_acc_id_lst.DELETE;
631: l_user_id2_lst.DELETE;
632:

Line 714: SELECT CSM_II_RELATIONSHIPS_ACC_S.NEXTVAL INTO l_acc_id_lst(J) FROM dual;

710: EXIT WHEN l_user_id_lst.COUNT=0;
711:
712: FOR J IN 1..l_user_id_lst.COUNT
713: LOOP
714: SELECT CSM_II_RELATIONSHIPS_ACC_S.NEXTVAL INTO l_acc_id_lst(J) FROM dual;
715: END LOOP;
716:
717: FORALL i IN 1..l_rel_id_lst.COUNT
718: INSERT INTO CSM_II_RELATIONSHIPS_ACC (ACCESS_ID, USER_ID, RELATIONSHIP_ID,

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

714: SELECT CSM_II_RELATIONSHIPS_ACC_S.NEXTVAL INTO l_acc_id_lst(J) FROM dual;
715: END LOOP;
716:
717: FORALL i IN 1..l_rel_id_lst.COUNT
718: INSERT INTO CSM_II_RELATIONSHIPS_ACC (ACCESS_ID, USER_ID, RELATIONSHIP_ID,
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