APPS.MSC_X_USER_EXCEP_GEN dependencies on MSC_USER_ADV_EXPRESSIONS

Line 793: MSC_USER_ADV_EXPRESSIONS exp

789: NULL,
790: NULL --bug# 2410159
791: from
792: MSC_USER_EXCEPTION_COMPONENTS comp,
793: MSC_USER_ADV_EXPRESSIONS exp
794: where
795: comp.exception_id = v_exception_id
796: AND comp. component_type in (4)
797: AND comp.expression_id = exp.expression_id

Line 1388: from MSC_USER_ADV_EXPRESSIONS

1384: where exception_id = v_exception_id;
1385:
1386: cursor lastUpdateE is
1387: select max(LAST_UPDATE_DATE)
1388: from MSC_USER_ADV_EXPRESSIONS
1389: where expression_id in ( select expression_id
1390: from MSC_USER_EXCEPTION_COMPONENTS
1391: where exception_id = v_exception_id);
1392: l_lastupdatedateC DATE;

Line 3519: MSC_USER_ADV_EXPRESSIONS_S.NEXTVAL

3515: lUserId Number := FND_GLOBAL.USER_ID;
3516:
3517: cursor adv_exp is
3518: select
3519: MSC_USER_ADV_EXPRESSIONS_S.NEXTVAL
3520: ,ex.Expression_Id
3521: ,ex.NAME
3522: ,ex.DESCRIPTION
3523: ,ex.COMPONENT_TYPE

Line 3546: FROM MSC_USER_ADV_EXPRESSIONS ex,

3542: ,ex.ATTRIBUTE13
3543: ,ex.ATTRIBUTE14
3544: ,ex.ATTRIBUTE15
3545: ,ex.CONTEXT
3546: FROM MSC_USER_ADV_EXPRESSIONS ex,
3547: MSC_USER_EXCEPTION_COMPONENTS comp
3548: WHERE ex.EXPRESSION_ID = comp.EXPRESSION_ID
3549: and comp.EXCEPTION_ID = exceptionId;
3550:

Line 3764: insert into MSC_USER_ADV_EXPRESSIONS(

3760: lAttribute8,lAttribute9,lAttribute10,lAttribute11,lAttribute12,lAttribute13,lAttribute14,
3761: lAttribute15,lContext;
3762: exit when adv_exp%NOTFOUND;
3763:
3764: insert into MSC_USER_ADV_EXPRESSIONS(
3765: EXPRESSION_ID
3766: ,NAME
3767: ,DESCRIPTION
3768: ,COMPONENT_TYPE

Line 4011: delete from MSC_USER_ADV_EXPRESSIONS exp

4007:
4008: delete from MSC_RELATED_EXCEPTIONS
4009: where EXCEPTION_ID = exceptionId;
4010: */
4011: delete from MSC_USER_ADV_EXPRESSIONS exp
4012: where exp.expression_id in (
4013: select ex.expression_id
4014: from MSC_USER_EXCEPTION_COMPONENTS ex
4015: where ex.EXCEPTION_ID = exceptionId