DBA Data[Home] [Help]

APPS.CSM_SR_EVENT_PKG dependencies on CSM_ACC_PKG

Line 14: g_incidents_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

10: g_incidents_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC';
11: g_incidents_table_name CONSTANT VARCHAR2(30) := 'CS_INCIDENTS_ALL';
12: g_incidents_seq_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC_S' ;
13: g_incidents_pk1_name CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
14: g_incidents_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
15: CSM_ACC_PKG.t_publication_item_list('CSM_INCIDENTS_ALL');
16:
17: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
18: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC';

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

11: g_incidents_table_name CONSTANT VARCHAR2(30) := 'CS_INCIDENTS_ALL';
12: g_incidents_seq_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC_S' ;
13: g_incidents_pk1_name CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
14: g_incidents_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
15: CSM_ACC_PKG.t_publication_item_list('CSM_INCIDENTS_ALL');
16:
17: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
18: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC';
19: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC_S';

Line 20: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

16:
17: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
18: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC';
19: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC_S';
20: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSM_CSI_ITEM_ATTR');
22: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
23: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
24:

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

17: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
18: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC';
19: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC_S';
20: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSM_CSI_ITEM_ATTR');
22: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
23: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
24:
25: incident_not_found exception;

Line 515: CSM_ACC_PKG.Insert_Acc

511:
512: IF NOT l_htm5_user THEN
513: -- process inserts of additional attributes
514: FOR r_csi_iea_values_ins_rec IN l_csi_iea_values_ins_csr(p_instance_id) LOOP
515: CSM_ACC_PKG.Insert_Acc
516: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
517: ,P_ACC_TABLE_NAME => g_acc_table_name1
518: ,P_SEQ_NAME => g_acc_sequence_name1
519: ,P_PK1_NAME => g_pk1_name1

Line 549: CSM_ACC_PKG.Insert_Acc

545: BEGIN
546: CSM_UTIL_PKG.LOG('Entering INCIDENTS_ACC_I for incident_id: ' || p_incident_id,
547: 'CSM_SR_EVENT_PKG.INCIDENTS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
548:
549: CSM_ACC_PKG.Insert_Acc
550: ( P_PUBLICATION_ITEM_NAMES => g_incidents_pubi_name
551: ,P_ACC_TABLE_NAME => g_incidents_acc_table_name
552: ,P_SEQ_NAME => g_incidents_seq_name
553: ,P_PK1_NAME => g_incidents_pk1_name

Line 782: CSM_ACC_PKG.Delete_acc

778:
779: IF NOT l_htm5_user THEN
780: -- process deletes of additional attributes
781: FOR r_csi_iea_values_del_rec IN l_csi_iea_values_del_csr(p_instance_id) LOOP
782: CSM_ACC_PKG.Delete_acc
783: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
784: ,P_ACC_TABLE_NAME => g_acc_table_name1
785: ,P_PK1_NAME => g_pk1_name1
786: ,P_PK1_NUM_VALUE => r_csi_iea_values_del_rec.attribute_value_id

Line 815: CSM_ACC_PKG.Delete_Acc

811: BEGIN
812: CSM_UTIL_PKG.LOG('Entering INCIDENTS_ACC_D for incident_id: ' || p_incident_id,
813: 'CSM_SR_EVENT_PKG.INCIDENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
814:
815: CSM_ACC_PKG.Delete_Acc
816: ( P_PUBLICATION_ITEM_NAMES => g_incidents_pubi_name
817: ,P_ACC_TABLE_NAME => g_incidents_acc_table_name
818: ,P_PK1_NAME => g_incidents_pk1_name
819: ,P_PK1_NUM_VALUE => p_incident_id

Line 1533: CSM_ACC_PKG.Update_Acc

1529: p_user_id=>r_csm_task_assg_rec.user_id);
1530: END IF;
1531:
1532: -- incidents make dirty for update
1533: CSM_ACC_PKG.Update_Acc
1534: ( P_PUBLICATION_ITEM_NAMES => g_incidents_pubi_name
1535: ,P_ACC_TABLE_NAME => g_incidents_acc_table_name
1536: ,P_USER_ID => r_csm_task_assg_rec.user_id
1537: ,P_ACCESS_ID => r_csm_task_assg_rec.access_id