APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CSM_AUTO_SYNC_NFN_ACC

Line 451: ,P_ACC_TABLE_NAME => 'CSM_AUTO_SYNC_NFN_ACC'

447: WHERE CREATION_DATE < SYSDATE-l_days)
448: LOOP
449: CSM_ACC_PKG.Delete_Acc
450: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN')
451: ,P_ACC_TABLE_NAME => 'CSM_AUTO_SYNC_NFN_ACC'
452: ,P_PK1_NAME => 'NOTIFICATION_ID'
453: ,P_PK1_NUM_VALUE => nfn_rec.NOTIFICATION_ID
454: ,P_USER_ID => nfn_rec.USER_ID
455: );

Line 975: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc,

971: CURSOR c_sr(b_sr_id NUMBER,b_user_id NUMBER)
972: IS
973: SELECT 1
974: FROM jtf_task_assignments asg, csm_auto_sync_nfn nfn,
975: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc,
976: jtf_tasks_b tsk
977: where tsk.source_object_id=b_sr_id
978: and tsk.source_object_type_code='SR'
979: and tsk.task_id=asg.task_id

Line 1000: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc

996:
997: CURSOR c_task(b_task_id NUMBER,b_user_id NUMBER) IS
998: SELECT 1
999: FROM jtf_task_assignments asg, csm_auto_sync_nfn nfn,
1000: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc
1001: where task_id=b_task_id
1002: and (
1003: (nfn.object_name='TASK' and nfn.object_id=task_id)
1004: OR

Line 1021: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc,

1017:
1018: CURSOR c_task_asg(b_task_ass_id NUMBER,b_user_id NUMBER) IS
1019: SELECT 1
1020: FROM jtf_task_assignments asg, csm_auto_sync_nfn nfn,
1021: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc,
1022: jtf_tasks_b tsk
1023: where task_assignment_id=b_task_ass_id
1024: and tsk.task_id=asg.task_id
1025: and nfn.object_name='TASK_ASSIGNMENT' and nfn.object_id=task_assignment_id

Line 1535: ,P_ACC_TABLE_NAME => 'CSM_AUTO_SYNC_NFN_ACC'

1531: VALUES(l_usr_tab(I),l_not_tab(I),l_entity,l_pk_value,l_mode,0,sysdate,1,sysdate,1);
1532:
1533: CSM_ACC_PKG.Insert_Acc
1534: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN')
1535: ,P_ACC_TABLE_NAME => 'CSM_AUTO_SYNC_NFN_ACC'
1536: ,P_SEQ_NAME => 'CSM_AUTO_SYNC_NFN_ACC_S'
1537: ,P_PK1_NAME => 'NOTIFICATION_ID'
1538: ,P_PK1_NUM_VALUE => l_not_tab(I)
1539: ,P_USER_ID => l_usr_tab(I)

Line 1536: ,P_SEQ_NAME => 'CSM_AUTO_SYNC_NFN_ACC_S'

1532:
1533: CSM_ACC_PKG.Insert_Acc
1534: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN')
1535: ,P_ACC_TABLE_NAME => 'CSM_AUTO_SYNC_NFN_ACC'
1536: ,P_SEQ_NAME => 'CSM_AUTO_SYNC_NFN_ACC_S'
1537: ,P_PK1_NAME => 'NOTIFICATION_ID'
1538: ,P_PK1_NUM_VALUE => l_not_tab(I)
1539: ,P_USER_ID => l_usr_tab(I)
1540: );

Line 2080: ,P_ACC_TABLE_NAME => 'CSM_AUTO_SYNC_NFN_ACC'

2076: VALUES(asg_base.get_user_id(p_user_name),l_notification_id,'DEFERRED_TRANSACTION',l_tracking_id,'NEW',0,sysdate,1,sysdate,1);
2077:
2078: CSM_ACC_PKG.Insert_Acc
2079: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN')
2080: ,P_ACC_TABLE_NAME => 'CSM_AUTO_SYNC_NFN_ACC'
2081: ,P_SEQ_NAME => 'CSM_AUTO_SYNC_NFN_ACC_S'
2082: ,P_PK1_NAME => 'NOTIFICATION_ID'
2083: ,P_PK1_NUM_VALUE => l_notification_id
2084: ,P_USER_ID => asg_base.get_user_id(p_user_name)

Line 2081: ,P_SEQ_NAME => 'CSM_AUTO_SYNC_NFN_ACC_S'

2077:
2078: CSM_ACC_PKG.Insert_Acc
2079: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN')
2080: ,P_ACC_TABLE_NAME => 'CSM_AUTO_SYNC_NFN_ACC'
2081: ,P_SEQ_NAME => 'CSM_AUTO_SYNC_NFN_ACC_S'
2082: ,P_PK1_NAME => 'NOTIFICATION_ID'
2083: ,P_PK1_NUM_VALUE => l_notification_id
2084: ,P_USER_ID => asg_base.get_user_id(p_user_name)
2085: );

Line 2158: delete from csm_auto_sync_nfn_acc where user_id=p_user_id;

2154: PROCEDURE PURGE_USER(p_user_id IN NUMBER)
2155: IS
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);