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

504: END LOOP;
505:
506: -- process inserts of additional attributes
507: FOR r_csi_iea_values_ins_rec IN l_csi_iea_values_ins_csr(p_instance_id) LOOP
508: CSM_ACC_PKG.Insert_Acc
509: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
510: ,P_ACC_TABLE_NAME => g_acc_table_name1
511: ,P_SEQ_NAME => g_acc_sequence_name1
512: ,P_PK1_NAME => g_pk1_name1

Line 541: CSM_ACC_PKG.Insert_Acc

537: BEGIN
538: CSM_UTIL_PKG.LOG('Entering INCIDENTS_ACC_I for incident_id: ' || p_incident_id,
539: 'CSM_SR_EVENT_PKG.INCIDENTS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
540:
541: CSM_ACC_PKG.Insert_Acc
542: ( P_PUBLICATION_ITEM_NAMES => g_incidents_pubi_name
543: ,P_ACC_TABLE_NAME => g_incidents_acc_table_name
544: ,P_SEQ_NAME => g_incidents_seq_name
545: ,P_PK1_NAME => g_incidents_pk1_name

Line 772: CSM_ACC_PKG.Delete_acc

768: END LOOP;
769:
770: -- process deletes of additional attributes
771: FOR r_csi_iea_values_del_rec IN l_csi_iea_values_del_csr(p_instance_id) LOOP
772: CSM_ACC_PKG.Delete_acc
773: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
774: ,P_ACC_TABLE_NAME => g_acc_table_name1
775: ,P_PK1_NAME => g_pk1_name1
776: ,P_PK1_NUM_VALUE => r_csi_iea_values_del_rec.attribute_value_id

Line 804: CSM_ACC_PKG.Delete_Acc

800: BEGIN
801: CSM_UTIL_PKG.LOG('Entering INCIDENTS_ACC_D for incident_id: ' || p_incident_id,
802: 'CSM_SR_EVENT_PKG.INCIDENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
803:
804: CSM_ACC_PKG.Delete_Acc
805: ( P_PUBLICATION_ITEM_NAMES => g_incidents_pubi_name
806: ,P_ACC_TABLE_NAME => g_incidents_acc_table_name
807: ,P_PK1_NAME => g_incidents_pk1_name
808: ,P_PK1_NUM_VALUE => p_incident_id

Line 1511: CSM_ACC_PKG.Update_Acc

1507: p_user_id=>r_csm_task_assg_rec.user_id);
1508: END IF;
1509:
1510: -- incidents make dirty for update
1511: CSM_ACC_PKG.Update_Acc
1512: ( P_PUBLICATION_ITEM_NAMES => g_incidents_pubi_name
1513: ,P_ACC_TABLE_NAME => g_incidents_acc_table_name
1514: ,P_USER_ID => r_csm_task_assg_rec.user_id
1515: ,P_ACCESS_ID => r_csm_task_assg_rec.access_id