APPS.MST_WB_UTIL dependencies on MST_PLANS

Line 1683: FROM mst_plans

1679: fnd_message.set_token('DESTINATION_CITY', l_temp);
1680:
1681: SELECT distance_uom
1682: INTO l_str1
1683: FROM mst_plans
1684: WHERE plan_id = P_PLAN_ID;
1685: fnd_message.set_token('DISTANCE_UOM', l_str1);
1686:
1687: SELECT round(number3), round(number4)

Line 1863: FROM mst_plans

1859: ELSIF l_exception_type = 201 THEN
1860: IF P_LINE_NUM = 1 THEN
1861: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_201_1');
1862: SELECT distance_uom INTO l_temp
1863: FROM mst_plans
1864: WHERE plan_id = P_PLAN_ID;
1865: fnd_message.set_token('DISTANCE_UOM', l_temp);
1866:
1867: SELECT carrier_id, continuous_move_id, round(number2), round(number3)

Line 2160: FROM mst_plans

2156: fnd_message.set_token('MAX_PALLETS', round(l_id7));
2157:
2158: SELECT volume_uom
2159: INTO l_temp
2160: FROM mst_plans
2161: WHERE plan_id = P_PLAN_ID;
2162:
2163: SELECT msikfv.internal_volume * get_uom_conversion_rate (msikfv.volume_uom_code,
2164: l_temp,

Line 2182: FROM mst_plans

2178: End If;
2179:
2180: SELECT weight_uom, volume_uom
2181: INTO l_temp, l_temp1
2182: FROM mst_plans
2183: WHERE plan_id = P_PLAN_ID;
2184:
2185: fnd_message.set_token('WEIGHT_UOM', l_temp);
2186: fnd_message.set_token('VOLUME_UOM', l_temp1);

Line 2222: FROM mst_plans

2218: fnd_message.set_token('MAX_PALLETS', round(l_id7));
2219:
2220: SELECT weight_uom, volume_uom
2221: INTO l_temp, l_temp1
2222: FROM mst_plans
2223: WHERE plan_id = P_PLAN_ID;
2224:
2225: fnd_message.set_token('WEIGHT_UOM', l_temp);
2226: fnd_message.set_token('VOLUME_UOM', l_temp1);

Line 4442: FROM mst_plans

4438: WHERE carrier_id = p_carrier_id;
4439:
4440: CURSOR l_uom_cur IS
4441: SELECT distance_uom, weight_uom, volume_uom
4442: FROM mst_plans
4443: WHERE plan_id = P_PLAN_ID;
4444:
4445: CURSOR l_vehicle_cur (p_vehicle_type_id IN NUMBER) IS
4446: SELECT msikfv.concatenated_segments

Line 5224: FROM mst_plans

5220: END IF;
5221:
5222: SELECT volume_uom
5223: INTO l_str1
5224: FROM mst_plans
5225: WHERE plan_id = P_PLAN_ID;
5226:
5227: SELECT msikfv.internal_volume * get_uom_conversion_rate (msikfv.volume_uom_code,
5228: l_str1,

Line 5793: delete from MST_PLANS

5789:
5790: delete from MST_EXCEPT_DETAILS_DETAILS
5791: where plan_id = p_plan_id;
5792:
5793: delete from MST_PLANS
5794: where plan_id = p_plan_id;
5795:
5796: commit;
5797: l_message := 'Purge of plan '||p_compile_designator||':'||p_description||' successfully completed.';