DBA Data[Home] [Help]

APPS.POS_BUSINESS_CLASS_BO_PKG dependencies on POS_BUSINESS_CLASS_INT

Line 5: batch_id pos_business_class_int.sdh_batch_id%TYPE,

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,

Line 6: source_system pos_business_class_int.source_system%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,

Line 7: source_system_reference pos_business_class_int.source_system_reference%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,

Line 8: vendor_interface_id pos_business_class_int.vendor_interface_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,

Line 9: business_class_interface_id pos_business_class_int.business_class_interface_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,

Line 10: --request_id pos_business_class_int.request_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,

Line 11: classification_id pos_business_class_int.classification_id%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,

Line 12: vendor_id pos_business_class_int.vendor_id%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,

Line 13: lookup_type pos_business_class_int.lookup_type%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,

Line 14: lookup_code pos_business_class_int.lookup_code%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,

Line 15: start_date_active pos_business_class_int.start_date_active%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,

Line 16: end_date_active pos_business_class_int.end_date_active%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,

Line 17: status pos_business_class_int.status%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,

Line 18: ext_attr_1 pos_business_class_int.ext_attr_1%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,

Line 19: expiration_date pos_business_class_int.expiration_date%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,

Line 20: certificate_number pos_business_class_int.certificate_number%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,

Line 21: certifying_agency pos_business_class_int.certifying_agency%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,

Line 22: class_status pos_business_class_int.class_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,

Line 23: attribute1 pos_business_class_int.attribute1%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

Line 24: attribute2 pos_business_class_int.attribute2%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*/

Line 25: attribute3 pos_business_class_int.attribute3%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: );

Line 26: attribute4 pos_business_class_int.attribute4%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:

Line 27: attribute5 pos_business_class_int.attribute5%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,