DBA Data[Home] [Help]

APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CSM_DEFERRED_TRANSACTIONS_ACC

Line 2130: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'

2126: p_dml_type,l_parent_tracking_id,p_error_msg,sysdate);
2127:
2128: CSM_ACC_PKG.Insert_Acc
2129: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')
2130: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'
2131: ,P_SEQ_NAME => 'CSM_DEFERRED_TXNS_ACC_S'
2132: ,P_PK1_NAME => 'TRACKING_ID'
2133: ,P_PK1_NUM_VALUE => l_tracking_id
2134: ,P_USER_ID => asg_base.get_user_id(p_user_name)

Line 2160: delete from csm_deferred_transactions_acc where user_id=p_user_id;

2156: BEGIN
2157:
2158: delete from csm_auto_sync_nfn_acc where user_id=p_user_id;
2159:
2160: delete from csm_deferred_transactions_acc where user_id=p_user_id;
2161:
2162: delete from csm_deferred_nfn_info where client_id=csm_util_pkg.get_user_name(p_user_id);
2163:
2164: for rec in (select nfn.notification_id from csm_auto_sync_nfn nfn, wf_notifications wfn