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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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*/
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: );
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:
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,