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.AR_PREPAYMENTS dependencies on AR_CASH_RECEIPTS

Line 60: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,

56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2,
58: -- Receipt info. parameters
59: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
60: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
61: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
62: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
63: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
64: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,

Line 62: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,

58: -- Receipt info. parameters
59: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
60: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
61: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
62: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
63: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
64: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
65: p_amount IN ar_cash_receipts.amount%TYPE,
66: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,

Line 63: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,

59: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
60: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
61: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
62: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
63: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
64: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
65: p_amount IN ar_cash_receipts.amount%TYPE,
66: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
67:

Line 64: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,

60: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
61: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
62: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
63: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
64: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
65: p_amount IN ar_cash_receipts.amount%TYPE,
66: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
67:
68: --Bug:3106245 can not have a parameter as IN OUT

Line 65: p_amount IN ar_cash_receipts.amount%TYPE,

61: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
62: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
63: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
64: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
65: p_amount IN ar_cash_receipts.amount%TYPE,
66: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
67:
68: --Bug:3106245 can not have a parameter as IN OUT
69: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

Line 66: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,

62: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
63: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
64: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
65: p_amount IN ar_cash_receipts.amount%TYPE,
66: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
67:
68: --Bug:3106245 can not have a parameter as IN OUT
69: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
70:

Line 69: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

65: p_amount IN ar_cash_receipts.amount%TYPE,
66: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
67:
68: --Bug:3106245 can not have a parameter as IN OUT
69: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
70:
71: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
72: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
73: p_maturity_date IN DATE DEFAULT NULL,

Line 71: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,

67:
68: --Bug:3106245 can not have a parameter as IN OUT
69: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
70:
71: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
72: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
73: p_maturity_date IN DATE DEFAULT NULL,
74: p_postmark_date IN DATE DEFAULT NULL,
75: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

Line 75: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

71: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
72: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
73: p_maturity_date IN DATE DEFAULT NULL,
74: p_postmark_date IN DATE DEFAULT NULL,
75: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
76: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
77: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
78: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
79: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,

Line 78: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,

74: p_postmark_date IN DATE DEFAULT NULL,
75: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
76: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
77: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
78: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
79: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
80: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
81: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
82: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,

Line 83: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,

79: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
80: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
81: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
82: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
83: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
84: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
85: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
86: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
87: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,

Line 84: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,

80: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
81: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
82: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
83: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
84: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
85: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
86: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
87: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
88: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,

Line 85: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,

81: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
82: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
83: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
84: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
85: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
86: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
87: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
88: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
89: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

Line 88: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,

84: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
85: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
86: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
87: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
88: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
89: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
90: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
91: p_doc_sequence_value IN NUMBER DEFAULT NULL,
92: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 89: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

85: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
86: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
87: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
88: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
89: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
90: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
91: p_doc_sequence_value IN NUMBER DEFAULT NULL,
92: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
93: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,

Line 92: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,

88: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
89: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
90: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
91: p_doc_sequence_value IN NUMBER DEFAULT NULL,
92: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
93: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
94: p_called_from IN VARCHAR2 DEFAULT NULL,
95: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
96: DEFAULT ar_receipt_api_pub.attribute_rec_const,

Line 93: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,

89: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
90: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
91: p_doc_sequence_value IN NUMBER DEFAULT NULL,
92: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
93: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
94: p_called_from IN VARCHAR2 DEFAULT NULL,
95: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
96: DEFAULT ar_receipt_api_pub.attribute_rec_const,
97: -- ******* Global Flexfield parameters *******

Line 102: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,

98: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
99: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
100: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
101: -- *** Notes Receivable Additional Information ***
102: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
103: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
104: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
105: -- ** OUT NOCOPY variables for Creating receipt
106: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

Line 103: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,

99: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
100: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
101: -- *** Notes Receivable Additional Information ***
102: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
103: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
104: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
105: -- ** OUT NOCOPY variables for Creating receipt
106: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
107: -- Receipt application parameters

Line 104: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,

100: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
101: -- *** Notes Receivable Additional Information ***
102: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
103: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
104: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
105: -- ** OUT NOCOPY variables for Creating receipt
106: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
107: -- Receipt application parameters
108: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

Line 106: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

102: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
103: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
104: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
105: -- ** OUT NOCOPY variables for Creating receipt
106: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
107: -- Receipt application parameters
108: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
109: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
110: p_application_ref_type IN VARCHAR2 DEFAULT NULL,

Line 128: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,

124: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
125: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
126: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
127: -- processor such as iPayments
128: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
129: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
130: --- Bug: 3220078 Change the p_call_payment_processor to TRUE ---
131: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,
132:

Line 129: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,

125: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
126: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
127: -- processor such as iPayments
128: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
129: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
130: --- Bug: 3220078 Change the p_call_payment_processor to TRUE ---
131: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,
132:
133: p_payment_response_error_code OUT NOCOPY VARCHAR2,

Line 138: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE

134: -- OUT NOCOPY parameter for the Application
135: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
136: p_payment_set_id IN OUT NOCOPY NUMBER,
137: p_org_id IN NUMBER DEFAULT NULL,
138: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE
139: );
140:
141: /*========================================================================
142: | PUBLIC Procedure refund_prepayments

Line 183: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_prepay_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
182: p_number_of_refund_receipts OUT NOCOPY NUMBER,
183: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
184: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
185: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
186: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
187: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

Line 184: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_prepay_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
182: p_number_of_refund_receipts OUT NOCOPY NUMBER,
183: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
184: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
185: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
186: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
187: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
188: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,