APPS.MTH_UTIL_PKG dependencies on MTH_WORKDAYS_SHIFTS_S

Line 3105: VALUES(mth_workdays_shifts_s.nextval,

3101: graveyard_shift,from_date,to_date, shift_num,shift_name,
3102: source_org_code,system_fk_key,
3103: creation_date,last_update_date,creation_system_id,
3104: last_update_system_id)
3105: VALUES(mth_workdays_shifts_s.nextval,
3106: to_char(DECODE(GREATEST( l_start_time1, l_end_time1 ) ,
3107: l_start_time1 , l_start_date ,
3108: l_start_date) + ((TO_NUMBER(SUBSTR(l_start_time,1,2))+
3109: (TO_NUMBER(SUBSTR(l_start_time,4,2))/60)+

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 4479: (SELECT MTH_WORKDAYS_SHIFTS_S.NEXTVAL,

4475: SOURCE_ORG_CODE,
4476: SHIFT_TYPE,
4477: GRAVEYARD_SHIFT)
4478:
4479: (SELECT MTH_WORKDAYS_SHIFTS_S.NEXTVAL,
4480: stg.SHIFT_WORKDAY_PK,
4481: stg.SHIFT_DATE,
4482: TO_NUMBER(TO_CHAR( stg.SHIFT_DATE ,'J')),
4483: PD.plant_pk_key,

Line 4557: (SELECT MTH_WORKDAYS_SHIFTS_S.NEXTVAL,

4553: SOURCE_ORG_CODE,
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,