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_SERVICE_HISTORY_EVENT_PKG dependencies on CSM_ACC_PKG

Line 8: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

4: /*** Globals ***/
5: g_debug_level NUMBER;
6: g_object_name CONSTANT VARCHAR2(30) := 'CSM_SERVICE_HISTORY_EVENT_PKG' ;
7: g_table_name CONSTANT VARCHAR2(30) := 'CSM_SERVICE_HISTORY';
8: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSM_SERVICE_HISTORY');
10: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_SERVICE_HISTORY_ACC';
11: g_pk1_name CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
12: g_pk2_name CONSTANT VARCHAR2(30) := 'HISTORY_INCIDENT_ID';

Line 9: CSM_ACC_PKG.t_publication_item_list('CSM_SERVICE_HISTORY');

5: g_debug_level NUMBER;
6: g_object_name CONSTANT VARCHAR2(30) := 'CSM_SERVICE_HISTORY_EVENT_PKG' ;
7: g_table_name CONSTANT VARCHAR2(30) := 'CSM_SERVICE_HISTORY';
8: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSM_SERVICE_HISTORY');
10: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_SERVICE_HISTORY_ACC';
11: g_pk1_name CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
12: g_pk2_name CONSTANT VARCHAR2(30) := 'HISTORY_INCIDENT_ID';
13: g_pk3_name CONSTANT VARCHAR2(30) := 'INSTANCE_ID';

Line 20: g_incidents_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

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:
23: PROCEDURE DELETE_HISTORY_SR_RECORD( p_incident_id NUMBER
24: , p_history_id NUMBER

Line 21: CSM_ACC_PKG.t_publication_item_list('CSM_INCIDENTS_ALL');

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:
23: PROCEDURE DELETE_HISTORY_SR_RECORD( p_incident_id NUMBER
24: , p_history_id NUMBER
25: , p_user_id NUMBER )

Line 551: CSM_ACC_PKG.Insert_Acc

547: CSM_UTIL_PKG.LOG('Entering SERVICE_HISTORY_ACC_I for incident_id: ' || p_incident_id
548: || ' and parent_incident_id:' || p_parent_incident_id,
549: 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_I',FND_LOG.LEVEL_PROCEDURE);
550:
551: CSM_ACC_PKG.Insert_Acc
552: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
553: ,P_ACC_TABLE_NAME => g_acc_table_name
554: ,P_SEQ_NAME => g_seq_name
555: ,P_PK1_NAME => g_pk1_name

Line 636: CSM_ACC_PKG.Delete_Acc

632: CSM_UTIL_PKG.LOG('Entering SERVICE_HISTORY_ACC_D for incident_id: ' || p_incident_id
633: || ' and parent_incident_id:' || p_parent_incident_id,
634: 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_D',FND_LOG.LEVEL_PROCEDURE);
635:
636: CSM_ACC_PKG.Delete_Acc
637: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
638: ,P_ACC_TABLE_NAME => g_acc_table_name
639: ,P_PK1_NAME => g_pk1_name
640: ,P_PK1_NUM_VALUE => p_parent_incident_id

Line 766: --call the CSM_ACC_PKG to insert into csm_service_history_acc table

762: IF l_incident_id_tbl.COUNT > 0 THEN
763:
764: FOR i IN l_incident_id_tbl.FIRST..l_incident_id_tbl.LAST LOOP
765:
766: --call the CSM_ACC_PKG to insert into csm_service_history_acc table
767:
768: CSM_ACC_PKG.Insert_Acc
769: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
770: ,P_ACC_TABLE_NAME => g_acc_table_name

Line 768: CSM_ACC_PKG.Insert_Acc

764: FOR i IN l_incident_id_tbl.FIRST..l_incident_id_tbl.LAST LOOP
765:
766: --call the CSM_ACC_PKG to insert into csm_service_history_acc table
767:
768: CSM_ACC_PKG.Insert_Acc
769: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
770: ,P_ACC_TABLE_NAME => g_acc_table_name
771: ,P_SEQ_NAME => g_seq_name
772: ,P_PK1_NAME => g_pk1_name

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 787: CSM_ACC_PKG.Insert_Acc

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
790: ,P_SEQ_NAME => g_incidents_seq_name
791: ,P_PK1_NAME => g_incidents_pk1_name

Line 837: --call the CSM_ACC_PKG to delete from csm_service_history_acc table

833: IF l_incident_id_tbl.COUNT > 0 THEN
834:
835: FOR i IN l_incident_id_tbl.FIRST..l_incident_id_tbl.LAST LOOP
836:
837: --call the CSM_ACC_PKG to delete from csm_service_history_acc table
838:
839: CSM_ACC_PKG.Delete_Acc
840: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
841: ,P_ACC_TABLE_NAME => g_acc_table_name

Line 839: CSM_ACC_PKG.Delete_Acc

835: FOR i IN l_incident_id_tbl.FIRST..l_incident_id_tbl.LAST LOOP
836:
837: --call the CSM_ACC_PKG to delete from csm_service_history_acc table
838:
839: CSM_ACC_PKG.Delete_Acc
840: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
841: ,P_ACC_TABLE_NAME => g_acc_table_name
842: ,P_PK1_NAME => g_pk1_name
843: ,P_PK1_NUM_VALUE => l_parent_incident_id

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

Line 857: CSM_ACC_PKG.Delete_Acc

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
860: ,P_PK1_NAME => g_incidents_pk1_name
861: ,P_PK1_NUM_VALUE => l_incident_id_tbl(i)