eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on RA_CUSTOMER_TRX

Line 35: l_deposit_number ra_customer_trx.trx_number%TYPE := NULL;

31:
32: l_api_version NUMBER := 1.0;
33: l_api_name VARCHAR2(50) := 'create_emd_deposit';
34: l_progress NUMBER;
35: l_deposit_number ra_customer_trx.trx_number%TYPE := NULL;
36: l_deposit_date ra_customer_trx.trx_date%TYPE := NULL;
37: l_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
38: l_usr_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
39: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;

Line 36: l_deposit_date ra_customer_trx.trx_date%TYPE := NULL;

32: l_api_version NUMBER := 1.0;
33: l_api_name VARCHAR2(50) := 'create_emd_deposit';
34: l_progress NUMBER;
35: l_deposit_number ra_customer_trx.trx_number%TYPE := NULL;
36: l_deposit_date ra_customer_trx.trx_date%TYPE := NULL;
37: l_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
38: l_usr_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
39: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
40: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;

Line 37: l_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;

33: l_api_name VARCHAR2(50) := 'create_emd_deposit';
34: l_progress NUMBER;
35: l_deposit_number ra_customer_trx.trx_number%TYPE := NULL;
36: l_deposit_date ra_customer_trx.trx_date%TYPE := NULL;
37: l_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
38: l_usr_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
39: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
40: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
41: l_exchange_rate ra_customer_trx.exchange_rate%TYPE := NULL;

Line 38: l_usr_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;

34: l_progress NUMBER;
35: l_deposit_number ra_customer_trx.trx_number%TYPE := NULL;
36: l_deposit_date ra_customer_trx.trx_date%TYPE := NULL;
37: l_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
38: l_usr_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
39: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
40: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
41: l_exchange_rate ra_customer_trx.exchange_rate%TYPE := NULL;
42: l_exchange_date ra_customer_trx.exchange_date%TYPE := NULL;

Line 39: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;

35: l_deposit_number ra_customer_trx.trx_number%TYPE := NULL;
36: l_deposit_date ra_customer_trx.trx_date%TYPE := NULL;
37: l_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
38: l_usr_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
39: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
40: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
41: l_exchange_rate ra_customer_trx.exchange_rate%TYPE := NULL;
42: l_exchange_date ra_customer_trx.exchange_date%TYPE := NULL;
43: l_gl_date DATE := NULL;

Line 40: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;

36: l_deposit_date ra_customer_trx.trx_date%TYPE := NULL;
37: l_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
38: l_usr_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
39: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
40: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
41: l_exchange_rate ra_customer_trx.exchange_rate%TYPE := NULL;
42: l_exchange_date ra_customer_trx.exchange_date%TYPE := NULL;
43: l_gl_date DATE := NULL;
44: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;

Line 41: l_exchange_rate ra_customer_trx.exchange_rate%TYPE := NULL;

37: l_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
38: l_usr_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
39: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
40: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
41: l_exchange_rate ra_customer_trx.exchange_rate%TYPE := NULL;
42: l_exchange_date ra_customer_trx.exchange_date%TYPE := NULL;
43: l_gl_date DATE := NULL;
44: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
45: l_bill_to_customer_name hz_parties.party_name%TYPE := NULL;

Line 42: l_exchange_date ra_customer_trx.exchange_date%TYPE := NULL;

38: l_usr_currency_code ra_customer_trx.invoice_currency_code%TYPE := NULL;
39: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
40: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
41: l_exchange_rate ra_customer_trx.exchange_rate%TYPE := NULL;
42: l_exchange_date ra_customer_trx.exchange_date%TYPE := NULL;
43: l_gl_date DATE := NULL;
44: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
45: l_bill_to_customer_name hz_parties.party_name%TYPE := NULL;
46: l_bill_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;

Line 44: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;

40: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE := NULL;
41: l_exchange_rate ra_customer_trx.exchange_rate%TYPE := NULL;
42: l_exchange_date ra_customer_trx.exchange_date%TYPE := NULL;
43: l_gl_date DATE := NULL;
44: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
45: l_bill_to_customer_name hz_parties.party_name%TYPE := NULL;
46: l_bill_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
47: l_bill_to_location hz_cust_site_uses.location%TYPE := NULL;
48: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE := NULL;

