DBA Data[Home] [Help]

APPS.ARP_PROCESS_CREDIT_INS_COVER dependencies on RA_CUSTOMER_TRX

Line 10: p_trx_date IN ra_customer_trx.trx_date%type,

6: PROCEDURE insert_header_cover (
7: p_form_name IN varchar2,
8: p_form_version IN number,
9: p_batch_id IN ra_batches.batch_id%type,
10: p_trx_date IN ra_customer_trx.trx_date%type,
11: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
12: p_complete_flag IN ra_customer_trx.complete_flag%type,
13: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
14: p_batch_source_id IN ra_batch_sources.batch_source_id%type,

Line 12: p_complete_flag IN ra_customer_trx.complete_flag%type,

8: p_form_version IN number,
9: p_batch_id IN ra_batches.batch_id%type,
10: p_trx_date IN ra_customer_trx.trx_date%type,
11: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
12: p_complete_flag IN ra_customer_trx.complete_flag%type,
13: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
14: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
15: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
16: p_currency_code IN fnd_currencies.currency_code%type,

Line 13: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

9: p_batch_id IN ra_batches.batch_id%type,
10: p_trx_date IN ra_customer_trx.trx_date%type,
11: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
12: p_complete_flag IN ra_customer_trx.complete_flag%type,
13: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
14: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
15: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
16: p_currency_code IN fnd_currencies.currency_code%type,
17: p_exchange_date IN ra_customer_trx.exchange_date%type,

Line 17: p_exchange_date IN ra_customer_trx.exchange_date%type,

13: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
14: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
15: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
16: p_currency_code IN fnd_currencies.currency_code%type,
17: p_exchange_date IN ra_customer_trx.exchange_date%type,
18: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
19: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
20: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
21: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,

Line 18: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

14: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
15: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
16: p_currency_code IN fnd_currencies.currency_code%type,
17: p_exchange_date IN ra_customer_trx.exchange_date%type,
18: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
19: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
20: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
21: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
22: p_split_term_method IN

Line 19: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

15: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
16: p_currency_code IN fnd_currencies.currency_code%type,
17: p_exchange_date IN ra_customer_trx.exchange_date%type,
18: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
19: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
20: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
21: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
22: p_split_term_method IN
23: ra_customer_trx.credit_method_for_installments%type,

Line 20: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

16: p_currency_code IN fnd_currencies.currency_code%type,
17: p_exchange_date IN ra_customer_trx.exchange_date%type,
18: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
19: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
20: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
21: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
22: p_split_term_method IN
23: ra_customer_trx.credit_method_for_installments%type,
24: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,

Line 21: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,

17: p_exchange_date IN ra_customer_trx.exchange_date%type,
18: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
19: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
20: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
21: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
22: p_split_term_method IN
23: ra_customer_trx.credit_method_for_installments%type,
24: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
25: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,

Line 23: ra_customer_trx.credit_method_for_installments%type,

19: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
20: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
21: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
22: p_split_term_method IN
23: ra_customer_trx.credit_method_for_installments%type,
24: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
25: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
26: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
27: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,

Line 24: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,

20: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
21: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
22: p_split_term_method IN
23: ra_customer_trx.credit_method_for_installments%type,
24: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
25: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
26: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
27: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
28: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,

Line 25: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,

21: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
22: p_split_term_method IN
23: ra_customer_trx.credit_method_for_installments%type,
24: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
25: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
26: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
27: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
28: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
29: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,

Line 26: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,

22: p_split_term_method IN
23: ra_customer_trx.credit_method_for_installments%type,
24: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
25: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
26: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
27: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
28: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
29: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
30: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

Line 27: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,

23: ra_customer_trx.credit_method_for_installments%type,
24: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
25: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
26: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
27: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
28: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
29: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
30: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
31: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,

Line 28: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,

24: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
25: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
26: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
27: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
28: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
29: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
30: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
31: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
32: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

Line 29: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,

25: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
26: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
27: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
28: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
29: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
30: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
31: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
32: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
33: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

Line 30: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

26: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
27: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
28: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
29: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
30: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
31: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
32: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
33: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
34: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,

Line 31: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,

27: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
28: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
29: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
30: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
31: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
32: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
33: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
34: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
35: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

Line 32: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

28: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
29: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
30: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
31: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
32: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
33: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
34: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
35: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
36: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,

Line 33: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

29: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
30: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
31: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
32: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
33: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
34: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
35: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
36: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
37: p_customer_bank_account_id IN

Line 34: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,

30: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
31: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
32: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
33: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
34: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
35: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
36: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
37: p_customer_bank_account_id IN
38: ra_customer_trx.customer_bank_account_id%type,

Line 35: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

31: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
32: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
33: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
34: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
35: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
36: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
37: p_customer_bank_account_id IN
38: ra_customer_trx.customer_bank_account_id%type,
39: p_printing_option IN ra_customer_trx.printing_option%type,

Line 36: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,

32: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
33: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
34: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
35: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
36: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
37: p_customer_bank_account_id IN
38: ra_customer_trx.customer_bank_account_id%type,
39: p_printing_option IN ra_customer_trx.printing_option%type,
40: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,

Line 38: ra_customer_trx.customer_bank_account_id%type,

34: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
35: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
36: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
37: p_customer_bank_account_id IN
38: ra_customer_trx.customer_bank_account_id%type,
39: p_printing_option IN ra_customer_trx.printing_option%type,
40: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
41: p_printing_pending IN ra_customer_trx.printing_pending%type,
42: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,

Line 39: p_printing_option IN ra_customer_trx.printing_option%type,

35: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
36: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
37: p_customer_bank_account_id IN
38: ra_customer_trx.customer_bank_account_id%type,
39: p_printing_option IN ra_customer_trx.printing_option%type,
40: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
41: p_printing_pending IN ra_customer_trx.printing_pending%type,
42: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
43: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,

Line 40: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,

36: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
37: p_customer_bank_account_id IN
38: ra_customer_trx.customer_bank_account_id%type,
39: p_printing_option IN ra_customer_trx.printing_option%type,
40: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
41: p_printing_pending IN ra_customer_trx.printing_pending%type,
42: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
43: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
44: p_reason_code IN ra_customer_trx.reason_code%type,

Line 41: p_printing_pending IN ra_customer_trx.printing_pending%type,

37: p_customer_bank_account_id IN
38: ra_customer_trx.customer_bank_account_id%type,
39: p_printing_option IN ra_customer_trx.printing_option%type,
40: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
41: p_printing_pending IN ra_customer_trx.printing_pending%type,
42: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
43: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
44: p_reason_code IN ra_customer_trx.reason_code%type,
45: p_customer_reference IN ra_customer_trx.customer_reference%type,

Line 42: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,

38: ra_customer_trx.customer_bank_account_id%type,
39: p_printing_option IN ra_customer_trx.printing_option%type,
40: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
41: p_printing_pending IN ra_customer_trx.printing_pending%type,
42: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
43: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
44: p_reason_code IN ra_customer_trx.reason_code%type,
45: p_customer_reference IN ra_customer_trx.customer_reference%type,
46: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

Line 43: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,

39: p_printing_option IN ra_customer_trx.printing_option%type,
40: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
41: p_printing_pending IN ra_customer_trx.printing_pending%type,
42: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
43: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
44: p_reason_code IN ra_customer_trx.reason_code%type,
45: p_customer_reference IN ra_customer_trx.customer_reference%type,
46: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
47: p_internal_notes IN ra_customer_trx.internal_notes%type,

Line 44: p_reason_code IN ra_customer_trx.reason_code%type,

40: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
41: p_printing_pending IN ra_customer_trx.printing_pending%type,
42: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
43: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
44: p_reason_code IN ra_customer_trx.reason_code%type,
45: p_customer_reference IN ra_customer_trx.customer_reference%type,
46: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
47: p_internal_notes IN ra_customer_trx.internal_notes%type,
48: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,

Line 45: p_customer_reference IN ra_customer_trx.customer_reference%type,

41: p_printing_pending IN ra_customer_trx.printing_pending%type,
42: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
43: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
44: p_reason_code IN ra_customer_trx.reason_code%type,
45: p_customer_reference IN ra_customer_trx.customer_reference%type,
46: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
47: p_internal_notes IN ra_customer_trx.internal_notes%type,
48: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
49: p_created_from IN ra_customer_trx.created_from%type,

Line 46: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

42: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
43: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
44: p_reason_code IN ra_customer_trx.reason_code%type,
45: p_customer_reference IN ra_customer_trx.customer_reference%type,
46: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
47: p_internal_notes IN ra_customer_trx.internal_notes%type,
48: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
49: p_created_from IN ra_customer_trx.created_from%type,
50: p_old_trx_number IN ra_customer_trx.old_trx_number%type,

Line 47: p_internal_notes IN ra_customer_trx.internal_notes%type,

43: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
44: p_reason_code IN ra_customer_trx.reason_code%type,
45: p_customer_reference IN ra_customer_trx.customer_reference%type,
46: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
47: p_internal_notes IN ra_customer_trx.internal_notes%type,
48: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
49: p_created_from IN ra_customer_trx.created_from%type,
50: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
51: p_attribute_category IN ra_customer_trx.attribute_category%type,

Line 48: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,

44: p_reason_code IN ra_customer_trx.reason_code%type,
45: p_customer_reference IN ra_customer_trx.customer_reference%type,
46: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
47: p_internal_notes IN ra_customer_trx.internal_notes%type,
48: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
49: p_created_from IN ra_customer_trx.created_from%type,
50: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
51: p_attribute_category IN ra_customer_trx.attribute_category%type,
52: p_attribute1 IN ra_customer_trx.attribute1%type,

Line 49: p_created_from IN ra_customer_trx.created_from%type,

45: p_customer_reference IN ra_customer_trx.customer_reference%type,
46: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
47: p_internal_notes IN ra_customer_trx.internal_notes%type,
48: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
49: p_created_from IN ra_customer_trx.created_from%type,
50: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
51: p_attribute_category IN ra_customer_trx.attribute_category%type,
52: p_attribute1 IN ra_customer_trx.attribute1%type,
53: p_attribute2 IN ra_customer_trx.attribute2%type,

Line 50: p_old_trx_number IN ra_customer_trx.old_trx_number%type,

46: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
47: p_internal_notes IN ra_customer_trx.internal_notes%type,
48: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
49: p_created_from IN ra_customer_trx.created_from%type,
50: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
51: p_attribute_category IN ra_customer_trx.attribute_category%type,
52: p_attribute1 IN ra_customer_trx.attribute1%type,
53: p_attribute2 IN ra_customer_trx.attribute2%type,
54: p_attribute3 IN ra_customer_trx.attribute3%type,

Line 51: p_attribute_category IN ra_customer_trx.attribute_category%type,

47: p_internal_notes IN ra_customer_trx.internal_notes%type,
48: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
49: p_created_from IN ra_customer_trx.created_from%type,
50: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
51: p_attribute_category IN ra_customer_trx.attribute_category%type,
52: p_attribute1 IN ra_customer_trx.attribute1%type,
53: p_attribute2 IN ra_customer_trx.attribute2%type,
54: p_attribute3 IN ra_customer_trx.attribute3%type,
55: p_attribute4 IN ra_customer_trx.attribute4%type,

Line 52: p_attribute1 IN ra_customer_trx.attribute1%type,

48: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
49: p_created_from IN ra_customer_trx.created_from%type,
50: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
51: p_attribute_category IN ra_customer_trx.attribute_category%type,
52: p_attribute1 IN ra_customer_trx.attribute1%type,
53: p_attribute2 IN ra_customer_trx.attribute2%type,
54: p_attribute3 IN ra_customer_trx.attribute3%type,
55: p_attribute4 IN ra_customer_trx.attribute4%type,
56: p_attribute5 IN ra_customer_trx.attribute5%type,

Line 53: p_attribute2 IN ra_customer_trx.attribute2%type,

49: p_created_from IN ra_customer_trx.created_from%type,
50: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
51: p_attribute_category IN ra_customer_trx.attribute_category%type,
52: p_attribute1 IN ra_customer_trx.attribute1%type,
53: p_attribute2 IN ra_customer_trx.attribute2%type,
54: p_attribute3 IN ra_customer_trx.attribute3%type,
55: p_attribute4 IN ra_customer_trx.attribute4%type,
56: p_attribute5 IN ra_customer_trx.attribute5%type,
57: p_attribute6 IN ra_customer_trx.attribute6%type,

Line 54: p_attribute3 IN ra_customer_trx.attribute3%type,

50: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
51: p_attribute_category IN ra_customer_trx.attribute_category%type,
52: p_attribute1 IN ra_customer_trx.attribute1%type,
53: p_attribute2 IN ra_customer_trx.attribute2%type,
54: p_attribute3 IN ra_customer_trx.attribute3%type,
55: p_attribute4 IN ra_customer_trx.attribute4%type,
56: p_attribute5 IN ra_customer_trx.attribute5%type,
57: p_attribute6 IN ra_customer_trx.attribute6%type,
58: p_attribute7 IN ra_customer_trx.attribute7%type,

Line 55: p_attribute4 IN ra_customer_trx.attribute4%type,

51: p_attribute_category IN ra_customer_trx.attribute_category%type,
52: p_attribute1 IN ra_customer_trx.attribute1%type,
53: p_attribute2 IN ra_customer_trx.attribute2%type,
54: p_attribute3 IN ra_customer_trx.attribute3%type,
55: p_attribute4 IN ra_customer_trx.attribute4%type,
56: p_attribute5 IN ra_customer_trx.attribute5%type,
57: p_attribute6 IN ra_customer_trx.attribute6%type,
58: p_attribute7 IN ra_customer_trx.attribute7%type,
59: p_attribute8 IN ra_customer_trx.attribute8%type,

Line 56: p_attribute5 IN ra_customer_trx.attribute5%type,

52: p_attribute1 IN ra_customer_trx.attribute1%type,
53: p_attribute2 IN ra_customer_trx.attribute2%type,
54: p_attribute3 IN ra_customer_trx.attribute3%type,
55: p_attribute4 IN ra_customer_trx.attribute4%type,
56: p_attribute5 IN ra_customer_trx.attribute5%type,
57: p_attribute6 IN ra_customer_trx.attribute6%type,
58: p_attribute7 IN ra_customer_trx.attribute7%type,
59: p_attribute8 IN ra_customer_trx.attribute8%type,
60: p_attribute9 IN ra_customer_trx.attribute9%type,

Line 57: p_attribute6 IN ra_customer_trx.attribute6%type,

53: p_attribute2 IN ra_customer_trx.attribute2%type,
54: p_attribute3 IN ra_customer_trx.attribute3%type,
55: p_attribute4 IN ra_customer_trx.attribute4%type,
56: p_attribute5 IN ra_customer_trx.attribute5%type,
57: p_attribute6 IN ra_customer_trx.attribute6%type,
58: p_attribute7 IN ra_customer_trx.attribute7%type,
59: p_attribute8 IN ra_customer_trx.attribute8%type,
60: p_attribute9 IN ra_customer_trx.attribute9%type,
61: p_attribute10 IN ra_customer_trx.attribute10%type,

Line 58: p_attribute7 IN ra_customer_trx.attribute7%type,

54: p_attribute3 IN ra_customer_trx.attribute3%type,
55: p_attribute4 IN ra_customer_trx.attribute4%type,
56: p_attribute5 IN ra_customer_trx.attribute5%type,
57: p_attribute6 IN ra_customer_trx.attribute6%type,
58: p_attribute7 IN ra_customer_trx.attribute7%type,
59: p_attribute8 IN ra_customer_trx.attribute8%type,
60: p_attribute9 IN ra_customer_trx.attribute9%type,
61: p_attribute10 IN ra_customer_trx.attribute10%type,
62: p_attribute11 IN ra_customer_trx.attribute11%type,

Line 59: p_attribute8 IN ra_customer_trx.attribute8%type,

55: p_attribute4 IN ra_customer_trx.attribute4%type,
56: p_attribute5 IN ra_customer_trx.attribute5%type,
57: p_attribute6 IN ra_customer_trx.attribute6%type,
58: p_attribute7 IN ra_customer_trx.attribute7%type,
59: p_attribute8 IN ra_customer_trx.attribute8%type,
60: p_attribute9 IN ra_customer_trx.attribute9%type,
61: p_attribute10 IN ra_customer_trx.attribute10%type,
62: p_attribute11 IN ra_customer_trx.attribute11%type,
63: p_attribute12 IN ra_customer_trx.attribute12%type,

Line 60: p_attribute9 IN ra_customer_trx.attribute9%type,

56: p_attribute5 IN ra_customer_trx.attribute5%type,
57: p_attribute6 IN ra_customer_trx.attribute6%type,
58: p_attribute7 IN ra_customer_trx.attribute7%type,
59: p_attribute8 IN ra_customer_trx.attribute8%type,
60: p_attribute9 IN ra_customer_trx.attribute9%type,
61: p_attribute10 IN ra_customer_trx.attribute10%type,
62: p_attribute11 IN ra_customer_trx.attribute11%type,
63: p_attribute12 IN ra_customer_trx.attribute12%type,
64: p_attribute13 IN ra_customer_trx.attribute13%type,

Line 61: p_attribute10 IN ra_customer_trx.attribute10%type,

57: p_attribute6 IN ra_customer_trx.attribute6%type,
58: p_attribute7 IN ra_customer_trx.attribute7%type,
59: p_attribute8 IN ra_customer_trx.attribute8%type,
60: p_attribute9 IN ra_customer_trx.attribute9%type,
61: p_attribute10 IN ra_customer_trx.attribute10%type,
62: p_attribute11 IN ra_customer_trx.attribute11%type,
63: p_attribute12 IN ra_customer_trx.attribute12%type,
64: p_attribute13 IN ra_customer_trx.attribute13%type,
65: p_attribute14 IN ra_customer_trx.attribute14%type,

Line 62: p_attribute11 IN ra_customer_trx.attribute11%type,

58: p_attribute7 IN ra_customer_trx.attribute7%type,
59: p_attribute8 IN ra_customer_trx.attribute8%type,
60: p_attribute9 IN ra_customer_trx.attribute9%type,
61: p_attribute10 IN ra_customer_trx.attribute10%type,
62: p_attribute11 IN ra_customer_trx.attribute11%type,
63: p_attribute12 IN ra_customer_trx.attribute12%type,
64: p_attribute13 IN ra_customer_trx.attribute13%type,
65: p_attribute14 IN ra_customer_trx.attribute14%type,
66: p_attribute15 IN ra_customer_trx.attribute15%type,

Line 63: p_attribute12 IN ra_customer_trx.attribute12%type,

59: p_attribute8 IN ra_customer_trx.attribute8%type,
60: p_attribute9 IN ra_customer_trx.attribute9%type,
61: p_attribute10 IN ra_customer_trx.attribute10%type,
62: p_attribute11 IN ra_customer_trx.attribute11%type,
63: p_attribute12 IN ra_customer_trx.attribute12%type,
64: p_attribute13 IN ra_customer_trx.attribute13%type,
65: p_attribute14 IN ra_customer_trx.attribute14%type,
66: p_attribute15 IN ra_customer_trx.attribute15%type,
67: p_interface_header_context IN

Line 64: p_attribute13 IN ra_customer_trx.attribute13%type,

60: p_attribute9 IN ra_customer_trx.attribute9%type,
61: p_attribute10 IN ra_customer_trx.attribute10%type,
62: p_attribute11 IN ra_customer_trx.attribute11%type,
63: p_attribute12 IN ra_customer_trx.attribute12%type,
64: p_attribute13 IN ra_customer_trx.attribute13%type,
65: p_attribute14 IN ra_customer_trx.attribute14%type,
66: p_attribute15 IN ra_customer_trx.attribute15%type,
67: p_interface_header_context IN
68: ra_customer_trx.interface_header_context%type,

Line 65: p_attribute14 IN ra_customer_trx.attribute14%type,

61: p_attribute10 IN ra_customer_trx.attribute10%type,
62: p_attribute11 IN ra_customer_trx.attribute11%type,
63: p_attribute12 IN ra_customer_trx.attribute12%type,
64: p_attribute13 IN ra_customer_trx.attribute13%type,
65: p_attribute14 IN ra_customer_trx.attribute14%type,
66: p_attribute15 IN ra_customer_trx.attribute15%type,
67: p_interface_header_context IN
68: ra_customer_trx.interface_header_context%type,
69: p_interface_header_attribute1 IN

Line 66: p_attribute15 IN ra_customer_trx.attribute15%type,

62: p_attribute11 IN ra_customer_trx.attribute11%type,
63: p_attribute12 IN ra_customer_trx.attribute12%type,
64: p_attribute13 IN ra_customer_trx.attribute13%type,
65: p_attribute14 IN ra_customer_trx.attribute14%type,
66: p_attribute15 IN ra_customer_trx.attribute15%type,
67: p_interface_header_context IN
68: ra_customer_trx.interface_header_context%type,
69: p_interface_header_attribute1 IN
70: ra_customer_trx.interface_header_attribute1%type,

Line 68: ra_customer_trx.interface_header_context%type,

64: p_attribute13 IN ra_customer_trx.attribute13%type,
65: p_attribute14 IN ra_customer_trx.attribute14%type,
66: p_attribute15 IN ra_customer_trx.attribute15%type,
67: p_interface_header_context IN
68: ra_customer_trx.interface_header_context%type,
69: p_interface_header_attribute1 IN
70: ra_customer_trx.interface_header_attribute1%type,
71: p_interface_header_attribute2 IN
72: ra_customer_trx.interface_header_attribute2%type,

Line 70: ra_customer_trx.interface_header_attribute1%type,

66: p_attribute15 IN ra_customer_trx.attribute15%type,
67: p_interface_header_context IN
68: ra_customer_trx.interface_header_context%type,
69: p_interface_header_attribute1 IN
70: ra_customer_trx.interface_header_attribute1%type,
71: p_interface_header_attribute2 IN
72: ra_customer_trx.interface_header_attribute2%type,
73: p_interface_header_attribute3 IN
74: ra_customer_trx.interface_header_attribute3%type,

Line 72: ra_customer_trx.interface_header_attribute2%type,

68: ra_customer_trx.interface_header_context%type,
69: p_interface_header_attribute1 IN
70: ra_customer_trx.interface_header_attribute1%type,
71: p_interface_header_attribute2 IN
72: ra_customer_trx.interface_header_attribute2%type,
73: p_interface_header_attribute3 IN
74: ra_customer_trx.interface_header_attribute3%type,
75: p_interface_header_attribute4 IN
76: ra_customer_trx.interface_header_attribute4%type,

Line 74: ra_customer_trx.interface_header_attribute3%type,

70: ra_customer_trx.interface_header_attribute1%type,
71: p_interface_header_attribute2 IN
72: ra_customer_trx.interface_header_attribute2%type,
73: p_interface_header_attribute3 IN
74: ra_customer_trx.interface_header_attribute3%type,
75: p_interface_header_attribute4 IN
76: ra_customer_trx.interface_header_attribute4%type,
77: p_interface_header_attribute5 IN
78: ra_customer_trx.interface_header_attribute5%type,

Line 76: ra_customer_trx.interface_header_attribute4%type,

72: ra_customer_trx.interface_header_attribute2%type,
73: p_interface_header_attribute3 IN
74: ra_customer_trx.interface_header_attribute3%type,
75: p_interface_header_attribute4 IN
76: ra_customer_trx.interface_header_attribute4%type,
77: p_interface_header_attribute5 IN
78: ra_customer_trx.interface_header_attribute5%type,
79: p_interface_header_attribute6 IN
80: ra_customer_trx.interface_header_attribute6%type,

Line 78: ra_customer_trx.interface_header_attribute5%type,

74: ra_customer_trx.interface_header_attribute3%type,
75: p_interface_header_attribute4 IN
76: ra_customer_trx.interface_header_attribute4%type,
77: p_interface_header_attribute5 IN
78: ra_customer_trx.interface_header_attribute5%type,
79: p_interface_header_attribute6 IN
80: ra_customer_trx.interface_header_attribute6%type,
81: p_interface_header_attribute7 IN
82: ra_customer_trx.interface_header_attribute7%type,

Line 80: ra_customer_trx.interface_header_attribute6%type,

76: ra_customer_trx.interface_header_attribute4%type,
77: p_interface_header_attribute5 IN
78: ra_customer_trx.interface_header_attribute5%type,
79: p_interface_header_attribute6 IN
80: ra_customer_trx.interface_header_attribute6%type,
81: p_interface_header_attribute7 IN
82: ra_customer_trx.interface_header_attribute7%type,
83: p_interface_header_attribute8 IN
84: ra_customer_trx.interface_header_attribute8%type,

Line 82: ra_customer_trx.interface_header_attribute7%type,

78: ra_customer_trx.interface_header_attribute5%type,
79: p_interface_header_attribute6 IN
80: ra_customer_trx.interface_header_attribute6%type,
81: p_interface_header_attribute7 IN
82: ra_customer_trx.interface_header_attribute7%type,
83: p_interface_header_attribute8 IN
84: ra_customer_trx.interface_header_attribute8%type,
85: p_interface_header_attribute9 IN
86: ra_customer_trx.interface_header_attribute9%type,

Line 84: ra_customer_trx.interface_header_attribute8%type,

80: ra_customer_trx.interface_header_attribute6%type,
81: p_interface_header_attribute7 IN
82: ra_customer_trx.interface_header_attribute7%type,
83: p_interface_header_attribute8 IN
84: ra_customer_trx.interface_header_attribute8%type,
85: p_interface_header_attribute9 IN
86: ra_customer_trx.interface_header_attribute9%type,
87: p_interface_header_attribute10 IN
88: ra_customer_trx.interface_header_attribute10%type,

Line 86: ra_customer_trx.interface_header_attribute9%type,

82: ra_customer_trx.interface_header_attribute7%type,
83: p_interface_header_attribute8 IN
84: ra_customer_trx.interface_header_attribute8%type,
85: p_interface_header_attribute9 IN
86: ra_customer_trx.interface_header_attribute9%type,
87: p_interface_header_attribute10 IN
88: ra_customer_trx.interface_header_attribute10%type,
89: p_interface_header_attribute11 IN
90: ra_customer_trx.interface_header_attribute11%type,

Line 88: ra_customer_trx.interface_header_attribute10%type,

84: ra_customer_trx.interface_header_attribute8%type,
85: p_interface_header_attribute9 IN
86: ra_customer_trx.interface_header_attribute9%type,
87: p_interface_header_attribute10 IN
88: ra_customer_trx.interface_header_attribute10%type,
89: p_interface_header_attribute11 IN
90: ra_customer_trx.interface_header_attribute11%type,
91: p_interface_header_attribute12 IN
92: ra_customer_trx.interface_header_attribute12%type,

Line 90: ra_customer_trx.interface_header_attribute11%type,

86: ra_customer_trx.interface_header_attribute9%type,
87: p_interface_header_attribute10 IN
88: ra_customer_trx.interface_header_attribute10%type,
89: p_interface_header_attribute11 IN
90: ra_customer_trx.interface_header_attribute11%type,
91: p_interface_header_attribute12 IN
92: ra_customer_trx.interface_header_attribute12%type,
93: p_interface_header_attribute13 IN
94: ra_customer_trx.interface_header_attribute13%type,

Line 92: ra_customer_trx.interface_header_attribute12%type,

88: ra_customer_trx.interface_header_attribute10%type,
89: p_interface_header_attribute11 IN
90: ra_customer_trx.interface_header_attribute11%type,
91: p_interface_header_attribute12 IN
92: ra_customer_trx.interface_header_attribute12%type,
93: p_interface_header_attribute13 IN
94: ra_customer_trx.interface_header_attribute13%type,
95: p_interface_header_attribute14 IN
96: ra_customer_trx.interface_header_attribute14%type,

Line 94: ra_customer_trx.interface_header_attribute13%type,

90: ra_customer_trx.interface_header_attribute11%type,
91: p_interface_header_attribute12 IN
92: ra_customer_trx.interface_header_attribute12%type,
93: p_interface_header_attribute13 IN
94: ra_customer_trx.interface_header_attribute13%type,
95: p_interface_header_attribute14 IN
96: ra_customer_trx.interface_header_attribute14%type,
97: p_interface_header_attribute15 IN
98: ra_customer_trx.interface_header_attribute15%type,

Line 96: ra_customer_trx.interface_header_attribute14%type,

92: ra_customer_trx.interface_header_attribute12%type,
93: p_interface_header_attribute13 IN
94: ra_customer_trx.interface_header_attribute13%type,
95: p_interface_header_attribute14 IN
96: ra_customer_trx.interface_header_attribute14%type,
97: p_interface_header_attribute15 IN
98: ra_customer_trx.interface_header_attribute15%type,
99: p_default_ussgl_trx_code IN
100: ra_customer_trx.default_ussgl_transaction_code%type,

Line 98: ra_customer_trx.interface_header_attribute15%type,

94: ra_customer_trx.interface_header_attribute13%type,
95: p_interface_header_attribute14 IN
96: ra_customer_trx.interface_header_attribute14%type,
97: p_interface_header_attribute15 IN
98: ra_customer_trx.interface_header_attribute15%type,
99: p_default_ussgl_trx_code IN
100: ra_customer_trx.default_ussgl_transaction_code%type,
101: p_line_percent IN number,
102: p_freight_percent IN number,

Line 100: ra_customer_trx.default_ussgl_transaction_code%type,

96: ra_customer_trx.interface_header_attribute14%type,
97: p_interface_header_attribute15 IN
98: ra_customer_trx.interface_header_attribute15%type,
99: p_default_ussgl_trx_code IN
100: ra_customer_trx.default_ussgl_transaction_code%type,
101: p_line_percent IN number,
102: p_freight_percent IN number,
103: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
104: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

Line 103: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

99: p_default_ussgl_trx_code IN
100: ra_customer_trx.default_ussgl_transaction_code%type,
101: p_line_percent IN number,
102: p_freight_percent IN number,
103: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
104: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
105: p_compute_tax IN varchar2,
106: p_comments IN ra_customer_trx.comments%type,
107: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,

Line 104: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

100: ra_customer_trx.default_ussgl_transaction_code%type,
101: p_line_percent IN number,
102: p_freight_percent IN number,
103: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
104: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
105: p_compute_tax IN varchar2,
106: p_comments IN ra_customer_trx.comments%type,
107: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
108: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,

Line 106: p_comments IN ra_customer_trx.comments%type,

102: p_freight_percent IN number,
103: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
104: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
105: p_compute_tax IN varchar2,
106: p_comments IN ra_customer_trx.comments%type,
107: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
108: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
109: p_computed_tax_percent IN OUT NOCOPY number,
110: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 107: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,

103: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
104: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
105: p_compute_tax IN varchar2,
106: p_comments IN ra_customer_trx.comments%type,
107: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
108: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
109: p_computed_tax_percent IN OUT NOCOPY number,
110: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
111: p_status OUT NOCOPY varchar2,

Line 108: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,

104: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
105: p_compute_tax IN varchar2,
106: p_comments IN ra_customer_trx.comments%type,
107: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
108: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
109: p_computed_tax_percent IN OUT NOCOPY number,
110: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
111: p_status OUT NOCOPY varchar2,
112: p_submit_cm_dist IN varchar2 DEFAULT 'N')

