APPS.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on CSM_INCIDENTS_ALL_ACC

Line 16: g_incidents_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC';

12: g_pk2_name CONSTANT VARCHAR2(30) := 'HISTORY_INCIDENT_ID';
13: g_pk3_name CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
14: g_seq_name CONSTANT VARCHAR2(30) := 'CSM_SERVICE_HISTORY_ACC_S' ;
15:
16: g_incidents_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC';
17: g_incidents_table_name CONSTANT VARCHAR2(30) := 'CS_INCIDENTS_ALL';
18: g_incidents_seq_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC_S' ;
19: g_incidents_pk1_name CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
20: g_incidents_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 18: g_incidents_seq_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC_S' ;

14: g_seq_name CONSTANT VARCHAR2(30) := 'CSM_SERVICE_HISTORY_ACC_S' ;
15:
16: g_incidents_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC';
17: g_incidents_table_name CONSTANT VARCHAR2(30) := 'CS_INCIDENTS_ALL';
18: g_incidents_seq_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC_S' ;
19: g_incidents_pk1_name CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
20: g_incidents_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSM_INCIDENTS_ALL');
22:

Line 441: FROM CSM_INCIDENTS_ALL_ACC acc

437: CURSOR c_acc_incidents
438: IS
439: SELECT acc.INCIDENT_ID
440: , acc.USER_ID
441: FROM CSM_INCIDENTS_ALL_ACC acc
442: , CS_INCIDENTS_ALL_B inc
443: , CS_INCIDENT_STATUSES_b cis
444: , JTF_TASKS_B tsk
445: , JTF_TASK_ASSIGNMENTS ta

Line 468: FROM csm_incidents_all_acc acc

464: history_incident_id
465: FROM csm_service_history_acc hacc
466: WHERE NOT EXISTS
467: (SELECT 'X'
468: FROM csm_incidents_all_acc acc
469: WHERE acc.user_id = hacc.user_id
470: AND acc.incident_id = hacc.incident_id);
471:
472: CURSOR l_upd_last_run_date_csr

Line 666: TYPE l_incident_id_tbl_type IS TABLE OF csm_incidents_all_acc.incident_id%TYPE INDEX BY BINARY_INTEGER;

662:
663: TYPE l_instance_id_tbl_type IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
664: TYPE l_user_id_tbl_type IS TABLE OF csm_parties_acc.user_id%TYPE INDEX BY BINARY_INTEGER;
665: TYPE l_party_id_tbl_type IS TABLE OF csm_parties_acc.party_id%TYPE INDEX BY BINARY_INTEGER;
666: TYPE l_incident_id_tbl_type IS TABLE OF csm_incidents_all_acc.incident_id%TYPE INDEX BY BINARY_INTEGER;
667:
668: l_instance_id_tbl l_instance_id_tbl_type;
669: l_incident_id_tbl l_incident_id_tbl_type;
670: l_user_id_tbl l_user_id_tbl_type;

Line 785: --call the CSM_ACC_PKG to insert into CSM_INCIDENTS_ALL_ACC table

781: END LOOP;
782:
783: FOR i IN l_incident_id_tbl.FIRST..l_incident_id_tbl.LAST LOOP
784:
785: --call the CSM_ACC_PKG to insert into CSM_INCIDENTS_ALL_ACC table
786:
787: CSM_ACC_PKG.Insert_Acc
788: ( P_PUBLICATION_ITEM_NAMES => g_incidents_pubi_name
789: ,P_ACC_TABLE_NAME => g_incidents_acc_table_name

Line 855: --call the CSM_ACC_PKG to Delete from CSM_INCIDENTS_ALL_ACC table

851: END LOOP;
852:
853: FOR i IN l_incident_id_tbl.FIRST..l_incident_id_tbl.LAST LOOP
854:
855: --call the CSM_ACC_PKG to Delete from CSM_INCIDENTS_ALL_ACC table
856:
857: CSM_ACC_PKG.Delete_Acc
858: ( P_PUBLICATION_ITEM_NAMES => g_incidents_pubi_name
859: ,P_ACC_TABLE_NAME => g_incidents_acc_table_name