Line 48: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE := NULL;

44: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
45: l_bill_to_customer_name hz_parties.party_name%TYPE := NULL;
46: l_bill_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
47: l_bill_to_location hz_cust_site_uses.location%TYPE := NULL;
48: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE := NULL;
49: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%TYPE := NULL;
50: l_bill_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
51: l_bill_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
52: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;

Line 49: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%TYPE := NULL;

45: l_bill_to_customer_name hz_parties.party_name%TYPE := NULL;
46: l_bill_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
47: l_bill_to_location hz_cust_site_uses.location%TYPE := NULL;
48: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE := NULL;
49: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%TYPE := NULL;
50: l_bill_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
51: l_bill_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
52: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
53: l_ship_to_customer_name hz_parties.party_name%TYPE := NULL;

Line 52: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;

48: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE := NULL;
49: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%TYPE := NULL;
50: l_bill_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
51: l_bill_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
52: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
53: l_ship_to_customer_name hz_parties.party_name%TYPE := NULL;
54: l_ship_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
55: l_ship_to_location hz_cust_site_uses.location%TYPE := NULL;
56: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE := NULL;

Line 56: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE := NULL;

52: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
53: l_ship_to_customer_name hz_parties.party_name%TYPE := NULL;
54: l_ship_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
55: l_ship_to_location hz_cust_site_uses.location%TYPE := NULL;
56: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE := NULL;
57: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%TYPE := NULL;
58: l_ship_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
59: l_ship_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
60: l_term_id ra_terms.term_id%TYPE := NULL;

Line 57: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%TYPE := NULL;

53: l_ship_to_customer_name hz_parties.party_name%TYPE := NULL;
54: l_ship_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
55: l_ship_to_location hz_cust_site_uses.location%TYPE := NULL;
56: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE := NULL;
57: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%TYPE := NULL;
58: l_ship_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
59: l_ship_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
60: l_term_id ra_terms.term_id%TYPE := NULL;
61: l_salesrep_id ra_salesreps.salesrep_id%TYPE := NULL;

Line 97: l_document_number ra_customer_trx.doc_sequence_value%TYPE := NULL;

93: l_attribute13 VARCHAR2(150) := NULL;
94: l_attribute14 VARCHAR2(150) := NULL;
95: l_attribute15 VARCHAR2(150) := NULL;
96: l_global_attr_cust_rec ar_deposit_api_pub.global_attr_rec_type := NULL;
97: l_document_number ra_customer_trx.doc_sequence_value%TYPE := NULL;
98: l_ussgl_transaction_code ra_customer_trx.default_ussgl_transaction_code%TYPE := NULL;
99: l_printing_option ra_customer_trx.printing_option%TYPE := NULL;
100: l_default_tax_exempt_flag ra_customer_trx.default_tax_exempt_flag%TYPE := NULL;
101: l_status_trx ra_customer_trx.status_trx%TYPE := NULL;

Line 98: l_ussgl_transaction_code ra_customer_trx.default_ussgl_transaction_code%TYPE := NULL;

94: l_attribute14 VARCHAR2(150) := NULL;
95: l_attribute15 VARCHAR2(150) := NULL;
96: l_global_attr_cust_rec ar_deposit_api_pub.global_attr_rec_type := NULL;
97: l_document_number ra_customer_trx.doc_sequence_value%TYPE := NULL;
98: l_ussgl_transaction_code ra_customer_trx.default_ussgl_transaction_code%TYPE := NULL;
99: l_printing_option ra_customer_trx.printing_option%TYPE := NULL;
100: l_default_tax_exempt_flag ra_customer_trx.default_tax_exempt_flag%TYPE := NULL;
101: l_status_trx ra_customer_trx.status_trx%TYPE := NULL;
102: l_financial_charges ra_customer_trx.finance_charges%TYPE := NULL;

