APPS.CSM_MTL_TXN_LOT_NUM_ACC_PKG dependencies on CSM_ACC_PKG

Line 6: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

2: /* $Header: csmltacb.pls 120.0.12010000.2 2008/10/20 10:40:59 trajasek ship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_MTL_TXN_LOT_NUM_ACC';
6: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
7: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_TXNS_LOT_NUM');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_TRANSACTIONS_LOT_NUMBERS';
9: g_tasks_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_TXN_LOT_NUM_ACC_S';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';

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

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_MTL_TXN_LOT_NUM_ACC';
6: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
7: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_TXNS_LOT_NUM');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_TRANSACTIONS_LOT_NUMBERS';
9: g_tasks_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_TXN_LOT_NUM_ACC_S';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';
11: g_pk2_name CONSTANT VARCHAR2(30) := 'LOT_NUMBER';

Line 53: CSM_ACC_PKG.Insert_Acc

49: IF l_transaction_id_lst.COUNT > 0 THEN
50: /*** Loop over all available records and put them in the acc table ***/
51: FOR i in 1..l_transaction_id_lst.COUNT LOOP
52: /*** Call common package to insert record into ACC table ***/
53: CSM_ACC_PKG.Insert_Acc
54: ( p_publication_item_names => g_publication_item_name
55: ,p_acc_table_name => g_acc_table_name
56: ,p_seq_name => g_tasks_seq_name
57: ,p_user_id => p_user_id

Line 112: l_acc_id := CSM_ACC_PKG.Get_Acc_Id

108:
109: /*** Loop over all available records and put them in the acc table ***/
110: /*** Call common package to insert record into ACC table ***/
111: FOR i in 1..l_transaction_id_lst.COUNT LOOP
112: l_acc_id := CSM_ACC_PKG.Get_Acc_Id
113: ( P_ACC_TABLE_NAME => g_acc_table_name
114: ,p_pk1_name => g_pk1_name
115: ,p_pk1_num_value => l_transaction_id_lst(i)
116: ,p_pk2_name => g_pk2_name

Line 122: CSM_ACC_PKG.Insert_Acc

118: ,p_user_id => p_user_id);
119:
120: IF l_acc_id = -1 THEN
121: /*** Record is not yet in ACC tables. Insert has to be done ***/
122: CSM_ACC_PKG.Insert_Acc
123: ( p_publication_item_names => g_publication_item_name
124: ,p_acc_table_name => g_acc_table_name
125: ,p_seq_name => g_tasks_seq_name
126: ,p_pk1_name => g_pk1_name

Line 134: CSM_ACC_PKG.Update_Acc

130: ,p_user_id => p_user_id
131: );
132: ELSE
133: /*** Record is already in ACC. Only an update is required for re-sending ***/
134: CSM_ACC_PKG.Update_Acc
135: ( p_publication_item_names => g_publication_item_name
136: ,p_acc_table_name => g_acc_table_name
137: ,p_user_id => p_user_id
138: ,p_access_id => l_acc_id

Line 193: CSM_ACC_PKG.Delete_Acc

189: IF l_transaction_id_lst.COUNT > 0 THEN
190: /*** Loop over all available records and put them in the acc table ***/
191: FOR i in 1..l_transaction_id_lst.COUNT LOOP
192: /*** Call common package to insert record into ACC table ***/
193: CSM_ACC_PKG.Delete_Acc
194: ( p_publication_item_names => g_publication_item_name
195: ,p_acc_table_name => g_acc_table_name
196: ,p_user_id => p_user_id
197: ,p_pk1_name => g_pk1_name