1 PACKAGE MST_RELEASE AUTHID CURRENT_USER AS
2 /*$Header: MSTRELPS.pls 115.3 2003/10/15 17:23:32 atsrivas noship $ */
3
4 type number_tab_type is table of number index by binary_integer;
5
6 -- this procedure is called from ui to insert trip data into mst_release_temp for release
7 -- for loads given in p_load_tab. if p_load_type = 'CM' then this list contains CMs otherwise trips
8
9 procedure insert_trips (p_plan_id IN NUMBER
10 , p_release_id IN NUMBER
11 , p_load_tab IN NUMBER_TAB_TYPE
12 , p_load_type IN VARCHAR2);--'CM' or 'TRIP'
13
14 -- this procedure is used to release the loads for release_id = p_release_id in mst_release_trips
15 -- it is called from ui after inserting trip data into mst_release_temp using procedure 'insert_trips'
16 -- also it is called from procedure 'release_plan' after inserting plan's trip data into mst_release_temp
17
18 procedure release_load (p_err_code OUT NOCOPY VARCHAR2
19 , p_err_buff OUT NOCOPY VARCHAR2
20 , p_plan_id IN NUMBER
21 , p_release_id IN NUMBER
22 , p_release_mode IN NUMBER DEFAULT NULL);
23
24 -- this procedure is called form ui as well as engine to release entire plan
25
26 procedure release_plan (p_err_code OUT NOCOPY VARCHAR2
27 , p_err_buff OUT NOCOPY VARCHAR2
28 , p_plan_id IN NUMBER
29 , p_release_id IN NUMBER
30 , p_release_mode IN NUMBER DEFAULT NULL);
31
32
33 -- p_release_mode = 1 => auto release
34 -- = null => manual release
35
36
37 procedure submit_release_request ( p_request_id OUT NOCOPY NUMBER
38 , p_release_type IN VARCHAR2 -- 'LOAD' or 'PLAN
39 , p_plan_id IN NUMBER
40 , p_release_id IN NUMBER
41 , p_release_mode IN NUMBER DEFAULT NULL);
42
43 ------ following functions are being used in MSTEXCEP.pld -------------------------------------------
44 -- p_release_type = 1 => auto released, 2 => released, 3 => flagged for release, 4 => unreleased
45 procedure set_release_type (p_release_type IN NUMBER);
46
47 -- used in views of all tls, all ltls, all parcels, all continuous moves
48 function get_release_type RETURN NUMBER;
49 -----------------------------------------------------------------------------------------------------
50
51 END MST_RELEASE;