Line 99: l_printing_option ra_customer_trx.printing_option%TYPE := NULL;

95: l_attribute15 VARCHAR2(150) := NULL;
96: l_global_attr_cust_rec ar_deposit_api_pub.global_attr_rec_type := NULL;
97: l_document_number ra_customer_trx.doc_sequence_value%TYPE := NULL;
98: l_ussgl_transaction_code ra_customer_trx.default_ussgl_transaction_code%TYPE := NULL;
99: l_printing_option ra_customer_trx.printing_option%TYPE := NULL;
100: l_default_tax_exempt_flag ra_customer_trx.default_tax_exempt_flag%TYPE := NULL;
101: l_status_trx ra_customer_trx.status_trx%TYPE := NULL;
102: l_financial_charges ra_customer_trx.finance_charges%TYPE := NULL;
103: l_agreement_id ra_customer_trx.agreement_id%TYPE := NULL;

Line 100: l_default_tax_exempt_flag ra_customer_trx.default_tax_exempt_flag%TYPE := NULL;

96: l_global_attr_cust_rec ar_deposit_api_pub.global_attr_rec_type := NULL;
97: l_document_number ra_customer_trx.doc_sequence_value%TYPE := NULL;
98: l_ussgl_transaction_code ra_customer_trx.default_ussgl_transaction_code%TYPE := NULL;
99: l_printing_option ra_customer_trx.printing_option%TYPE := NULL;
100: l_default_tax_exempt_flag ra_customer_trx.default_tax_exempt_flag%TYPE := NULL;
101: l_status_trx ra_customer_trx.status_trx%TYPE := NULL;
102: l_financial_charges ra_customer_trx.finance_charges%TYPE := NULL;
103: l_agreement_id ra_customer_trx.agreement_id%TYPE := NULL;
104: l_special_instructions ra_customer_trx.special_instructions%TYPE := NULL;

Line 101: l_status_trx ra_customer_trx.status_trx%TYPE := NULL;

97: l_document_number ra_customer_trx.doc_sequence_value%TYPE := NULL;
98: l_ussgl_transaction_code ra_customer_trx.default_ussgl_transaction_code%TYPE := NULL;
99: l_printing_option ra_customer_trx.printing_option%TYPE := NULL;
100: l_default_tax_exempt_flag ra_customer_trx.default_tax_exempt_flag%TYPE := NULL;
101: l_status_trx ra_customer_trx.status_trx%TYPE := NULL;
102: l_financial_charges ra_customer_trx.finance_charges%TYPE := NULL;
103: l_agreement_id ra_customer_trx.agreement_id%TYPE := NULL;
104: l_special_instructions ra_customer_trx.special_instructions%TYPE := NULL;
105: l_comments ra_customer_trx.comments%TYPE := NULL;

Line 102: l_financial_charges ra_customer_trx.finance_charges%TYPE := NULL;

98: l_ussgl_transaction_code ra_customer_trx.default_ussgl_transaction_code%TYPE := NULL;
99: l_printing_option ra_customer_trx.printing_option%TYPE := NULL;
100: l_default_tax_exempt_flag ra_customer_trx.default_tax_exempt_flag%TYPE := NULL;
101: l_status_trx ra_customer_trx.status_trx%TYPE := NULL;
102: l_financial_charges ra_customer_trx.finance_charges%TYPE := NULL;
103: l_agreement_id ra_customer_trx.agreement_id%TYPE := NULL;
104: l_special_instructions ra_customer_trx.special_instructions%TYPE := NULL;
105: l_comments ra_customer_trx.comments%TYPE := NULL;
106: l_purchase_order ra_customer_trx.purchase_order%TYPE := NULL;

Line 103: l_agreement_id ra_customer_trx.agreement_id%TYPE := NULL;

