DBA Data[Home] [Help]

APPS.CSM_AUTO_SYNC_PKG dependencies on CSM_AUTO_SYNC_ACC

Line 21: g_auto_sync_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC';

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';

Line 23: g_auto_sync_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC_S';

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');

Line 233: UPDATE csm_auto_sync_acc

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