1 Package Okl_Uwq_Sel_Pkg AUTHID CURRENT_USER AS
2 /* $Header: OKLRUWQS.pls 115.4 2002/12/18 12:52:00 kjinger noship $ */
3
4 G_CurrentForm VARCHAR2(60) := 'OKLCSHDR_FUNC';
5 l_profile VARCHAR2(10);
6 l_dumpData VARCHAR2(10);
7 l_NoAreaCodeMatch VARCHAR2(10);
8 ------------------------------------------------------------------------------
9 -- Procedure : handleOTSInbound,
10 -- Usage : Used by UWQ to call Leasing Center Form Form
11 -- Description : This procedure takes the table of objects containing
12 -- the meta data as input and gives the following as output:
13 -- 1. Action Type - Method to be used to call the telesales form
14 -- using APP_NAVIGATE.EXECUTEFND_FUNCTION.EXECUTE etc.
15 -- 2. Action Name - Name of the function to call the telesales form.
16 -- 3. Action Param - Parameters to be passed to the telesales form.
17 -- Parameters :
18 -- p_ieu_media_data IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST Required
19 -- p_action_type OUT NUMBER
20 -- p_action_name OUT VARCHAR2
21 -- p_action_param OUT VARCHAR2
22 --
23 ------------------------------------------------------------------------------
24 PROCEDURE handleOTSInbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
25 p_action_type OUT NOCOPY NUMBER,
26 p_action_name OUT NOCOPY VARCHAR2,
27 p_action_param OUT NOCOPY VARCHAR2);
28 PROCEDURE handleOTSOutbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
29 p_action_type OUT NOCOPY NUMBER,
30 p_action_name OUT NOCOPY VARCHAR2,
31 p_action_param OUT NOCOPY VARCHAR2);
32 PROCEDURE handleEmail (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
33 p_action_type OUT NOCOPY NUMBER,
34 p_action_name OUT NOCOPY VARCHAR2,
35 p_action_param OUT NOCOPY VARCHAR2);
36 PROCEDURE handleOCInbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
37 p_action_type OUT NOCOPY NUMBER,
38 p_action_name OUT NOCOPY VARCHAR2,
39 p_action_param OUT NOCOPY VARCHAR2);
40 PROCEDURE handleOCOutbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
41 p_action_type OUT NOCOPY NUMBER,
42 p_action_name OUT NOCOPY VARCHAR2,
43 p_action_param OUT NOCOPY VARCHAR2);
44 PROCEDURE setCurrentForm(p_formName VARCHAR2);
45 FUNCTION constructParam RETURN VARCHAR2;
46 END Okl_Uwq_Sel_Pkg;