[Home] [Help]
942: or_tab(j).aps_data_use := 0 ; -- APS Way
943:
944: -- bug: 8616967 added the below code to convert usage from APS_UOM_CODE to GME_UOM_CODE.
945: IF ( or_tab(j).APS_UOM_CODE <> or_tab(j).GME_UOM_CODE ) THEN
946: or_tab(j).aps_rsrc_usage := inv_convert.inv_um_convert(
947: or_tab(j).Product_item ,
948: NULL,
949: or_tab(j).organization_id,
950: 5,
969: log_message( or_tab(j).aps_rsrc_usage ||'**'|| or_tab(j).APS_UOM_CODE );
970:
971: -- bug: 8616967 added the below code to convert usage from APS_UOM_CODE to GME_UOM_CODE.
972: IF ( or_tab(j).APS_UOM_CODE <> or_tab(j).GME_UOM_CODE ) THEN
973: or_tab(j).aps_rsrc_usage := inv_convert.inv_um_convert(
974: or_tab(j).Product_item ,
975: NULL,
976: or_tab(j).organization_id,
977: 5,
1261: END IF ;
1262: gmp_debug_message(rsrc_tran_tab(rtran_cnt).resource_hour ||'**'||rsrc_tran_tab(rtran_cnt).aps_uom_code );
1263: -- bug: 8616967 added the below code to convert usage from APS_UOM_CODE to GME_UOM_CODE.
1264: IF ( rsrc_tran_tab(rtran_cnt).aps_uom_code <> rsrc_tran_tab(rtran_cnt).gme_usage_uom) THEN
1265: rsrc_tran_tab(rtran_cnt).resource_hour := inv_convert.inv_um_convert(
1266: rsrc_tran_tab(rtran_cnt).Product_item ,
1267: NULL,
1268: rsrc_tran_tab(rtran_cnt).ORGANIZATION_ID,
1269: 5,
1778: -- Bug 13944581 vkinduri Modified cursor to restrict UOM conversion for DoNot Plan Resources.
1779: CURSOR get_zero_non_usage IS
1780: SELECT
1781: gsr.batchstep_resource_id, gsr.resources, gsr.plan_rsrc_count,
1782: DECODE(crd.schedule_ind, 3, Decode(gsr.plan_rsrc_usage, 0, 0, gsr.plan_rsrc_usage), DECODE(gsr.plan_rsrc_usage, 0, 0, inv_convert.inv_um_convert(-1,38,
1783: gsr.plan_rsrc_usage,u2.uom_code,u1.uom_code,NULL,NULL))) plan_rsrc_usage,
1784: gsr.offset_interval,
1785: gsr.plan_start_date,
1786: gsr.plan_cmplt_date,