99: l_printing_option ra_customer_trx.printing_option%TYPE := NULL;
100: l_default_tax_exempt_flag ra_customer_trx.default_tax_exempt_flag%TYPE := NULL;
101: l_status_trx ra_customer_trx.status_trx%TYPE := NULL;
102: l_financial_charges ra_customer_trx.finance_charges%TYPE := NULL;
103: l_agreement_id ra_customer_trx.agreement_id%TYPE := NULL;
104: l_special_instructions ra_customer_trx.special_instructions%TYPE := NULL;
105: l_comments ra_customer_trx.comments%TYPE := NULL;
106: l_purchase_order ra_customer_trx.purchase_order%TYPE := NULL;
107: l_purchase_order_revision ra_customer_trx.purchase_order_revision%TYPE := NULL;

Line 104: l_special_instructions ra_customer_trx.special_instructions%TYPE := NULL;

100: l_default_tax_exempt_flag ra_customer_trx.default_tax_exempt_flag%TYPE := NULL;
101: l_status_trx ra_customer_trx.status_trx%TYPE := NULL;
102: l_financial_charges ra_customer_trx.finance_charges%TYPE := NULL;
103: l_agreement_id ra_customer_trx.agreement_id%TYPE := NULL;
104: l_special_instructions ra_customer_trx.special_instructions%TYPE := NULL;
105: l_comments ra_customer_trx.comments%TYPE := NULL;
106: l_purchase_order ra_customer_trx.purchase_order%TYPE := NULL;
107: l_purchase_order_revision ra_customer_trx.purchase_order_revision%TYPE := NULL;
108: l_purchase_order_date ra_customer_trx.purchase_order_date%TYPE := NULL;

Line 105: l_comments ra_customer_trx.comments%TYPE := NULL;

101: l_status_trx ra_customer_trx.status_trx%TYPE := NULL;
102: l_financial_charges ra_customer_trx.finance_charges%TYPE := NULL;
103: l_agreement_id ra_customer_trx.agreement_id%TYPE := NULL;
104: l_special_instructions ra_customer_trx.special_instructions%TYPE := NULL;
105: l_comments ra_customer_trx.comments%TYPE := NULL;
106: l_purchase_order ra_customer_trx.purchase_order%TYPE := NULL;
107: l_purchase_order_revision ra_customer_trx.purchase_order_revision%TYPE := NULL;
108: l_purchase_order_date ra_customer_trx.purchase_order_date%TYPE := NULL;
109: l_remit_to_address_id ra_customer_trx.remit_to_address_id%TYPE := NULL;

Line 106: l_purchase_order ra_customer_trx.purchase_order%TYPE := NULL;

102: l_financial_charges ra_customer_trx.finance_charges%TYPE := NULL;
103: l_agreement_id ra_customer_trx.agreement_id%TYPE := NULL;
104: l_special_instructions ra_customer_trx.special_instructions%TYPE := NULL;
105: l_comments ra_customer_trx.comments%TYPE := NULL;
106: l_purchase_order ra_customer_trx.purchase_order%TYPE := NULL;
107: l_purchase_order_revision ra_customer_trx.purchase_order_revision%TYPE := NULL;
108: l_purchase_order_date ra_customer_trx.purchase_order_date%TYPE := NULL;
109: l_remit_to_address_id ra_customer_trx.remit_to_address_id%TYPE := NULL;
110: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;

Line 107: l_purchase_order_revision ra_customer_trx.purchase_order_revision%TYPE := NULL;

103: l_agreement_id ra_customer_trx.agreement_id%TYPE := NULL;
104: l_special_instructions ra_customer_trx.special_instructions%TYPE := NULL;
105: l_comments ra_customer_trx.comments%TYPE := NULL;
106: l_purchase_order ra_customer_trx.purchase_order%TYPE := NULL;
107: l_purchase_order_revision ra_customer_trx.purchase_order_revision%TYPE := NULL;
108: l_purchase_order_date ra_customer_trx.purchase_order_date%TYPE := NULL;
109: l_remit_to_address_id ra_customer_trx.remit_to_address_id%TYPE := NULL;
110: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
111: l_sold_to_customer_name hz_parties.party_name%TYPE := NULL;

Line 108: l_purchase_order_date ra_customer_trx.purchase_order_date%TYPE := NULL;

