1: PACKAGE ARP_CT_PKG AUTHID CURRENT_USER AS
2: /* $Header: ARTITRXS.pls 120.9 2010/11/30 17:29:43 nemani ship $ */
3:
4: PROCEDURE set_to_dummy( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype);
5:
6: PROCEDURE lock_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type );
7:
8: PROCEDURE lock_fetch_p( p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
2: /* $Header: ARTITRXS.pls 120.9 2010/11/30 17:29:43 nemani ship $ */
3:
4: PROCEDURE set_to_dummy( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype);
5:
6: PROCEDURE lock_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type );
7:
8: PROCEDURE lock_fetch_p( p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
9: p_customer_trx_id IN
10: ra_customer_trx.customer_trx_id%type );
4: PROCEDURE set_to_dummy( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype);
5:
6: PROCEDURE lock_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type );
7:
8: PROCEDURE lock_fetch_p( p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
9: p_customer_trx_id IN
10: ra_customer_trx.customer_trx_id%type );
11:
12: PROCEDURE lock_compare_p( p_trx_rec IN ra_customer_trx%rowtype,
6: PROCEDURE lock_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type );
7:
8: PROCEDURE lock_fetch_p( p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
9: p_customer_trx_id IN
10: ra_customer_trx.customer_trx_id%type );
11:
12: PROCEDURE lock_compare_p( p_trx_rec IN ra_customer_trx%rowtype,
13: p_customer_trx_id IN
14: ra_customer_trx.customer_trx_id%type,
8: PROCEDURE lock_fetch_p( p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
9: p_customer_trx_id IN
10: ra_customer_trx.customer_trx_id%type );
11:
12: PROCEDURE lock_compare_p( p_trx_rec IN ra_customer_trx%rowtype,
13: p_customer_trx_id IN
14: ra_customer_trx.customer_trx_id%type,
15: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE);
16:
10: ra_customer_trx.customer_trx_id%type );
11:
12: PROCEDURE lock_compare_p( p_trx_rec IN ra_customer_trx%rowtype,
13: p_customer_trx_id IN
14: ra_customer_trx.customer_trx_id%type,
15: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE);
16:
17: PROCEDURE fetch_p( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype,
18: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
13: p_customer_trx_id IN
14: ra_customer_trx.customer_trx_id%type,
15: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE);
16:
17: PROCEDURE fetch_p( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype,
18: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
19:
20: procedure delete_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
21:
14: ra_customer_trx.customer_trx_id%type,
15: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE);
16:
17: PROCEDURE fetch_p( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype,
18: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
19:
20: procedure delete_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
21:
22: PROCEDURE update_p( p_trx_rec IN ra_customer_trx%rowtype,
16:
17: PROCEDURE fetch_p( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype,
18: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
19:
20: procedure delete_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
21:
22: PROCEDURE update_p( p_trx_rec IN ra_customer_trx%rowtype,
23: p_customer_trx_id IN
24: ra_customer_trx.customer_trx_id%type);
18: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
19:
20: procedure delete_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
21:
22: PROCEDURE update_p( p_trx_rec IN ra_customer_trx%rowtype,
23: p_customer_trx_id IN
24: ra_customer_trx.customer_trx_id%type);
25:
26: PROCEDURE update_p_print( p_trx_rec IN ra_customer_trx%rowtype,
20: procedure delete_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
21:
22: PROCEDURE update_p( p_trx_rec IN ra_customer_trx%rowtype,
23: p_customer_trx_id IN
24: ra_customer_trx.customer_trx_id%type);
25:
26: PROCEDURE update_p_print( p_trx_rec IN ra_customer_trx%rowtype,
27: p_customer_trx_id IN
28: ra_customer_trx.customer_trx_id%type);
22: PROCEDURE update_p( p_trx_rec IN ra_customer_trx%rowtype,
23: p_customer_trx_id IN
24: ra_customer_trx.customer_trx_id%type);
25:
26: PROCEDURE update_p_print( p_trx_rec IN ra_customer_trx%rowtype,
27: p_customer_trx_id IN
28: ra_customer_trx.customer_trx_id%type);
29:
30: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
24: ra_customer_trx.customer_trx_id%type);
25:
26: PROCEDURE update_p_print( p_trx_rec IN ra_customer_trx%rowtype,
27: p_customer_trx_id IN
28: ra_customer_trx.customer_trx_id%type);
29:
30: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
31: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
32: p_trx_date IN ra_customer_trx.trx_date%type,
26: PROCEDURE update_p_print( p_trx_rec IN ra_customer_trx%rowtype,
27: p_customer_trx_id IN
28: ra_customer_trx.customer_trx_id%type);
29:
30: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
31: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
32: p_trx_date IN ra_customer_trx.trx_date%type,
33: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
34: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
27: p_customer_trx_id IN
28: ra_customer_trx.customer_trx_id%type);
29:
30: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
31: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
32: p_trx_date IN ra_customer_trx.trx_date%type,
33: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
34: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
35: P_TAX_AFFECT_FLAG in varchar2,
28: ra_customer_trx.customer_trx_id%type);
29:
30: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
31: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
32: p_trx_date IN ra_customer_trx.trx_date%type,
33: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
34: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
35: P_TAX_AFFECT_FLAG in varchar2,
36: p_enforce_nat_acc_flag IN BOOLEAN);
29:
30: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
31: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
32: p_trx_date IN ra_customer_trx.trx_date%type,
33: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
34: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
35: P_TAX_AFFECT_FLAG in varchar2,
36: p_enforce_nat_acc_flag IN BOOLEAN);
37:
30: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
31: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
32: p_trx_date IN ra_customer_trx.trx_date%type,
33: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
34: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
35: P_TAX_AFFECT_FLAG in varchar2,
36: p_enforce_nat_acc_flag IN BOOLEAN);
37:
38: PROCEDURE insert_p(
35: P_TAX_AFFECT_FLAG in varchar2,
36: p_enforce_nat_acc_flag IN BOOLEAN);
37:
38: PROCEDURE insert_p(
39: p_trx_rec IN ra_customer_trx%rowtype,
40: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
41: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
42: );
43:
36: p_enforce_nat_acc_flag IN BOOLEAN);
37:
38: PROCEDURE insert_p(
39: p_trx_rec IN ra_customer_trx%rowtype,
40: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
41: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
42: );
43:
44: PROCEDURE display_header_p(
37:
38: PROCEDURE insert_p(
39: p_trx_rec IN ra_customer_trx%rowtype,
40: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
41: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
42: );
43:
44: PROCEDURE display_header_p(
45: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
41: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
42: );
43:
44: PROCEDURE display_header_p(
45: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
46:
47: PROCEDURE display_header_rec ( p_trx_rec IN ra_customer_trx%rowtype );
48:
49: PROCEDURE lock_compare_frt_cover(
43:
44: PROCEDURE display_header_p(
45: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
46:
47: PROCEDURE display_header_rec ( p_trx_rec IN ra_customer_trx%rowtype );
48:
49: PROCEDURE lock_compare_frt_cover(
50: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
51: p_ship_via IN ra_customer_trx.ship_via%type,
46:
47: PROCEDURE display_header_rec ( p_trx_rec IN ra_customer_trx%rowtype );
48:
49: PROCEDURE lock_compare_frt_cover(
50: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
51: p_ship_via IN ra_customer_trx.ship_via%type,
52: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
53: p_waybill_number IN ra_customer_trx.waybill_number%type,
54: p_fob_point IN ra_customer_trx.fob_point%type);
47: PROCEDURE display_header_rec ( p_trx_rec IN ra_customer_trx%rowtype );
48:
49: PROCEDURE lock_compare_frt_cover(
50: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
51: p_ship_via IN ra_customer_trx.ship_via%type,
52: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
53: p_waybill_number IN ra_customer_trx.waybill_number%type,
54: p_fob_point IN ra_customer_trx.fob_point%type);
55:
48:
49: PROCEDURE lock_compare_frt_cover(
50: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
51: p_ship_via IN ra_customer_trx.ship_via%type,
52: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
53: p_waybill_number IN ra_customer_trx.waybill_number%type,
54: p_fob_point IN ra_customer_trx.fob_point%type);
55:
56: PROCEDURE lock_compare_cover(
49: PROCEDURE lock_compare_frt_cover(
50: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
51: p_ship_via IN ra_customer_trx.ship_via%type,
52: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
53: p_waybill_number IN ra_customer_trx.waybill_number%type,
54: p_fob_point IN ra_customer_trx.fob_point%type);
55:
56: PROCEDURE lock_compare_cover(
57: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
50: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
51: p_ship_via IN ra_customer_trx.ship_via%type,
52: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
53: p_waybill_number IN ra_customer_trx.waybill_number%type,
54: p_fob_point IN ra_customer_trx.fob_point%type);
55:
56: PROCEDURE lock_compare_cover(
57: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
58: p_trx_number IN ra_customer_trx.trx_number%type,
53: p_waybill_number IN ra_customer_trx.waybill_number%type,
54: p_fob_point IN ra_customer_trx.fob_point%type);
55:
56: PROCEDURE lock_compare_cover(
57: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
58: p_trx_number IN ra_customer_trx.trx_number%type,
59: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
60: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
61: p_complete_flag IN ra_customer_trx.complete_flag%type,
54: p_fob_point IN ra_customer_trx.fob_point%type);
55:
56: PROCEDURE lock_compare_cover(
57: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
58: p_trx_number IN ra_customer_trx.trx_number%type,
59: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
60: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
61: p_complete_flag IN ra_customer_trx.complete_flag%type,
62: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
55:
56: PROCEDURE lock_compare_cover(
57: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
58: p_trx_number IN ra_customer_trx.trx_number%type,
59: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
60: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
61: p_complete_flag IN ra_customer_trx.complete_flag%type,
62: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
63: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
56: PROCEDURE lock_compare_cover(
57: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
58: p_trx_number IN ra_customer_trx.trx_number%type,
59: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
60: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
61: p_complete_flag IN ra_customer_trx.complete_flag%type,
62: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
63: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
64: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
57: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
58: p_trx_number IN ra_customer_trx.trx_number%type,
59: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
60: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
61: p_complete_flag IN ra_customer_trx.complete_flag%type,
62: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
63: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
64: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
65: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
58: p_trx_number IN ra_customer_trx.trx_number%type,
59: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
60: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
61: p_complete_flag IN ra_customer_trx.complete_flag%type,
62: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
63: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
64: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
65: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
66: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
59: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
60: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
61: p_complete_flag IN ra_customer_trx.complete_flag%type,
62: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
63: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
64: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
65: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
66: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
67: p_batch_id IN ra_customer_trx.batch_id%type,
60: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
61: p_complete_flag IN ra_customer_trx.complete_flag%type,
62: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
63: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
64: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
65: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
66: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
67: p_batch_id IN ra_customer_trx.batch_id%type,
68: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
61: p_complete_flag IN ra_customer_trx.complete_flag%type,
62: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
63: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
64: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
65: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
66: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
67: p_batch_id IN ra_customer_trx.batch_id%type,
68: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
69: p_agreement_id IN ra_customer_trx.agreement_id%type,
62: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
63: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
64: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
65: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
66: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
67: p_batch_id IN ra_customer_trx.batch_id%type,
68: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
69: p_agreement_id IN ra_customer_trx.agreement_id%type,
70: p_trx_date IN ra_customer_trx.trx_date%type,
63: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
64: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
65: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
66: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
67: p_batch_id IN ra_customer_trx.batch_id%type,
68: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
69: p_agreement_id IN ra_customer_trx.agreement_id%type,
70: p_trx_date IN ra_customer_trx.trx_date%type,
71: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
64: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
65: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
66: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
67: p_batch_id IN ra_customer_trx.batch_id%type,
68: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
69: p_agreement_id IN ra_customer_trx.agreement_id%type,
70: p_trx_date IN ra_customer_trx.trx_date%type,
71: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
72: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
65: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
66: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
67: p_batch_id IN ra_customer_trx.batch_id%type,
68: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
69: p_agreement_id IN ra_customer_trx.agreement_id%type,
70: p_trx_date IN ra_customer_trx.trx_date%type,
71: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
72: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
73: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
66: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
67: p_batch_id IN ra_customer_trx.batch_id%type,
68: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
69: p_agreement_id IN ra_customer_trx.agreement_id%type,
70: p_trx_date IN ra_customer_trx.trx_date%type,
71: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
72: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
73: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
74: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
67: p_batch_id IN ra_customer_trx.batch_id%type,
68: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
69: p_agreement_id IN ra_customer_trx.agreement_id%type,
70: p_trx_date IN ra_customer_trx.trx_date%type,
71: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
72: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
73: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
74: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
75: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
68: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
69: p_agreement_id IN ra_customer_trx.agreement_id%type,
70: p_trx_date IN ra_customer_trx.trx_date%type,
71: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
72: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
73: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
74: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
75: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
76: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
69: p_agreement_id IN ra_customer_trx.agreement_id%type,
70: p_trx_date IN ra_customer_trx.trx_date%type,
71: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
72: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
73: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
74: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
75: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
76: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
77: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
70: p_trx_date IN ra_customer_trx.trx_date%type,
71: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
72: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
73: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
74: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
75: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
76: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
77: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
78: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
71: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
72: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
73: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
74: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
75: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
76: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
77: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
78: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
79: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
72: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
73: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
74: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
75: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
76: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
77: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
78: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
79: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
80: p_customer_reference IN ra_customer_trx.customer_reference%type,
73: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
74: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
75: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
76: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
77: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
78: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
79: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
80: p_customer_reference IN ra_customer_trx.customer_reference%type,
81: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
74: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
75: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
76: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
77: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
78: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
79: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
80: p_customer_reference IN ra_customer_trx.customer_reference%type,
81: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
82: p_cr_method_for_installments IN
75: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
76: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
77: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
78: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
79: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
80: p_customer_reference IN ra_customer_trx.customer_reference%type,
81: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
82: p_cr_method_for_installments IN
83: ra_customer_trx.credit_method_for_installments%type,
76: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
77: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
78: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
79: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
80: p_customer_reference IN ra_customer_trx.customer_reference%type,
81: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
82: p_cr_method_for_installments IN
83: ra_customer_trx.credit_method_for_installments%type,
84: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
77: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
78: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
79: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
80: p_customer_reference IN ra_customer_trx.customer_reference%type,
81: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
82: p_cr_method_for_installments IN
83: ra_customer_trx.credit_method_for_installments%type,
84: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
85: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
79: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
80: p_customer_reference IN ra_customer_trx.customer_reference%type,
81: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
82: p_cr_method_for_installments IN
83: ra_customer_trx.credit_method_for_installments%type,
84: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
85: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
86: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
87: p_exchange_date IN ra_customer_trx.exchange_date%type,
80: p_customer_reference IN ra_customer_trx.customer_reference%type,
81: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
82: p_cr_method_for_installments IN
83: ra_customer_trx.credit_method_for_installments%type,
84: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
85: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
86: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
87: p_exchange_date IN ra_customer_trx.exchange_date%type,
88: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
81: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
82: p_cr_method_for_installments IN
83: ra_customer_trx.credit_method_for_installments%type,
84: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
85: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
86: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
87: p_exchange_date IN ra_customer_trx.exchange_date%type,
88: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
89: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
82: p_cr_method_for_installments IN
83: ra_customer_trx.credit_method_for_installments%type,
84: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
85: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
86: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
87: p_exchange_date IN ra_customer_trx.exchange_date%type,
88: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
89: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
90: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
83: ra_customer_trx.credit_method_for_installments%type,
84: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
85: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
86: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
87: p_exchange_date IN ra_customer_trx.exchange_date%type,
88: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
89: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
90: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
91: p_finance_charges IN ra_customer_trx.finance_charges%type,
84: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
85: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
86: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
87: p_exchange_date IN ra_customer_trx.exchange_date%type,
88: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
89: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
90: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
91: p_finance_charges IN ra_customer_trx.finance_charges%type,
92: p_fob_point IN ra_customer_trx.fob_point%type,
85: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
86: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
87: p_exchange_date IN ra_customer_trx.exchange_date%type,
88: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
89: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
90: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
91: p_finance_charges IN ra_customer_trx.finance_charges%type,
92: p_fob_point IN ra_customer_trx.fob_point%type,
93: p_comments IN ra_customer_trx.comments%type,
86: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
87: p_exchange_date IN ra_customer_trx.exchange_date%type,
88: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
89: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
90: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
91: p_finance_charges IN ra_customer_trx.finance_charges%type,
92: p_fob_point IN ra_customer_trx.fob_point%type,
93: p_comments IN ra_customer_trx.comments%type,
94: p_internal_notes IN ra_customer_trx.internal_notes%type,
87: p_exchange_date IN ra_customer_trx.exchange_date%type,
88: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
89: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
90: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
91: p_finance_charges IN ra_customer_trx.finance_charges%type,
92: p_fob_point IN ra_customer_trx.fob_point%type,
93: p_comments IN ra_customer_trx.comments%type,
94: p_internal_notes IN ra_customer_trx.internal_notes%type,
95: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
88: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
89: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
90: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
91: p_finance_charges IN ra_customer_trx.finance_charges%type,
92: p_fob_point IN ra_customer_trx.fob_point%type,
93: p_comments IN ra_customer_trx.comments%type,
94: p_internal_notes IN ra_customer_trx.internal_notes%type,
95: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
96: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
89: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
90: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
91: p_finance_charges IN ra_customer_trx.finance_charges%type,
92: p_fob_point IN ra_customer_trx.fob_point%type,
93: p_comments IN ra_customer_trx.comments%type,
94: p_internal_notes IN ra_customer_trx.internal_notes%type,
95: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
96: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
97: p_last_printed_sequence_num IN
90: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
91: p_finance_charges IN ra_customer_trx.finance_charges%type,
92: p_fob_point IN ra_customer_trx.fob_point%type,
93: p_comments IN ra_customer_trx.comments%type,
94: p_internal_notes IN ra_customer_trx.internal_notes%type,
95: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
96: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
97: p_last_printed_sequence_num IN
98: ra_customer_trx.last_printed_sequence_num%type,
91: p_finance_charges IN ra_customer_trx.finance_charges%type,
92: p_fob_point IN ra_customer_trx.fob_point%type,
93: p_comments IN ra_customer_trx.comments%type,
94: p_internal_notes IN ra_customer_trx.internal_notes%type,
95: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
96: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
97: p_last_printed_sequence_num IN
98: ra_customer_trx.last_printed_sequence_num%type,
99: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
92: p_fob_point IN ra_customer_trx.fob_point%type,
93: p_comments IN ra_customer_trx.comments%type,
94: p_internal_notes IN ra_customer_trx.internal_notes%type,
95: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
96: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
97: p_last_printed_sequence_num IN
98: ra_customer_trx.last_printed_sequence_num%type,
99: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
100: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
94: p_internal_notes IN ra_customer_trx.internal_notes%type,
95: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
96: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
97: p_last_printed_sequence_num IN
98: ra_customer_trx.last_printed_sequence_num%type,
99: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
100: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
101: p_printing_count IN ra_customer_trx.printing_count%type,
102: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
95: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
96: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
97: p_last_printed_sequence_num IN
98: ra_customer_trx.last_printed_sequence_num%type,
99: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
100: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
101: p_printing_count IN ra_customer_trx.printing_count%type,
102: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
103: p_printing_option IN ra_customer_trx.printing_option%type,
96: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
97: p_last_printed_sequence_num IN
98: ra_customer_trx.last_printed_sequence_num%type,
99: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
100: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
101: p_printing_count IN ra_customer_trx.printing_count%type,
102: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
103: p_printing_option IN ra_customer_trx.printing_option%type,
104: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
97: p_last_printed_sequence_num IN
98: ra_customer_trx.last_printed_sequence_num%type,
99: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
100: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
101: p_printing_count IN ra_customer_trx.printing_count%type,
102: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
103: p_printing_option IN ra_customer_trx.printing_option%type,
104: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
105: p_printing_pending IN ra_customer_trx.printing_pending%type,
98: ra_customer_trx.last_printed_sequence_num%type,
99: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
100: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
101: p_printing_count IN ra_customer_trx.printing_count%type,
102: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
103: p_printing_option IN ra_customer_trx.printing_option%type,
104: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
105: p_printing_pending IN ra_customer_trx.printing_pending%type,
106: p_purchase_order IN ra_customer_trx.purchase_order%type,
99: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
100: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
101: p_printing_count IN ra_customer_trx.printing_count%type,
102: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
103: p_printing_option IN ra_customer_trx.printing_option%type,
104: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
105: p_printing_pending IN ra_customer_trx.printing_pending%type,
106: p_purchase_order IN ra_customer_trx.purchase_order%type,
107: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
100: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
101: p_printing_count IN ra_customer_trx.printing_count%type,
102: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
103: p_printing_option IN ra_customer_trx.printing_option%type,
104: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
105: p_printing_pending IN ra_customer_trx.printing_pending%type,
106: p_purchase_order IN ra_customer_trx.purchase_order%type,
107: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
108: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
101: p_printing_count IN ra_customer_trx.printing_count%type,
102: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
103: p_printing_option IN ra_customer_trx.printing_option%type,
104: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
105: p_printing_pending IN ra_customer_trx.printing_pending%type,
106: p_purchase_order IN ra_customer_trx.purchase_order%type,
107: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
108: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
109: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
102: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
103: p_printing_option IN ra_customer_trx.printing_option%type,
104: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
105: p_printing_pending IN ra_customer_trx.printing_pending%type,
106: p_purchase_order IN ra_customer_trx.purchase_order%type,
107: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
108: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
109: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
110: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
103: p_printing_option IN ra_customer_trx.printing_option%type,
104: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
105: p_printing_pending IN ra_customer_trx.printing_pending%type,
106: p_purchase_order IN ra_customer_trx.purchase_order%type,
107: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
108: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
109: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
110: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
111: p_shipment_id IN ra_customer_trx.shipment_id%type,
104: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
105: p_printing_pending IN ra_customer_trx.printing_pending%type,
106: p_purchase_order IN ra_customer_trx.purchase_order%type,
107: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
108: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
109: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
110: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
111: p_shipment_id IN ra_customer_trx.shipment_id%type,
112: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
105: p_printing_pending IN ra_customer_trx.printing_pending%type,
106: p_purchase_order IN ra_customer_trx.purchase_order%type,
107: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
108: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
109: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
110: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
111: p_shipment_id IN ra_customer_trx.shipment_id%type,
112: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
113: p_ship_via IN ra_customer_trx.ship_via%type,
106: p_purchase_order IN ra_customer_trx.purchase_order%type,
107: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
108: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
109: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
110: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
111: p_shipment_id IN ra_customer_trx.shipment_id%type,
112: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
113: p_ship_via IN ra_customer_trx.ship_via%type,
114: p_term_due_date IN ra_customer_trx.term_due_date%type,
107: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
108: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
109: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
110: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
111: p_shipment_id IN ra_customer_trx.shipment_id%type,
112: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
113: p_ship_via IN ra_customer_trx.ship_via%type,
114: p_term_due_date IN ra_customer_trx.term_due_date%type,
115: p_term_id IN ra_customer_trx.term_id%type,
108: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
109: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
110: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
111: p_shipment_id IN ra_customer_trx.shipment_id%type,
112: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
113: p_ship_via IN ra_customer_trx.ship_via%type,
114: p_term_due_date IN ra_customer_trx.term_due_date%type,
115: p_term_id IN ra_customer_trx.term_id%type,
116: p_territory_id IN ra_customer_trx.territory_id%type,
109: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
110: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
111: p_shipment_id IN ra_customer_trx.shipment_id%type,
112: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
113: p_ship_via IN ra_customer_trx.ship_via%type,
114: p_term_due_date IN ra_customer_trx.term_due_date%type,
115: p_term_id IN ra_customer_trx.term_id%type,
116: p_territory_id IN ra_customer_trx.territory_id%type,
117: p_waybill_number IN ra_customer_trx.waybill_number%type,
110: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
111: p_shipment_id IN ra_customer_trx.shipment_id%type,
112: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
113: p_ship_via IN ra_customer_trx.ship_via%type,
114: p_term_due_date IN ra_customer_trx.term_due_date%type,
115: p_term_id IN ra_customer_trx.term_id%type,
116: p_territory_id IN ra_customer_trx.territory_id%type,
117: p_waybill_number IN ra_customer_trx.waybill_number%type,
118: p_status_trx IN ra_customer_trx.status_trx%type,
111: p_shipment_id IN ra_customer_trx.shipment_id%type,
112: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
113: p_ship_via IN ra_customer_trx.ship_via%type,
114: p_term_due_date IN ra_customer_trx.term_due_date%type,
115: p_term_id IN ra_customer_trx.term_id%type,
116: p_territory_id IN ra_customer_trx.territory_id%type,
117: p_waybill_number IN ra_customer_trx.waybill_number%type,
118: p_status_trx IN ra_customer_trx.status_trx%type,
119: p_reason_code IN ra_customer_trx.reason_code%type,
112: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
113: p_ship_via IN ra_customer_trx.ship_via%type,
114: p_term_due_date IN ra_customer_trx.term_due_date%type,
115: p_term_id IN ra_customer_trx.term_id%type,
116: p_territory_id IN ra_customer_trx.territory_id%type,
117: p_waybill_number IN ra_customer_trx.waybill_number%type,
118: p_status_trx IN ra_customer_trx.status_trx%type,
119: p_reason_code IN ra_customer_trx.reason_code%type,
120: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
113: p_ship_via IN ra_customer_trx.ship_via%type,
114: p_term_due_date IN ra_customer_trx.term_due_date%type,
115: p_term_id IN ra_customer_trx.term_id%type,
116: p_territory_id IN ra_customer_trx.territory_id%type,
117: p_waybill_number IN ra_customer_trx.waybill_number%type,
118: p_status_trx IN ra_customer_trx.status_trx%type,
119: p_reason_code IN ra_customer_trx.reason_code%type,
120: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
121: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
114: p_term_due_date IN ra_customer_trx.term_due_date%type,
115: p_term_id IN ra_customer_trx.term_id%type,
116: p_territory_id IN ra_customer_trx.territory_id%type,
117: p_waybill_number IN ra_customer_trx.waybill_number%type,
118: p_status_trx IN ra_customer_trx.status_trx%type,
119: p_reason_code IN ra_customer_trx.reason_code%type,
120: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
121: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
122: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
115: p_term_id IN ra_customer_trx.term_id%type,
116: p_territory_id IN ra_customer_trx.territory_id%type,
117: p_waybill_number IN ra_customer_trx.waybill_number%type,
118: p_status_trx IN ra_customer_trx.status_trx%type,
119: p_reason_code IN ra_customer_trx.reason_code%type,
120: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
121: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
122: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
123: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
116: p_territory_id IN ra_customer_trx.territory_id%type,
117: p_waybill_number IN ra_customer_trx.waybill_number%type,
118: p_status_trx IN ra_customer_trx.status_trx%type,
119: p_reason_code IN ra_customer_trx.reason_code%type,
120: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
121: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
122: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
123: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
124: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
117: p_waybill_number IN ra_customer_trx.waybill_number%type,
118: p_status_trx IN ra_customer_trx.status_trx%type,
119: p_reason_code IN ra_customer_trx.reason_code%type,
120: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
121: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
122: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
123: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
124: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
125: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
118: p_status_trx IN ra_customer_trx.status_trx%type,
119: p_reason_code IN ra_customer_trx.reason_code%type,
120: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
121: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
122: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
123: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
124: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
125: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
126: p_created_from IN ra_customer_trx.created_from%type,
119: p_reason_code IN ra_customer_trx.reason_code%type,
120: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
121: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
122: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
123: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
124: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
125: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
126: p_created_from IN ra_customer_trx.created_from%type,
127: p_deflt_ussgl_trx_code_context IN
120: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
121: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
122: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
123: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
124: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
125: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
126: p_created_from IN ra_customer_trx.created_from%type,
127: p_deflt_ussgl_trx_code_context IN
128: ra_customer_trx.default_ussgl_trx_code_context%type,
121: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
122: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
123: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
124: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
125: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
126: p_created_from IN ra_customer_trx.created_from%type,
127: p_deflt_ussgl_trx_code_context IN
128: ra_customer_trx.default_ussgl_trx_code_context%type,
129: p_deflt_ussgl_transaction_code IN
122: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
123: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
124: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
125: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
126: p_created_from IN ra_customer_trx.created_from%type,
127: p_deflt_ussgl_trx_code_context IN
128: ra_customer_trx.default_ussgl_trx_code_context%type,
129: p_deflt_ussgl_transaction_code IN
130: ra_customer_trx.default_ussgl_transaction_code%type,
124: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
125: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
126: p_created_from IN ra_customer_trx.created_from%type,
127: p_deflt_ussgl_trx_code_context IN
128: ra_customer_trx.default_ussgl_trx_code_context%type,
129: p_deflt_ussgl_transaction_code IN
130: ra_customer_trx.default_ussgl_transaction_code%type,
131: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
132: p_interface_header_context IN
126: p_created_from IN ra_customer_trx.created_from%type,
127: p_deflt_ussgl_trx_code_context IN
128: ra_customer_trx.default_ussgl_trx_code_context%type,
129: p_deflt_ussgl_transaction_code IN
130: ra_customer_trx.default_ussgl_transaction_code%type,
131: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
132: p_interface_header_context IN
133: ra_customer_trx.interface_header_context%type,
134: p_interface_header_attribute1 IN
127: p_deflt_ussgl_trx_code_context IN
128: ra_customer_trx.default_ussgl_trx_code_context%type,
129: p_deflt_ussgl_transaction_code IN
130: ra_customer_trx.default_ussgl_transaction_code%type,
131: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
132: p_interface_header_context IN
133: ra_customer_trx.interface_header_context%type,
134: p_interface_header_attribute1 IN
135: ra_customer_trx.interface_header_attribute1%type,
129: p_deflt_ussgl_transaction_code IN
130: ra_customer_trx.default_ussgl_transaction_code%type,
131: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
132: p_interface_header_context IN
133: ra_customer_trx.interface_header_context%type,
134: p_interface_header_attribute1 IN
135: ra_customer_trx.interface_header_attribute1%type,
136: p_interface_header_attribute2 IN
137: ra_customer_trx.interface_header_attribute2%type,
131: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
132: p_interface_header_context IN
133: ra_customer_trx.interface_header_context%type,
134: p_interface_header_attribute1 IN
135: ra_customer_trx.interface_header_attribute1%type,
136: p_interface_header_attribute2 IN
137: ra_customer_trx.interface_header_attribute2%type,
138: p_interface_header_attribute3 IN
139: ra_customer_trx.interface_header_attribute3%type,
133: ra_customer_trx.interface_header_context%type,
134: p_interface_header_attribute1 IN
135: ra_customer_trx.interface_header_attribute1%type,
136: p_interface_header_attribute2 IN
137: ra_customer_trx.interface_header_attribute2%type,
138: p_interface_header_attribute3 IN
139: ra_customer_trx.interface_header_attribute3%type,
140: p_interface_header_attribute4 IN
141: ra_customer_trx.interface_header_attribute4%type,
135: ra_customer_trx.interface_header_attribute1%type,
136: p_interface_header_attribute2 IN
137: ra_customer_trx.interface_header_attribute2%type,
138: p_interface_header_attribute3 IN
139: ra_customer_trx.interface_header_attribute3%type,
140: p_interface_header_attribute4 IN
141: ra_customer_trx.interface_header_attribute4%type,
142: p_interface_header_attribute5 IN
143: ra_customer_trx.interface_header_attribute5%type,
137: ra_customer_trx.interface_header_attribute2%type,
138: p_interface_header_attribute3 IN
139: ra_customer_trx.interface_header_attribute3%type,
140: p_interface_header_attribute4 IN
141: ra_customer_trx.interface_header_attribute4%type,
142: p_interface_header_attribute5 IN
143: ra_customer_trx.interface_header_attribute5%type,
144: p_interface_header_attribute6 IN
145: ra_customer_trx.interface_header_attribute6%type,
139: ra_customer_trx.interface_header_attribute3%type,
140: p_interface_header_attribute4 IN
141: ra_customer_trx.interface_header_attribute4%type,
142: p_interface_header_attribute5 IN
143: ra_customer_trx.interface_header_attribute5%type,
144: p_interface_header_attribute6 IN
145: ra_customer_trx.interface_header_attribute6%type,
146: p_interface_header_attribute7 IN
147: ra_customer_trx.interface_header_attribute7%type,
141: ra_customer_trx.interface_header_attribute4%type,
142: p_interface_header_attribute5 IN
143: ra_customer_trx.interface_header_attribute5%type,
144: p_interface_header_attribute6 IN
145: ra_customer_trx.interface_header_attribute6%type,
146: p_interface_header_attribute7 IN
147: ra_customer_trx.interface_header_attribute7%type,
148: p_interface_header_attribute8 IN
149: ra_customer_trx.interface_header_attribute8%type,
143: ra_customer_trx.interface_header_attribute5%type,
144: p_interface_header_attribute6 IN
145: ra_customer_trx.interface_header_attribute6%type,
146: p_interface_header_attribute7 IN
147: ra_customer_trx.interface_header_attribute7%type,
148: p_interface_header_attribute8 IN
149: ra_customer_trx.interface_header_attribute8%type,
150: p_interface_header_attribute9 IN
151: ra_customer_trx.interface_header_attribute9%type,
145: ra_customer_trx.interface_header_attribute6%type,
146: p_interface_header_attribute7 IN
147: ra_customer_trx.interface_header_attribute7%type,
148: p_interface_header_attribute8 IN
149: ra_customer_trx.interface_header_attribute8%type,
150: p_interface_header_attribute9 IN
151: ra_customer_trx.interface_header_attribute9%type,
152: p_interface_header_attribute10 IN
153: ra_customer_trx.interface_header_attribute10%type,
147: ra_customer_trx.interface_header_attribute7%type,
148: p_interface_header_attribute8 IN
149: ra_customer_trx.interface_header_attribute8%type,
150: p_interface_header_attribute9 IN
151: ra_customer_trx.interface_header_attribute9%type,
152: p_interface_header_attribute10 IN
153: ra_customer_trx.interface_header_attribute10%type,
154: p_interface_header_attribute11 IN
155: ra_customer_trx.interface_header_attribute11%type,
149: ra_customer_trx.interface_header_attribute8%type,
150: p_interface_header_attribute9 IN
151: ra_customer_trx.interface_header_attribute9%type,
152: p_interface_header_attribute10 IN
153: ra_customer_trx.interface_header_attribute10%type,
154: p_interface_header_attribute11 IN
155: ra_customer_trx.interface_header_attribute11%type,
156: p_interface_header_attribute12 IN
157: ra_customer_trx.interface_header_attribute12%type,
151: ra_customer_trx.interface_header_attribute9%type,
152: p_interface_header_attribute10 IN
153: ra_customer_trx.interface_header_attribute10%type,
154: p_interface_header_attribute11 IN
155: ra_customer_trx.interface_header_attribute11%type,
156: p_interface_header_attribute12 IN
157: ra_customer_trx.interface_header_attribute12%type,
158: p_interface_header_attribute13 IN
159: ra_customer_trx.interface_header_attribute13%type,
153: ra_customer_trx.interface_header_attribute10%type,
154: p_interface_header_attribute11 IN
155: ra_customer_trx.interface_header_attribute11%type,
156: p_interface_header_attribute12 IN
157: ra_customer_trx.interface_header_attribute12%type,
158: p_interface_header_attribute13 IN
159: ra_customer_trx.interface_header_attribute13%type,
160: p_interface_header_attribute14 IN
161: ra_customer_trx.interface_header_attribute14%type,
155: ra_customer_trx.interface_header_attribute11%type,
156: p_interface_header_attribute12 IN
157: ra_customer_trx.interface_header_attribute12%type,
158: p_interface_header_attribute13 IN
159: ra_customer_trx.interface_header_attribute13%type,
160: p_interface_header_attribute14 IN
161: ra_customer_trx.interface_header_attribute14%type,
162: p_interface_header_attribute15 IN
163: ra_customer_trx.interface_header_attribute15%type,
157: ra_customer_trx.interface_header_attribute12%type,
158: p_interface_header_attribute13 IN
159: ra_customer_trx.interface_header_attribute13%type,
160: p_interface_header_attribute14 IN
161: ra_customer_trx.interface_header_attribute14%type,
162: p_interface_header_attribute15 IN
163: ra_customer_trx.interface_header_attribute15%type,
164: p_attribute_category IN ra_customer_trx.attribute_category%type,
165: p_attribute1 IN ra_customer_trx.attribute1%type,
159: ra_customer_trx.interface_header_attribute13%type,
160: p_interface_header_attribute14 IN
161: ra_customer_trx.interface_header_attribute14%type,
162: p_interface_header_attribute15 IN
163: ra_customer_trx.interface_header_attribute15%type,
164: p_attribute_category IN ra_customer_trx.attribute_category%type,
165: p_attribute1 IN ra_customer_trx.attribute1%type,
166: p_attribute2 IN ra_customer_trx.attribute2%type,
167: p_attribute3 IN ra_customer_trx.attribute3%type,
160: p_interface_header_attribute14 IN
161: ra_customer_trx.interface_header_attribute14%type,
162: p_interface_header_attribute15 IN
163: ra_customer_trx.interface_header_attribute15%type,
164: p_attribute_category IN ra_customer_trx.attribute_category%type,
165: p_attribute1 IN ra_customer_trx.attribute1%type,
166: p_attribute2 IN ra_customer_trx.attribute2%type,
167: p_attribute3 IN ra_customer_trx.attribute3%type,
168: p_attribute4 IN ra_customer_trx.attribute4%type,
161: ra_customer_trx.interface_header_attribute14%type,
162: p_interface_header_attribute15 IN
163: ra_customer_trx.interface_header_attribute15%type,
164: p_attribute_category IN ra_customer_trx.attribute_category%type,
165: p_attribute1 IN ra_customer_trx.attribute1%type,
166: p_attribute2 IN ra_customer_trx.attribute2%type,
167: p_attribute3 IN ra_customer_trx.attribute3%type,
168: p_attribute4 IN ra_customer_trx.attribute4%type,
169: p_attribute5 IN ra_customer_trx.attribute5%type,
162: p_interface_header_attribute15 IN
163: ra_customer_trx.interface_header_attribute15%type,
164: p_attribute_category IN ra_customer_trx.attribute_category%type,
165: p_attribute1 IN ra_customer_trx.attribute1%type,
166: p_attribute2 IN ra_customer_trx.attribute2%type,
167: p_attribute3 IN ra_customer_trx.attribute3%type,
168: p_attribute4 IN ra_customer_trx.attribute4%type,
169: p_attribute5 IN ra_customer_trx.attribute5%type,
170: p_attribute6 IN ra_customer_trx.attribute6%type,
163: ra_customer_trx.interface_header_attribute15%type,
164: p_attribute_category IN ra_customer_trx.attribute_category%type,
165: p_attribute1 IN ra_customer_trx.attribute1%type,
166: p_attribute2 IN ra_customer_trx.attribute2%type,
167: p_attribute3 IN ra_customer_trx.attribute3%type,
168: p_attribute4 IN ra_customer_trx.attribute4%type,
169: p_attribute5 IN ra_customer_trx.attribute5%type,
170: p_attribute6 IN ra_customer_trx.attribute6%type,
171: p_attribute7 IN ra_customer_trx.attribute7%type,
164: p_attribute_category IN ra_customer_trx.attribute_category%type,
165: p_attribute1 IN ra_customer_trx.attribute1%type,
166: p_attribute2 IN ra_customer_trx.attribute2%type,
167: p_attribute3 IN ra_customer_trx.attribute3%type,
168: p_attribute4 IN ra_customer_trx.attribute4%type,
169: p_attribute5 IN ra_customer_trx.attribute5%type,
170: p_attribute6 IN ra_customer_trx.attribute6%type,
171: p_attribute7 IN ra_customer_trx.attribute7%type,
172: p_attribute8 IN ra_customer_trx.attribute8%type,
165: p_attribute1 IN ra_customer_trx.attribute1%type,
166: p_attribute2 IN ra_customer_trx.attribute2%type,
167: p_attribute3 IN ra_customer_trx.attribute3%type,
168: p_attribute4 IN ra_customer_trx.attribute4%type,
169: p_attribute5 IN ra_customer_trx.attribute5%type,
170: p_attribute6 IN ra_customer_trx.attribute6%type,
171: p_attribute7 IN ra_customer_trx.attribute7%type,
172: p_attribute8 IN ra_customer_trx.attribute8%type,
173: p_attribute9 IN ra_customer_trx.attribute9%type,
166: p_attribute2 IN ra_customer_trx.attribute2%type,
167: p_attribute3 IN ra_customer_trx.attribute3%type,
168: p_attribute4 IN ra_customer_trx.attribute4%type,
169: p_attribute5 IN ra_customer_trx.attribute5%type,
170: p_attribute6 IN ra_customer_trx.attribute6%type,
171: p_attribute7 IN ra_customer_trx.attribute7%type,
172: p_attribute8 IN ra_customer_trx.attribute8%type,
173: p_attribute9 IN ra_customer_trx.attribute9%type,
174: p_attribute10 IN ra_customer_trx.attribute10%type,
167: p_attribute3 IN ra_customer_trx.attribute3%type,
168: p_attribute4 IN ra_customer_trx.attribute4%type,
169: p_attribute5 IN ra_customer_trx.attribute5%type,
170: p_attribute6 IN ra_customer_trx.attribute6%type,
171: p_attribute7 IN ra_customer_trx.attribute7%type,
172: p_attribute8 IN ra_customer_trx.attribute8%type,
173: p_attribute9 IN ra_customer_trx.attribute9%type,
174: p_attribute10 IN ra_customer_trx.attribute10%type,
175: p_attribute11 IN ra_customer_trx.attribute11%type,
168: p_attribute4 IN ra_customer_trx.attribute4%type,
169: p_attribute5 IN ra_customer_trx.attribute5%type,
170: p_attribute6 IN ra_customer_trx.attribute6%type,
171: p_attribute7 IN ra_customer_trx.attribute7%type,
172: p_attribute8 IN ra_customer_trx.attribute8%type,
173: p_attribute9 IN ra_customer_trx.attribute9%type,
174: p_attribute10 IN ra_customer_trx.attribute10%type,
175: p_attribute11 IN ra_customer_trx.attribute11%type,
176: p_attribute12 IN ra_customer_trx.attribute12%type,
169: p_attribute5 IN ra_customer_trx.attribute5%type,
170: p_attribute6 IN ra_customer_trx.attribute6%type,
171: p_attribute7 IN ra_customer_trx.attribute7%type,
172: p_attribute8 IN ra_customer_trx.attribute8%type,
173: p_attribute9 IN ra_customer_trx.attribute9%type,
174: p_attribute10 IN ra_customer_trx.attribute10%type,
175: p_attribute11 IN ra_customer_trx.attribute11%type,
176: p_attribute12 IN ra_customer_trx.attribute12%type,
177: p_attribute13 IN ra_customer_trx.attribute13%type,
170: p_attribute6 IN ra_customer_trx.attribute6%type,
171: p_attribute7 IN ra_customer_trx.attribute7%type,
172: p_attribute8 IN ra_customer_trx.attribute8%type,
173: p_attribute9 IN ra_customer_trx.attribute9%type,
174: p_attribute10 IN ra_customer_trx.attribute10%type,
175: p_attribute11 IN ra_customer_trx.attribute11%type,
176: p_attribute12 IN ra_customer_trx.attribute12%type,
177: p_attribute13 IN ra_customer_trx.attribute13%type,
178: p_attribute14 IN ra_customer_trx.attribute14%type,
171: p_attribute7 IN ra_customer_trx.attribute7%type,
172: p_attribute8 IN ra_customer_trx.attribute8%type,
173: p_attribute9 IN ra_customer_trx.attribute9%type,
174: p_attribute10 IN ra_customer_trx.attribute10%type,
175: p_attribute11 IN ra_customer_trx.attribute11%type,
176: p_attribute12 IN ra_customer_trx.attribute12%type,
177: p_attribute13 IN ra_customer_trx.attribute13%type,
178: p_attribute14 IN ra_customer_trx.attribute14%type,
179: p_attribute15 IN ra_customer_trx.attribute15%type,
172: p_attribute8 IN ra_customer_trx.attribute8%type,
173: p_attribute9 IN ra_customer_trx.attribute9%type,
174: p_attribute10 IN ra_customer_trx.attribute10%type,
175: p_attribute11 IN ra_customer_trx.attribute11%type,
176: p_attribute12 IN ra_customer_trx.attribute12%type,
177: p_attribute13 IN ra_customer_trx.attribute13%type,
178: p_attribute14 IN ra_customer_trx.attribute14%type,
179: p_attribute15 IN ra_customer_trx.attribute15%type,
180: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
173: p_attribute9 IN ra_customer_trx.attribute9%type,
174: p_attribute10 IN ra_customer_trx.attribute10%type,
175: p_attribute11 IN ra_customer_trx.attribute11%type,
176: p_attribute12 IN ra_customer_trx.attribute12%type,
177: p_attribute13 IN ra_customer_trx.attribute13%type,
178: p_attribute14 IN ra_customer_trx.attribute14%type,
179: p_attribute15 IN ra_customer_trx.attribute15%type,
180: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
181: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
174: p_attribute10 IN ra_customer_trx.attribute10%type,
175: p_attribute11 IN ra_customer_trx.attribute11%type,
176: p_attribute12 IN ra_customer_trx.attribute12%type,
177: p_attribute13 IN ra_customer_trx.attribute13%type,
178: p_attribute14 IN ra_customer_trx.attribute14%type,
179: p_attribute15 IN ra_customer_trx.attribute15%type,
180: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
181: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
182: p_billing_date IN ra_customer_trx.billing_date%type,
175: p_attribute11 IN ra_customer_trx.attribute11%type,
176: p_attribute12 IN ra_customer_trx.attribute12%type,
177: p_attribute13 IN ra_customer_trx.attribute13%type,
178: p_attribute14 IN ra_customer_trx.attribute14%type,
179: p_attribute15 IN ra_customer_trx.attribute15%type,
180: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
181: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
182: p_billing_date IN ra_customer_trx.billing_date%type,
183: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE);
176: p_attribute12 IN ra_customer_trx.attribute12%type,
177: p_attribute13 IN ra_customer_trx.attribute13%type,
178: p_attribute14 IN ra_customer_trx.attribute14%type,
179: p_attribute15 IN ra_customer_trx.attribute15%type,
180: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
181: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
182: p_billing_date IN ra_customer_trx.billing_date%type,
183: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE);
184:
177: p_attribute13 IN ra_customer_trx.attribute13%type,
178: p_attribute14 IN ra_customer_trx.attribute14%type,
179: p_attribute15 IN ra_customer_trx.attribute15%type,
180: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
181: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
182: p_billing_date IN ra_customer_trx.billing_date%type,
183: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE);
184:
185:
178: p_attribute14 IN ra_customer_trx.attribute14%type,
179: p_attribute15 IN ra_customer_trx.attribute15%type,
180: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
181: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
182: p_billing_date IN ra_customer_trx.billing_date%type,
183: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE);
184:
185:
186: PROCEDURE lock_compare_cover(
183: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE);
184:
185:
186: PROCEDURE lock_compare_cover(
187: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
188: p_trx_number IN ra_customer_trx.trx_number%type,
189: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
190: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
191: p_complete_flag IN ra_customer_trx.complete_flag%type,
184:
185:
186: PROCEDURE lock_compare_cover(
187: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
188: p_trx_number IN ra_customer_trx.trx_number%type,
189: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
190: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
191: p_complete_flag IN ra_customer_trx.complete_flag%type,
192: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
185:
186: PROCEDURE lock_compare_cover(
187: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
188: p_trx_number IN ra_customer_trx.trx_number%type,
189: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
190: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
191: p_complete_flag IN ra_customer_trx.complete_flag%type,
192: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
193: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
186: PROCEDURE lock_compare_cover(
187: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
188: p_trx_number IN ra_customer_trx.trx_number%type,
189: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
190: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
191: p_complete_flag IN ra_customer_trx.complete_flag%type,
192: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
193: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
194: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
187: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
188: p_trx_number IN ra_customer_trx.trx_number%type,
189: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
190: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
191: p_complete_flag IN ra_customer_trx.complete_flag%type,
192: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
193: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
194: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
195: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
188: p_trx_number IN ra_customer_trx.trx_number%type,
189: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
190: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
191: p_complete_flag IN ra_customer_trx.complete_flag%type,
192: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
193: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
194: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
195: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
196: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
189: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
190: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
191: p_complete_flag IN ra_customer_trx.complete_flag%type,
192: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
193: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
194: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
195: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
196: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
197: p_batch_id IN ra_customer_trx.batch_id%type,
190: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
191: p_complete_flag IN ra_customer_trx.complete_flag%type,
192: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
193: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
194: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
195: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
196: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
197: p_batch_id IN ra_customer_trx.batch_id%type,
198: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
191: p_complete_flag IN ra_customer_trx.complete_flag%type,
192: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
193: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
194: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
195: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
196: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
197: p_batch_id IN ra_customer_trx.batch_id%type,
198: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
199: p_agreement_id IN ra_customer_trx.agreement_id%type,
192: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
193: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
194: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
195: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
196: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
197: p_batch_id IN ra_customer_trx.batch_id%type,
198: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
199: p_agreement_id IN ra_customer_trx.agreement_id%type,
200: p_trx_date IN ra_customer_trx.trx_date%type,
193: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
194: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
195: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
196: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
197: p_batch_id IN ra_customer_trx.batch_id%type,
198: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
199: p_agreement_id IN ra_customer_trx.agreement_id%type,
200: p_trx_date IN ra_customer_trx.trx_date%type,
201: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
194: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
195: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
196: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
197: p_batch_id IN ra_customer_trx.batch_id%type,
198: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
199: p_agreement_id IN ra_customer_trx.agreement_id%type,
200: p_trx_date IN ra_customer_trx.trx_date%type,
201: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
202: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
195: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
196: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
197: p_batch_id IN ra_customer_trx.batch_id%type,
198: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
199: p_agreement_id IN ra_customer_trx.agreement_id%type,
200: p_trx_date IN ra_customer_trx.trx_date%type,
201: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
202: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
203: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
196: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
197: p_batch_id IN ra_customer_trx.batch_id%type,
198: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
199: p_agreement_id IN ra_customer_trx.agreement_id%type,
200: p_trx_date IN ra_customer_trx.trx_date%type,
201: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
202: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
203: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
204: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
197: p_batch_id IN ra_customer_trx.batch_id%type,
198: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
199: p_agreement_id IN ra_customer_trx.agreement_id%type,
200: p_trx_date IN ra_customer_trx.trx_date%type,
201: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
202: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
203: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
204: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
205: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
198: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
199: p_agreement_id IN ra_customer_trx.agreement_id%type,
200: p_trx_date IN ra_customer_trx.trx_date%type,
201: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
202: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
203: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
204: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
205: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
206: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
199: p_agreement_id IN ra_customer_trx.agreement_id%type,
200: p_trx_date IN ra_customer_trx.trx_date%type,
201: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
202: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
203: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
204: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
205: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
206: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
207: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
200: p_trx_date IN ra_customer_trx.trx_date%type,
201: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
202: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
203: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
204: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
205: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
206: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
207: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
208: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
201: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
202: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
203: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
204: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
205: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
206: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
207: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
208: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
209: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
202: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
203: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
204: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
205: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
206: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
207: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
208: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
209: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
210: p_customer_reference IN ra_customer_trx.customer_reference%type,
203: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
204: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
205: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
206: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
207: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
208: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
209: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
210: p_customer_reference IN ra_customer_trx.customer_reference%type,
211: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
204: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
205: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
206: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
207: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
208: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
209: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
210: p_customer_reference IN ra_customer_trx.customer_reference%type,
211: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
212: p_cr_method_for_installments IN
205: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
206: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
207: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
208: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
209: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
210: p_customer_reference IN ra_customer_trx.customer_reference%type,
211: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
212: p_cr_method_for_installments IN
213: ra_customer_trx.credit_method_for_installments%type,
206: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
207: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
208: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
209: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
210: p_customer_reference IN ra_customer_trx.customer_reference%type,
211: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
212: p_cr_method_for_installments IN
213: ra_customer_trx.credit_method_for_installments%type,
214: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
207: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
208: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
209: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
210: p_customer_reference IN ra_customer_trx.customer_reference%type,
211: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
212: p_cr_method_for_installments IN
213: ra_customer_trx.credit_method_for_installments%type,
214: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
215: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
209: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
210: p_customer_reference IN ra_customer_trx.customer_reference%type,
211: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
212: p_cr_method_for_installments IN
213: ra_customer_trx.credit_method_for_installments%type,
214: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
215: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
216: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
217: p_exchange_date IN ra_customer_trx.exchange_date%type,
210: p_customer_reference IN ra_customer_trx.customer_reference%type,
211: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
212: p_cr_method_for_installments IN
213: ra_customer_trx.credit_method_for_installments%type,
214: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
215: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
216: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
217: p_exchange_date IN ra_customer_trx.exchange_date%type,
218: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
211: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
212: p_cr_method_for_installments IN
213: ra_customer_trx.credit_method_for_installments%type,
214: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
215: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
216: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
217: p_exchange_date IN ra_customer_trx.exchange_date%type,
218: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
219: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
212: p_cr_method_for_installments IN
213: ra_customer_trx.credit_method_for_installments%type,
214: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
215: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
216: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
217: p_exchange_date IN ra_customer_trx.exchange_date%type,
218: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
219: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
220: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
213: ra_customer_trx.credit_method_for_installments%type,
214: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
215: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
216: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
217: p_exchange_date IN ra_customer_trx.exchange_date%type,
218: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
219: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
220: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
221: p_finance_charges IN ra_customer_trx.finance_charges%type,
214: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
215: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
216: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
217: p_exchange_date IN ra_customer_trx.exchange_date%type,
218: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
219: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
220: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
221: p_finance_charges IN ra_customer_trx.finance_charges%type,
222: p_fob_point IN ra_customer_trx.fob_point%type,
215: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
216: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
217: p_exchange_date IN ra_customer_trx.exchange_date%type,
218: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
219: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
220: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
221: p_finance_charges IN ra_customer_trx.finance_charges%type,
222: p_fob_point IN ra_customer_trx.fob_point%type,
223: p_comments IN ra_customer_trx.comments%type,
216: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
217: p_exchange_date IN ra_customer_trx.exchange_date%type,
218: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
219: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
220: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
221: p_finance_charges IN ra_customer_trx.finance_charges%type,
222: p_fob_point IN ra_customer_trx.fob_point%type,
223: p_comments IN ra_customer_trx.comments%type,
224: p_internal_notes IN ra_customer_trx.internal_notes%type,
217: p_exchange_date IN ra_customer_trx.exchange_date%type,
218: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
219: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
220: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
221: p_finance_charges IN ra_customer_trx.finance_charges%type,
222: p_fob_point IN ra_customer_trx.fob_point%type,
223: p_comments IN ra_customer_trx.comments%type,
224: p_internal_notes IN ra_customer_trx.internal_notes%type,
225: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
218: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
219: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
220: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
221: p_finance_charges IN ra_customer_trx.finance_charges%type,
222: p_fob_point IN ra_customer_trx.fob_point%type,
223: p_comments IN ra_customer_trx.comments%type,
224: p_internal_notes IN ra_customer_trx.internal_notes%type,
225: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
226: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
219: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
220: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
221: p_finance_charges IN ra_customer_trx.finance_charges%type,
222: p_fob_point IN ra_customer_trx.fob_point%type,
223: p_comments IN ra_customer_trx.comments%type,
224: p_internal_notes IN ra_customer_trx.internal_notes%type,
225: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
226: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
227: p_last_printed_sequence_num IN
220: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
221: p_finance_charges IN ra_customer_trx.finance_charges%type,
222: p_fob_point IN ra_customer_trx.fob_point%type,
223: p_comments IN ra_customer_trx.comments%type,
224: p_internal_notes IN ra_customer_trx.internal_notes%type,
225: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
226: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
227: p_last_printed_sequence_num IN
228: ra_customer_trx.last_printed_sequence_num%type,
221: p_finance_charges IN ra_customer_trx.finance_charges%type,
222: p_fob_point IN ra_customer_trx.fob_point%type,
223: p_comments IN ra_customer_trx.comments%type,
224: p_internal_notes IN ra_customer_trx.internal_notes%type,
225: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
226: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
227: p_last_printed_sequence_num IN
228: ra_customer_trx.last_printed_sequence_num%type,
229: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
222: p_fob_point IN ra_customer_trx.fob_point%type,
223: p_comments IN ra_customer_trx.comments%type,
224: p_internal_notes IN ra_customer_trx.internal_notes%type,
225: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
226: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
227: p_last_printed_sequence_num IN
228: ra_customer_trx.last_printed_sequence_num%type,
229: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
230: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
224: p_internal_notes IN ra_customer_trx.internal_notes%type,
225: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
226: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
227: p_last_printed_sequence_num IN
228: ra_customer_trx.last_printed_sequence_num%type,
229: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
230: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
231: p_printing_count IN ra_customer_trx.printing_count%type,
232: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
225: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
226: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
227: p_last_printed_sequence_num IN
228: ra_customer_trx.last_printed_sequence_num%type,
229: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
230: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
231: p_printing_count IN ra_customer_trx.printing_count%type,
232: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
233: p_printing_option IN ra_customer_trx.printing_option%type,
226: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
227: p_last_printed_sequence_num IN
228: ra_customer_trx.last_printed_sequence_num%type,
229: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
230: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
231: p_printing_count IN ra_customer_trx.printing_count%type,
232: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
233: p_printing_option IN ra_customer_trx.printing_option%type,
234: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
227: p_last_printed_sequence_num IN
228: ra_customer_trx.last_printed_sequence_num%type,
229: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
230: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
231: p_printing_count IN ra_customer_trx.printing_count%type,
232: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
233: p_printing_option IN ra_customer_trx.printing_option%type,
234: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
235: p_printing_pending IN ra_customer_trx.printing_pending%type,
228: ra_customer_trx.last_printed_sequence_num%type,
229: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
230: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
231: p_printing_count IN ra_customer_trx.printing_count%type,
232: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
233: p_printing_option IN ra_customer_trx.printing_option%type,
234: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
235: p_printing_pending IN ra_customer_trx.printing_pending%type,
236: p_purchase_order IN ra_customer_trx.purchase_order%type,
229: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
230: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
231: p_printing_count IN ra_customer_trx.printing_count%type,
232: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
233: p_printing_option IN ra_customer_trx.printing_option%type,
234: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
235: p_printing_pending IN ra_customer_trx.printing_pending%type,
236: p_purchase_order IN ra_customer_trx.purchase_order%type,
237: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
230: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
231: p_printing_count IN ra_customer_trx.printing_count%type,
232: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
233: p_printing_option IN ra_customer_trx.printing_option%type,
234: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
235: p_printing_pending IN ra_customer_trx.printing_pending%type,
236: p_purchase_order IN ra_customer_trx.purchase_order%type,
237: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
238: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
231: p_printing_count IN ra_customer_trx.printing_count%type,
232: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
233: p_printing_option IN ra_customer_trx.printing_option%type,
234: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
235: p_printing_pending IN ra_customer_trx.printing_pending%type,
236: p_purchase_order IN ra_customer_trx.purchase_order%type,
237: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
238: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
239: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
232: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
233: p_printing_option IN ra_customer_trx.printing_option%type,
234: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
235: p_printing_pending IN ra_customer_trx.printing_pending%type,
236: p_purchase_order IN ra_customer_trx.purchase_order%type,
237: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
238: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
239: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
240: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
233: p_printing_option IN ra_customer_trx.printing_option%type,
234: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
235: p_printing_pending IN ra_customer_trx.printing_pending%type,
236: p_purchase_order IN ra_customer_trx.purchase_order%type,
237: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
238: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
239: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
240: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
241: p_shipment_id IN ra_customer_trx.shipment_id%type,
234: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
235: p_printing_pending IN ra_customer_trx.printing_pending%type,
236: p_purchase_order IN ra_customer_trx.purchase_order%type,
237: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
238: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
239: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
240: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
241: p_shipment_id IN ra_customer_trx.shipment_id%type,
242: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
235: p_printing_pending IN ra_customer_trx.printing_pending%type,
236: p_purchase_order IN ra_customer_trx.purchase_order%type,
237: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
238: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
239: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
240: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
241: p_shipment_id IN ra_customer_trx.shipment_id%type,
242: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
243: p_ship_via IN ra_customer_trx.ship_via%type,
236: p_purchase_order IN ra_customer_trx.purchase_order%type,
237: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
238: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
239: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
240: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
241: p_shipment_id IN ra_customer_trx.shipment_id%type,
242: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
243: p_ship_via IN ra_customer_trx.ship_via%type,
244: p_term_due_date IN ra_customer_trx.term_due_date%type,
237: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
238: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
239: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
240: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
241: p_shipment_id IN ra_customer_trx.shipment_id%type,
242: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
243: p_ship_via IN ra_customer_trx.ship_via%type,
244: p_term_due_date IN ra_customer_trx.term_due_date%type,
245: p_term_id IN ra_customer_trx.term_id%type,
238: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
239: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
240: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
241: p_shipment_id IN ra_customer_trx.shipment_id%type,
242: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
243: p_ship_via IN ra_customer_trx.ship_via%type,
244: p_term_due_date IN ra_customer_trx.term_due_date%type,
245: p_term_id IN ra_customer_trx.term_id%type,
246: p_territory_id IN ra_customer_trx.territory_id%type,
239: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
240: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
241: p_shipment_id IN ra_customer_trx.shipment_id%type,
242: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
243: p_ship_via IN ra_customer_trx.ship_via%type,
244: p_term_due_date IN ra_customer_trx.term_due_date%type,
245: p_term_id IN ra_customer_trx.term_id%type,
246: p_territory_id IN ra_customer_trx.territory_id%type,
247: p_waybill_number IN ra_customer_trx.waybill_number%type,
240: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
241: p_shipment_id IN ra_customer_trx.shipment_id%type,
242: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
243: p_ship_via IN ra_customer_trx.ship_via%type,
244: p_term_due_date IN ra_customer_trx.term_due_date%type,
245: p_term_id IN ra_customer_trx.term_id%type,
246: p_territory_id IN ra_customer_trx.territory_id%type,
247: p_waybill_number IN ra_customer_trx.waybill_number%type,
248: p_status_trx IN ra_customer_trx.status_trx%type,
241: p_shipment_id IN ra_customer_trx.shipment_id%type,
242: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
243: p_ship_via IN ra_customer_trx.ship_via%type,
244: p_term_due_date IN ra_customer_trx.term_due_date%type,
245: p_term_id IN ra_customer_trx.term_id%type,
246: p_territory_id IN ra_customer_trx.territory_id%type,
247: p_waybill_number IN ra_customer_trx.waybill_number%type,
248: p_status_trx IN ra_customer_trx.status_trx%type,
249: p_reason_code IN ra_customer_trx.reason_code%type,
242: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
243: p_ship_via IN ra_customer_trx.ship_via%type,
244: p_term_due_date IN ra_customer_trx.term_due_date%type,
245: p_term_id IN ra_customer_trx.term_id%type,
246: p_territory_id IN ra_customer_trx.territory_id%type,
247: p_waybill_number IN ra_customer_trx.waybill_number%type,
248: p_status_trx IN ra_customer_trx.status_trx%type,
249: p_reason_code IN ra_customer_trx.reason_code%type,
250: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
243: p_ship_via IN ra_customer_trx.ship_via%type,
244: p_term_due_date IN ra_customer_trx.term_due_date%type,
245: p_term_id IN ra_customer_trx.term_id%type,
246: p_territory_id IN ra_customer_trx.territory_id%type,
247: p_waybill_number IN ra_customer_trx.waybill_number%type,
248: p_status_trx IN ra_customer_trx.status_trx%type,
249: p_reason_code IN ra_customer_trx.reason_code%type,
250: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
251: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
244: p_term_due_date IN ra_customer_trx.term_due_date%type,
245: p_term_id IN ra_customer_trx.term_id%type,
246: p_territory_id IN ra_customer_trx.territory_id%type,
247: p_waybill_number IN ra_customer_trx.waybill_number%type,
248: p_status_trx IN ra_customer_trx.status_trx%type,
249: p_reason_code IN ra_customer_trx.reason_code%type,
250: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
251: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
252: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
245: p_term_id IN ra_customer_trx.term_id%type,
246: p_territory_id IN ra_customer_trx.territory_id%type,
247: p_waybill_number IN ra_customer_trx.waybill_number%type,
248: p_status_trx IN ra_customer_trx.status_trx%type,
249: p_reason_code IN ra_customer_trx.reason_code%type,
250: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
251: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
252: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
253: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
246: p_territory_id IN ra_customer_trx.territory_id%type,
247: p_waybill_number IN ra_customer_trx.waybill_number%type,
248: p_status_trx IN ra_customer_trx.status_trx%type,
249: p_reason_code IN ra_customer_trx.reason_code%type,
250: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
251: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
252: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
253: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
254: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
247: p_waybill_number IN ra_customer_trx.waybill_number%type,
248: p_status_trx IN ra_customer_trx.status_trx%type,
249: p_reason_code IN ra_customer_trx.reason_code%type,
250: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
251: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
252: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
253: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
254: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
255: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
248: p_status_trx IN ra_customer_trx.status_trx%type,
249: p_reason_code IN ra_customer_trx.reason_code%type,
250: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
251: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
252: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
253: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
254: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
255: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
256: p_created_from IN ra_customer_trx.created_from%type,
249: p_reason_code IN ra_customer_trx.reason_code%type,
250: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
251: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
252: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
253: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
254: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
255: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
256: p_created_from IN ra_customer_trx.created_from%type,
257: p_deflt_ussgl_trx_code_context IN
250: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
251: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
252: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
253: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
254: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
255: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
256: p_created_from IN ra_customer_trx.created_from%type,
257: p_deflt_ussgl_trx_code_context IN
258: ra_customer_trx.default_ussgl_trx_code_context%type,
251: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
252: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
253: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
254: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
255: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
256: p_created_from IN ra_customer_trx.created_from%type,
257: p_deflt_ussgl_trx_code_context IN
258: ra_customer_trx.default_ussgl_trx_code_context%type,
259: p_deflt_ussgl_transaction_code IN
252: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
253: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
254: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
255: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
256: p_created_from IN ra_customer_trx.created_from%type,
257: p_deflt_ussgl_trx_code_context IN
258: ra_customer_trx.default_ussgl_trx_code_context%type,
259: p_deflt_ussgl_transaction_code IN
260: ra_customer_trx.default_ussgl_transaction_code%type,
254: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
255: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
256: p_created_from IN ra_customer_trx.created_from%type,
257: p_deflt_ussgl_trx_code_context IN
258: ra_customer_trx.default_ussgl_trx_code_context%type,
259: p_deflt_ussgl_transaction_code IN
260: ra_customer_trx.default_ussgl_transaction_code%type,
261: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
262: p_interface_header_context IN
256: p_created_from IN ra_customer_trx.created_from%type,
257: p_deflt_ussgl_trx_code_context IN
258: ra_customer_trx.default_ussgl_trx_code_context%type,
259: p_deflt_ussgl_transaction_code IN
260: ra_customer_trx.default_ussgl_transaction_code%type,
261: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
262: p_interface_header_context IN
263: ra_customer_trx.interface_header_context%type,
264: p_interface_header_attribute1 IN
257: p_deflt_ussgl_trx_code_context IN
258: ra_customer_trx.default_ussgl_trx_code_context%type,
259: p_deflt_ussgl_transaction_code IN
260: ra_customer_trx.default_ussgl_transaction_code%type,
261: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
262: p_interface_header_context IN
263: ra_customer_trx.interface_header_context%type,
264: p_interface_header_attribute1 IN
265: ra_customer_trx.interface_header_attribute1%type,
259: p_deflt_ussgl_transaction_code IN
260: ra_customer_trx.default_ussgl_transaction_code%type,
261: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
262: p_interface_header_context IN
263: ra_customer_trx.interface_header_context%type,
264: p_interface_header_attribute1 IN
265: ra_customer_trx.interface_header_attribute1%type,
266: p_interface_header_attribute2 IN
267: ra_customer_trx.interface_header_attribute2%type,
261: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
262: p_interface_header_context IN
263: ra_customer_trx.interface_header_context%type,
264: p_interface_header_attribute1 IN
265: ra_customer_trx.interface_header_attribute1%type,
266: p_interface_header_attribute2 IN
267: ra_customer_trx.interface_header_attribute2%type,
268: p_interface_header_attribute3 IN
269: ra_customer_trx.interface_header_attribute3%type,
263: ra_customer_trx.interface_header_context%type,
264: p_interface_header_attribute1 IN
265: ra_customer_trx.interface_header_attribute1%type,
266: p_interface_header_attribute2 IN
267: ra_customer_trx.interface_header_attribute2%type,
268: p_interface_header_attribute3 IN
269: ra_customer_trx.interface_header_attribute3%type,
270: p_interface_header_attribute4 IN
271: ra_customer_trx.interface_header_attribute4%type,
265: ra_customer_trx.interface_header_attribute1%type,
266: p_interface_header_attribute2 IN
267: ra_customer_trx.interface_header_attribute2%type,
268: p_interface_header_attribute3 IN
269: ra_customer_trx.interface_header_attribute3%type,
270: p_interface_header_attribute4 IN
271: ra_customer_trx.interface_header_attribute4%type,
272: p_interface_header_attribute5 IN
273: ra_customer_trx.interface_header_attribute5%type,
267: ra_customer_trx.interface_header_attribute2%type,
268: p_interface_header_attribute3 IN
269: ra_customer_trx.interface_header_attribute3%type,
270: p_interface_header_attribute4 IN
271: ra_customer_trx.interface_header_attribute4%type,
272: p_interface_header_attribute5 IN
273: ra_customer_trx.interface_header_attribute5%type,
274: p_interface_header_attribute6 IN
275: ra_customer_trx.interface_header_attribute6%type,
269: ra_customer_trx.interface_header_attribute3%type,
270: p_interface_header_attribute4 IN
271: ra_customer_trx.interface_header_attribute4%type,
272: p_interface_header_attribute5 IN
273: ra_customer_trx.interface_header_attribute5%type,
274: p_interface_header_attribute6 IN
275: ra_customer_trx.interface_header_attribute6%type,
276: p_interface_header_attribute7 IN
277: ra_customer_trx.interface_header_attribute7%type,
271: ra_customer_trx.interface_header_attribute4%type,
272: p_interface_header_attribute5 IN
273: ra_customer_trx.interface_header_attribute5%type,
274: p_interface_header_attribute6 IN
275: ra_customer_trx.interface_header_attribute6%type,
276: p_interface_header_attribute7 IN
277: ra_customer_trx.interface_header_attribute7%type,
278: p_interface_header_attribute8 IN
279: ra_customer_trx.interface_header_attribute8%type,
273: ra_customer_trx.interface_header_attribute5%type,
274: p_interface_header_attribute6 IN
275: ra_customer_trx.interface_header_attribute6%type,
276: p_interface_header_attribute7 IN
277: ra_customer_trx.interface_header_attribute7%type,
278: p_interface_header_attribute8 IN
279: ra_customer_trx.interface_header_attribute8%type,
280: p_interface_header_attribute9 IN
281: ra_customer_trx.interface_header_attribute9%type,
275: ra_customer_trx.interface_header_attribute6%type,
276: p_interface_header_attribute7 IN
277: ra_customer_trx.interface_header_attribute7%type,
278: p_interface_header_attribute8 IN
279: ra_customer_trx.interface_header_attribute8%type,
280: p_interface_header_attribute9 IN
281: ra_customer_trx.interface_header_attribute9%type,
282: p_interface_header_attribute10 IN
283: ra_customer_trx.interface_header_attribute10%type,
277: ra_customer_trx.interface_header_attribute7%type,
278: p_interface_header_attribute8 IN
279: ra_customer_trx.interface_header_attribute8%type,
280: p_interface_header_attribute9 IN
281: ra_customer_trx.interface_header_attribute9%type,
282: p_interface_header_attribute10 IN
283: ra_customer_trx.interface_header_attribute10%type,
284: p_interface_header_attribute11 IN
285: ra_customer_trx.interface_header_attribute11%type,
279: ra_customer_trx.interface_header_attribute8%type,
280: p_interface_header_attribute9 IN
281: ra_customer_trx.interface_header_attribute9%type,
282: p_interface_header_attribute10 IN
283: ra_customer_trx.interface_header_attribute10%type,
284: p_interface_header_attribute11 IN
285: ra_customer_trx.interface_header_attribute11%type,
286: p_interface_header_attribute12 IN
287: ra_customer_trx.interface_header_attribute12%type,
281: ra_customer_trx.interface_header_attribute9%type,
282: p_interface_header_attribute10 IN
283: ra_customer_trx.interface_header_attribute10%type,
284: p_interface_header_attribute11 IN
285: ra_customer_trx.interface_header_attribute11%type,
286: p_interface_header_attribute12 IN
287: ra_customer_trx.interface_header_attribute12%type,
288: p_interface_header_attribute13 IN
289: ra_customer_trx.interface_header_attribute13%type,
283: ra_customer_trx.interface_header_attribute10%type,
284: p_interface_header_attribute11 IN
285: ra_customer_trx.interface_header_attribute11%type,
286: p_interface_header_attribute12 IN
287: ra_customer_trx.interface_header_attribute12%type,
288: p_interface_header_attribute13 IN
289: ra_customer_trx.interface_header_attribute13%type,
290: p_interface_header_attribute14 IN
291: ra_customer_trx.interface_header_attribute14%type,
285: ra_customer_trx.interface_header_attribute11%type,
286: p_interface_header_attribute12 IN
287: ra_customer_trx.interface_header_attribute12%type,
288: p_interface_header_attribute13 IN
289: ra_customer_trx.interface_header_attribute13%type,
290: p_interface_header_attribute14 IN
291: ra_customer_trx.interface_header_attribute14%type,
292: p_interface_header_attribute15 IN
293: ra_customer_trx.interface_header_attribute15%type,
287: ra_customer_trx.interface_header_attribute12%type,
288: p_interface_header_attribute13 IN
289: ra_customer_trx.interface_header_attribute13%type,
290: p_interface_header_attribute14 IN
291: ra_customer_trx.interface_header_attribute14%type,
292: p_interface_header_attribute15 IN
293: ra_customer_trx.interface_header_attribute15%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
289: ra_customer_trx.interface_header_attribute13%type,
290: p_interface_header_attribute14 IN
291: ra_customer_trx.interface_header_attribute14%type,
292: p_interface_header_attribute15 IN
293: ra_customer_trx.interface_header_attribute15%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
290: p_interface_header_attribute14 IN
291: ra_customer_trx.interface_header_attribute14%type,
292: p_interface_header_attribute15 IN
293: ra_customer_trx.interface_header_attribute15%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
291: ra_customer_trx.interface_header_attribute14%type,
292: p_interface_header_attribute15 IN
293: ra_customer_trx.interface_header_attribute15%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
292: p_interface_header_attribute15 IN
293: ra_customer_trx.interface_header_attribute15%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
293: ra_customer_trx.interface_header_attribute15%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
311: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
311: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
312: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
311: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
312: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
313: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
311: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
312: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
313: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
314: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
311: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
312: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
313: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
314: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
315: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
311: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
312: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
313: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
314: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
315: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
316: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
311: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
312: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
313: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
314: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
315: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
316: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
317: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
310: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
311: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
312: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
313: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
314: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
315: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
316: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
317: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
318: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
311: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
312: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
313: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
314: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
315: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
316: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
317: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
318: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
319: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
312: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
313: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
314: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
315: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
316: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
317: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
318: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
319: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
320: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
313: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
314: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
315: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
316: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
317: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
318: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
319: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
320: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
321: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
314: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
315: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
316: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
317: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
318: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
319: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
320: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
321: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
322: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
315: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
316: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
317: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
318: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
319: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
320: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
321: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
322: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
323: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
316: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
317: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
318: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
319: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
320: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
321: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
322: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
323: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
324: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
317: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
318: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
319: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
320: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
321: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
322: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
323: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
324: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
325: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
318: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
319: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
320: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
321: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
322: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
323: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
324: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
325: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
326: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
319: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
320: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
321: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
322: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
323: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
324: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
325: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
326: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
327: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
320: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
321: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
322: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
323: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
324: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
325: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
326: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
327: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
328: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
321: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
322: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
323: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
324: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
325: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
326: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
327: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
328: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
329: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
322: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
323: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
324: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
325: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
326: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
327: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
328: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
329: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
330: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
323: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
324: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
325: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
326: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
327: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
328: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
329: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
330: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
331: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
324: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
325: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
326: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
327: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
328: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
329: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
330: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
331: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
332: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
325: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
326: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
327: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
328: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
329: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
330: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
331: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
332: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
333: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
326: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
327: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
328: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
329: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
330: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
331: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
332: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
333: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
334: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
327: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
328: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
329: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
330: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
331: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
332: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
333: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
334: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
335: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
328: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
329: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
330: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
331: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
332: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
333: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
334: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
335: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
336: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
329: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
330: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
331: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
332: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
333: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
334: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
335: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
336: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
337: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
330: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
331: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
332: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
333: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
334: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
335: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
336: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
337: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
338: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
331: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
332: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
333: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
334: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
335: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
336: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
337: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
338: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
339: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
332: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
333: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
334: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
335: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
336: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
337: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
338: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
339: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
340: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
333: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
334: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
335: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
336: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
337: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
338: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
339: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
340: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
341: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
334: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
335: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
336: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
337: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
338: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
339: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
340: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
341: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
342: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
335: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
336: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
337: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
338: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
339: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
340: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
341: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
342: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
343: p_billing_date IN ra_customer_trx.billing_date%type);
336: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
337: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
338: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
339: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
340: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
341: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
342: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
343: p_billing_date IN ra_customer_trx.billing_date%type);
344:
337: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
338: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
339: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
340: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
341: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
342: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
343: p_billing_date IN ra_customer_trx.billing_date%type);
344:
345:
338: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
339: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
340: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
341: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
342: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
343: p_billing_date IN ra_customer_trx.billing_date%type);
344:
345:
346:
339: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
340: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
341: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
342: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
343: p_billing_date IN ra_customer_trx.billing_date%type);
344:
345:
346:
347: FUNCTION get_text_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2;