APPS.MTH_PROCESS_UDA_PKG dependencies on MTH_EXT_ATTR_ERR

Line 514: INSERT INTO MTH_EXT_ATTR_ERR

510: BEGIN
511: mth_util_pkg.log_msg('PROCESS_INTERFACE_TO_STAGING start', mth_util_pkg.G_DBG_PROC_FUN_START);
512: mth_util_pkg.log_msg('p_entity = ' || p_entity , mth_util_pkg.G_DBG_PARAM_VAL);
513:
514: INSERT INTO MTH_EXT_ATTR_ERR
515: (
516: ATTR_GRP_NAME,
517: ATTR_NAME,
518: ATTR_VALUE,

Line 577: mth_util_pkg.log_msg('Number of rows inserted in MTH_EXT_ATTR_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

573: )
574: )
575: );
576:
577: mth_util_pkg.log_msg('Number of rows inserted in MTH_EXT_ATTR_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
578:
579:
580:
581:

Line 658: MTH_EXT_ATTR_ERR

654:
655:
656: INSERT
657: INTO
658: MTH_EXT_ATTR_ERR
659: (ATTR_GRP_NAME,
660: ATTR_NAME,
661: ATTR_VALUE,
662: GROUP_ID)

Line 670: MTH_EXT_ATTR_ERR err,

666: stg.ATTR_VALUE,
667: stg.attr_group_id
668: FROM
669: ego_attr_groups_v egv,
670: MTH_EXT_ATTR_ERR err,
671: MTH_EXT_ATTR_T_STG stg
672: WHERE
673: ( stg.ATTR_GROUP_ID = egv.ATTR_GROUP_ID) AND
674: (stg.GROUP_ID = err.GROUP_ID) AND

Line 678: mth_util_pkg.log_msg('Number of rows inserted in MTH_EXT_ATTR_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

674: (stg.GROUP_ID = err.GROUP_ID) AND
675: ( egv.ATTR_GROUP_NAME = err.ATTR_GRP_NAME)
676: );
677:
678: mth_util_pkg.log_msg('Number of rows inserted in MTH_EXT_ATTR_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
679:
680:
681: DELETE
682: FROM

Line 693: MTH_EXT_ATTR_ERR err

689: err.ATTR_VALUE,
690: err.GROUP_ID
691: FROM
692: ego_attr_groups_v egv,
693: MTH_EXT_ATTR_ERR err
694: WHERE
695: (egv.APPLICATION_ID = 9001 ) AND
696: (egv.ATTR_GROUP_TYPE = Decode(P_ENTITY,'EQUIPMENTS','MTH_EQUIPMENTS_GROUP','ITEMS','MTH_ITEMS_GROUP','OTHERS','MTH_OTHERS_GROUP',
697: 'PRODUCTION_SCHEDULES','MTH_PROD_SCH_GROUP','PRODUCTION_SEGMENTS','MTH_PRODUCTION_SEGMENTS_GROUP',

Line 733: MTH_UTIL_PKG.MTH_TRUNCATE_TABLE('MTH_EXT_ATTR_ERR');

729: --MTH_EXT_ATTR_EQ,IT,OT,PSG,PS,UE_PF--
730: mth_util_pkg.log_msg('PROCESS_UDA_STATIC_DATA start', mth_util_pkg.G_DBG_PROC_FUN_START);
731: mth_util_pkg.log_msg('p_entity = ' || p_entity , mth_util_pkg.G_DBG_PARAM_VAL);
732:
733: MTH_UTIL_PKG.MTH_TRUNCATE_TABLE('MTH_EXT_ATTR_ERR');
734: MTH_PROCESS_UDA_PKG.PROCESS_INTERFACE_TO_STAGING(p_entity);
735: IF p_entity = 'USER_ENTITIES' THEN
736: MTH_COMMON_PKG.CALL_NTB_UPLOAD_COMPOSITE_PK(p_entity);
737: ELSE