104: l_special_instructions ra_customer_trx.special_instructions%TYPE := NULL;
105: l_comments ra_customer_trx.comments%TYPE := NULL;
106: l_purchase_order ra_customer_trx.purchase_order%TYPE := NULL;
107: l_purchase_order_revision ra_customer_trx.purchase_order_revision%TYPE := NULL;
108: l_purchase_order_date ra_customer_trx.purchase_order_date%TYPE := NULL;
109: l_remit_to_address_id ra_customer_trx.remit_to_address_id%TYPE := NULL;
110: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
111: l_sold_to_customer_name hz_parties.party_name%TYPE := NULL;
112: l_sold_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;

Line 109: l_remit_to_address_id ra_customer_trx.remit_to_address_id%TYPE := NULL;

105: l_comments ra_customer_trx.comments%TYPE := NULL;
106: l_purchase_order ra_customer_trx.purchase_order%TYPE := NULL;
107: l_purchase_order_revision ra_customer_trx.purchase_order_revision%TYPE := NULL;
108: l_purchase_order_date ra_customer_trx.purchase_order_date%TYPE := NULL;
109: l_remit_to_address_id ra_customer_trx.remit_to_address_id%TYPE := NULL;
110: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
111: l_sold_to_customer_name hz_parties.party_name%TYPE := NULL;
112: l_sold_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
113: l_paying_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;

Line 110: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;

106: l_purchase_order ra_customer_trx.purchase_order%TYPE := NULL;
107: l_purchase_order_revision ra_customer_trx.purchase_order_revision%TYPE := NULL;
108: l_purchase_order_date ra_customer_trx.purchase_order_date%TYPE := NULL;
109: l_remit_to_address_id ra_customer_trx.remit_to_address_id%TYPE := NULL;
110: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
111: l_sold_to_customer_name hz_parties.party_name%TYPE := NULL;
112: l_sold_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
113: l_paying_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
114: l_paying_customer_name hz_parties.party_name%TYPE := NULL;

Line 113: l_paying_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;

109: l_remit_to_address_id ra_customer_trx.remit_to_address_id%TYPE := NULL;
110: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
111: l_sold_to_customer_name hz_parties.party_name%TYPE := NULL;
112: l_sold_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
113: l_paying_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
114: l_paying_customer_name hz_parties.party_name%TYPE := NULL;
115: l_paying_customer_number hz_cust_accounts.account_number%TYPE := NULL;
116: l_paying_location hz_cust_site_uses.location%TYPE := NULL;
117: l_receipt_method_id ra_customer_trx.receipt_method_id%TYPE := NULL;

Line 117: l_receipt_method_id ra_customer_trx.receipt_method_id%TYPE := NULL;

113: l_paying_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
114: l_paying_customer_name hz_parties.party_name%TYPE := NULL;
115: l_paying_customer_number hz_cust_accounts.account_number%TYPE := NULL;
116: l_paying_location hz_cust_site_uses.location%TYPE := NULL;
117: l_receipt_method_id ra_customer_trx.receipt_method_id%TYPE := NULL;
118: l_receipt_method_name ar_receipt_methods.name%TYPE := NULL;
119: l_cust_bank_account_id ra_customer_trx.customer_bank_account_id%TYPE := NULL;
120: l_cust_bank_account_name ap_bank_accounts.bank_account_name%TYPE := NULL;
121: l_cust_bank_account_number ap_bank_accounts.bank_account_num%TYPE := NULL;

Line 119: l_cust_bank_account_id ra_customer_trx.customer_bank_account_id%TYPE := NULL;

115: l_paying_customer_number hz_cust_accounts.account_number%TYPE := NULL;
116: l_paying_location hz_cust_site_uses.location%TYPE := NULL;
117: l_receipt_method_id ra_customer_trx.receipt_method_id%TYPE := NULL;
118: l_receipt_method_name ar_receipt_methods.name%TYPE := NULL;
119: l_cust_bank_account_id ra_customer_trx.customer_bank_account_id%TYPE := NULL;
120: l_cust_bank_account_name ap_bank_accounts.bank_account_name%TYPE := NULL;
121: l_cust_bank_account_number ap_bank_accounts.bank_account_num%TYPE := NULL;
122: l_start_date_commitment DATE := NULL;
123: l_end_date_commitment DATE := NULL;

