DBA Data[Home] [Help]

PACKAGE: APPS.FTE_MLS_TEST_NT

Source


1 PACKAGE FTE_MLS_TEST_NT AUTHID CURRENT_USER AS
2 /* $Header: FTEMLTES.pls 120.2 2005/07/06 07:51:43 nltan noship $ */
3 
4 --========================================================================
5 -- PROCEDURE : ASSIGN_SERVICE_TENDER        FTE wrapper
6 --
7 -- COMMENT   : Procedure assigns service, creates/updates ranked list,
8 --             tenders, and deletes rates. If the FTE_TENDER_ATTR_REC is
9 --	       populated, then
10 -- CALLER    : FTE UI: TripWB, DeliveryWB, ManageItinerary
11 --========================================================================
12 --
13 PROCEDURE ASSIGN_SERVICE_TENDER
14 (
15 	p_API_VERSION_NUMBER	IN	NUMBER,
16 	p_INIT_MSG_LIST		IN	VARCHAR2,
17 	p_COMMIT		IN	VARCHAR2,
18 	p_SS_ATTR_REC		IN	FTE_SS_ATTR_REC,
19 	p_SS_RATE_SORT_TAB	IN OUT NOCOPY FTE_SS_RATE_SORT_TAB_TYPE,
20 	p_TENDER_ATTR_REC	IN	FTE_TENDER_ATTR_REC,
21 	p_REQUEST_ID		IN	NUMBER,
22 	p_SERVICE_ACTION	IN	VARCHAR2,
23 	p_LIST_ACTION		IN	VARCHAR2,
24 	x_RETURN_STATUS		OUT NOCOPY VARCHAR2,
25 	x_MSG_COUNT		OUT NOCOPY NUMBER,
26 	x_MSG_DATA		OUT NOCOPY VARCHAR2
27 );
28 --
29 PROCEDURE SEARCH_SERVICES
30 (
31 	p_API_VERSION_NUMBER	IN	NUMBER,
32 	p_INIT_MSG_LIST		IN	VARCHAR2,
33 	p_COMMIT		IN	VARCHAR2,
34 	p_CALLER		IN	VARCHAR2,
35 	p_FTE_SS_ATTR_REC	IN	FTE_SS_ATTR_REC,
36 	x_LIST_CREATE_TYPE	OUT NOCOPY VARCHAR2,
37 	x_SS_RATE_SORT_TAB	OUT NOCOPY FTE_SS_RATE_SORT_TAB_TYPE,
38 	x_PRICING_REQUEST_ID	OUT NOCOPY NUMBER,
39 	x_RETURN_STATUS		OUT NOCOPY VARCHAR2,
40 	x_MSG_COUNT		OUT NOCOPY NUMBER,
41 	x_MSG_DATA		OUT NOCOPY VARCHAR2
42 );
43 --
44 END FTE_MLS_TEST_NT;