17: g_object_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_PKG'; -- package name
18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC';
22: g_auto_sync_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC';
23: g_auto_sync_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC_S';
24: g_auto_sync_pk1_name CONSTANT VARCHAR2(30) := 'ID';
25: g_auto_sync_pk2_name CONSTANT VARCHAR2(30) := 'AUTO_SYNC_NUM';
19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC';
22: g_auto_sync_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC';
23: g_auto_sync_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC_S';
24: g_auto_sync_pk1_name CONSTANT VARCHAR2(30) := 'ID';
25: g_auto_sync_pk2_name CONSTANT VARCHAR2(30) := 'AUTO_SYNC_NUM';
26: g_auto_sync_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC');
229: /***************************************************************************
230: ** Update the record
231: ***************************************************************************/
232:
233: UPDATE csm_auto_sync_acc
234: SET AUTO_SYNC_NUM = l_auto_sync_num,
235: LAST_UPDATE_DATE = sysdate,
236: LAST_UPDATED_BY = l_user_id
237: where ID=l_id