Line 148: X_new_trx_number ra_customer_trx.trx_number%TYPE := NULL;

144: l_comm_interface_line_attr15 VARCHAR2(150) := NULL;
145: l_global_attr_cust_lines_rec ar_deposit_api_pub.global_attr_rec_type := NULL;
146: l_org_id NUMBER := NULL;
147: l_payment_trxn_extension_id NUMBER := NULL;
148: X_new_trx_number ra_customer_trx.trx_number%TYPE := NULL;
149: X_new_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := NULL;
150: X_new_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE := NULL;
151: X_new_rowid VARCHAR2(18) := NULL;
152: l_batch_source_id ra_batch_sources.batch_source_id%TYPE := NULL;

Line 149: X_new_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := NULL;

145: l_global_attr_cust_lines_rec ar_deposit_api_pub.global_attr_rec_type := NULL;
146: l_org_id NUMBER := NULL;
147: l_payment_trxn_extension_id NUMBER := NULL;
148: X_new_trx_number ra_customer_trx.trx_number%TYPE := NULL;
149: X_new_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := NULL;
150: X_new_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE := NULL;
151: X_new_rowid VARCHAR2(18) := NULL;
152: l_batch_source_id ra_batch_sources.batch_source_id%TYPE := NULL;
153: l_batch_source_name ra_batch_sources.NAME%TYPE := NULL;

Line 150: X_new_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE := NULL;

146: l_org_id NUMBER := NULL;
147: l_payment_trxn_extension_id NUMBER := NULL;
148: X_new_trx_number ra_customer_trx.trx_number%TYPE := NULL;
149: X_new_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := NULL;
150: X_new_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE := NULL;
151: X_new_rowid VARCHAR2(18) := NULL;
152: l_batch_source_id ra_batch_sources.batch_source_id%TYPE := NULL;
153: l_batch_source_name ra_batch_sources.NAME%TYPE := NULL;
154: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE := NULL;

Line 495: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;

491: l_issuer_name ar_cash_receipts.issuer_name%TYPE DEFAULT NULL;
492: l_issue_date ar_cash_receipts.issue_date%TYPE DEFAULT NULL;
493: l_issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL;
494: l_cr_id NUMBER DEFAULT NULL;
495: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
496: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;
497: l_installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL;
498: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL;
499: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;

Line 496: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;

492: l_issue_date ar_cash_receipts.issue_date%TYPE DEFAULT NULL;
493: l_issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL;
494: l_cr_id NUMBER DEFAULT NULL;
495: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
496: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;
497: l_installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL;
498: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL;
499: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;
500: l_amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL;

Line 507: l_line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL;

503: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
504: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
505: app_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
506: l_customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL;
507: l_line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL;
508: l_show_closed_invoices VARCHAR2(1) DEFAULT 'N';
509: l_move_deferred_tax VARCHAR2(1) DEFAULT 'Y';
510: l_link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL;
511: app_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;

Line 663: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;

659: l_api_name VARCHAR2(50) := 'unapply_emd_receipt';
660: l_progress NUMBER;
661: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
662: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;
663: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;
664: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
665: l_installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL;
666: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL;
667: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL;

Line 664: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;

660: l_progress NUMBER;
661: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
662: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;
663: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;
664: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
665: l_installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL;
666: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL;
667: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL;
668: l_reversal_gl_date ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL;

Line 789: l_link_to_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;

785: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;
786: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
787: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;
788: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE; --this has no default
789: l_link_to_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
790: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE; --this has no default
791: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
792: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
793: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;

Line 1019: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

1015:
1016: l_api_version NUMBER := 1.0;
1017: l_api_name VARCHAR2(50) := 'create_cm_on_emd_deposit';
1018: l_progress NUMBER;
1019: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1020: l_line_credit_flag ra_cm_requests.line_credits_flag%type;
1021: l_line_amount NUMBER := NULL;
1022: l_tax_amount NUMBER := NULL;
1023: l_freight_amount NUMBER := NULL;

