1 PACKAGE FTE_MOVES_PVT AUTHID CURRENT_USER AS
2 /* $Header: FTEMVTHS.pls 120.0 2005/05/26 18:23:31 appldev noship $ */
3
4 c_sdebug CONSTANT NUMBER := wsh_debug_sv.c_level1;
5 c_debug CONSTANT NUMBER := wsh_debug_sv.c_level2;
6
7 --
8 -- Type: Fte Moves Rectype
9 -- Definition: In sync with the table definition for trips
10 -- Use: In table handlers, calling packages
11
12
13 TYPE MOVE_REC_TYPE IS RECORD (
14 MOVE_ID FTE_MOVES.MOVE_ID%TYPE,
15 MOVE_TYPE_CODE FTE_MOVES.MOVE_TYPE_CODE%TYPE,
16 LANE_ID FTE_MOVES.LANE_ID%TYPE,
17 SERVICE_LEVEL FTE_MOVES.SERVICE_LEVEL%TYPE,
18 PLANNED_FLAG FTE_MOVES.PLANNED_FLAG%TYPE,
19 CM_TRIP_NUMBER FTE_MOVES.CM_TRIP_NUMBER%TYPE,
20 TP_PLAN_NAME FTE_MOVES.TP_PLAN_NAME%TYPE,
21 CREATION_DATE DATE,
22 CREATED_BY NUMBER,
23 LAST_UPDATE_DATE DATE,
24 LAST_UPDATED_BY NUMBER,
25 LAST_UPDATE_LOGIN NUMBER,
26 PROGRAM_APPLICATION_ID NUMBER,
27 PROGRAM_ID NUMBER,
28 PROGRAM_UPDATE_DATE DATE,
29 REQUEST_ID NUMBER,
30 ATTRIBUTE_CATEGORY VARCHAR2(150),
31 ATTRIBUTE1 VARCHAR2(150),
32 ATTRIBUTE2 VARCHAR2(150),
33 ATTRIBUTE3 VARCHAR2(150),
34 ATTRIBUTE4 VARCHAR2(150),
35 ATTRIBUTE5 VARCHAR2(150),
36 ATTRIBUTE6 VARCHAR2(150),
37 ATTRIBUTE7 VARCHAR2(150),
38 ATTRIBUTE8 VARCHAR2(150),
39 ATTRIBUTE9 VARCHAR2(150),
40 ATTRIBUTE10 VARCHAR2(150),
41 ATTRIBUTE11 VARCHAR2(150),
42 ATTRIBUTE12 VARCHAR2(150),
43 ATTRIBUTE13 VARCHAR2(150),
44 ATTRIBUTE14 VARCHAR2(150),
45 ATTRIBUTE15 VARCHAR2(150)
46 );
47
48
49 -- Table of MOVES_REC_TYPE
50 TYPE MOVE_ATTR_TBL_TYPE is TABLE of MOVE_REC_TYPE INDEX BY BINARY_INTEGER;
51
52
53
54 --
55 -- Procedure: Create_Move
56 -- Parameters: Move Record info; rowid, move_id, name, return_status as OUT
57 -- Description: This procedure will create a move. It will
58 -- return to the user the move_id and generates a name if
59 -- move name is not specified.
60 --
61
62 PROCEDURE CREATE_MOVE(
63 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64 p_move_info IN MOVE_REC_TYPE,
65 x_move_id OUT NOCOPY NUMBER,
66 x_return_status OUT NOCOPY VARCHAR2
67 );
68
69
70 --
71 -- Procedure: Delete_move
72 -- Parameters: Row_id, move_id, return_status and validate_flag
73 -- Description: This procedure will delete a move. If rowid is not null
74 -- move_id is found, and move_id is used to delete move.
75 -- validate_flag - 'Y' means check_delete_move is called
76 --
77
78 PROCEDURE DELETE_MOVE(
79 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
80 p_move_id IN NUMBER,
81 p_validate_flag IN VARCHAR2 DEFAULT 'Y',
82 x_return_status OUT NOCOPY VARCHAR2
83 );
84
85
86 --
87 -- Procedure: Update_move
88 -- Parameters: move rowid, move Record info and return_status
89 -- Description: This procedure will update a move.
90 --
91
92 PROCEDURE UPDATE_MOVE(
93 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
94 p_move_info IN move_rec_type,
95 x_return_status OUT NOCOPY VARCHAR2
96 );
97
98
99 --
100 -- Procedure: MARK_MOVE_REPRICE_FLAG
101 -- Parameters: move rowid, x_return_status,x_return_msg,x_return_data
102 -- Description: This procedure will mark reprice flag for all the trips in the move. This
103 -- procedure can be called to set reprice flag if move is CM is dissolved.
104 --
105
106
107 PROCEDURE MARK_MOVE_REPRICE_FLAG(
108 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
109 p_MOVE_id IN NUMBER,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY VARCHAR2,
112 x_msg_data OUT NOCOPY VARCHAR2);
113
114
115 --
116 -- Procedure: Lock_move
117 -- Parameters: move rowid, move Record info and return_status
118 -- Description: This procedure will lock a move row.
119 --
120 /**
121 PROCEDURE LOCK_MOVE(
122 p_rowid IN VARCHAR2,
123 p_move_info IN move_rec_type
124 x_return_status OUT NOCOPY VARCHAR2
125 );
126
127 --
128 -- PROCEDURE: Populate_Record
129 -- Parameters: MOVE id as IN, MOVE Record info and return status as OUT
130 -- Description: This PROCEDURE will populate a MOVE Record.
131 --
132
133 PROCEDURE POPULATE_RECORD(
134 p_MOVE_id IN NUMBER,
135 x_MOVE_info OUT NOCOPY MOVE_rec_type,
136 x_return_status OUT NOCOPY VARCHAR2);
137
138
139 --
140 -- Function: Get_Name
141 -- Parameters: p_MOVE_id - Id for MOVE
142 -- Description: This PROCEDURE will return MOVE Name for a MOVE Id
143 --
144
145
146 FUNCTION Get_Name
147 (p_MOVE_id IN NUMBER
148 ) RETURN VARCHAR2;
149
150
151 --
152 -- PROCEDURE: Lock_MOVE Wrapper
153 -- Parameters: A table of all Attributes of a MOVE Record,
154 -- Caller in
155 -- Return_Status,Valid_index_id_tab out
156 -- Description: This PROCEDURE will lock multiple MOVEs.
157 PROCEDURE Lock_MOVE(
158 p_rec_attr_tab IN MOVE_Attr_Tbl_Type,
159 p_caller IN VARCHAR2,
160 p_valid_index_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
161 x_valid_ids_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
162 x_return_status OUT NOCOPY VARCHAR2
163 );
164 */
165
166 END FTE_MOVES_PVT;
167
168