[Home] [Help]
PACKAGE: APPS.IEX_XML_PKG
Source
1 PACKAGE iex_xml_pkg AUTHID CURRENT_USER AS
2 /* $Header: iextxmls.pls 120.7 2010/08/24 09:36:28 gnramasa ship $ */
3
4 PROCEDURE insert_row(
5 px_rowid IN OUT NOCOPY VARCHAR2
6 , px_xml_request_id IN OUT NOCOPY NUMBER
7 , p_query_temp_id NUMBER
8 , p_status VARCHAR2
9 , p_document BLOB
10 , p_html_document BLOB
11 , p_xmldata CLOB
12 , p_method VARCHAR2
13 , p_destination VARCHAR2
14 , p_subject VARCHAR2
15 , p_object_type VARCHAR2
16 , p_object_id NUMBER
17 , p_resource_id NUMBER
18 , p_view_by VARCHAR2
19 , p_party_id NUMBER
20 , p_cust_account_id NUMBER
21 , p_cust_site_use_id NUMBER
22 , p_delinquency_id NUMBER
23 , p_last_update_date DATE
24 , p_last_updated_by NUMBER
25 , p_creation_date DATE
26 , p_created_by NUMBER
27 , p_last_update_login NUMBER
28 , p_object_version_number NUMBER
29 , p_request_id NUMBER
30 , p_worker_id NUMBER
31 , p_confirmation_mode VARCHAR2 -- added by gnramasa for bug 8489610 14-May-09
32 , p_conc_request_id NUMBER -- added by gnramasa for bug 8489610 14-May-09
33 , p_org_id number -- added for bug 9151851
34 , p_template_language VARCHAR2 -- added by gnramasa for bug 8489610 28-May-09
35 , p_template_territory VARCHAR2 -- added by gnramasa for bug 8489610 28-May-09
36 , p_document_type VARCHAR2 default NULL
37 , p_addt_query_id number default null --added for bug 9970624 gnramasa 4th Aug 10
38 , p_addt_xmldata CLOB default null --added for bug 9970624 gnramasa 4th Aug 10
39 , p_addt_status VARCHAR2 default null --added for bug 9970624 gnramasa 4th Aug 10
40 , p_addt_document BLOB default null --added for bug 9970624 gnramasa 4th Aug 10
41 , p_addt_html_document BLOB default null --added for bug 9970624 gnramasa 4th Aug 10
42 );
43
44 PROCEDURE delete_row(
45 p_xml_request_id NUMBER
46 );
47
48
49 PROCEDURE update_row(
50 p_xml_request_id NUMBER
51 , p_query_temp_id NUMBER default null
52 , p_status VARCHAR2 default null
53 , p_document BLOB default null
54 , p_html_document BLOB default null
55 , p_xmldata CLOB default null
56 , p_method VARCHAR2 default null
57 , p_destination VARCHAR2 default null
58 , p_subject VARCHAR2 default null
59 , p_object_type VARCHAR2 default null
60 , p_object_id NUMBER default null
61 , p_resource_id NUMBER default null
62 , p_view_by VARCHAR2 default null
63 , p_party_id NUMBER default null
64 , p_cust_account_id NUMBER default null
65 , p_cust_site_use_id NUMBER default null
66 , p_delinquency_id NUMBER default null
67 , p_last_update_date DATE default null
68 , p_last_updated_by NUMBER default null
69 , p_creation_date DATE default null
70 , p_created_by NUMBER default null
71 , p_last_update_login NUMBER default null
72 , p_object_version_number NUMBER default null
73 , p_request_id NUMBER default null
74 , p_worker_id NUMBER default null
75 , p_confirmation_mode VARCHAR2 default null -- added by gnramasa for bug 8489610 14-May-09
76 , p_conc_request_id NUMBER default null -- added by gnramasa for bug 8489610 14-May-09
77 , p_template_language VARCHAR2 default null -- added by gnramasa for bug 8489610 28-May-09
78 , p_template_territory VARCHAR2 default null -- added by gnramasa for bug 8489610 28-May-09
79 , p_document_type VARCHAR2 default NULL
80 , p_addt_query_id number default null --added for bug 9970624 gnramasa 4th Aug 10
81 , p_addt_xmldata CLOB default null --added for bug 9970624 gnramasa 4th Aug 10
82 , p_addt_status VARCHAR2 default null --added for bug 9970624 gnramasa 4th Aug 10
83 , p_addt_document BLOB default null --added for bug 9970624 gnramasa 4th Aug 10
84 , p_addt_html_document BLOB default null --added for bug 9970624 gnramasa 4th Aug 10
85 );
86
87
88 Procedure WriteLog ( p_msg IN VARCHAR2);
89
90
91
92 END iex_xml_pkg;