Line 1033: l_credit_method_installments ra_customer_trx.credit_method_for_installments%type DEFAULT NULL;

1029: l_transaction_url ra_cm_requests.transaction_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1030: l_trans_act_url ra_cm_requests.activities_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1031: l_cm_line_tbl arw_cmreq_cover.Cm_Line_Tbl_Type_Cover := ar_credit_memo_api_pub.cm_line_tbl_type_cover ;
1032: l_skip_workflow_flag VARCHAR2(1) DEFAULT 'N';
1033: l_credit_method_installments ra_customer_trx.credit_method_for_installments%type DEFAULT NULL;
1034: l_credit_method_rules ra_customer_trx.credit_method_for_rules%type DEFAULT NULL;
1035: l_batch_source_name ra_batch_sources.NAME%TYPE DEFAULT NULL;
1036: l_org_id NUMBER DEFAULT NULL;
1037: x_request_id ra_cm_requests.request_id%type;

Line 1034: l_credit_method_rules ra_customer_trx.credit_method_for_rules%type DEFAULT NULL;

1030: l_trans_act_url ra_cm_requests.activities_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1031: l_cm_line_tbl arw_cmreq_cover.Cm_Line_Tbl_Type_Cover := ar_credit_memo_api_pub.cm_line_tbl_type_cover ;
1032: l_skip_workflow_flag VARCHAR2(1) DEFAULT 'N';
1033: l_credit_method_installments ra_customer_trx.credit_method_for_installments%type DEFAULT NULL;
1034: l_credit_method_rules ra_customer_trx.credit_method_for_rules%type DEFAULT NULL;
1035: l_batch_source_name ra_batch_sources.NAME%TYPE DEFAULT NULL;
1036: l_org_id NUMBER DEFAULT NULL;
1037: x_request_id ra_cm_requests.request_id%type;
1038: l_attribute_rec arw_cmreq_cover.pq_attribute_rec_type DEFAULT ar_credit_memo_api_pub.attribute_rec_const;

Line 1195: FROM ra_customer_trx_all rx,

1191: SELECT rx.TRX_NUMBER,
1192: rl.customer_trx_line_id
1193: INTO x_out_rec.cm_trx_number,
1194: x_out_rec.cm_customer_trx_line_id
1195: FROM ra_customer_trx_all rx,
1196: ra_customer_trx_lines_all rl
1197: WHERE rx.customer_trx_id = x_cm_customer_trx_id
1198: AND rl.customer_trx_id = rx.customer_trx_id;
1199: END IF;

Line 1196: ra_customer_trx_lines_all rl

1192: rl.customer_trx_line_id
1193: INTO x_out_rec.cm_trx_number,
1194: x_out_rec.cm_customer_trx_line_id
1195: FROM ra_customer_trx_all rx,
1196: ra_customer_trx_lines_all rl
1197: WHERE rx.customer_trx_id = x_cm_customer_trx_id
1198: AND rl.customer_trx_id = rx.customer_trx_id;
1199: END IF;
1200: x_out_rec.cm_customer_trx_id := x_cm_customer_trx_id;

Line 4330: ra_customer_trx_all rct,

4326: Max(arp.receivable_application_id)
4327: INTO x_cash_receipt_id,
4328: x_receivable_app_id
4329: from ar_receivable_applications_all arp,
4330: ra_customer_trx_all rct,
4331: ra_cust_trx_types_all ctyp,
4332: ar_cash_receipts_all acr
4333: where arp.applied_customer_trx_id = p_parent_trx_id
4334: AND arp.org_id = p_org_id

Line 4416: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;

4412: x_return_status OUT NOCOPY VARCHAR2)
4413: IS
4414: l_module_name VARCHAR2(20);
4415: l_module_version VARCHAR2(1);
4416: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
4417: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
4418: l_org_id NUMBER;
4419: l_period_name gl_period_statuses.period_name%TYPE;
4420: l_auction_status pon_auction_headers_all.AUCTION_STATUS%TYPE;

