[Home] [Help]
PACKAGE: APPS.FTE_TRACKING_WRAPPER
Source
1 PACKAGE FTE_TRACKING_WRAPPER as
2 /* $Header: FTETKWRS.pls 120.1 2005/06/01 21:21:13 appldev $ */
3
4 --========================================================================
5 -- PROCEDURE : Insert_delete_delivery FTE Tracking wrapper
6 --
7 -- COMMENT : Insert the data from the header interface table to
8 -- wsh_delivery_leg_activities and wsh_delivery_leg_details.
9 -- Delete the record from the detail interface table if they are
10 -- repeated.
11 --========================================================================
12
13 PROCEDURE GET_DELIVERY_OR_CONTAINER(
14 p_transaction_id IN NUMBER,
15 x_exception_message OUT NOCOPY VARCHAR2,
16 x_return_status OUT NOCOPY NUMBER,
17 x_error_token_text OUT NOCOPY NUMBER);
18
19 PROCEDURE GET_DELIVERY_DETAILS(
20 p_transaction_id IN NUMBER,
21 p_carrier_id IN NUMBER,
22 x_exception_message OUT NOCOPY VARCHAR2,
23 x_return_status OUT NOCOPY NUMBER,
24 x_error_token_text OUT NOCOPY NUMBER);
25
26 PROCEDURE INSERT_ERROR_STATUS(
27 p_interface_error_id IN NUMBER,
28 p_interface_table_name IN VARCHAR2,
29 p_interface_id IN NUMBER,
30 p_message_code IN NUMBER,
31 p_message_name IN VARCHAR2,
32 p_error_message IN VARCHAR2,
33 p_carrier_id IN NUMBER);
34
35 PROCEDURE CALL_LAST_DELIVERY_LEG(
36 p_delivery_leg_id IN NUMBER,
37 p_received_date IN DATE);
38
39
40 PROCEDURE CALL_LAST_DELIVERY_LEG(
41 p_api_version_number IN NUMBER,
42 p_init_msg_list IN VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_delivery_leg_id IN NUMBER,
47 p_received_date IN DATE);
48 --MDC Changes for Release 12
49 PROCEDURE POPULATE_CHILD_DELIVERY_LEGS
50 (
51 p_init_msg_list IN VARCHAR2,
52 p_delivery_leg_id IN NUMBER,
53 p_transaction_id IN NUMBER,
54 p_carrier_id IN NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 END FTE_TRACKING_WRAPPER;