1 PACKAGE AST_UWQ_SEL_PKG AUTHID CURRENT_USER AS
2 /* $Header: asttmsls.pls 115.22 2002/12/26 19:13:36 kmahajan ship $ */
3
4 G_CurrentForm varchar2(60) := 'AST_RC_CALL';
5 l_profile varchar2(10);
6 l_dumpData varchar2(10);
7 l_NoAreaCodeMatch varchar2(10);
8
9 ------------------------------------------------------------------------------
10 -- Procedure : handleOTSInbound,
11 -- Usage : Used by UWQ to call Telesales Form
12 -- Description : This procedure takes the table of objects containing
13 -- the meta data as input and gives the following as output:
14 -- 1. Action Type - Method to be used to call the telesales form
15 -- using APP_NAVIGATE.EXECUTEFND_FUNCTION.EXECUTE etc.
16 -- 2. Action Name - Name of the function to call the telesales form.
17 -- 3. Action Param - Parameters to be passed to the telesales form.
18 -- Parameters :
19 -- p_ieu_media_data IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST Required
20 -- p_action_type OUT NUMBER
21 -- p_action_name OUT VARCHAR2
22 -- p_action_param OUT VARCHAR2
23 --
24 ------------------------------------------------------------------------------
25
26 PROCEDURE handleOTSInbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
27 p_action_type OUT NOCOPY NUMBER,
28 p_action_name OUT NOCOPY varchar2,
29 p_action_param OUT NOCOPY varchar2);
30
31 PROCEDURE handleOTSOutbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
32 p_action_type OUT NOCOPY NUMBER,
33 p_action_name OUT NOCOPY varchar2,
34 p_action_param OUT NOCOPY varchar2);
35
36 PROCEDURE handleEmail (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
41 PROCEDURE handleOCInbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
42 p_action_type OUT NOCOPY NUMBER,
43 p_action_name OUT NOCOPY varchar2,
44 p_action_param OUT NOCOPY varchar2);
45
46 PROCEDURE handleOCOutbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
47 p_action_type OUT NOCOPY NUMBER,
48 p_action_name OUT NOCOPY varchar2,
49 p_action_param OUT NOCOPY varchar2);
50
51 PROCEDURE setCurrentForm(p_formName varchar2);
52 FUNCTION constructParam return varchar2;
53 PROCEDURE handleFooTask (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
54 p_action_type OUT NOCOPY NUMBER,
55 p_action_name OUT NOCOPY varchar2,
56 p_action_param OUT NOCOPY varchar2,
57 p_msg_name OUT NOCOPY varchar2,
58 p_msg_param OUT NOCOPY varchar2,
59 p_dialog_style OUT NOCOPY NUMBER,
60 p_msg_appl_short_name OUT NOCOPY varchar2) ;
61
62
63
64 END AST_UWQ_SEL_PKG;