Line 4417: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;

4413: IS
4414: l_module_name VARCHAR2(20);
4415: l_module_version VARCHAR2(1);
4416: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
4417: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
4418: l_org_id NUMBER;
4419: l_period_name gl_period_statuses.period_name%TYPE;
4420: l_auction_status pon_auction_headers_all.AUCTION_STATUS%TYPE;
4421: l_document_num pon_auction_headers_all.document_number%TYPE;

Line 5551: l_deposit_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;

5547: invalid_value VARCHAR2(240);
5548: concat_err_msg VARCHAR2(2000);
5549: l_return_status VARCHAR2(1);
5550: l_cust_trx_name ra_cust_trx_types.NAME%TYPE;
5551: l_deposit_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
5552: l_emd_transactions_info pon_emd_trx_rec;
5553: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
5554: l_trx_number ra_customer_trx.trx_number%TYPE;
5555: l_memo_desc ar_memo_lines_all_tl.description%TYPE;

Line 5553: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

5549: l_return_status VARCHAR2(1);
5550: l_cust_trx_name ra_cust_trx_types.NAME%TYPE;
5551: l_deposit_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
5552: l_emd_transactions_info pon_emd_trx_rec;
5553: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
5554: l_trx_number ra_customer_trx.trx_number%TYPE;
5555: l_memo_desc ar_memo_lines_all_tl.description%TYPE;
5556: l_memo_name ar_memo_lines_all_tl.name%TYPE; -- bug 8628651
5557: l_term_name VARCHAR2(25);

Line 5554: l_trx_number ra_customer_trx.trx_number%TYPE;

5550: l_cust_trx_name ra_cust_trx_types.NAME%TYPE;
5551: l_deposit_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
5552: l_emd_transactions_info pon_emd_trx_rec;
5553: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
5554: l_trx_number ra_customer_trx.trx_number%TYPE;
5555: l_memo_desc ar_memo_lines_all_tl.description%TYPE;
5556: l_memo_name ar_memo_lines_all_tl.name%TYPE; -- bug 8628651
5557: l_term_name VARCHAR2(25);
5558:

Line 5645: FROM ra_customer_trx_lines_all

5641:
5642: BEGIN
5643: SELECT customer_trx_line_id
5644: INTO l_deposit_trx_line_id
5645: FROM ra_customer_trx_lines_all
5646: WHERE customer_trx_id = p_in_rec.deposit_trx_id
5647: AND org_id = p_in_rec.org_id
5648: AND ROWNUM =1;
5649: EXCEPTION

Line 5656: SELECT ra_customer_trx_lines_s.NEXTVAL INTO l_interface_line_id FROM DUAL;

5652: RETURN;
5653: END;
5654:
5655: /* Bug 8784319 */
5656: SELECT ra_customer_trx_lines_s.NEXTVAL INTO l_interface_line_id FROM DUAL;
5657:
5658: print_log('l_interface_line_id'||l_interface_line_id);
5659: --Inserting into ra_interface_lines_all before calling auto invoice program
5660: print_log('Before inserting records into ra_interface_lines');

Line 5871: FROM ra_customer_trx_all rc, ra_customer_trx_lines_all rcl

5867: SELECT rc.CUSTOMER_TRX_ID,
5868: rc.TRX_NUMBER
5869: INTO l_customer_trx_id,
5870: l_trx_number
5871: FROM ra_customer_trx_all rc, ra_customer_trx_lines_all rcl
5872: WHERE rc.CUSTOMER_TRX_ID = rcl.CUSTOMER_TRX_ID
5873: AND rcl.INTERFACE_LINE_CONTEXT = 'EMD TRANSACTIONS'
5874: AND rcl.INTERFACE_LINE_ATTRIBUTE7 = to_char(l_emd_transactions_info.emd_trx_group_id)
5875: AND rcl.INTERFACE_LINE_ATTRIBUTE8 = to_char(l_emd_transactions_info.emd_transaction_id)