PACKAGE: APPS.FTE_SS_INTERFACE

Source

1 PACKAGE FTE_SS_INTERFACE AS
2 /* $Header: FTESSITS.pls 120.2 2005/07/14 08:19:38 nltan noship $ */
3 
4 S_CALLER_WF	CONSTANT	VARCHAR2(30)	:= 'WF';
5 S_CALLER_UI	CONSTANT	VARCHAR2(30)	:= 'UI';
6 
7 G_SEQ_DEBUG	VARCHAR2(30) := 'OFF';
8 G_RG_DEBUG	VARCHAR2(30) := 'OFF';
9 
10 G_ROUTING_GUIDE_RESULTS	FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
11 G_SS_RATE_SORT_RESULTS	FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
12 
13 
14 PROCEDURE SEARCH_SERVICES(
15 	P_INIT_MSG_LIST			IN	VARCHAR2,
16 	P_API_VERSION_NUMBER		IN	NUMBER,
17 	P_COMMIT			IN	VARCHAR2,
18 	P_CALLER			IN	VARCHAR2,
19 	P_FTE_SS_ATTR_REC		IN	FTE_SS_ATTR_REC,
20 	X_RATING_REQUEST_ID		OUT NOCOPY	NUMBER,
21 	X_LIST_CREATE_TYPE		OUT NOCOPY	VARCHAR2,
22 	X_SS_RATE_SORT_TAB		OUT NOCOPY	FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
23 	X_RETURN_STATUS			OUT NOCOPY	VARCHAR2,
24 	X_MSG_COUNT			OUT NOCOPY	NUMBER,
25 	X_MSG_DATA			OUT NOCOPY	VARCHAR2);
26 
27 
28 PROCEDURE SEARCH_SERVICES_UIWRAPPER(
29 	P_INIT_MSG_LIST			IN	VARCHAR2,
30 	P_API_VERSION_NUMBER		IN	NUMBER,
31 	P_COMMIT			IN	VARCHAR2,
32 	P_CALLER			IN	VARCHAR2,
33 	P_FTE_SS_ATTR_REC		IN	FTE_SS_ATTR_REC,
34 	X_RATING_REQUEST_ID		OUT NOCOPY	NUMBER,
35 	X_LIST_CREATE_TYPE		OUT NOCOPY	VARCHAR2,
36 	X_SS_RATE_SORT_TAB		OUT NOCOPY	FTE_SS_RATE_SORT_TAB_TYPE,
37 	X_RETURN_STATUS			OUT NOCOPY	VARCHAR2,
38 	X_MSG_COUNT			OUT NOCOPY	NUMBER,
39 	X_MSG_DATA			OUT NOCOPY	VARCHAR2);
40 
41 
42   PROCEDURE GET_RANKED_RESULTS_WRAPPER
43   ( p_api_version_number     IN   		NUMBER,
44     p_init_msg_list          IN   		VARCHAR2,
45     x_return_status          OUT NOCOPY 	VARCHAR2,
46     x_msg_count              OUT NOCOPY 	NUMBER,
47     x_msg_data               OUT NOCOPY 	VARCHAR2,
48     x_routing_guide	     OUT NOCOPY		FTE_SS_RATE_SORT_TAB_TYPE,
49     p_routing_rule_id		     IN			NUMBER);
50 
51 
52 --========================================================================
53 -- PROCEDURE : ASSIGN_SERVICE_TENDER        FTE wrapper
54 --
55 -- COMMENT   : Procedure assigns service, creates/updates ranked list,
56 --             tenders, and deletes rates. If the FTE_TENDER_ATTR_REC is
57 --	       populated, then
58 -- CALLER    : FTE UI: TripWB, DeliveryWB, ManageItinerary
59 --========================================================================
60 --
61 PROCEDURE ASSIGN_SERVICE_TENDER
62 (
63 	p_API_VERSION_NUMBER	IN	NUMBER,
64 	p_INIT_MSG_LIST		IN	VARCHAR2,
65 	p_COMMIT		IN	VARCHAR2,
66 	p_SS_ATTR_REC		IN	FTE_SS_ATTR_REC,
67 	p_SS_RATE_SORT_TAB	IN OUT NOCOPY FTE_SS_RATE_SORT_TAB_TYPE,
68 	p_TENDER_ATTR_REC	IN	FTE_TENDER_ATTR_REC,
69 	p_REQUEST_ID		IN	NUMBER,
70 	p_SERVICE_ACTION	IN	VARCHAR2,
71 	p_LIST_ACTION		IN	VARCHAR2,
72 	x_RETURN_STATUS		OUT NOCOPY VARCHAR2,
73 	x_MSG_COUNT		OUT NOCOPY NUMBER,
74 	x_MSG_DATA		OUT NOCOPY VARCHAR2
75 );
76 
77 END FTE_SS_INTERFACE;