APPS.CSM_MTL_MATERIAL_TXN_ACC_PKG dependencies on CSM_ACC_PKG

Line 6: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

2: /* $Header: csmmtacb.pls 120.5.12010000.2 2008/10/20 10:42:08 trajasek ship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_MTL_MATERIAL_TXN_ACC';
6: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
7: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_MATERIAL_TXNS');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_MATERIAL_TRANSACTIONS';
9: g_tasks_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_MATERIAL_TXN_ACC_S';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';

Line 7: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_MATERIAL_TXNS');

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_MTL_MATERIAL_TXN_ACC';
6: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
7: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_MATERIAL_TXNS');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_MATERIAL_TRANSACTIONS';
9: g_tasks_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_MATERIAL_TXN_ACC_S';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';
11:

Line 25: CSM_ACC_PKG.Insert_Acc

21: , message => 'Entering Insert_MTL_Mat_Transaction Procedure to process TRAN ID : ' || p_transaction_id
22: , log_level => FND_LOG.LEVEL_STATEMENT);
23:
24: /*** Call common package to insert record into ACC table ***/
25: CSM_ACC_PKG.Insert_Acc
26: ( p_publication_item_names => g_publication_item_name
27: ,p_acc_table_name => g_acc_table_name
28: ,p_seq_name => g_tasks_seq_name
29: ,p_user_id => p_user_id

Line 65: l_acc_id := CSM_ACC_PKG.Get_Acc_Id

61: , message => ' Entering Update_CSP_Sec_Inventory procedure to process TRAN ID :'|| p_transaction_id
62: , log_level => FND_LOG.LEVEL_STATEMENT);
63:
64: /*** Call common package to insert record into ACC table ***/
65: l_acc_id := CSM_ACC_PKG.Get_Acc_Id
66: ( P_ACC_TABLE_NAME => g_acc_table_name
67: ,P_PK1_NAME => g_pk1_name
68: ,P_PK1_NUM_VALUE => p_transaction_id
69: ,p_user_id => p_user_id);

Line 73: CSM_ACC_PKG.Insert_Acc

69: ,p_user_id => p_user_id);
70:
71: IF l_acc_id = -1 THEN
72: /*** Record is not yet in ACC tables. Insert has to be done ***/
73: CSM_ACC_PKG.Insert_Acc
74: ( p_publication_item_names => g_publication_item_name
75: ,p_acc_table_name => g_acc_table_name
76: ,p_seq_name => g_tasks_seq_name
77: ,p_user_id => p_user_id

Line 83: CSM_ACC_PKG.Update_Acc

79: ,p_pk1_num_value => p_transaction_id
80: );
81: ELSE
82: /*** Record is already in ACC. Only an update is required for re-sending ***/
83: CSM_ACC_PKG.Update_Acc
84: ( p_publication_item_names => g_publication_item_name
85: ,p_acc_table_name => g_acc_table_name
86: ,p_user_id => p_user_id
87: ,p_access_id => l_acc_id

Line 121: CSM_ACC_PKG.Delete_Acc

117: , message =>' Entering Delete_MTL_Mat_Transaction Procedure for TRAN ID :'|| p_transaction_id
118: , log_level => FND_LOG.LEVEL_STATEMENT);
119:
120: /*** Call common package to insert record into ACC table ***/
121: CSM_ACC_PKG.Delete_Acc
122: ( p_publication_item_names => g_publication_item_name
123: ,p_acc_table_name => g_acc_table_name
124: ,p_user_id => p_user_id
125: ,p_pk1_name => g_pk1_name