APPS.FND_OAM_KBF_SUBS dependencies on FND_OAM_BIZEX_SENT_NOTIF

Line 25: from FND_OAM_BIZEX_SENT_NOTIF

21: fdebug('pSubID:' || pSubID);
22: fdebug('pUniqueExId:' || pUniqueExId);
23:
24: select count(*) into l_count
25: from FND_OAM_BIZEX_SENT_NOTIF
26: where
27: UNIQUE_EXCEPTION_ID = pUniqueExId
28: and SUBSCRIPTION_ID = pSubID
29: ;

Line 423: insert into FND_OAM_BIZEX_SENT_NOTIF(UNIQUE_EXCEPTION_ID, SUBSCRIPTION_ID, SENT) values

419: l_sub_list := subs_record.role_id;
420: ELSE
421: l_sub_list := l_sub_list || ','|| subs_record.role_id;
422: END IF;
423: insert into FND_OAM_BIZEX_SENT_NOTIF(UNIQUE_EXCEPTION_ID, SUBSCRIPTION_ID, SENT) values
424: (l_unique_ex_id, subs_record.SUBSCRIPTION_ID, sysdate);
425:
426: ---fdebug('l_sub_list=' || l_sub_list);
427: