DBA Data[Home] [Help]

APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CSM_ACC_PKG

Line 17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
20: g_pub_item CONSTANT VARCHAR2(30) := 'CSF_M_ITEM_INSTANCES';
21:

Line 18: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');

14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
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';

Line 25: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

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';
29:

Line 26: CSM_ACC_PKG.t_publication_item_list('CSF_M_II_RELATIONSHIPS');

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';
29:
30: PROCEDURE ITEM_INSTANCE_MDIRTY_U_ECHUSER(p_instance_id IN NUMBER,

Line 46: CSM_ACC_PKG.Update_Acc

42: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER',FND_LOG.LEVEL_PROCEDURE);
43:
44: -- get users who have access to this instance_ID
45: FOR r_instance_users_rec in l_instance_users_csr(p_instance_id) LOOP
46: CSM_ACC_PKG.Update_Acc
47: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
48: ,P_ACC_TABLE_NAME => g_acc_table_name1
49: ,P_ACCESS_ID => r_instance_users_rec.access_id
50: ,P_USER_ID => r_instance_users_rec.user_id

Line 76: CSM_ACC_PKG.Insert_Acc

72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I ',
74: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
75:
76: CSM_ACC_PKG.Insert_Acc
77: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
78: ,P_ACC_TABLE_NAME => g_acc_table_name2
79: ,P_SEQ_NAME => g_acc_sequence_name2
80: ,P_PK1_NAME => g_pk1_name2

Line 129: CSM_ACC_PKG.Insert_Acc

125: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR ',
126: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
127:
128: IF p_instance_id IS NOT NULL AND p_user_id IS NOT NULL THEN
129: CSM_ACC_PKG.Insert_Acc
130: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
131: ,P_ACC_TABLE_NAME => g_acc_table_name1
132: ,P_SEQ_NAME => g_acc_sequence_name1
133: ,P_PK1_NAME => g_pk1_name1

Line 193: CSM_ACC_PKG.Delete_Acc

189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D ',
191: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
192:
193: CSM_ACC_PKG.Delete_Acc
194: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
195: ,P_ACC_TABLE_NAME => g_acc_table_name2
196: ,P_PK1_NAME => g_pk1_name2
197: ,P_PK1_NUM_VALUE => p_relationship_id

Line 252: CSM_ACC_PKG.Delete_Acc

248: CLOSE l_check_instance_ref ;
249:
250: IF L_REF_EXISTS <> 1 THEN
251: -- delete from csm_item_instances_acc
252: CSM_ACC_PKG.Delete_Acc
253: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
254: ,P_ACC_TABLE_NAME => g_acc_table_name1
255: ,P_PK1_NAME => g_pk1_name1
256: ,P_PK1_NUM_VALUE => p_instance_id

Line 951: CSM_ACC_PKG.Insert_Acc

947: p_party_id,
948: p_instance_id,
949: l_parent_instance_id )
950: LOOP
951: CSM_ACC_PKG.Insert_Acc
952: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
953: ,P_ACC_TABLE_NAME => g_acc_table_name1
954: ,P_SEQ_NAME => g_acc_sequence_name1
955: ,P_PK1_NAME => g_pk1_name1

Line 974: CSM_ACC_PKG.Insert_Acc

970: LOOP
971:
972: IF csm_sr_event_pkg.g_ib_count < l_max_ib_at_location
973: THEN
974: CSM_ACC_PKG.Insert_Acc
975: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
976: ,P_ACC_TABLE_NAME => g_acc_table_name1
977: ,P_SEQ_NAME => g_acc_sequence_name1
978: ,P_PK1_NAME => g_pk1_name1

Line 1111: CSM_ACC_PKG.Delete_Acc

1107: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
1108: FOR c_ib_items IN c_ib_at_location_csr (
1109: p_user_id, p_party_site_id, p_location_id, p_party_id, p_incident_id )
1110: LOOP
1111: CSM_ACC_PKG.Delete_Acc
1112: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
1113: ,P_ACC_TABLE_NAME => g_acc_table_name1
1114: ,P_PK1_NAME => g_pk1_name1
1115: ,P_PK1_NUM_VALUE => c_ib_items.instance_id