PACKAGE: APPS.MST_CM_DETAILS

Source

1 PACKAGE mst_cm_details AUTHID CURRENT_USER AS
2 /*$Header: MSTCMDLS.pls 115.1 2003/07/30 18:30:22 jnhuang noship $ */
3 
4 function get_number_of_loads(
5 arg_plan_id IN number,
6 arg_continuous_move_id IN number
7 ) return number;
8 
9 function get_distance(
10 arg_plan_id IN number,
11 arg_continuous_move_id IN number
12 ) return number;
13 
14 function get_savings(
15 arg_plan_id IN number,
16 arg_continuous_move_id IN number,
17 arg_total_cm_trip_cost IN number
18 ) return number;
19 
20 
21 function get_number_of_stops(
22 arg_plan_id IN number,
23 arg_trip_id IN number
24 ) return number;
25 
26 function get_total_savings(
27 arg_plan_id IN number
28 ) return number;
29 
30 function get_number_of_exceptions(
31 arg_plan_id IN number
32 ) return number;
33 
34 function get_percent_of_tl_in_cm(
35 arg_plan_id IN number
36 ) return number;
37 
38 function get_trip_loading_status(
39 arg_plan_id number,
40 arg_trip_id number
41 ) return varchar2;
42 
43 END mst_cm_details;
44 
45