DBA Data[Home] [Help]

APPS.GMP_WPS_WRITER dependencies on INV_CONVERT

Line 352: DECODE(gsr.plan_rsrc_usage, 0, 0, inv_convert.inv_um_convert(-1,38,

348: -- Activities, its resources and resource transactions with ZERO usage
349: CURSOR get_zero_non_usage IS
350: SELECT
351: gsr.batchstep_resource_id,
352: DECODE(gsr.plan_rsrc_usage, 0, 0, inv_convert.inv_um_convert(-1,38,
353: gsr.plan_rsrc_usage,u2.uom_code,u1.uom_code,NULL,NULL)) plan_rsrc_usage,
354: gsr.offset_interval,
355: gsr.plan_start_date,
356: gsr.plan_cmplt_date

Line 645: inv_convert.inv_um_convert(-1,38,(pseq_dep_usage(i)/60),puom_hour,

641: ELSE
642: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);
643: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);
644: v_seq_dep_usage :=
645: inv_convert.inv_um_convert(-1,38,(pseq_dep_usage(i)/60),puom_hour,
646: v_uom_code,NULL,NULL);
647:
648: IF v_o_resources = v_n_resources THEN
649: pnew_act_res(i) := pact_res_id(i);

Line 697: inv_convert.inv_um_convert(-1,38,v_res_usage,puom_hour,

693: v_step_res_row.plan_cmplt_date := v_end_date;
694: v_step_res_row.resources := v_n_resources;
695: v_step_res_row.sequence_dependent_usage := v_seq_dep_usage;
696: v_step_res_row.plan_rsrc_usage :=
697: inv_convert.inv_um_convert(-1,38,v_res_usage,puom_hour,
698: v_uom_code,NULL,NULL);
699:
700: IF NOT GME_BATCH_STEP_RESOURCES_DBL.insert_row
701: (v_step_res_row, v_in_step_res_row) THEN

Line 979: v_res_usage := inv_convert.inv_um_convert(-1,38,temp_date,

975: IF validate_resource%NOTFOUND THEN
976: return_status := -1;
977: ELSE
978: temp_date := (pend_date(i) - pstart_date(i))/60;
979: v_res_usage := inv_convert.inv_um_convert(-1,38,temp_date,
980: puom_hour,v_uom_code,NULL,NULL);
981: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);
982: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);
983: