APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CSM_ACC_PKG

Line 17: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

13: g_notification_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC';
14: g_notification_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
15: g_notification_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC_S';
16: g_notification_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
17: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_MAIL_MESSAGES', 'CSF_M_MAIL_RECIPIENTS');
19:
20: FUNCTION check_if_notification_exists(p_notification_id IN number, p_user_id IN number)
21: RETURN boolean

Line 18: CSM_ACC_PKG.t_publication_item_list('CSF_M_MAIL_MESSAGES', 'CSF_M_MAIL_RECIPIENTS');

14: g_notification_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
15: g_notification_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC_S';
16: g_notification_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
17: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_MAIL_MESSAGES', 'CSF_M_MAIL_RECIPIENTS');
19:
20: FUNCTION check_if_notification_exists(p_notification_id IN number, p_user_id IN number)
21: RETURN boolean
22: IS

Line 52: CSM_ACC_PKG.Insert_Acc

48: IS
49: l_sysdate DATE;
50: l_count NUMBER;
51: BEGIN
52: CSM_ACC_PKG.Insert_Acc
53: ( P_PUBLICATION_ITEM_NAMES => g_notification_pubi_name
54: ,P_ACC_TABLE_NAME => g_notification_acc_table_name
55: ,P_SEQ_NAME => g_notification_seq_name
56: ,P_PK1_NAME => g_notification_pk1_name

Line 271: CSM_ACC_PKG.Delete_Acc

267:
268: l_notification_id := p_event.GetValueForParameter('NOTIFICATION_ID');
269:
270: FOR r_notification_rec IN c_users(l_notification_id) LOOP
271: CSM_ACC_PKG.Delete_Acc
272: ( P_PUBLICATION_ITEM_NAMES => g_notification_pubi_name
273: ,P_ACC_TABLE_NAME => g_notification_acc_table_name
274: ,P_PK1_NAME => g_notification_pk1_name
275: ,P_PK1_NUM_VALUE => l_notification_id

Line 354: CSM_ACC_PKG.Delete_Acc

350: FOR i IN l_purge_notf_tbl.FIRST..l_purge_notf_tbl.LAST LOOP
351: l_notification_id := l_purge_notf_tbl(i);
352: l_user_id := l_purge_userid_tbl(i);
353:
354: CSM_ACC_PKG.Delete_Acc
355: ( P_PUBLICATION_ITEM_NAMES => g_notification_pubi_name
356: ,P_ACC_TABLE_NAME => g_notification_acc_table_name
357: ,P_PK1_NAME => g_notification_pk1_name
358: ,P_PK1_NUM_VALUE => l_notification_id