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

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

Line 194: CSM_ACC_PKG.Delete_Acc

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

Line 253: CSM_ACC_PKG.Delete_Acc

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

Line 900: CSM_ACC_PKG.Insert_Acc

896: p_party_id,
897: p_instance_id,
898: l_parent_instance_id )
899: LOOP
900: CSM_ACC_PKG.Insert_Acc
901: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
902: ,P_ACC_TABLE_NAME => g_acc_table_name1
903: ,P_SEQ_NAME => g_acc_sequence_name1
904: ,P_PK1_NAME => g_pk1_name1

Line 929: CSM_ACC_PKG.Insert_Acc

925: LOOP
926:
927: IF csm_sr_event_pkg.g_ib_count < l_max_ib_at_location
928: THEN
929: CSM_ACC_PKG.Insert_Acc
930: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
931: ,P_ACC_TABLE_NAME => g_acc_table_name1
932: ,P_SEQ_NAME => g_acc_sequence_name1
933: ,P_PK1_NAME => g_pk1_name1

Line 1070: CSM_ACC_PKG.Delete_Acc

1066: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
1067: FOR c_ib_items IN c_ib_at_location_csr (
1068: p_user_id, p_party_site_id, p_location_id, p_party_id, p_incident_id )
1069: LOOP
1070: CSM_ACC_PKG.Delete_Acc
1071: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
1072: ,P_ACC_TABLE_NAME => g_acc_table_name1
1073: ,P_PK1_NAME => g_pk1_name1
1074: ,P_PK1_NUM_VALUE => c_ib_items.instance_id