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;
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:
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,
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,
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,
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,
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,
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,
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,
162: x_return_status OUT NOCOPY VARCHAR2
163: );
164: */
165:
166: END FTE_MOVES_PVT;
167:
168: