eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTH_UTIL_PKG dependencies on MTH_UTIL_PKG

Line 1: PACKAGE BODY mth_util_pkg AS

1: PACKAGE BODY mth_util_pkg AS
2: /*$Header: mthutilb.pls 120.36.12020000.5 2012/11/29 12:53:44 sasuren ship $ */
3:
4:
5: /* *****************************************************************************

Line 494: WHERE item_fk_key != MTH_UTIL_PKG.MTH_UA_GET_VAL

490: decode(level2_fk_key,NULL,0,1) +
491: decode(level1_fk_key,NULL,0,1)) over(PARTITION BY hierarchy_id)
492: max_level--maximum level in the hierarchy
493: FROM mth_item_denorm_d
494: WHERE item_fk_key != MTH_UTIL_PKG.MTH_UA_GET_VAL
495: )
496: WHERE c_level 497: AND level9_fk_key IS NOT NULL
498: )';

Line 616: mth_util_pkg.log_msg('Truncated table '||p_table_name, mth_util_pkg.G_DBG_USER_INFO);

612: --Prepare the truncate statement using schema name and table name
613: v_stmt := 'TRUNCATE TABLE '||p_schema_name||'.'||p_table_name;
614: EXECUTE IMMEDIATE v_stmt;
615: -- Truncate called for table
616: mth_util_pkg.log_msg('Truncated table '||p_table_name, mth_util_pkg.G_DBG_USER_INFO);
617:
618: END mth_truncate_table;
619:
620: /* ****************************************************************************

Line 1320: v_unassigned_string VARCHAR2(20) := to_char(mth_util_pkg.mth_ua_get_val);

1316: IS
1317: v_bneed_refresh BOOLEAN := FALSE;
1318: v_last_refresh_date DATE;
1319: v_refresh_date_required DATE;
1320: v_unassigned_string VARCHAR2(20) := to_char(mth_util_pkg.mth_ua_get_val);
1321: v_mv_name varchar2(30);
1322: cursor getRefreshDate (p_mv_name in varchar2) is
1323: SELECT last_refresh_date
1324: FROM user_mviews

Line 2788: v_unassigned_string VARCHAR2(20) := to_char(mth_util_pkg.mth_ua_get_val);

2784: p_user_measure2 IN NUMBER,p_user_measure3 IN NUMBER, p_user_measure4 IN NUMBER,
2785: p_user_measure5 IN NUMBER ,p_hour_fk_key IN NUMBER,p_hour_fk IN VARCHAR2,p_hour_to_time IN DATE) IS
2786:
2787: --initialize variables here
2788: v_unassigned_string VARCHAR2(20) := to_char(mth_util_pkg.mth_ua_get_val);
2789: v_count NUMBER;
2790: v_next_hour_from_time DATE;
2791: v_next_hour_to_time DATE;
2792: v_next_hour_fk_key VARCHAR2(120);

Line 3041: l_system_fk_key := "MTH_UTIL_PKG"."MTH_UA_GET_VAL"();

3037: ELSE
3038: l_start_date := p_start_date;
3039: END IF;
3040: l_end_date := p_end_date;
3041: l_system_fk_key := "MTH_UTIL_PKG"."MTH_UA_GET_VAL"();
3042:
3043: IF (l_end_date > l_start_date)
3044: THEN
3045: --DELETE FROM mth_workday_shifts_D WHERE plant_fk_key = l_plant_fk_key and shift_date>=l_start_date ;

Line 3273: VALUES(mth_workdays_shifts_s.nextval,TO_CHAR(l_start_date,'yyyymmdd-hh24:mi:ss')||'-'||l_plant_pk|| "MTH_UTIL_PKG"."MTH_UA_GET_VAL"(),l_start_date ,TO_NUMBER(TO_CHAR( l_start_date ,'J')),

3269: INSERT INTO mth_workday_shifts_D(shift_workday_pk_key, shift_workday_pk,
3270: shift_date,shift_date_julian,plant_fk_key,shift_type,graveyard_shift,from_date,to_date, shift_num,shift_name,source_org_code,system_fk_key,
3271: creation_date,last_update_date,creation_system_id,
3272: last_update_system_id)
3273: VALUES(mth_workdays_shifts_s.nextval,TO_CHAR(l_start_date,'yyyymmdd-hh24:mi:ss')||'-'||l_plant_pk|| "MTH_UTIL_PKG"."MTH_UA_GET_VAL"(),l_start_date ,TO_NUMBER(TO_CHAR( l_start_date ,'J')),
3274: l_plant_fk_key,'BOTH',null,null,
3275: null,null,FND_PROFILE.VALUE('MTH_CATCH_ALL_NAME'),null, l_system_fk_key,
3276: l_sysdate, l_sysdate,l_creation_system_id,l_last_update_system_id);
3277: l_start_date := l_start_date+1;

Line 3597: --mth_util_pkg.switch_column_default_value(v_raw_tab_name, v_curr_partition);

3593:
3594: Begin
3595:
3596: -- 1. First switch the partition for the meter readings raw table
3597: --mth_util_pkg.switch_column_default_value(v_raw_tab_name, v_curr_partition);
3598: IF (v_curr_partition = 0) THEN
3599: -- No data available in the table to be processed
3600: RETURN;
3601: END IF;

Line 3864: mth_util_pkg.log_msg('GET_RUN_LOG_DATES start', mth_util_pkg.G_DBG_PROC_FUN_START);

3860: p_to_date OUT NOCOPY DATE)
3861: IS
3862:
3863: BEGIN
3864: mth_util_pkg.log_msg('GET_RUN_LOG_DATES start', mth_util_pkg.G_DBG_PROC_FUN_START);
3865: mth_util_pkg.log_msg('p_fact_table = ' || p_fact_table , mth_util_pkg.G_DBG_PARAM_VAL);
3866: mth_util_pkg.log_msg('p_db_global_name = ' || p_db_global_name , mth_util_pkg.G_DBG_PARAM_VAL);
3867: mth_util_pkg.log_msg('p_hub_organization_code = ' || p_hub_organization_code, mth_util_pkg.G_DBG_PARAM_VAL);
3868: mth_util_pkg.log_msg('p_ebs_organization_id = ' || p_ebs_organization_id , mth_util_pkg.G_DBG_PARAM_VAL);

Line 3865: mth_util_pkg.log_msg('p_fact_table = ' || p_fact_table , mth_util_pkg.G_DBG_PARAM_VAL);

3861: IS
3862:
3863: BEGIN
3864: mth_util_pkg.log_msg('GET_RUN_LOG_DATES start', mth_util_pkg.G_DBG_PROC_FUN_START);
3865: mth_util_pkg.log_msg('p_fact_table = ' || p_fact_table , mth_util_pkg.G_DBG_PARAM_VAL);
3866: mth_util_pkg.log_msg('p_db_global_name = ' || p_db_global_name , mth_util_pkg.G_DBG_PARAM_VAL);
3867: mth_util_pkg.log_msg('p_hub_organization_code = ' || p_hub_organization_code, mth_util_pkg.G_DBG_PARAM_VAL);
3868: mth_util_pkg.log_msg('p_ebs_organization_id = ' || p_ebs_organization_id , mth_util_pkg.G_DBG_PARAM_VAL);
3869:

Line 3866: mth_util_pkg.log_msg('p_db_global_name = ' || p_db_global_name , mth_util_pkg.G_DBG_PARAM_VAL);

3862:
3863: BEGIN
3864: mth_util_pkg.log_msg('GET_RUN_LOG_DATES start', mth_util_pkg.G_DBG_PROC_FUN_START);
3865: mth_util_pkg.log_msg('p_fact_table = ' || p_fact_table , mth_util_pkg.G_DBG_PARAM_VAL);
3866: mth_util_pkg.log_msg('p_db_global_name = ' || p_db_global_name , mth_util_pkg.G_DBG_PARAM_VAL);
3867: mth_util_pkg.log_msg('p_hub_organization_code = ' || p_hub_organization_code, mth_util_pkg.G_DBG_PARAM_VAL);
3868: mth_util_pkg.log_msg('p_ebs_organization_id = ' || p_ebs_organization_id , mth_util_pkg.G_DBG_PARAM_VAL);
3869:
3870: SELECT MAX(FROM_DATE), MAX(TO_DATE)

Line 3867: mth_util_pkg.log_msg('p_hub_organization_code = ' || p_hub_organization_code, mth_util_pkg.G_DBG_PARAM_VAL);

3863: BEGIN
3864: mth_util_pkg.log_msg('GET_RUN_LOG_DATES start', mth_util_pkg.G_DBG_PROC_FUN_START);
3865: mth_util_pkg.log_msg('p_fact_table = ' || p_fact_table , mth_util_pkg.G_DBG_PARAM_VAL);
3866: mth_util_pkg.log_msg('p_db_global_name = ' || p_db_global_name , mth_util_pkg.G_DBG_PARAM_VAL);
3867: mth_util_pkg.log_msg('p_hub_organization_code = ' || p_hub_organization_code, mth_util_pkg.G_DBG_PARAM_VAL);
3868: mth_util_pkg.log_msg('p_ebs_organization_id = ' || p_ebs_organization_id , mth_util_pkg.G_DBG_PARAM_VAL);
3869:
3870: SELECT MAX(FROM_DATE), MAX(TO_DATE)
3871: INTO p_from_date, p_to_date

Line 3868: mth_util_pkg.log_msg('p_ebs_organization_id = ' || p_ebs_organization_id , mth_util_pkg.G_DBG_PARAM_VAL);

3864: mth_util_pkg.log_msg('GET_RUN_LOG_DATES start', mth_util_pkg.G_DBG_PROC_FUN_START);
3865: mth_util_pkg.log_msg('p_fact_table = ' || p_fact_table , mth_util_pkg.G_DBG_PARAM_VAL);
3866: mth_util_pkg.log_msg('p_db_global_name = ' || p_db_global_name , mth_util_pkg.G_DBG_PARAM_VAL);
3867: mth_util_pkg.log_msg('p_hub_organization_code = ' || p_hub_organization_code, mth_util_pkg.G_DBG_PARAM_VAL);
3868: mth_util_pkg.log_msg('p_ebs_organization_id = ' || p_ebs_organization_id , mth_util_pkg.G_DBG_PARAM_VAL);
3869:
3870: SELECT MAX(FROM_DATE), MAX(TO_DATE)
3871: INTO p_from_date, p_to_date
3872: FROM MTH_RUN_LOG

Line 3881: mth_util_pkg.log_msg('p_from_date = ' || to_char(p_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

3877: OR ebs_organization_id IS NULL)
3878: AND (hub_organization_code = nvl(p_hub_organization_code,hub_organization_code)
3879: OR hub_organization_code IS NULL);
3880:
3881: mth_util_pkg.log_msg('p_from_date = ' || to_char(p_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
3882: mth_util_pkg.log_msg('p_to_date = ' || to_char(p_to_date, 'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
3883: mth_util_pkg.log_msg('GET_RUN_LOG_DATES end', mth_util_pkg.G_DBG_PROC_FUN_END);
3884:
3885: END GET_RUN_LOG_DATES;

Line 3882: mth_util_pkg.log_msg('p_to_date = ' || to_char(p_to_date, 'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

3878: AND (hub_organization_code = nvl(p_hub_organization_code,hub_organization_code)
3879: OR hub_organization_code IS NULL);
3880:
3881: mth_util_pkg.log_msg('p_from_date = ' || to_char(p_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
3882: mth_util_pkg.log_msg('p_to_date = ' || to_char(p_to_date, 'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
3883: mth_util_pkg.log_msg('GET_RUN_LOG_DATES end', mth_util_pkg.G_DBG_PROC_FUN_END);
3884:
3885: END GET_RUN_LOG_DATES;
3886:

Line 3883: mth_util_pkg.log_msg('GET_RUN_LOG_DATES end', mth_util_pkg.G_DBG_PROC_FUN_END);

3879: OR hub_organization_code IS NULL);
3880:
3881: mth_util_pkg.log_msg('p_from_date = ' || to_char(p_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
3882: mth_util_pkg.log_msg('p_to_date = ' || to_char(p_to_date, 'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
3883: mth_util_pkg.log_msg('GET_RUN_LOG_DATES end', mth_util_pkg.G_DBG_PROC_FUN_END);
3884:
3885: END GET_RUN_LOG_DATES;
3886:
3887:

Line 3905: mth_util_pkg.g_mth_debug := nvl(fnd_profile.value('MTH_DEBUG_LEVEL'),0);

3901: p_execution_id IN OUT NOCOPY NUMBER
3902: ) IS
3903: BEGIN
3904:
3905: mth_util_pkg.g_mth_debug := nvl(fnd_profile.value('MTH_DEBUG_LEVEL'),0);
3906: mth_util_pkg.g_debug_indent_level := 0;
3907: if FND_GLOBAL.CONC_REQUEST_ID <> -1 then
3908: mth_util_pkg.g_execution_id := -1;
3909: else

Line 3906: mth_util_pkg.g_debug_indent_level := 0;

3902: ) IS
3903: BEGIN
3904:
3905: mth_util_pkg.g_mth_debug := nvl(fnd_profile.value('MTH_DEBUG_LEVEL'),0);
3906: mth_util_pkg.g_debug_indent_level := 0;
3907: if FND_GLOBAL.CONC_REQUEST_ID <> -1 then
3908: mth_util_pkg.g_execution_id := -1;
3909: else
3910: if p_execution_id is null then

Line 3908: mth_util_pkg.g_execution_id := -1;

3904:
3905: mth_util_pkg.g_mth_debug := nvl(fnd_profile.value('MTH_DEBUG_LEVEL'),0);
3906: mth_util_pkg.g_debug_indent_level := 0;
3907: if FND_GLOBAL.CONC_REQUEST_ID <> -1 then
3908: mth_util_pkg.g_execution_id := -1;
3909: else
3910: if p_execution_id is null then
3911: mth_util_pkg.g_execution_id := MTH_EXECUTION_S.NEXTVAL;
3912: p_execution_id := mth_util_pkg.g_execution_id;

Line 3911: mth_util_pkg.g_execution_id := MTH_EXECUTION_S.NEXTVAL;

3907: if FND_GLOBAL.CONC_REQUEST_ID <> -1 then
3908: mth_util_pkg.g_execution_id := -1;
3909: else
3910: if p_execution_id is null then
3911: mth_util_pkg.g_execution_id := MTH_EXECUTION_S.NEXTVAL;
3912: p_execution_id := mth_util_pkg.g_execution_id;
3913: else
3914: mth_util_pkg.g_execution_id := p_execution_id;
3915: end if;

Line 3912: p_execution_id := mth_util_pkg.g_execution_id;

3908: mth_util_pkg.g_execution_id := -1;
3909: else
3910: if p_execution_id is null then
3911: mth_util_pkg.g_execution_id := MTH_EXECUTION_S.NEXTVAL;
3912: p_execution_id := mth_util_pkg.g_execution_id;
3913: else
3914: mth_util_pkg.g_execution_id := p_execution_id;
3915: end if;
3916:

Line 3914: mth_util_pkg.g_execution_id := p_execution_id;

3910: if p_execution_id is null then
3911: mth_util_pkg.g_execution_id := MTH_EXECUTION_S.NEXTVAL;
3912: p_execution_id := mth_util_pkg.g_execution_id;
3913: else
3914: mth_util_pkg.g_execution_id := p_execution_id;
3915: end if;
3916:
3917: select value
3918: into mth_util_pkg.g_debug_file_dir

Line 3918: into mth_util_pkg.g_debug_file_dir

3914: mth_util_pkg.g_execution_id := p_execution_id;
3915: end if;
3916:
3917: select value
3918: into mth_util_pkg.g_debug_file_dir
3919: from v$parameter2
3920: where name='utl_file_dir'
3921: and rownum = 1;
3922:

Line 3924: mth_util_pkg.log_msg('-----------------------------------------------------', 1);

3920: where name='utl_file_dir'
3921: and rownum = 1;
3922:
3923: end if;
3924: mth_util_pkg.log_msg('-----------------------------------------------------', 1);
3925: mth_util_pkg.log_msg('Initialize called for - ' || p_context_desc, 1);
3926:
3927: EXCEPTION
3928: WHEN OTHERS THEN

Line 3925: mth_util_pkg.log_msg('Initialize called for - ' || p_context_desc, 1);

3921: and rownum = 1;
3922:
3923: end if;
3924: mth_util_pkg.log_msg('-----------------------------------------------------', 1);
3925: mth_util_pkg.log_msg('Initialize called for - ' || p_context_desc, 1);
3926:
3927: EXCEPTION
3928: WHEN OTHERS THEN
3929: return;

Line 3954: if mth_util_pkg.g_mth_debug is null then

3950: l_indent_level NUMBER;
3951: l_execution_id NUMBER;
3952: BEGIN
3953:
3954: if mth_util_pkg.g_mth_debug is null then
3955: Initialize_Debug('Unknown',l_execution_id);
3956: end if;
3957:
3958: if p_msg_lvl <= mth_util_pkg.g_mth_debug then

Line 3958: if p_msg_lvl <= mth_util_pkg.g_mth_debug then

3954: if mth_util_pkg.g_mth_debug is null then
3955: Initialize_Debug('Unknown',l_execution_id);
3956: end if;
3957:
3958: if p_msg_lvl <= mth_util_pkg.g_mth_debug then
3959:
3960: if p_msg_lvl = mth_util_pkg.G_DBG_PROC_FUN_END then
3961: mth_util_pkg.g_debug_indent_level := mth_util_pkg.g_debug_indent_level - 1;
3962: end if;

Line 3960: if p_msg_lvl = mth_util_pkg.G_DBG_PROC_FUN_END then

3956: end if;
3957:
3958: if p_msg_lvl <= mth_util_pkg.g_mth_debug then
3959:
3960: if p_msg_lvl = mth_util_pkg.G_DBG_PROC_FUN_END then
3961: mth_util_pkg.g_debug_indent_level := mth_util_pkg.g_debug_indent_level - 1;
3962: end if;
3963: if p_msg_lvl = 0 then
3964: l_indent_level := 0;

Line 3961: mth_util_pkg.g_debug_indent_level := mth_util_pkg.g_debug_indent_level - 1;

3957:
3958: if p_msg_lvl <= mth_util_pkg.g_mth_debug then
3959:
3960: if p_msg_lvl = mth_util_pkg.G_DBG_PROC_FUN_END then
3961: mth_util_pkg.g_debug_indent_level := mth_util_pkg.g_debug_indent_level - 1;
3962: end if;
3963: if p_msg_lvl = 0 then
3964: l_indent_level := 0;
3965: else

Line 3966: l_indent_level := 2 * mth_util_pkg.g_debug_indent_level;

3962: end if;
3963: if p_msg_lvl = 0 then
3964: l_indent_level := 0;
3965: else
3966: l_indent_level := 2 * mth_util_pkg.g_debug_indent_level;
3967: end if;
3968: if p_msg_lvl = mth_util_pkg.G_DBG_PROC_FUN_START then
3969: mth_util_pkg.g_debug_indent_level := mth_util_pkg.g_debug_indent_level + 1;
3970: end if;

Line 3968: if p_msg_lvl = mth_util_pkg.G_DBG_PROC_FUN_START then

3964: l_indent_level := 0;
3965: else
3966: l_indent_level := 2 * mth_util_pkg.g_debug_indent_level;
3967: end if;
3968: if p_msg_lvl = mth_util_pkg.G_DBG_PROC_FUN_START then
3969: mth_util_pkg.g_debug_indent_level := mth_util_pkg.g_debug_indent_level + 1;
3970: end if;
3971:
3972: if mth_util_pkg.g_execution_id = -1 then

Line 3969: mth_util_pkg.g_debug_indent_level := mth_util_pkg.g_debug_indent_level + 1;

3965: else
3966: l_indent_level := 2 * mth_util_pkg.g_debug_indent_level;
3967: end if;
3968: if p_msg_lvl = mth_util_pkg.G_DBG_PROC_FUN_START then
3969: mth_util_pkg.g_debug_indent_level := mth_util_pkg.g_debug_indent_level + 1;
3970: end if;
3971:
3972: if mth_util_pkg.g_execution_id = -1 then
3973: fnd_file.put_line(FND_FILE.LOG, LPad(' ',l_indent_level,' ') || p_msg_txt);

Line 3972: if mth_util_pkg.g_execution_id = -1 then

3968: if p_msg_lvl = mth_util_pkg.G_DBG_PROC_FUN_START then
3969: mth_util_pkg.g_debug_indent_level := mth_util_pkg.g_debug_indent_level + 1;
3970: end if;
3971:
3972: if mth_util_pkg.g_execution_id = -1 then
3973: fnd_file.put_line(FND_FILE.LOG, LPad(' ',l_indent_level,' ') || p_msg_txt);
3974: else
3975: fname := utl_file.fopen(mth_util_pkg.g_debug_file_dir,'MOC-'||mth_util_pkg.g_execution_id,'a');
3976: utl_file.put(fname, LPad(' ',l_indent_level,' ') || p_msg_txt);

Line 3975: fname := utl_file.fopen(mth_util_pkg.g_debug_file_dir,'MOC-'||mth_util_pkg.g_execution_id,'a');

3971:
3972: if mth_util_pkg.g_execution_id = -1 then
3973: fnd_file.put_line(FND_FILE.LOG, LPad(' ',l_indent_level,' ') || p_msg_txt);
3974: else
3975: fname := utl_file.fopen(mth_util_pkg.g_debug_file_dir,'MOC-'||mth_util_pkg.g_execution_id,'a');
3976: utl_file.put(fname, LPad(' ',l_indent_level,' ') || p_msg_txt);
3977: -- dbms_output.put_line(LPad(' ',l_indent_level,' ') || p_msg_txt); --to be removed before checkin
3978: utl_file.fflush(fname);
3979: utl_file.fclose(fname);

Line 4007: mth_util_pkg.log_msg('INCR_EQUIPMENT_SHIFTS start', mth_util_pkg.G_DBG_PROC_FUN_START);

4003: v_log_to_date DATE;
4004: v_unassigned_val VARCHAR2(30);
4005:
4006: BEGIN
4007: mth_util_pkg.log_msg('INCR_EQUIPMENT_SHIFTS start', mth_util_pkg.G_DBG_PROC_FUN_START);
4008:
4009: -- Initialize default parameters
4010: v_log_to_date := sysdate;
4011: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

Line 4011: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

4007: mth_util_pkg.log_msg('INCR_EQUIPMENT_SHIFTS start', mth_util_pkg.G_DBG_PROC_FUN_START);
4008:
4009: -- Initialize default parameters
4010: v_log_to_date := sysdate;
4011: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
4012:
4013:
4014: -- Call mth_run_log_pre_load
4015: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);

Line 4015: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);

4011: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
4012:
4013:
4014: -- Call mth_run_log_pre_load
4015: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
4016:
4017: -- Call GET_RUN_LOG_DATES
4018: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_SHIFTS_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
4019:

Line 4018: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_SHIFTS_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

4014: -- Call mth_run_log_pre_load
4015: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
4016:
4017: -- Call GET_RUN_LOG_DATES
4018: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_SHIFTS_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
4019:
4020: DELETE
4021: FROM MTH_EQUIPMENT_SHIFTS_D ESD
4022: WHERE EXISTS (SELECT 1

Line 4030: mth_util_pkg.log_msg('Number of rows deleted from MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4026: AND WSD.PLANT_FK_KEY = MAV.SITE_ID
4027: AND
4028: ESD.EQUIPMENT_FK_KEY = MAV.ENTITY_PK_KEY AND
4029: ESD.SHIFT_WORKDAY_FK_KEY = WSD.SHIFT_WORKDAY_PK_KEY ) ;
4030: mth_util_pkg.log_msg('Number of rows deleted from MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4031:
4032: INSERT INTO MTH_EQUIPMENT_SHIFTS_D (EQUIPMENT_FK_KEY,
4033: AVAILABILITY_DATE,
4034: SHIFT_WORKDAY_FK_KEY,

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

4090: ( RES.FROM_DATE >= COST.EQUIPMENT_EFFECTIVE_DATE (+) AND
4091: RES.FROM_DATE <= NVL ( COST.EQUIPMENT_EXPIRATION_DATE (+) ,TO_DATE('4000-01-01', 'YYYY-MM-DD') )
4092: ) )
4093: ;
4094: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4095:
4096: ----Call mth_run_log_post_load
4097: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val);
4098:

Line 4097: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val);

4093: ;
4094: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4095:
4096: ----Call mth_run_log_post_load
4097: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val);
4098:
4099:
4100: mth_util_pkg.log_msg('INCR_EQUIPMENT_SHIFTS end', mth_util_pkg.G_DBG_PROC_FUN_END);
4101: COMMIT;

Line 4100: mth_util_pkg.log_msg('INCR_EQUIPMENT_SHIFTS end', mth_util_pkg.G_DBG_PROC_FUN_END);

4096: ----Call mth_run_log_post_load
4097: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val);
4098:
4099:
4100: mth_util_pkg.log_msg('INCR_EQUIPMENT_SHIFTS end', mth_util_pkg.G_DBG_PROC_FUN_END);
4101: COMMIT;
4102: EXCEPTION
4103: WHEN OTHERS THEN
4104: mth_util_pkg.log_msg('Exception OTHERS in INCR_EQUIPMENT_SHIFTS', mth_util_pkg.G_DBG_EXCEPTION);

Line 4104: mth_util_pkg.log_msg('Exception OTHERS in INCR_EQUIPMENT_SHIFTS', mth_util_pkg.G_DBG_EXCEPTION);

4100: mth_util_pkg.log_msg('INCR_EQUIPMENT_SHIFTS end', mth_util_pkg.G_DBG_PROC_FUN_END);
4101: COMMIT;
4102: EXCEPTION
4103: WHEN OTHERS THEN
4104: mth_util_pkg.log_msg('Exception OTHERS in INCR_EQUIPMENT_SHIFTS', mth_util_pkg.G_DBG_EXCEPTION);
4105: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
4106: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
4107: ROLLBACK;
4108: RAISE;

Line 4105: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

4101: COMMIT;
4102: EXCEPTION
4103: WHEN OTHERS THEN
4104: mth_util_pkg.log_msg('Exception OTHERS in INCR_EQUIPMENT_SHIFTS', mth_util_pkg.G_DBG_EXCEPTION);
4105: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
4106: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
4107: ROLLBACK;
4108: RAISE;
4109:

Line 4106: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

4102: EXCEPTION
4103: WHEN OTHERS THEN
4104: mth_util_pkg.log_msg('Exception OTHERS in INCR_EQUIPMENT_SHIFTS', mth_util_pkg.G_DBG_EXCEPTION);
4105: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
4106: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
4107: ROLLBACK;
4108: RAISE;
4109:
4110: END INCR_EQUIP_SHIFTS;

Line 4131: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

4127: v_reprocess_flag number;
4128: BEGIN
4129: -- Initialize default parameters
4130: v_log_date := sysdate;
4131: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
4132: -- mth_util_pkg.switch_column_default_value ( 'MTH_WORKDAY_SHIFTS_STG', v_processing_flag);
4133: -- SELECT Count(*) INTO v_reprocess_flag FROM MTH_WORKDAY_SHIFTS_ERR WHERE REPROCESS_READY_YN='Y';
4134:
4135: -- IF ( v_processing_flag=1 OR v_processing_flag=2 OR v_reprocess_flag>0 ) THEN

Line 4132: -- mth_util_pkg.switch_column_default_value ( 'MTH_WORKDAY_SHIFTS_STG', v_processing_flag);

4128: BEGIN
4129: -- Initialize default parameters
4130: v_log_date := sysdate;
4131: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
4132: -- mth_util_pkg.switch_column_default_value ( 'MTH_WORKDAY_SHIFTS_STG', v_processing_flag);
4133: -- SELECT Count(*) INTO v_reprocess_flag FROM MTH_WORKDAY_SHIFTS_ERR WHERE REPROCESS_READY_YN='Y';
4134:
4135: -- IF ( v_processing_flag=1 OR v_processing_flag=2 OR v_reprocess_flag>0 ) THEN
4136:

Line 4138: mth_util_pkg.log_msg('MTH_WORKDAY_SHIFTS_SF start', mth_util_pkg.G_DBG_PROC_FUN_START);

4134:
4135: -- IF ( v_processing_flag=1 OR v_processing_flag=2 OR v_reprocess_flag>0 ) THEN
4136:
4137:
4138: mth_util_pkg.log_msg('MTH_WORKDAY_SHIFTS_SF start', mth_util_pkg.G_DBG_PROC_FUN_START);
4139:
4140:
4141: SELECT MTH_UTIL_PKG.GET_PROFILE_VAL('MTH_SHIFT_SETUP' ) INTO v_profile FROM DUAL ;
4142:

Line 4141: SELECT MTH_UTIL_PKG.GET_PROFILE_VAL('MTH_SHIFT_SETUP' ) INTO v_profile FROM DUAL ;

4137:
4138: mth_util_pkg.log_msg('MTH_WORKDAY_SHIFTS_SF start', mth_util_pkg.G_DBG_PROC_FUN_START);
4139:
4140:
4141: SELECT MTH_UTIL_PKG.GET_PROFILE_VAL('MTH_SHIFT_SETUP' ) INTO v_profile FROM DUAL ;
4142:
4143: INSERT INTO MTH_WORKDAY_SHIFTS_STG
4144: (SHIFT_DATE,
4145: SOURCE_ORG_CODE,

Line 4188: mth_util_pkg.log_msg('Number of rows inserted in MTH_WORKDAY_SHIFTS_STG from error table - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4184: FROM MTH_WORKDAY_SHIFTS_ERR
4185: WHERE UPPER( REPROCESS_READY_YN ) = 'Y'
4186: )
4187: ;
4188: mth_util_pkg.log_msg('Number of rows inserted in MTH_WORKDAY_SHIFTS_STG from error table - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4189:
4190: --delete data from the output error table
4191: DELETE FROM MTH_WORKDAY_SHIFTS_ERR
4192: WHERE UPPER(REPROCESS_READY_YN) IN ('D','Y'); --Bug 14753663

Line 4193: mth_util_pkg.log_msg('Number of rows deleted in MTH_WORKDAY_SHIFTS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4189:
4190: --delete data from the output error table
4191: DELETE FROM MTH_WORKDAY_SHIFTS_ERR
4192: WHERE UPPER(REPROCESS_READY_YN) IN ('D','Y'); --Bug 14753663
4193: mth_util_pkg.log_msg('Number of rows deleted in MTH_WORKDAY_SHIFTS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4194: mth_util_pkg.REFRESH_ONE_MV ('MTH_SHIFT_REFERENCE_MV',null,null,'C');
4195: mth_util_pkg.switch_column_default_value('MTH_WORKDAY_SHIFTS_STG',v_processing_flag);
4196: IF ( v_processing_flag=1 OR v_processing_flag=2 ) THEN
4197:

Line 4194: mth_util_pkg.REFRESH_ONE_MV ('MTH_SHIFT_REFERENCE_MV',null,null,'C');

4190: --delete data from the output error table
4191: DELETE FROM MTH_WORKDAY_SHIFTS_ERR
4192: WHERE UPPER(REPROCESS_READY_YN) IN ('D','Y'); --Bug 14753663
4193: mth_util_pkg.log_msg('Number of rows deleted in MTH_WORKDAY_SHIFTS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4194: mth_util_pkg.REFRESH_ONE_MV ('MTH_SHIFT_REFERENCE_MV',null,null,'C');
4195: mth_util_pkg.switch_column_default_value('MTH_WORKDAY_SHIFTS_STG',v_processing_flag);
4196: IF ( v_processing_flag=1 OR v_processing_flag=2 ) THEN
4197:
4198: --Execute all validations on csv records

Line 4195: mth_util_pkg.switch_column_default_value('MTH_WORKDAY_SHIFTS_STG',v_processing_flag);

4191: DELETE FROM MTH_WORKDAY_SHIFTS_ERR
4192: WHERE UPPER(REPROCESS_READY_YN) IN ('D','Y'); --Bug 14753663
4193: mth_util_pkg.log_msg('Number of rows deleted in MTH_WORKDAY_SHIFTS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4194: mth_util_pkg.REFRESH_ONE_MV ('MTH_SHIFT_REFERENCE_MV',null,null,'C');
4195: mth_util_pkg.switch_column_default_value('MTH_WORKDAY_SHIFTS_STG',v_processing_flag);
4196: IF ( v_processing_flag=1 OR v_processing_flag=2 ) THEN
4197:
4198: --Execute all validations on csv records
4199:

Line 4209: mth_util_pkg.log_msg('Number of rows with DUP in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4205: GROUP BY shift_workday_pk) dup
4206: WHERE dup.cnt>1
4207: AND dup.shift_workday_pk = stg.shift_workday_pk
4208: AND stg.processing_flag = v_processing_flag );
4209: mth_util_pkg.log_msg('Number of rows with DUP in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4210:
4211: -- Validation for Null From Date
4212: UPDATE mth_workday_shifts_stg stg
4213: SET stg.err_code = stg.err_code || 'NFD '

Line 4216: mth_util_pkg.log_msg('Number of rows with NFD in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4212: UPDATE mth_workday_shifts_stg stg
4213: SET stg.err_code = stg.err_code || 'NFD '
4214: WHERE stg.from_date IS NULL
4215: AND stg.processing_flag = v_processing_flag;
4216: mth_util_pkg.log_msg('Number of rows with NFD in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4217:
4218:
4219: -- Validation for Null To Date
4220: UPDATE mth_workday_shifts_stg stg

Line 4224: mth_util_pkg.log_msg('Number of rows with NTD in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4220: UPDATE mth_workday_shifts_stg stg
4221: SET stg.err_code = stg.err_code || 'NTD '
4222: WHERE stg.to_date IS NULL
4223: AND stg.processing_flag = v_processing_flag;
4224: mth_util_pkg.log_msg('Number of rows with NTD in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4225:
4226: -- Validation for From Date = To date
4227: UPDATE mth_workday_shifts_stg stg
4228: SET stg.err_code = stg.err_code || 'SDT '

Line 4231: mth_util_pkg.log_msg('Number of rows with SDT in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4227: UPDATE mth_workday_shifts_stg stg
4228: SET stg.err_code = stg.err_code || 'SDT '
4229: WHERE stg.from_date= stg.to_date
4230: AND stg.processing_flag = v_processing_flag;
4231: mth_util_pkg.log_msg('Number of rows with SDT in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4232:
4233: -- Validation for From Date > To date
4234: UPDATE mth_workday_shifts_stg stg
4235: SET stg.err_code = stg.err_code || 'DTE '

Line 4238: mth_util_pkg.log_msg('Number of rows with DTE in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4234: UPDATE mth_workday_shifts_stg stg
4235: SET stg.err_code = stg.err_code || 'DTE '
4236: WHERE Nvl(stg.from_date,TO_DATE ('01-01-1900', 'DD-MM-YYYY')) >Nvl ( stg.To_Date, TO_DATE ('01-01-2999', 'DD-MM-YYYY') )
4237: AND stg.processing_flag = v_processing_flag;
4238: mth_util_pkg.log_msg('Number of rows with DTE in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4239:
4240: -- Validation for shift_type
4241:
4242: UPDATE mth_workday_shifts_stg stg

Line 4257: mth_util_pkg.log_msg('Number of rows with SFT in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4253: ) fls
4254: WHERE fls.SHIFT_TYPE = stg.SHIFT_TYPE
4255: AND stg.processing_flag = v_processing_flag
4256: AND fls.meaning IS NULL);
4257: mth_util_pkg.log_msg('Number of rows with SFT in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4258:
4259: -- Validation for graveyard shift
4260: UPDATE mth_workday_shifts_stg stg
4261: SET stg.err_code = stg.err_code || 'GRA '

Line 4275: mth_util_pkg.log_msg('Number of rows with GRA in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4271: )flg
4272: WHERE flg.graveyard_shift = stg.graveyard_shift
4273: AND stg.processing_flag = v_processing_flag
4274: AND flg.meaning IS NULL);
4275: mth_util_pkg.log_msg('Number of rows with GRA in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4276:
4277: -- Validation for incorrect plant
4278: UPDATE mth_workday_shifts_stg stg
4279: SET stg.err_code = stg.err_code || 'PLT '

Line 4289: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = PLANTS.SYSTEM_PK (+)

4285: WHERE NVL(MP.TO_DATE,SYSDATE) >= TRUNC(SYSDATE)
4286: AND MP.PLANT_PK_KEY = MOL.PLANT_FK_KEY
4287: AND MOL.SYSTEM_FK_KEY = MS.SYSTEM_PK_KEY )PLANTS
4288: WHERE STG.SOURCE_ORG_CODE = PLANTS.ORGANIZATION_CODE (+)
4289: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = PLANTS.SYSTEM_PK (+)
4290: )plants1
4291: WHERE stg.shift_workday_pk = plants1.shift_workday_pk
4292: AND stg.processing_flag = v_processing_flag
4293: AND plants1.plant_pk_key IS NULL);

Line 4294: mth_util_pkg.log_msg('Number of rows with PLT in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4290: )plants1
4291: WHERE stg.shift_workday_pk = plants1.shift_workday_pk
4292: AND stg.processing_flag = v_processing_flag
4293: AND plants1.plant_pk_key IS NULL);
4294: mth_util_pkg.log_msg('Number of rows with PLT in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4295:
4296: --Validation for OVP
4297: UPDATE mth_workday_shifts_stg stag
4298: SET stag.err_code = stag.err_code || 'OVP '

Line 4321: mth_util_pkg.log_msg('Number of rows with OVP in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4317: WHERE ovp.overlap = 1
4318: AND stag.shift_workday_pk = ovp.shift_workday_pk
4319: AND stag.from_date = ovp.from_date
4320: AND stag.To_Date = ovp.To_Date);
4321: mth_util_pkg.log_msg('Number of rows with OVP in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4322:
4323: --Validation for SAE
4324: UPDATE mth_workday_shifts_stg stg
4325: SET stg.err_code = stg.err_code || 'SAE '

Line 4339: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = MS.SYSTEM_PK (+)

4335: AND NVL(plants.TO_DATE,SYSDATE) >= TRUNC(SYSDATE)
4336: AND plants.PLANT_PK_KEY = MOL.PLANT_FK_KEY
4337: AND MOL.SYSTEM_FK_KEY = MS.SYSTEM_PK_KEY
4338: AND STG.SOURCE_ORG_CODE = MOL.ORGANIZATION_CODE (+)
4339: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = MS.SYSTEM_PK (+)
4340: AND plants.PLANT_PK_KEY=MSV.PLANT_FK_KEY )sae
4341: WHERE stg.shift_workday_pk = sae.shift_workday_pk);
4342: mth_util_pkg.log_msg('Number of rows with SAE in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4343:

Line 4342: mth_util_pkg.log_msg('Number of rows with SAE in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4338: AND STG.SOURCE_ORG_CODE = MOL.ORGANIZATION_CODE (+)
4339: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = MS.SYSTEM_PK (+)
4340: AND plants.PLANT_PK_KEY=MSV.PLANT_FK_KEY )sae
4341: WHERE stg.shift_workday_pk = sae.shift_workday_pk);
4342: mth_util_pkg.log_msg('Number of rows with SAE in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4343:
4344: --Validation for profile value
4345: UPDATE mth_workday_shifts_stg stg
4346: SET stg.err_code = stg.err_code || 'PRF '

Line 4348: mth_util_pkg.log_msg('Number of rows with PRF in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4344: --Validation for profile value
4345: UPDATE mth_workday_shifts_stg stg
4346: SET stg.err_code = stg.err_code || 'PRF '
4347: WHERE v_profile<>'External Source';
4348: mth_util_pkg.log_msg('Number of rows with PRF in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4349:
4350:
4351: --Insert records into mth_workday_shifts_err
4352:

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

4396: GRAVEYARD_SHIFT
4397: FROM mth_workday_shifts_stg
4398: WHERE err_code IS NOT NULL
4399: );
4400: mth_util_pkg.log_msg('Number of rows inserted in MTH_WORKDAY_SHIFTS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4401:
4402:
4403:
4404: DELETE FROM mth_equipment_shifts_D

Line 4421: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = MS.SYSTEM_PK

4417: AND NVL(plants.TO_DATE,SYSDATE) >= TRUNC(SYSDATE)
4418: AND plants.PLANT_PK_KEY = MOL.PLANT_FK_KEY
4419: AND MOL.SYSTEM_FK_KEY = MS.SYSTEM_PK_KEY
4420: AND STG.SOURCE_ORG_CODE = MOL.ORGANIZATION_CODE
4421: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = MS.SYSTEM_PK
4422: AND stg.err_code IS NULL
4423: And stg.SOURCE_ORG_CODE = nvl ( wsd.SOURCE_ORG_CODE , stg.SOURCE_ORG_CODE ));
4424:
4425: mth_util_pkg.log_msg('Number of rows deleted from mth_equipment_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line 4425: mth_util_pkg.log_msg('Number of rows deleted from mth_equipment_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4421: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = MS.SYSTEM_PK
4422: AND stg.err_code IS NULL
4423: And stg.SOURCE_ORG_CODE = nvl ( wsd.SOURCE_ORG_CODE , stg.SOURCE_ORG_CODE ));
4424:
4425: mth_util_pkg.log_msg('Number of rows deleted from mth_equipment_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4426:
4427: DELETE FROM mth_workday_shifts_D
4428: WHERE shift_workday_pk_key IN (SELECT shift_workday_pk_key FROM
4429: mth_workday_shifts_D wsd,

Line 4444: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = MS.SYSTEM_PK

4440: AND NVL(plants.TO_DATE,SYSDATE) >= TRUNC(SYSDATE)
4441: AND plants.PLANT_PK_KEY = MOL.PLANT_FK_KEY
4442: AND MOL.SYSTEM_FK_KEY = MS.SYSTEM_PK_KEY
4443: AND STG.SOURCE_ORG_CODE = MOL.ORGANIZATION_CODE
4444: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = MS.SYSTEM_PK
4445: AND stg.err_code IS NULL
4446: And stg.SOURCE_ORG_CODE = nvl ( wsd.SOURCE_ORG_CODE , stg.SOURCE_ORG_CODE ));
4447:
4448: mth_util_pkg.log_msg('Number of rows deleted from mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line 4448: mth_util_pkg.log_msg('Number of rows deleted from mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4444: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = MS.SYSTEM_PK
4445: AND stg.err_code IS NULL
4446: And stg.SOURCE_ORG_CODE = nvl ( wsd.SOURCE_ORG_CODE , stg.SOURCE_ORG_CODE ));
4447:
4448: mth_util_pkg.log_msg('Number of rows deleted from mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4449:
4450: INSERT INTO MTH_WORKDAY_SHIFTS_D
4451: (SHIFT_WORKDAY_PK_KEY,
4452: SHIFT_WORKDAY_PK,

Line 4484: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),

4480: stg.SHIFT_WORKDAY_PK,
4481: stg.SHIFT_DATE,
4482: TO_NUMBER(TO_CHAR( stg.SHIFT_DATE ,'J')),
4483: PD.plant_pk_key,
4484: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),
4485: STG.USER_ATTR1,
4486: stg.USER_ATTR2,
4487: stg.USER_ATTR3,
4488: stg.USER_ATTR4,

Line 4497: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),

4493: stg.USER_MEASURE4,
4494: stg.USER_MEASURE5,
4495: SYSDATE,
4496: SYSDATE,
4497: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),
4498: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),
4499: stg.FROM_DATE,
4500: stg.TO_DATE,
4501: STG.SHIFT_NUM,

Line 4498: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),

4494: stg.USER_MEASURE5,
4495: SYSDATE,
4496: SYSDATE,
4497: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),
4498: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),
4499: stg.FROM_DATE,
4500: stg.TO_DATE,
4501: STG.SHIFT_NUM,
4502: STG.SHIFT_NAME,

Line 4508: WHERE NVL ( STG.SYSTEM_FK , MTH_UTIL_PKG.MTH_UA_GET_VAL ) = SP.SYSTEM_PK

4504: Decode(STG.SHIFT_TYPE,NULL,'PROD-SHIFT',FL2.LOOKUP_CODE),
4505: DECODE(STG.GRAVEYARD_SHIFT,NULL,NULL,FL1.LOOKUP_CODE)
4506: FROM
4507: MTH_WORKDAY_SHIFTS_STG STG ,MTH_SYSTEMS_SETUP SP,MTH_PLANTS_D PD,MTH_ORGANIZATIONS_L MOL,FND_LOOKUP_VALUES FL1,FND_LOOKUP_VALUES FL2
4508: WHERE NVL ( STG.SYSTEM_FK , MTH_UTIL_PKG.MTH_UA_GET_VAL ) = SP.SYSTEM_PK
4509: AND NVL(PD.TO_DATE,SYSDATE) >= TRUNC(SYSDATE)
4510: AND PD.PLANT_PK_KEY = MOL.PLANT_FK_KEY
4511: AND MOL.SYSTEM_FK_KEY = SP.SYSTEM_PK_KEY
4512: AND STG.SOURCE_ORG_CODE = MOL.ORGANIZATION_CODE

Line 4513: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = SP.SYSTEM_PK (+)

4509: AND NVL(PD.TO_DATE,SYSDATE) >= TRUNC(SYSDATE)
4510: AND PD.PLANT_PK_KEY = MOL.PLANT_FK_KEY
4511: AND MOL.SYSTEM_FK_KEY = SP.SYSTEM_PK_KEY
4512: AND STG.SOURCE_ORG_CODE = MOL.ORGANIZATION_CODE
4513: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = SP.SYSTEM_PK (+)
4514: AND FL1.LOOKUP_TYPE ='MTH_GRAVEYARD_SHIFT_TYPE'
4515: AND FL1.LANGUAGE = USERENV('LANG')
4516: AND FL1.ENABLED_FLAG ='Y'
4517: AND FL1.MEANING =NVL(STG.GRAVEYARD_SHIFT,'Shift End Date')

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

4521: AND NVL( STG.SHIFT_TYPE ,'Production Shift') = FL2.MEANING
4522: AND STG.processing_flag = v_processing_flag
4523: AND STG.ERR_CODE IS NULL );
4524:
4525: mth_util_pkg.log_msg('Number of rows inserted in mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4526:
4527:
4528: INSERT INTO MTH_WORKDAY_SHIFTS_D
4529: (SHIFT_WORKDAY_PK_KEY,

Line 4558: TO_CHAR( CATCH_ALL.DAY,'yyyymmdd-hh24:mi:ss') ||'-'|| PD.PLANT_PK || MTH_UTIL_PKG.MTH_UA_GET_VAL(),

4554: SHIFT_TYPE,
4555: GRAVEYARD_SHIFT)
4556:
4557: (SELECT MTH_WORKDAYS_SHIFTS_S.NEXTVAL,
4558: TO_CHAR( CATCH_ALL.DAY,'yyyymmdd-hh24:mi:ss') ||'-'|| PD.PLANT_PK || MTH_UTIL_PKG.MTH_UA_GET_VAL(),
4559: CATCH_ALL.DAY,
4560: TO_NUMBER(TO_CHAR( CATCH_ALL.DAY ,'J')),
4561: PD.plant_pk_key,
4562: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),

Line 4562: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),

4558: TO_CHAR( CATCH_ALL.DAY,'yyyymmdd-hh24:mi:ss') ||'-'|| PD.PLANT_PK || MTH_UTIL_PKG.MTH_UA_GET_VAL(),
4559: CATCH_ALL.DAY,
4560: TO_NUMBER(TO_CHAR( CATCH_ALL.DAY ,'J')),
4561: PD.plant_pk_key,
4562: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),
4563: NULL,
4564: NULL,
4565: NULL,
4566: NULL,

Line 4575: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),

4571: NULL,
4572: NULL,
4573: SYSDATE,
4574: SYSDATE,
4575: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),
4576: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),
4577: NULL,
4578: NULL,
4579: NULL,

Line 4576: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),

4572: NULL,
4573: SYSDATE,
4574: SYSDATE,
4575: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),
4576: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),
4577: NULL,
4578: NULL,
4579: NULL,
4580: MTH_UTIL_PKG.GET_PROFILE_VAL('MTH_CATCH_ALL_NAME'),

Line 4580: MTH_UTIL_PKG.GET_PROFILE_VAL('MTH_CATCH_ALL_NAME'),

4576: NVL( SP.SYSTEM_PK_KEY , MTH_UTIL_PKG.MTH_UA_GET_VAL() ),
4577: NULL,
4578: NULL,
4579: NULL,
4580: MTH_UTIL_PKG.GET_PROFILE_VAL('MTH_CATCH_ALL_NAME'),
4581: STG.SOURCE_ORG_CODE,
4582: 'BOTH' ,
4583: NULL
4584: FROM

Line 4593: WHERE NVL ( STG.SYSTEM_FK , MTH_UTIL_PKG.MTH_UA_GET_VAL ) = SP.SYSTEM_PK

4589: UNION
4590: SELECT DAY FROM MTH_GREGORIAN_CALENDAR
4591: UNION
4592: SELECT REPORT_DATE DAY FROM MTH_DAY_D )) CATCH_ALL
4593: WHERE NVL ( STG.SYSTEM_FK , MTH_UTIL_PKG.MTH_UA_GET_VAL ) = SP.SYSTEM_PK
4594: AND NVL(PD.TO_DATE,SYSDATE) >= TRUNC(SYSDATE)
4595: AND PD.PLANT_PK_KEY = MOL.PLANT_FK_KEY
4596: AND MOL.SYSTEM_FK_KEY = SP.SYSTEM_PK_KEY
4597: AND STG.SOURCE_ORG_CODE = MOL.ORGANIZATION_CODE

Line 4601: mth_util_pkg.log_msg('Number of catch all rows inserted in mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4597: AND STG.SOURCE_ORG_CODE = MOL.ORGANIZATION_CODE
4598: AND CATCH_ALL.DAY = stg.SHIFT_DATE
4599: );
4600:
4601: mth_util_pkg.log_msg('Number of catch all rows inserted in mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4602:
4603: mth_util_pkg.truncate_table_partition(' MTH_WORKDAY_SHIFTS_STG',v_processing_flag);
4604:
4605: mth_util_pkg.log_msg('MTH_WORKDAY_SHIFTS_SF end', mth_util_pkg.G_DBG_PROC_FUN_END);

Line 4603: mth_util_pkg.truncate_table_partition(' MTH_WORKDAY_SHIFTS_STG',v_processing_flag);

4599: );
4600:
4601: mth_util_pkg.log_msg('Number of catch all rows inserted in mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4602:
4603: mth_util_pkg.truncate_table_partition(' MTH_WORKDAY_SHIFTS_STG',v_processing_flag);
4604:
4605: mth_util_pkg.log_msg('MTH_WORKDAY_SHIFTS_SF end', mth_util_pkg.G_DBG_PROC_FUN_END);
4606: mth_util_pkg.refresh_mv('MTH_SHIFT_GREGORIAN_DENORM_MV','f',null,null,null,null,null,null,null);
4607: COMMIT;

Line 4605: mth_util_pkg.log_msg('MTH_WORKDAY_SHIFTS_SF end', mth_util_pkg.G_DBG_PROC_FUN_END);

4601: mth_util_pkg.log_msg('Number of catch all rows inserted in mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4602:
4603: mth_util_pkg.truncate_table_partition(' MTH_WORKDAY_SHIFTS_STG',v_processing_flag);
4604:
4605: mth_util_pkg.log_msg('MTH_WORKDAY_SHIFTS_SF end', mth_util_pkg.G_DBG_PROC_FUN_END);
4606: mth_util_pkg.refresh_mv('MTH_SHIFT_GREGORIAN_DENORM_MV','f',null,null,null,null,null,null,null);
4607: COMMIT;
4608: ELSE
4609: mth_util_pkg.log_msg('There are no records in MTH_WORKDAY_SHIFTS_STG for processing');

Line 4606: mth_util_pkg.refresh_mv('MTH_SHIFT_GREGORIAN_DENORM_MV','f',null,null,null,null,null,null,null);

4602:
4603: mth_util_pkg.truncate_table_partition(' MTH_WORKDAY_SHIFTS_STG',v_processing_flag);
4604:
4605: mth_util_pkg.log_msg('MTH_WORKDAY_SHIFTS_SF end', mth_util_pkg.G_DBG_PROC_FUN_END);
4606: mth_util_pkg.refresh_mv('MTH_SHIFT_GREGORIAN_DENORM_MV','f',null,null,null,null,null,null,null);
4607: COMMIT;
4608: ELSE
4609: mth_util_pkg.log_msg('There are no records in MTH_WORKDAY_SHIFTS_STG for processing');
4610: END IF ;

Line 4609: mth_util_pkg.log_msg('There are no records in MTH_WORKDAY_SHIFTS_STG for processing');

4605: mth_util_pkg.log_msg('MTH_WORKDAY_SHIFTS_SF end', mth_util_pkg.G_DBG_PROC_FUN_END);
4606: mth_util_pkg.refresh_mv('MTH_SHIFT_GREGORIAN_DENORM_MV','f',null,null,null,null,null,null,null);
4607: COMMIT;
4608: ELSE
4609: mth_util_pkg.log_msg('There are no records in MTH_WORKDAY_SHIFTS_STG for processing');
4610: END IF ;
4611:
4612:
4613: EXCEPTION

Line 4616: mth_util_pkg.log_msg('Exception OTHERS in MTH_WORKDAY_SHIFTS_SF', mth_util_pkg.G_DBG_EXCEPTION);

4612:
4613: EXCEPTION
4614: WHEN OTHERS THEN
4615: --Call logging API and then throw exception
4616: mth_util_pkg.log_msg('Exception OTHERS in MTH_WORKDAY_SHIFTS_SF', mth_util_pkg.G_DBG_EXCEPTION);
4617: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
4618: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
4619: ROLLBACK;
4620: RAISE;

Line 4617: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

4613: EXCEPTION
4614: WHEN OTHERS THEN
4615: --Call logging API and then throw exception
4616: mth_util_pkg.log_msg('Exception OTHERS in MTH_WORKDAY_SHIFTS_SF', mth_util_pkg.G_DBG_EXCEPTION);
4617: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
4618: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
4619: ROLLBACK;
4620: RAISE;
4621:

Line 4618: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

4614: WHEN OTHERS THEN
4615: --Call logging API and then throw exception
4616: mth_util_pkg.log_msg('Exception OTHERS in MTH_WORKDAY_SHIFTS_SF', mth_util_pkg.G_DBG_EXCEPTION);
4617: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
4618: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
4619: ROLLBACK;
4620: RAISE;
4621:
4622:

Line 4718: mth_util_pkg.log_msg('MAIN start', mth_util_pkg.G_DBG_PROC_FUN_START);

4714: v_industry VARCHAR2(30) ;
4715:
4716:
4717: BEGIN
4718: mth_util_pkg.log_msg('MAIN start', mth_util_pkg.G_DBG_PROC_FUN_START);
4719:
4720: If P_PROD_TO_BE_CLEANUP = 'ALL' THEN
4721: v_lookup_type := 'MTH_ALL_CLEANUP_LIST';
4722: elsIf P_PROD_TO_BE_CLEANUP = 'MOC' THEN

Line 4737: mth_util_pkg.mth_truncate_table(r_tab.LOOKUP_CODE,v_schema_name);

4733: THEN
4734:
4735: FOR r_tab IN c_tabs(v_lookup_type) LOOP
4736:
4737: mth_util_pkg.mth_truncate_table(r_tab.LOOKUP_CODE,v_schema_name);
4738:
4739: END LOOP;
4740:
4741: FOR r_seq IN c_seqs(v_lookup_type) LOOP

Line 4743: mth_util_pkg.mth_Reset_sequence(r_seq.LOOKUP_CODE,v_schema_name);

4739: END LOOP;
4740:
4741: FOR r_seq IN c_seqs(v_lookup_type) LOOP
4742:
4743: mth_util_pkg.mth_Reset_sequence(r_seq.LOOKUP_CODE,v_schema_name);
4744:
4745: END LOOP;
4746:
4747: FOR r_mv IN c_mvs(v_lookup_type) LOOP

Line 4764: mth_util_pkg.log_msg('MAIN end', mth_util_pkg.G_DBG_PROC_FUN_END);

4760: AND lv.LOOKUP_CODE like rl.FACT_TABLE || '%');
4761: commit;
4762:
4763: p_retcode := 0;
4764: mth_util_pkg.log_msg('MAIN end', mth_util_pkg.G_DBG_PROC_FUN_END);
4765:
4766: END IF;
4767:
4768: EXCEPTION

Line 4770: mth_util_pkg.log_msg('Exception in CLEAN_UP_TABLE_DATA.', mth_util_pkg.G_DBG_EXCEPTION);

4766: END IF;
4767:
4768: EXCEPTION
4769: WHEN OTHERS THEN
4770: mth_util_pkg.log_msg('Exception in CLEAN_UP_TABLE_DATA.', mth_util_pkg.G_DBG_EXCEPTION);
4771: mth_util_pkg.log_msg('Unknown Exception occured while processing');
4772: mth_util_pkg.log_msg(-20001, mth_util_pkg.G_DBG_EXCEPTION);
4773: p_retcode := 2;
4774: p_err_buff := mth_util_pkg.G_DBG_EXCEPTION;

Line 4771: mth_util_pkg.log_msg('Unknown Exception occured while processing');

4767:
4768: EXCEPTION
4769: WHEN OTHERS THEN
4770: mth_util_pkg.log_msg('Exception in CLEAN_UP_TABLE_DATA.', mth_util_pkg.G_DBG_EXCEPTION);
4771: mth_util_pkg.log_msg('Unknown Exception occured while processing');
4772: mth_util_pkg.log_msg(-20001, mth_util_pkg.G_DBG_EXCEPTION);
4773: p_retcode := 2;
4774: p_err_buff := mth_util_pkg.G_DBG_EXCEPTION;
4775: RAISE;

Line 4772: mth_util_pkg.log_msg(-20001, mth_util_pkg.G_DBG_EXCEPTION);

4768: EXCEPTION
4769: WHEN OTHERS THEN
4770: mth_util_pkg.log_msg('Exception in CLEAN_UP_TABLE_DATA.', mth_util_pkg.G_DBG_EXCEPTION);
4771: mth_util_pkg.log_msg('Unknown Exception occured while processing');
4772: mth_util_pkg.log_msg(-20001, mth_util_pkg.G_DBG_EXCEPTION);
4773: p_retcode := 2;
4774: p_err_buff := mth_util_pkg.G_DBG_EXCEPTION;
4775: RAISE;
4776:

Line 4774: p_err_buff := mth_util_pkg.G_DBG_EXCEPTION;

4770: mth_util_pkg.log_msg('Exception in CLEAN_UP_TABLE_DATA.', mth_util_pkg.G_DBG_EXCEPTION);
4771: mth_util_pkg.log_msg('Unknown Exception occured while processing');
4772: mth_util_pkg.log_msg(-20001, mth_util_pkg.G_DBG_EXCEPTION);
4773: p_retcode := 2;
4774: p_err_buff := mth_util_pkg.G_DBG_EXCEPTION;
4775: RAISE;
4776:
4777: END CLEAN_UP_TABLE_DATA;
4778:

Line 4799: return mth_util_pkg.g_processing_flag;

4795: v_status VARCHAR2(30) ;
4796: v_industry VARCHAR2(30) ;
4797: BEGIN
4798: IF p_table_name = 'default' THEN
4799: return mth_util_pkg.g_processing_flag;
4800: ELSE
4801: IF (FND_INSTALLATION.GET_APP_INFO(
4802: application_short_name => 'MTH'
4803: , status => v_status

Line 4840: END mth_util_pkg;

4836: END IF;
4837: END Get_Processing_Flag;
4838:
4839:
4840: END mth_util_pkg;