[Home] [Help]
PACKAGE: APPS.IEX_UWQ_SEL_PKG
Source
1 PACKAGE IEX_UWQ_SEL_PKG AS
2 /* $Header: iextmsls.pls 120.1.12010000.1 2008/11/12 10:18:55 appldev noship $ */
3
4 G_CurrentForm varchar2(60) := 'IEXRCALL';
5
6 l_eventName varchar2(60);
7 l_partyId number;
8 l_partyType varchar2(80);
9 l_customerNumber number;
10 l_contactId number;
11 l_contactNumber number;
12 l_eventConfCode varchar2(30);
13 l_eventId number;
14 l_collateralReqNum VARCHAR2(30) ;
15 l_collateralId number;
16 l_campaignCode varchar2(30);
17 l_campaignId number;
18 l_dnis varchar2(25);
19 l_callId varchar2(30);
20 l_ani varchar2(30);
21 l_accountCode number;
22 l_usage varchar2(60);
23 l_agentID varchar2(60);
24 l_mediaType varchar2(60);
25 l_mediaItemID varchar2(60);
26 l_workitemID varchar2(60);
27 l_sendername varchar2(60);
28 l_subject varchar2(60);
29 l_messageID varchar2(60);
30 l_profile varchar2(10);
31 l_PhoneAreaCodeYN varchar2(10);
32 l_dumpData varchar2(10);
33 l_MoreAniMatch varchar2(10);
34 l_AreaCodeLength varchar2(10);
35 l_PhoneNumberLength varchar2(10);
36
37 l_task_id varchar2(60) ;
38 l_source_code varchar2(60) ;
39 l_source_code_id varchar2(60) ;
40 l_customer_trx_id number;
41 l_trx_view_by varchar2(60) ;
42 l_InvoiceNum varchar2(60) ;
43 l_AccountRolesExist VARCHAR2(10);
44
45 -- kmahajan - added for bug 2695645
46 l_customerID number;
47
48 --for handlefootask function below..jraj..11/5/02
49 l_source_object_type varchar2(300);
50 l_source_campaign_id number;
51 l_nm_party_id number;
52
53 l_blocked boolean;
54
55
56 ------------------------------------------------------------------------------
57 -- Procedure : handleIEXInbound,
58 -- Usage : Used by UWQ to call Telesales Form
59 -- Description : This procedure takes the table of objects containing
60 -- the meta data as input and gives the following as output:
61 -- 1. Action Type - Method to be used to call the telesales form
62 -- using APP_NAVIGATE.EXECUTEFND_FUNCTION.EXECUTE etc.
63 -- 2. Action Name - Name of the function to call the telesales form.
64 -- 3. Action Param - Parameters to be passed to the telesales form.
65 -- Parameters :
66 -- p_ieu_media_data IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST Required
67 -- p_action_type OUT NUMBER
68 -- p_action_name OUT VARCHAR2
69 -- p_action_param OUT VARCHAR2
70 --
71 ------------------------------------------------------------------------------
72
73 PROCEDURE handleIEXInbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
74 p_action_type OUT NOCOPY NUMBER,
75 p_action_name OUT NOCOPY varchar2,
76 p_action_param OUT NOCOPY varchar2);
77
78 PROCEDURE handleIEXOutbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
79 p_action_type OUT NOCOPY NUMBER,
80 p_action_name OUT NOCOPY varchar2,
81 p_action_param OUT NOCOPY varchar2);
82
83 PROCEDURE handleEmail (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
84 p_action_type OUT NOCOPY NUMBER,
85 p_action_name OUT NOCOPY varchar2,
86 p_action_param OUT NOCOPY varchar2);
87
88 PROCEDURE handleOOCInbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
89 p_action_type OUT NOCOPY NUMBER,
90 p_action_name OUT NOCOPY varchar2,
91 p_action_param OUT NOCOPY varchar2);
92
93 PROCEDURE setCurrentForm(p_formName varchar2);
94
95 PROCEDURE getFooData(p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST);
96
97 PROCEDURE handleFooTask (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
98 p_action_type OUT NOCOPY NUMBER,
99 p_action_name OUT NOCOPY varchar2,
100 p_action_param OUT NOCOPY varchar2);
101
102 END IEX_UWQ_SEL_PKG;