APPS.MSC_X_USER_EXCEP_GEN dependencies on MSC_USER_EXCEPTION_NTFS

Line 2986: from MSC_USER_EXCEPTION_NTFS

2982: p_result OUT NOCOPY VARCHAR2) Is
2983:
2984: cursor wfNtfRev(l_exception_id in number) is
2985: select WF_ROLE,WF_ROLE_TYPE
2986: from MSC_USER_EXCEPTION_NTFS
2987: where EXCEPTION_ID = l_exception_id and
2988: SEND_NTF_FLAG = 'Y' ;
2989:
2990: l_exception_exist NUMBER := 0;

Line 3815: insert into MSC_USER_EXCEPTION_NTFS(

3811:
3812: end loop;
3813: close adv_exp;
3814:
3815: insert into MSC_USER_EXCEPTION_NTFS(
3816: NOTIFICATION_ENTRY_ID
3817: ,EXCEPTION_ID
3818: ,WF_ROLE
3819: ,WF_ROLE_TYPE

Line 3845: MSC_USER_EXCEPTION_NTFS_S.NEXTVAL

3841: ,ATTRIBUTE15
3842: ,CONTEXT
3843: )
3844: select
3845: MSC_USER_EXCEPTION_NTFS_S.NEXTVAL
3846: ,lexceptionId
3847: ,WF_ROLE
3848: ,WF_ROLE_TYPE
3849: ,SEND_NTF_FLAG

Line 3872: from MSC_USER_EXCEPTION_NTFS

3868: ,ATTRIBUTE13
3869: ,ATTRIBUTE14
3870: ,ATTRIBUTE15
3871: ,CONTEXT
3872: from MSC_USER_EXCEPTION_NTFS
3873: where EXCEPTION_ID = exceptionId;
3874:
3875: insert into MSC_RELATED_EXCEPTIONS
3876: (

Line 4005: /* delete from MSC_USER_EXCEPTION_NTFS

4001: delete from msc_item_exceptions
4002: where exception_type = exceptionId
4003: and exception_group = -99;
4004:
4005: /* delete from MSC_USER_EXCEPTION_NTFS
4006: where EXCEPTION_ID = exceptionId;
4007:
4008: delete from MSC_RELATED_EXCEPTIONS
4009: where EXCEPTION_ID = exceptionId;