APPS.CSM_MAIL_RECIPIENTS_PKG dependencies on CSM_ACC_PKG

Line 18: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

14: g_debug_level NUMBER; -- debug level
15:
16: g_notification_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC';
17: g_notification_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
18: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSF_M_MAIL_MESSAGES', 'CSF_M_MAIL_RECIPIENTS');
20:
21: CURSOR c_mail_recipients( b_user_name VARCHAR2, b_tranid NUMBER) is
22: SELECT *

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

15:
16: g_notification_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC';
17: g_notification_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
18: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSF_M_MAIL_MESSAGES', 'CSF_M_MAIL_RECIPIENTS');
20:
21: CURSOR c_mail_recipients( b_user_name VARCHAR2, b_tranid NUMBER) is
22: SELECT *
23: FROM csf_m_mail_recipients_inq

Line 76: CSM_ACC_PKG.Delete_Acc

72: when others then
73: null;
74: end;
75:
76: CSM_ACC_PKG.Delete_Acc
77: ( P_PUBLICATION_ITEM_NAMES => g_notification_pubi_name
78: ,P_ACC_TABLE_NAME => g_notification_acc_table_name
79: ,P_PK1_NAME => g_notification_pk1_name
80: ,P_PK1_NUM_VALUE => p_record.notification_id