Line 110: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

106: p_comments IN ra_customer_trx.comments%type,
107: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
108: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
109: p_computed_tax_percent IN OUT NOCOPY number,
110: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
111: p_status OUT NOCOPY varchar2,
112: p_submit_cm_dist IN varchar2 DEFAULT 'N')
113: IS
114:

Line 115: l_cm_header ra_customer_trx%rowtype;

111: p_status OUT NOCOPY varchar2,
112: p_submit_cm_dist IN varchar2 DEFAULT 'N')
113: IS
114:
115: l_cm_header ra_customer_trx%rowtype;
116: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
117:
118: BEGIN
119:

Line 116: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

112: p_submit_cm_dist IN varchar2 DEFAULT 'N')
113: IS
114:
115: l_cm_header ra_customer_trx%rowtype;
116: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
117:
118: BEGIN
119:
120: IF PG_DEBUG in ('Y', 'C') THEN

Line 222: FROM ra_customer_trx_all

218: l_cm_header.purchase_order_revision,
219: l_cm_header.purchase_order_date,
220: l_cm_header.territory_id, /* Bug-3852057 */
221: l_cm_header.legal_entity_id /* R12 LE uptake */
222: FROM ra_customer_trx_all
223: WHERE customer_trx_id = p_prev_customer_trx_id;
224:
225: --
226: -- call the entity handler