eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CSM_ACC_PKG

Line 8: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

4: g_notification_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC';
5: g_notification_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
6: g_notification_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC_S';
7: g_notification_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
8: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSF_M_MAIL_MESSAGES', 'CSF_M_MAIL_RECIPIENTS');
10: g_switch_optimize_off BOOLEAN:=TRUE;
11: g_ItemType Varchar2(10) := 'CSM_MSGS';
12:

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

5: g_notification_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
6: g_notification_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC_S';
7: g_notification_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
8: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSF_M_MAIL_MESSAGES', 'CSF_M_MAIL_RECIPIENTS');
10: g_switch_optimize_off BOOLEAN:=TRUE;
11: g_ItemType Varchar2(10) := 'CSM_MSGS';
12:
13: --to DOWNLOAD ALL NON_MFS NFN TO HTML5 USERS

Line 109: CSM_ACC_PKG.Insert_Acc

105: IS
106: l_sysdate DATE;
107: l_count NUMBER;
108: BEGIN
109: CSM_ACC_PKG.Insert_Acc
110: ( P_PUBLICATION_ITEM_NAMES => g_notification_pubi_name
111: ,P_ACC_TABLE_NAME => g_notification_acc_table_name
112: ,P_SEQ_NAME => g_notification_seq_name
113: ,P_PK1_NAME => g_notification_pk1_name

Line 338: CSM_ACC_PKG.Delete_Acc

334:
335: l_notification_id := p_event.GetValueForParameter('NOTIFICATION_ID');
336:
337: FOR r_notification_rec IN c_users(l_notification_id) LOOP
338: CSM_ACC_PKG.Delete_Acc
339: ( P_PUBLICATION_ITEM_NAMES => g_notification_pubi_name
340: ,P_ACC_TABLE_NAME => g_notification_acc_table_name
341: ,P_PK1_NAME => g_notification_pk1_name
342: ,P_PK1_NUM_VALUE => l_notification_id

Line 413: CSM_ACC_PKG.Delete_Acc

409: null;
410: end;
411: END IF;
412:
413: CSM_ACC_PKG.Delete_Acc
414: ( P_PUBLICATION_ITEM_NAMES => g_notification_pubi_name
415: ,P_ACC_TABLE_NAME => g_notification_acc_table_name
416: ,P_PK1_NAME => g_notification_pk1_name
417: ,P_PK1_NUM_VALUE => rec.notification_id

Line 449: CSM_ACC_PKG.Delete_Acc

445:
446: FOR nfn_rec IN (SELECT NOTIFICATION_ID,USER_ID FROM csm_auto_sync_nfn
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

Line 450: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN')

446: FOR nfn_rec IN (SELECT NOTIFICATION_ID,USER_ID FROM csm_auto_sync_nfn
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

Line 464: CSM_ACC_PKG.Delete_Acc

460: FOR nfn_rec IN (SELECT NOTIFICATION_ID,USER_ID FROM csm_client_nfn_log_acc acc
461: WHERE NOT EXISTS (SELECT 1 FROM csm_auto_sync_nfn b
462: WHERE b.NOTIFICATION_ID=acc.NOTIFICATION_ID))
463: LOOP
464: CSM_ACC_PKG.Delete_Acc
465: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_CLIENT_NFN_LOG')
466: ,P_ACC_TABLE_NAME => 'CSM_CLIENT_NFN_LOG_ACC'
467: ,P_PK1_NAME => 'NOTIFICATION_ID'
468: ,P_PK1_NUM_VALUE => nfn_rec.NOTIFICATION_ID

Line 465: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_CLIENT_NFN_LOG')

461: WHERE NOT EXISTS (SELECT 1 FROM csm_auto_sync_nfn b
462: WHERE b.NOTIFICATION_ID=acc.NOTIFICATION_ID))
463: LOOP
464: CSM_ACC_PKG.Delete_Acc
465: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_CLIENT_NFN_LOG')
466: ,P_ACC_TABLE_NAME => 'CSM_CLIENT_NFN_LOG_ACC'
467: ,P_PK1_NAME => 'NOTIFICATION_ID'
468: ,P_PK1_NUM_VALUE => nfn_rec.NOTIFICATION_ID
469: ,P_USER_ID => nfn_rec.USER_ID

Line 1533: CSM_ACC_PKG.Insert_Acc

1529: INSERT INTO csm_auto_sync_nfn(USER_ID,NOTIFICATION_ID,OBJECT_NAME,OBJECT_ID,DML,REMINDERS_SENT,CREATION_DATE,CREATED_BY
1530: ,LAST_UPDATE_DATE,LAST_UPDATED_BY)
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'

Line 1534: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN')

1530: ,LAST_UPDATE_DATE,LAST_UPDATED_BY)
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)

Line 2078: CSM_ACC_PKG.Insert_Acc

2074: INSERT INTO csm_auto_sync_nfn(USER_ID,NOTIFICATION_ID,OBJECT_NAME,OBJECT_ID,DML,REMINDERS_SENT,CREATION_DATE,CREATED_BY
2075: ,LAST_UPDATE_DATE,LAST_UPDATED_BY)
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'

Line 2079: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN')

2075: ,LAST_UPDATE_DATE,LAST_UPDATED_BY)
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

Line 2128: CSM_ACC_PKG.Insert_Acc

2124: DEFERRED_TRAN_ID , SEQUENCE, DML , PARENT_ID , ERROR_MSG ,CREATION_DATE )
2125: VALUES(l_tracking_id,p_user_name,l_notification_id,p_pubitem,p_pk,p_tranid,p_sequence,
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'

Line 2129: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')

2125: VALUES(l_tracking_id,p_user_name,l_notification_id,p_pubitem,p_pk,p_tranid,p_sequence,
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