[Home] [Help]
PACKAGE: APPS.EC_TRADING_PARTNER_PVT
Source
1 PACKAGE EC_Trading_Partner_PVT AUTHID CURRENT_USER AS
2 -- $Header: ECVTPXFS.pls 120.2 2005/09/28 07:23:08 arsriniv ship $
3
4 -- Global constants holding the package and file names to be used by
5 -- messaging routines in the case of an unexpected error.
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'EC_Trading_Partner_PVT';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ECVTPXFB.pls';
9
10 -- Global constants representing CUSTOMER and SUPPLIER
11
12 G_BANK CONSTANT VARCHAR2(10) := 'BANK';
13 G_CUSTOMER CONSTANT VARCHAR2(10) := 'CUSTOMER';
14 G_SUPPLIER CONSTANT VARCHAR2(10) := 'SUPPLIER';
15 G_LOCATION CONSTANT VARCHAR2(10) := 'LOCATION';
16
17 G_TP_NOT_FOUND CONSTANT VARCHAR2(1) := 'X';
18
19 -- Start of Comments
20 -- API name : Get_TP_Address
21 -- Type : Private.
22 -- Function : Retrieve Supplier/Customer and Address information for a TP
23 -- Pre-reqs : None.
24 -- Paramaeters :
25 -- IN : p_api_version_number IN NUMBER Required
26 -- p_init_msg_list IN VARCHAR2 Optional
27 -- Default = FND_API.G_FALSE
28 -- p_simulate IN VARCHAR2 Optional
29 -- Default = FND_API.G_FALSE
30 -- p_commit IN VARCHAR2 Optional
31 -- Default = FND_API.G_FALSE
32 -- p_validation_level IN NUMBER Optional
33 -- Default = FND_API.G_VALID_LEVEL_FULL
34 -- p_translator_code IN VARCHAR2 Required
35 -- p_location_code_ext IN VARCHAR2 Required
36 -- p_info_type IN VARCHAR2 Required
37 --
38 -- OUT : p_return_status OUT VARCHAR2(1)
39 -- p_msg_count OUT NUMBER
40 -- p_msg_data OUT VARCHAR2(2000)
41 -- p_entity_id OUT NUMBER
42 -- p_entity_address_id OUT NUMBER
43 -- .
44 -- Version : Current version 1.0
45 -- Initial version 1.0
46 --
47 -- Notes : Note text
48 --
49 --
50 -- API name : Get_TP_Address_Ref
51 -- Type : Private.
52 -- Function : Retrieve Supplier/Customer and Address information for a TP
53 -- This implementation is per request from the automotive team
54 -- Pre-reqs : None.
55 -- Paramaeters :
56 -- IN : p_api_version_number IN NUMBER Required
57 -- p_init_msg_list IN VARCHAR2 Optional
58 -- Default = FND_API.G_FALSE
59 -- p_simulate IN VARCHAR2 Optional
60 -- Default = FND_API.G_FALSE
61 -- p_commit IN VARCHAR2 Optional
62 -- Default = FND_API.G_FALSE
63 -- p_validation_level IN NUMBER Optional
64 -- Default = FND_API.G_VALID_LEVEL_FULL
65 -- p_reference_ext1 IN VARCHAR2 Required
66 -- p_reference_ext2 IN VARCHAR2 Required
67 -- p_info_type IN VARCHAR2 Required
68 --
69 -- OUT : p_return_status OUT VARCHAR2(1)
70 -- p_msg_count OUT NUMBER
71 -- p_msg_data OUT VARCHAR2(2000)
72 -- p_entity_id OUT NUMBER
73 -- p_entity_address_id OUT NUMBER
74 -- .
75 -- Version : Current version 1.0
76 -- Initial version 1.0
77 --
78 -- Notes : Note text
79 --
80 --
81 -- API name : Get_TP_Location_Code
82 -- Type : Private.
83 -- Function : Retrieve TP information for an address
84 -- Pre-reqs : None.
85 -- Paramaeters :
86 -- IN : p_api_version_number IN NUMBER Required
87 -- p_init_msg_list IN VARCHAR2 Optional
88 -- Default = FND_API.G_FALSE
89 -- p_simulate IN VARCHAR2 Optional
90 -- Default = FND_API.G_FALSE
91 -- p_commit IN VARCHAR2 Optional
92 -- Default = FND_API.G_FALSE
93 -- p_validation_level IN NUMBER Optional
94 -- Default = FND_API.G_VALID_LEVEL_FULL
95 -- p_entity_address_id IN NUMBER Required
96 -- p_info_type IN VARCHAR2 Required
97 --
98 -- OUT : p_return_status OUT VARCHAR2(1)
99 -- p_msg_count OUT NUMBER
100 -- p_msg_data OUT VARCHAR2(2000)
101 -- p_location_code_ext OUT VARCHAR2
102 -- p_reference_ext1 OUT VARCHAR2
103 -- p_reference_ext2 OUT VARCHAR2
104
105 -- .
106 -- Version : Current version 1.0
107 -- Initial version 1.0
108 --
109 -- Notes : Note text
110 --
111 --
112
113 -- ***********************************************
114 -- procedure Get_TP_Address
115 -- ***********************************************
116 PROCEDURE Get_TP_Address
117 ( p_api_version_number IN NUMBER,
118 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
120 p_commit IN VARCHAR2 := FND_API.G_FALSE,
121 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122 p_return_status OUT NOCOPY VARCHAR2,
123 p_msg_count OUT NOCOPY NUMBER,
124 p_msg_data OUT NOCOPY VARCHAR2,
125 p_translator_code IN VARCHAR2,
126 p_location_code_ext IN VARCHAR2,
127 p_info_type IN VARCHAR2,
128 p_entity_id OUT NOCOPY NUMBER,
129 p_entity_address_id OUT NOCOPY NUMBER
130 );
131
132
133 -- ***********************************************
134 -- procedure Get_TP_Address_Auto
135 --
136 -- Overload this procedure per request from
137 -- the automotive team
138 -- ***********************************************
139 PROCEDURE Get_TP_Address_Ref
140 ( p_api_version_number IN NUMBER,
141 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
143 p_commit IN VARCHAR2 := FND_API.G_FALSE,
144 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145 p_return_status OUT NOCOPY VARCHAR2,
146 p_msg_count OUT NOCOPY NUMBER,
147 p_msg_data OUT NOCOPY VARCHAR2,
148 p_reference_ext1 IN VARCHAR2,
149 p_reference_ext2 IN VARCHAR2,
150 p_info_type IN VARCHAR2,
151 p_entity_id OUT NOCOPY NUMBER,
152 p_entity_address_id OUT NOCOPY NUMBER
153 );
154
155
156 -- ***********************************************
157 -- procedure Get_TP_Location_Code
158 -- ***********************************************
159 PROCEDURE Get_TP_Location_Code
160 ( p_api_version_number IN NUMBER,
161 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
163 p_commit IN VARCHAR2 := FND_API.G_FALSE,
164 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165 p_return_status OUT NOCOPY VARCHAR2,
166 p_msg_count OUT NOCOPY NUMBER,
167 p_msg_data OUT NOCOPY VARCHAR2,
168 p_entity_address_id IN NUMBER,
169 p_info_type IN VARCHAR2,
170 p_location_code_ext OUT NOCOPY VARCHAR2,
171 p_reference_ext1 OUT NOCOPY VARCHAR2,
172 p_reference_ext2 OUT NOCOPY VARCHAR2
173 );
174
175
176 FUNCTION IS_ENTITY_ENABLED
177 ( p_api_version_number IN NUMBER,
178 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
180 p_commit IN VARCHAR2 := FND_API.G_FALSE,
181 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182 p_return_status OUT NOCOPY VARCHAR2,
183 p_msg_count OUT NOCOPY NUMBER,
184 p_msg_data OUT NOCOPY VARCHAR2,
185 p_transaction_type IN VARCHAR2,
186 p_transaction_subtype IN VARCHAR2,
187 p_entity_type IN VARCHAR2,
188 p_entity_id IN NUMBER
189 ) RETURN BOOLEAN;
190
191
192 END;