eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CUSTOMER_INFO_PVT dependencies on OE_ORDER_PUB

Line 9: p_customer_info_tbl IN OUT NOCOPY OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE,

5: G_SOLD_TO_CONTACT_ID NUMBER;
6:
7: Procedure get_customer_info_ids
8: (
9: p_customer_info_tbl IN OUT NOCOPY OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE,
10: p_operation_code IN VARCHAR2,
11: p_sold_to_customer_ref IN VARCHAR2,
12: p_ship_to_customer_ref IN VARCHAR2,
13: p_bill_to_customer_ref IN VARCHAR2,

Line 63: Procedure Create_account (p_header_customer_info_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,

59: x_msg_data OUT NOCOPY VARCHAR2
60: );
61:
62:
63: Procedure Create_account (p_header_customer_info_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,
64: x_party_id OUT NOCOPY NUMBER,
65: x_cust_account_id OUT NOCOPY NUMBER,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,

Line 83: p_customer_info_tbl IN OUT NOCOPY OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE

79:
80:
81:
82: Procedure Create_Addresses (
83: p_customer_info_tbl IN OUT NOCOPY OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE
84: , p_operation_code IN VARCHAR2
85: , p_sold_to_customer_id IN NUMBER
86: , p_ship_to_customer_id IN NUMBER
87: , p_bill_to_customer_id IN NUMBER

Line 103: p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,

99: );
100:
101: Procedure Create_Party_Site
102: ( p_party_id IN NUMBER,
103: p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,
104: x_location_id OUT NOCOPY NUMBER,
105: x_party_site_id OUT NOCOPY NUMBER,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,

Line 115: p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,

111:
112: PROCEDURE Create_Cust_Account_Site
113: ( p_party_site_id IN NUMBER,
114: p_cust_account_id IN NUMBER,
115: p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,
116: x_cust_account_site_id OUT NOCOPY NUMBER,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2 );

Line 133: Procedure Create_Contact ( p_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE

129: x_msg_data OUT NOCOPY VARCHAR2
130: );
131:
132:
133: Procedure Create_Contact ( p_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE
134: , p_operation_code IN VARCHAR2
135: , p_customer_id IN NUMBER
136: , p_customer_rec_index IN NUMBER
137: , p_usage_code IN VARCHAR2

Line 151: p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,

147: Function check_relation_exists ( p_customer_id IN NUMBER
148: ,p_rel_customer_id NUMBER ) RETURN BOOLEAN;
149:
150: Procedure Check_Party_Site_Exists( p_party_id IN NUMBER,
151: p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,
152: x_party_site_id OUT NOCOPY NUMBER
153: );
154:
155:

Line 163: Procedure Check_Customer_Fields (p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

159: );
160:
161:
162:
163: Procedure Check_Customer_Fields (p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
164: ,x_return_status OUT NOCOPY VARCHAR2 );
165: Procedure Validate_Customer_Fields (p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
166: ,x_return_status OUT NOCOPY VARCHAR2 );
167:

Line 165: Procedure Validate_Customer_Fields (p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

161:
162:
163: Procedure Check_Customer_Fields (p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
164: ,x_return_status OUT NOCOPY VARCHAR2 );
165: Procedure Validate_Customer_Fields (p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
166: ,x_return_status OUT NOCOPY VARCHAR2 );
167:
168: Procedure Check_Duplicate_Customer ( p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
169: , p_type IN VARCHAR2

Line 168: Procedure Check_Duplicate_Customer ( p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

164: ,x_return_status OUT NOCOPY VARCHAR2 );
165: Procedure Validate_Customer_Fields (p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
166: ,x_return_status OUT NOCOPY VARCHAR2 );
167:
168: Procedure Check_Duplicate_Customer ( p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
169: , p_type IN VARCHAR2
170: , x_customer_id OUT NOCOPY VARCHAR2
171: );
172:

Line 174: Procedure Check_Address_Fields (p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

170: , x_customer_id OUT NOCOPY VARCHAR2
171: );
172:
173:
174: Procedure Check_Address_Fields (p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
175: ,x_return_status OUT NOCOPY VARCHAR2 );
176: Procedure Validate_Address_Fields (p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
177: ,x_return_status OUT NOCOPY VARCHAR2 );
178: Procedure Check_Duplicate_Address ( p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

Line 176: Procedure Validate_Address_Fields (p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

172:
173:
174: Procedure Check_Address_Fields (p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
175: ,x_return_status OUT NOCOPY VARCHAR2 );
176: Procedure Validate_Address_Fields (p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
177: ,x_return_status OUT NOCOPY VARCHAR2 );
178: Procedure Check_Duplicate_Address ( p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
179: , p_sold_to_org_id IN NUMBER
180: , p_site_customer_id IN NUMBER

Line 178: Procedure Check_Duplicate_Address ( p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

174: Procedure Check_Address_Fields (p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
175: ,x_return_status OUT NOCOPY VARCHAR2 );
176: Procedure Validate_Address_Fields (p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
177: ,x_return_status OUT NOCOPY VARCHAR2 );
178: Procedure Check_Duplicate_Address ( p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
179: , p_sold_to_org_id IN NUMBER
180: , p_site_customer_id IN NUMBER
181: , p_site_usage IN VARCHAR2
182: , x_site_usage_id OUT NOCOPY NUMBER

Line 185: Procedure Value_To_Id_Address ( p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

181: , p_site_usage IN VARCHAR2
182: , x_site_usage_id OUT NOCOPY NUMBER
183: );
184:
185: Procedure Value_To_Id_Address ( p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
186: , p_sold_to_org_id IN NUMBER
187: , p_site_customer_id IN NUMBER
188: , p_site_usage IN VARCHAR2
189: , x_site_usage_id OUT NOCOPY NUMBER

Line 191: Procedure Value_To_Id_contact ( p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

187: , p_site_customer_id IN NUMBER
188: , p_site_usage IN VARCHAR2
189: , x_site_usage_id OUT NOCOPY NUMBER
190: );
191: Procedure Value_To_Id_contact ( p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
192: , p_customer_id IN NUMBER
193: , p_site_usage_code IN VARCHAR2
194: , p_site_usage_id OUT NOCOPY NUMBER
195: , x_contact_id OUT NOCOPY NUMBER

Line 198: Procedure Check_Contact_Fields (p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

194: , p_site_usage_id OUT NOCOPY NUMBER
195: , x_contact_id OUT NOCOPY NUMBER
196: );
197:
198: Procedure Check_Contact_Fields (p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
199: ,x_return_status OUT NOCOPY VARCHAR2 );
200: Procedure Validate_Contact_Fields (p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
201: ,x_return_status OUT NOCOPY VARCHAR2 );
202:

Line 200: Procedure Validate_Contact_Fields (p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

196: );
197:
198: Procedure Check_Contact_Fields (p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
199: ,x_return_status OUT NOCOPY VARCHAR2 );
200: Procedure Validate_Contact_Fields (p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
201: ,x_return_status OUT NOCOPY VARCHAR2 );
202:
203:
204:

Line 206: Function IS_BOTH_ID_VAL_PASSED ( p_customer_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)

202:
203:
204:
205:
206: Function IS_BOTH_ID_VAL_PASSED ( p_customer_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)
207: RETURN BOOLEAN;
208:
209: Function IS_BOTH_ID_VAL_PASSED ( p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)
210: RETURN BOOLEAN;

Line 209: Function IS_BOTH_ID_VAL_PASSED ( p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)

205:
206: Function IS_BOTH_ID_VAL_PASSED ( p_customer_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)
207: RETURN BOOLEAN;
208:
209: Function IS_BOTH_ID_VAL_PASSED ( p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)
210: RETURN BOOLEAN;
211:
212: Function IS_BOTH_ID_VAL_PASSED ( p_contact_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)
213: RETURN BOOLEAN;

Line 212: Function IS_BOTH_ID_VAL_PASSED ( p_contact_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)

208:
209: Function IS_BOTH_ID_VAL_PASSED ( p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)
210: RETURN BOOLEAN;
211:
212: Function IS_BOTH_ID_VAL_PASSED ( p_contact_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)
213: RETURN BOOLEAN;
214:
215:
216: FUNCTION Get_obj_version_number( p_location_id IN NUMBER DEFAULT NULL

Line 220: Procedure Update_Location ( p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

216: FUNCTION Get_obj_version_number( p_location_id IN NUMBER DEFAULT NULL
217: , p_cust_account_id IN NUMBER DEFAULT NULL
218: , p_party_id IN NUMBER DEFAULT NULL ) RETURN NUMBER;
219:
220: Procedure Update_Location ( p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
221: , p_site_use_id IN NUMBER
222: , p_site_usage_code IN VARCHAR2
223: , x_return_status OUT NOCOPY VARCHAR2
224: , x_msg_count OUT NOCOPY NUMBER

Line 229: Procedure Update_Customer ( p_customer_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

225: , x_msg_data OUT NOCOPY VARCHAR2
226: );
227:
228:
229: Procedure Update_Customer ( p_customer_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
230: , x_return_status OUT NOCOPY VARCHAR2 );
231:
232: PROCEDURE Update_Contact ( p_contact_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
233: , x_return_status OUT NOCOPY VARCHAR2

Line 232: PROCEDURE Update_Contact ( p_contact_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

228:
229: Procedure Update_Customer ( p_customer_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
230: , x_return_status OUT NOCOPY VARCHAR2 );
231:
232: PROCEDURE Update_Contact ( p_contact_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
233: , x_return_status OUT NOCOPY VARCHAR2
234: , x_msg_count OUT NOCOPY NUMBER
235: , x_msg_data OUT NOCOPY VARCHAR2
236: );