1 PACKAGE IEX_SEND_XML_PVT AUTHID CURRENT_USER as
2 /* $Header: iexvxmls.pls 120.4 2010/08/04 08:22:35 gnramasa ship $ */
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 p_dunning_mode IN VARCHAR2, -- added by gnramasa for bug 8489610 14-May-09
48 p_parent_request_id IN NUMBER DEFAULT NULL,
49 p_org_id in number default null, -- added for bug 9151851
50 p_addt_template_id IN NUMBER DEFAULT NULL, --added for bug 9970624 gnramasa 4th Aug 10
51 p_addt_query_id IN NUMBER DEFAULT NULL, --added for bug 9970624 gnramasa 4th Aug 10
52 X_Request_ID OUT NOCOPY NUMBER,
53 X_Return_Status OUT NOCOPY VARCHAR2,
54 X_Msg_Count OUT NOCOPY NUMBER,
55 X_Msg_Data OUT NOCOPY VARCHAR2
56 );
57
58 /*
59 Overview: This function is to get the xml data from a query which is defined by the dunning letter template.
60 Parameter: p_party_id : party_id
61 Return: clob contains the result of the query
62 creation date: 08/25/2004
63 author: ctlee
64 Note: test only
65 */
66 procedure GetXmlData
67 (
68 p_party_id IN number
69 , p_resource_id IN number
70 , p_bind_tbl IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL
71 , p_query_id IN number
72 , p_is_this_addt_query IN VARCHAR DEFAULT 'N' --added for bug 9970624 gnramasa 4th Aug 10
73 , x_return_status OUT NOCOPY VARCHAR2
74 , x_msg_count OUT NOCOPY NUMBER
75 , x_msg_data OUT NOCOPY VARCHAR2
76 , x_xml OUT NOCOPY clob
77 ) ;
78
79
80 /*
81 Overview: This function is to retrieve the existing xml data from
82 iex_xml_request_histories table.
83 */
84 procedure RetrieveXmlData
85 (
86 p_request_id IN number
87 , x_return_status OUT NOCOPY VARCHAR2
88 , x_msg_count OUT NOCOPY NUMBER
89 , x_msg_data OUT NOCOPY VARCHAR2
90 , x_xml OUT NOCOPY clob
91 , x_addt_xml OUT NOCOPY clob --added for bug 9970624 gnramasa 4th Aug 10
92 ) ;
93
94
95 /*
96 Overview: This function is to get the current setup in IEX ADMIN/SETUP
97 (iex_app_preferences_vl) for 'COLLECTIONS DELIVERY METHOD'.
98 */
99 function getCurrDeliveryMethod
100 return varchar2;
101
102
103
104 Procedure WriteLog ( p_msg IN VARCHAR2 );
105
106
107
108 End IEX_SEND_XML_PVT;