[Home] [Help]
39: l_count number;
40: begin
41: select count(1)
42: into l_count
43: from mst_cm_trips
44: where plan_id = p_plan_id;
45: return l_count;
46: EXCEPTION
47: WHEN NO_DATA_FOUND THEN
692: and mode_of_transport in ('LTL', 'PARCEL');
693:
694: select sum(TOTAL_TRANSPORTATION_COST)
695: into l_carrier_cm_cost
696: from mst_cm_trips
697: where plan_id = p_plan_id
698: and carrier_id = p_carrier_id;
699: l_carrier_cost := l_carrier_tl_cost + l_carrier_cm_cost + l_carrier_ltl_parcel_cost;
700: return l_carrier_cost;
5953: into l_count
5954: from mst_trips mt
5955: where plan_id = p_plan_id
5956: and mt.continuous_move_id in (select cm.continuous_move_id
5957: from mst_cm_trips cm
5958: where cm.plan_id = p_plan_id);
5959: return l_count;
5960: end;
5961:
6187: l_count number;
6188: begin
6189: select count('x')
6190: into l_count
6191: from mst_cm_trips
6192: where plan_id = p_plan_id
6193: and auto_release_flag = 1;
6194: return l_count;
6195: end get_auto_release_cm_count;
6199: l_count number;
6200: begin
6201: select count('x')
6202: into l_count
6203: from mst_cm_trips
6204: where plan_id = p_plan_id
6205: and release_status <> 4
6206: and release_date is not null
6207: and auto_release_flag <> 1;
6214: l_count number;
6215: begin
6216: select count('x')
6217: into l_count
6218: from mst_cm_trips
6219: where plan_id = p_plan_id
6220: and release_status = 4
6221: and release_date is not null;
6222: return l_count;
6227: l_count number;
6228: begin
6229: select count('x')
6230: into l_count
6231: from mst_cm_trips
6232: where plan_id = p_plan_id
6233: and selected_for_release = 1;
6234: return l_count;
6235: end get_flag_for_rel_cm_count;
6239: l_count number;
6240: begin
6241: select count('x')
6242: into l_count
6243: from mst_cm_trips
6244: where plan_id = p_plan_id
6245: and release_date is null;
6246: return l_count;
6247: end get_not_rel_cm_count;