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