[Home] [Help]
PACKAGE: APPS.POS_BUSINESS_CLASS_BO_PKG
Source
1 PACKAGE pos_business_class_bo_pkg AUTHID CURRENT_USER AS
2 /* $Header: POSSPBUCS.pls 120.1 2010/11/25 12:08:11 puppulur noship $ */
3
4 TYPE r_vendor_buss_rec_type IS RECORD(
5 batch_id pos_business_class_int.sdh_batch_id%TYPE,
6 source_system pos_business_class_int.source_system%TYPE,
7 source_system_reference pos_business_class_int.source_system_reference%TYPE,
8 vendor_interface_id pos_business_class_int.vendor_interface_id%TYPE,
9 business_class_interface_id pos_business_class_int.business_class_interface_id%TYPE,
10 --request_id pos_business_class_int.request_id%TYPE,
11 classification_id pos_business_class_int.classification_id%TYPE,
12 vendor_id pos_business_class_int.vendor_id%TYPE,
13 lookup_type pos_business_class_int.lookup_type%TYPE,
14 lookup_code pos_business_class_int.lookup_code%TYPE,
15 start_date_active pos_business_class_int.start_date_active%TYPE,
16 end_date_active pos_business_class_int.end_date_active%TYPE,
17 status pos_business_class_int.status%TYPE,
18 ext_attr_1 pos_business_class_int.ext_attr_1%TYPE,
19 expiration_date pos_business_class_int.expiration_date%TYPE,
20 certificate_number pos_business_class_int.certificate_number%TYPE,
21 certifying_agency pos_business_class_int.certifying_agency%TYPE,
22 class_status pos_business_class_int.class_status%TYPE,
23 attribute1 pos_business_class_int.attribute1%TYPE,
24 attribute2 pos_business_class_int.attribute2%TYPE,
25 attribute3 pos_business_class_int.attribute3%TYPE,
26 attribute4 pos_business_class_int.attribute4%TYPE,
27 attribute5 pos_business_class_int.attribute5%TYPE
28 /*,party_id NUMBER*/
29 );
30
31 PROCEDURE get_pos_business_class_bo_tbl(p_api_version IN NUMBER DEFAULT NULL,
32 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
33 p_party_id IN NUMBER,
34 p_orig_system IN VARCHAR2,
35 p_orig_system_reference IN VARCHAR2,
36 x_pos_bus_class_bo_tbl OUT NOCOPY pos_business_class_bo_tbl,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2);
40 PROCEDURE create_bus_class_attr(p_api_version IN NUMBER DEFAULT NULL,
41 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
42 p_pos_bus_class_bo IN pos_business_class_bo_tbl,
43 p_party_id IN NUMBER,
44 p_orig_system IN VARCHAR2,
45 p_orig_system_reference IN VARCHAR2,
46 p_create_update_flag IN VARCHAR2,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2);
50
51 END pos_business_class_bo_pkg;