APPS.MSC_X_USER_EXCEP_GEN dependencies on MSC_USER_EXCEPTION_COMPONENTS

Line 756: MSC_USER_EXCEPTION_COMPONENTS comp

752: ak_attributes akattr,
753: ak_region_items AkRegItem,
754: ak_region_items_tl AkRegItemTl,
755: MSC_USER_EXCEPTIONS mse,
756: MSC_USER_EXCEPTION_COMPONENTS comp
757: where
758: mse.region_code = 'MSCUSEREXCEPTION'
759: AND mse.exception_id = v_exception_id
760: AND mse.region_code = AkRegItem.region_code

Line 792: MSC_USER_EXCEPTION_COMPONENTS comp,

788: to_number(null),
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)

Line 1383: from MSC_USER_EXCEPTION_COMPONENTS

1379: lconditionTable VARCHAR2(30);
1380:
1381: cursor lastUpdateC is
1382: select max(LAST_UPDATE_DATE)
1383: from MSC_USER_EXCEPTION_COMPONENTS
1384: where exception_id = v_exception_id;
1385:
1386: cursor lastUpdateE is
1387: select max(LAST_UPDATE_DATE)

Line 1390: from MSC_USER_EXCEPTION_COMPONENTS

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;
1393: l_lastupdatedateE DATE;
1394:

Line 3547: MSC_USER_EXCEPTION_COMPONENTS comp

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:
3551: lExpressionId Number;

Line 3675: insert into MSC_USER_EXCEPTION_COMPONENTS(

3671: from MSC_USER_EXCEPTIONS
3672: where exception_id = exceptionId;
3673:
3674:
3675: insert into MSC_USER_EXCEPTION_COMPONENTS(
3676: COMPONENT_ID
3677: ,EXCEPTION_ID
3678: ,SEQ_NUM
3679: ,COMPONENT_TYPE

Line 3746: from MSC_USER_EXCEPTION_COMPONENTS

3742: ,ATTRIBUTE13
3743: ,ATTRIBUTE14
3744: ,ATTRIBUTE15
3745: ,CONTEXT
3746: from MSC_USER_EXCEPTION_COMPONENTS
3747: where EXCEPTION_ID = exceptionId ;
3748:
3749: -- its is decided to copy calculation also when copying exceptions
3750: --no global calclations. Data model not modified becasue we may want global calculation

Line 3807: update MSC_USER_EXCEPTION_COMPONENTS comp1

3803: lAttribute8,lAttribute9,lAttribute10,lAttribute11,lAttribute12,lAttribute13,lAttribute14,
3804: lAttribute15,lContext
3805: ) ;
3806:
3807: update MSC_USER_EXCEPTION_COMPONENTS comp1
3808: set EXPRESSION_ID = lExpressionId
3809: where EXPRESSION_ID = oldExpressionId
3810: and EXCEPTION_ID = lexceptionId;
3811:

Line 4014: from MSC_USER_EXCEPTION_COMPONENTS ex

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
4016: );
4017: -- calculations are no longer global
4018: --and GLOBAL_FLAG <> 'Y';

Line 4021: delete from MSC_USER_EXCEPTION_COMPONENTS

4017: -- calculations are no longer global
4018: --and GLOBAL_FLAG <> 'Y';
4019:
4020: /*
4021: delete from MSC_USER_EXCEPTION_COMPONENTS
4022: where EXCEPTION_ID = exceptionId;
4023:
4024: delete from MSC_USER_EXCEPTIONS
4025: where EXCEPTION_ID = exceptionId;