[Home] [Help]
PACKAGE: APPS.FTE_DELIVERY_ACTIVITY
Source
1 PACKAGE FTE_DELIVERY_ACTIVITY AUTHID CURRENT_USER AS
2 /* $Header: FTEDLACS.pls 120.0 2005/05/26 17:36:29 appldev noship $ */
3
4 --===================
5 -- TYPES
6 --===================
7 -- Rel 12 HBHAGAVA
8 TYPE delivery_leg_activity_rec IS RECORD (
9 ACTIVITY_ID NUMBER,
10 DELIVERY_LEG_ID NUMBER,
11 ACTIVITY_DATE DATE ,
12 ACTIVITY_TYPE VARCHAR2(30),
13 CREATION_DATE DATE ,
14 CREATED_BY NUMBER ,
15 LAST_UPDATE_DATE DATE ,
16 LAST_UPDATED_BY NUMBER ,
17 LAST_UPDATE_LOGIN NUMBER,
18 PROGRAM_APPLICATION_ID NUMBER,
19 PROGRAM_ID NUMBER,
20 PROGRAM_UPDATE_DATE DATE,
21 REQUEST_ID NUMBER,
22 ATTRIBUTE_CATEGORY VARCHAR2(240),
23 ATTRIBUTE1 VARCHAR2(240),
24 ATTRIBUTE2 VARCHAR2(240),
25 ATTRIBUTE3 VARCHAR2(240),
26 ATTRIBUTE4 VARCHAR2(240),
27 ATTRIBUTE5 VARCHAR2(240),
28 ATTRIBUTE6 VARCHAR2(240),
29 ATTRIBUTE7 VARCHAR2(240),
30 ATTRIBUTE8 VARCHAR2(240),
31 ATTRIBUTE9 VARCHAR2(240),
32 ATTRIBUTE10 VARCHAR2(240),
33 ATTRIBUTE11 VARCHAR2(240),
34 ATTRIBUTE12 VARCHAR2(240),
35 ATTRIBUTE13 VARCHAR2(240),
36 ATTRIBUTE14 VARCHAR2(240),
37 ATTRIBUTE15 VARCHAR2(240),
38 ACTION_BY NUMBER,
39 ACTION_BY_NAME VARCHAR2(255),
40 REMARKS VARCHAR2(2000),
41 RESULT_STATUS VARCHAR2(30),
42 INITIAL_STATUS VARCHAR2(30),
43 TRIP_ID NUMBER,
44 CARRIER_ID NUMBER,
45 MODE_OF_TRANSPORT VARCHAR2(30),
46 SERVICE_LEVEL VARCHAR2(30),
47 RANK_ID NUMBER,
48 RANK_VERSION NUMBER,
49 WF_ITEM_KEY VARCHAR2(240)
50 );
51
52
53 --===================
54 -- PROCEDURES
55 --===================
56
57 PROCEDURE ADD_HISTORY(
58
59 p_delivery_id IN NUMBER,
60 p_delivery_leg_id IN NUMBER,
61 p_trip_id IN NUMBER,
62 p_activity_date IN DATE,
63 p_activity_type IN VARCHAR2,
64 p_request_id IN NUMBER,
65 p_action_by IN NUMBER,
66 p_action_by_name IN VARCHAR2,
67 p_remarks IN VARCHAR2,
68 p_result_status IN VARCHAR2,
69 p_initial_status IN VARCHAR2,
70 p_carrier_id IN NUMBER,
71 p_mode_of_transport IN VARCHAR2,
72 p_service_level IN VARCHAR2,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_error_msg OUT NOCOPY VARCHAR2,
75 x_error_tkn OUT NOCOPY VARCHAR2);
76
77 PROCEDURE ADD_HISTORY(
78
79 p_trip_id IN NUMBER,
80 p_activity_date IN DATE,
81 p_activity_type IN VARCHAR2,
82 p_request_id IN NUMBER,
83 p_action_by IN NUMBER,
84 p_action_by_name IN VARCHAR2,
85 p_remarks IN VARCHAR2,
86 p_result_status IN VARCHAR2,
87 p_initial_status IN VARCHAR2,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_error_msg OUT NOCOPY VARCHAR2,
90 x_error_tkn OUT NOCOPY VARCHAR2);
91
92 PROCEDURE ADD_HISTORY(
93 p_init_msg_list IN VARCHAR2,
94 p_trip_id IN NUMBER,
95 p_delivery_leg_activity_rec IN delivery_leg_activity_rec,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2);
99
100
101 END FTE_DELIVERY_ACTIVITY;