1 PACKAGE IEX_SEND_XML_PVT as
2 /* $Header: iexvxmls.pls 120.0 2005/05/10 19:54:32 acaraujo noship $ */
3 -- Start of Comments
4 -- Package name : IEX_SEND_XML_PVT
5 -- Purpose : Generate XML Data and Delivery by XML Publisher
6 -- NOTE :
7 -- History :
8 -- 11/08/2004 CLCHANG Created.
9 -- End of Comments
10
11 TYPE bind_cnt_tbl is table of NUMBER index by binary_integer;
12
13
14 G_MISS_VARCHAR_TBL JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
15
16
17 -- *************************
18 -- Validation Procedures
19 -- *************************
20
21
22
23 -- **************************
24 -- **************************
25
26 -- API Name: Send_COPY
27
28 PROCEDURE Send_COPY(
29 p_Api_Version_Number IN NUMBER,
30 p_Init_Msg_List IN VARCHAR2 ,
31 p_Commit IN VARCHAR2 ,
32 p_resend IN VARCHAR2 DEFAULT NULL,
33 p_request_id IN NUMBER DEFAULT NULL,
34 p_User_id IN NUMBER,
35 p_party_id IN NUMBER,
36 p_subject IN VARCHAR2 ,
37 p_bind_tbl IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,
38 p_template_id IN NUMBER,
39 p_resource_id IN NUMBER,
40 p_query_id IN NUMBER,
41 p_method IN VARCHAR2,
42 p_dest IN VARCHAR2,
43 p_level IN VARCHAR2,
44 p_source_id IN NUMBER,
45 p_object_type IN VARCHAR2,
46 p_object_id IN NUMBER,
47 X_Request_ID OUT NOCOPY NUMBER,
48 X_Return_Status OUT NOCOPY VARCHAR2,
49 X_Msg_Count OUT NOCOPY NUMBER,
50 X_Msg_Data OUT NOCOPY VARCHAR2
51 );
52
53 /*
54 Overview: This function is to get the xml data from a query which is defined by the dunning letter template.
55 Parameter: p_party_id : party_id
56 Return: clob contains the result of the query
57 creation date: 08/25/2004
58 author: ctlee
59 Note: test only
60 */
61 procedure GetXmlData
62 (
63 p_party_id IN number
64 , p_resource_id IN number
65 , p_bind_tbl IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL
66 , p_query_id IN number
67 , x_return_status OUT NOCOPY VARCHAR2
68 , x_msg_count OUT NOCOPY NUMBER
69 , x_msg_data OUT NOCOPY VARCHAR2
70 , x_xml OUT NOCOPY clob
71 ) ;
72
73
74 /*
75 Overview: This function is to retrieve the existing xml data from
76 iex_xml_request_histories table.
77 */
78 procedure RetrieveXmlData
79 (
80 p_request_id IN number
81 , x_return_status OUT NOCOPY VARCHAR2
82 , x_msg_count OUT NOCOPY NUMBER
83 , x_msg_data OUT NOCOPY VARCHAR2
84 , x_xml OUT NOCOPY clob
85 ) ;
86
87
88 /*
89 Overview: This function is to get the current setup in IEX ADMIN/SETUP
90 (iex_app_preferences_vl) for 'COLLECTIONS DELIVERY METHOD'.
91 */
92 function getCurrDeliveryMethod
93 return varchar2;
94
95
96
97 Procedure WriteLog ( p_msg IN VARCHAR2 );
98
99
100
101 End IEX_SEND_XML_PVT;