1 PACKAGE FTE_DELIVERY_PUB AUTHID CURRENT_USER AS
2 /* $Header: FTEPDELS.pls 120.0 2005/05/26 18:00:59 appldev noship $ */
3
4 --===================
5 -- PUBLIC TYPES
6 --===================
7
8 TYPE delivery_in_rec_type IS RECORD (
9 name VARCHAR2(30),
10 carrier_name VARCHAR2(360),
11 mode_of_transport VARCHAR2(30),
12 service_level VARCHAR2(30)
13 );
14
15 --===================
16 -- PROCEDURES
17 --===================
18
19 --========================================================================
20 -- PROCEDURE : Rate_Delivery
21 -- API TYPE : PUBLIC
22 -- PARAMETERS:
23 -- p_api_version API version number
24 -- p_init_msg_list FND_API.G_TRUE to reset the list,
25 -- or FND_API.G_FLASE not to reset the list
26 -- p_commit FND_API.G_TRUE to commit the work,
27 -- or FND_API.G_FLASE not to commit the work
28 -- x_return_status API return status,
29 -- FND_API.G_RET_STS_SUCCESS, if delivery is rated
30 -- successfully,
31 -- FND_API.G_RET_STS_ERROR, if delivery failed to rate
32 -- FND_API.G_RET_STS_UNEXP_ERROR, unexpected error
33 -- x_msg_count number of messages on the list
34 -- x_msg_data message text if x_msg_count = 1
35 -- p_action_code 'RATE'
36 -- p_delivery_in_rec delivery input, delivery name is required;
37 -- carrier_name, mode_of_transport, service_level are optional
38 -- VERSION : current version 1.0
39 -- initial version 1.0
40 --
41 -- CREATED BY : version 1.0 XIZHANG
42 -- CREATION DT : version 1.0 MAR/23/2004
43 --
44 -- COMMENT : This procedure is used to rate an input delivery
45 -- If delivery is on multiple trips,
46 -- API will error out;
47 -- If delivery is on a trip with multiple deliveries,
48 -- API will error out;
49 -- If delivery has no trip and input ship method is null,
50 -- API will do LCCS using delivery ship method;
51 -- If delivery has no trip and input ship method is not null,
52 -- API will do LCCS using input ship method;
53 -- If delivery has one trip and input ship method is null,
54 -- API will rate delivery on existing service.
55 -- If delivery has one trip and input ship method is not null,
56 -- API will do LCCS using input ship method.
57 --
58 -- API will not update delivery with input ship method
59 --
60 -- If delivery is rated successfully, trip ship method will be
61 -- LCCS result ship method.
62 --========================================================================
63
64 PROCEDURE Rate_Delivery (
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2,
67 p_commit IN VARCHAR2,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_action_code IN VARCHAR2,
72 p_delivery_in_rec IN delivery_in_rec_type
73 );
74
75 END FTE_DELIVERY_PUB;