[Home] [Help]
PACKAGE: APPS.ECX_TRADING_PARTNER_PVT
Source
1 PACKAGE ECX_Trading_Partner_PVT AUTHID CURRENT_USER AS
2 -- $Header: ECXTPXFS.pls 120.5 2005/10/31 00:43:08 susaha ship $
3 G_BANK CONSTANT VARCHAR2(10) := 'BANK';
4 G_CUSTOMER CONSTANT VARCHAR2(10) := 'CUSTOMER';
5 G_SUPPLIER CONSTANT VARCHAR2(10) := 'SUPPLIER';
6 G_LOCATION CONSTANT VARCHAR2(10) := 'LOCATION';
7
8 g_oag_logicalid varchar2(2000);
9
10 /** Returns the trading partners Details as defined in the partner Setup **/
11 procedure get_tp_info
12 (
13 p_tp_header_id IN pls_integer,
14 p_party_id OUT NOCOPY NUMBER,
15 p_party_site_id OUT NOCOPY NUMBER,
16 p_org_id OUT NOCOPY pls_integer,
17 p_admin_email OUT NOCOPY varchar2,
18 retcode OUT NOCOPY pls_integer,
19 retmsg OUT NOCOPY varchar2
20 );
21
22 /** Returns the address_id for a given address_type **/
23 PROCEDURE Get_Address_id
24 (
25 p_location_code_ext IN VARCHAR2,
26 p_info_type IN VARCHAR2,
27 p_entity_address_id OUT NOCOPY pls_integer,
28 p_org_id OUT NOCOPY pls_integer,
29 retcode OUT NOCOPY pls_integer,
30 retmsg OUT NOCOPY varchar2
31 );
32
33 /** Uses the Global variables for the Inbound Transaction **/
34 /** Receivers TP Info **/
35 procedure get_receivers_tp_info
36 (
37 p_party_id OUT NOCOPY NUMBER,
38 p_party_site_id OUT NOCOPY NUMBER,
39 p_org_id OUT NOCOPY pls_integer,
40 p_admin_email OUT NOCOPY varchar2,
41 retcode OUT NOCOPY pls_integer,
42 retmsg OUT NOCOPY varchar2
43 );
44
45 /** Senders TP Info **/
46 procedure get_senders_tp_info
47 (
48 p_party_id OUT NOCOPY NUMBER,
49 p_party_site_id OUT NOCOPY NUMBER,
50 p_org_id OUT NOCOPY pls_integer,
51 p_admin_email OUT NOCOPY varchar2,
52 retcode OUT NOCOPY pls_integer,
53 retmsg OUT NOCOPY varchar2
54 );
55
56 /** Get TP Company email ****/
57 procedure get_tp_company_email
58 (
59 l_transaction_type IN varchar2,
60 l_transaction_subtype IN varchar2,
61 l_party_site_id IN number,
62 l_party_type IN varchar2 default null, --bug #2183619
63 l_email_addr OUT NOCOPY varchar2,
64 retcode OUT NOCOPY pls_integer,
65 errmsg OUT NOCOPY varchar2
66 );
67
68 /** Get System Adminstrator Email ***/
69 procedure get_sysadmin_email
70 (
71 email_address OUT NOCOPY varchar2,
72 retcode OUT NOCOPY pls_integer,
73 errmsg OUT NOCOPY varchar2
74 );
75
76 /** Get TP Details given party_type, party_id, party_site_id, trxn type trxn subtype ***/
77 procedure get_tp_details
78 (
79 p_party_type IN varchar2,
80 p_party_id IN number,
81 p_party_site_id IN number,
82 p_transaction_type IN varchar2,
83 p_transaction_subtype IN varchar2,
84 p_protocol_type OUT NOCOPY varchar2,
85 p_protocol_address OUT NOCOPY varchar2,
86 p_username OUT NOCOPY varchar2,
87 p_password OUT NOCOPY varchar2,
88 p_retcode OUT NOCOPY pls_integer,
89 p_errmsg OUT NOCOPY varchar2
90 );
91
92 /** Get error type***/
93 procedure get_error_type
94 (
95 i_error_type OUT NOCOPY pls_integer,
96 retcode OUT NOCOPY pls_integer,
97 errmsg OUT NOCOPY varchar2
98 );
99
100 procedure getEnvelopeInformation
101 (
102 i_internal_control_number in pls_integer,
103 i_message_type OUT NOCOPY varchar2,
104 i_message_standard OUT NOCOPY varchar2,
105 i_transaction_type OUT NOCOPY varchar2,
106 i_transaction_subtype OUT NOCOPY varchar2,
107 i_document_number OUT NOCOPY varchar2,
108 i_party_id OUT NOCOPY varchar2,
109 i_party_site_id OUT NOCOPY varchar2,
110 i_protocol_type OUT NOCOPY varchar2,
111 i_protocol_address OUT NOCOPY varchar2,
112 i_username OUT NOCOPY varchar2,
113 i_password OUT NOCOPY varchar2,
114 i_attribute1 OUT NOCOPY varchar2,
115 i_attribute2 OUT NOCOPY varchar2,
116 i_attribute3 OUT NOCOPY varchar2,
117 i_attribute4 OUT NOCOPY varchar2,
118 i_attribute5 OUT NOCOPY varchar2,
119 retcode OUT NOCOPY pls_integer,
120 retmsg OUT NOCOPY varchar2
121 );
122
123 procedure setOriginalReferenceId
124 (
125 i_internal_control_number in varchar2,
126 i_original_reference_id in varchar2,
127 retcode OUT NOCOPY pls_integer,
128 retmsg OUT NOCOPY varchar2
129 );
130 function getOAGLOGICALID
131 return varchar2;
132
133 Function IsUserAuthorized (p_user_name IN VARCHAR2,
134 p_tp_header_id IN PLS_INTEGER,
135 p_profile_value IN VARCHAR2 default null)
136 Return Boolean;
137
138 Function validateTPUser (
139 p_transaction_type IN VARCHAR2,
140 p_transaction_subtype IN VARCHAR2,
141 p_standard_code IN VARCHAR2,
142 p_standard_type IN VARCHAR2,
143 p_party_site_id IN VARCHAR2,
144 p_user_name IN VARCHAR2,
145 x_tp_header_id OUT NOCOPY NUMBER,
146 retcode OUT NOCOPY VARCHAR2,
147 errmsg OUT NOCOPY VARCHAR2)
148 return varchar2;
149
150 END ECX_TRADING_PARTNER_PVT;