APPS.CSM_MTL_TXN_LOT_NUM_ACC_PKG dependencies on CSM_MTL_TXN_LOT_NUM_ACC

Line 1: PACKAGE BODY CSM_MTL_TXN_LOT_NUM_ACC_PKG AS

1: PACKAGE BODY CSM_MTL_TXN_LOT_NUM_ACC_PKG AS
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';

Line 5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_MTL_TXN_LOT_NUM_ACC';

1: PACKAGE BODY CSM_MTL_TXN_LOT_NUM_ACC_PKG AS
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';

Line 9: g_tasks_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_TXN_LOT_NUM_ACC_S';

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';
12: g_old_user_id NUMBER; -- variable containing old user_id; populated in Pre_Update hook
13: g_debug_level NUMBER; -- debug level

Line 164: FROM CSM_MTL_TXN_LOT_NUM_ACC

160: IS
161: CURSOR c_transaction_lot_number( b_transaction_id NUMBER, b_user_id NUMBER)
162: IS
163: SELECT TRANSACTION_ID, LOT_NUMBER
164: FROM CSM_MTL_TXN_LOT_NUM_ACC
165: WHERE TRANSACTION_ID = b_transaction_id
166: AND USER_ID = b_user_id;
167:
168: r_transaction_lot_number c_transaction_lot_number%ROWTYPE;

Line 228: DELETE CSM_MTL_TXN_LOT_NUM_ACC

224: ( module => g_table_name
225: , message => 'Entering DELETE_ALL_ACC_RECORDS'
226: , log_level => FND_LOG.LEVEL_STATEMENT);
227:
228: DELETE CSM_MTL_TXN_LOT_NUM_ACC
229: WHERE USER_ID = p_user_id;
230:
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:

Line 246: fnd_msg_pub.Add_Exc_Msg('CSM_MTL_TXN_LOT_NUM_ACC_PKG','PROCESS_ACC',sqlerrm);

242: CSM_UTIL_PKG.LOG
243: ( module => g_table_name
244: , message => 'Caught exception in DELETE_ALL_ACC_RECORDS hook:' || fnd_global.local_chr(10) || sqlerrm
245: , log_level => FND_LOG.LEVEL_ERROR);
246: fnd_msg_pub.Add_Exc_Msg('CSM_MTL_TXN_LOT_NUM_ACC_PKG','PROCESS_ACC',sqlerrm);
247: END DELETE_ALL_ACC_RECORDS;
248:
249: END CSM_MTL_TXN_LOT_NUM_ACC_PKG;

Line 249: END CSM_MTL_TXN_LOT_NUM_ACC_PKG;

245: , log_level => FND_LOG.LEVEL_ERROR);
246: fnd_msg_pub.Add_Exc_Msg('CSM_MTL_TXN_LOT_NUM_ACC_PKG','PROCESS_ACC',sqlerrm);
247: END DELETE_ALL_ACC_RECORDS;
248:
249: END CSM_MTL_TXN_LOT_NUM_ACC_PKG;