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_PUB dependencies on AR_CASH_RECEIPTS

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

78: x_msg_count OUT NOCOPY NUMBER,
79: x_msg_data OUT NOCOPY VARCHAR2,
80: -- Receipt info. parameters
81: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
82: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
83: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
84: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
85: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
86: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,

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

80: -- Receipt info. parameters
81: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
82: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
83: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
84: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
85: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
86: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
87: p_amount IN ar_cash_receipts.amount%TYPE,
88: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,

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

81: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
82: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
83: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
84: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
85: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
86: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
87: p_amount IN ar_cash_receipts.amount%TYPE,
88: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
89:

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

82: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
83: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
84: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
85: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
86: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
87: p_amount IN ar_cash_receipts.amount%TYPE,
88: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
89:
90: -----Multiple prepayments project: receipt number should be IN OUT

Line 87: p_amount IN ar_cash_receipts.amount%TYPE,

83: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
84: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
85: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
86: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
87: p_amount IN ar_cash_receipts.amount%TYPE,
88: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
89:
90: -----Multiple prepayments project: receipt number should be IN OUT
91: p_receipt_number IN OUT NOCOPY ar_cash_receipts.receipt_number%TYPE,

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

84: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
85: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
86: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
87: p_amount IN ar_cash_receipts.amount%TYPE,
88: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
89:
90: -----Multiple prepayments project: receipt number should be IN OUT
91: p_receipt_number IN OUT NOCOPY ar_cash_receipts.receipt_number%TYPE,
92:

Line 91: p_receipt_number IN OUT NOCOPY ar_cash_receipts.receipt_number%TYPE,

87: p_amount IN ar_cash_receipts.amount%TYPE,
88: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
89:
90: -----Multiple prepayments project: receipt number should be IN OUT
91: p_receipt_number IN OUT NOCOPY ar_cash_receipts.receipt_number%TYPE,
92:
93: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
94: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
95: p_maturity_date IN DATE DEFAULT NULL,

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

89:
90: -----Multiple prepayments project: receipt number should be IN OUT
91: p_receipt_number IN OUT NOCOPY ar_cash_receipts.receipt_number%TYPE,
92:
93: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
94: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
95: p_maturity_date IN DATE DEFAULT NULL,
96: p_postmark_date IN DATE DEFAULT NULL,
97: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

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

93: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
94: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
95: p_maturity_date IN DATE DEFAULT NULL,
96: p_postmark_date IN DATE DEFAULT NULL,
97: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
98: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
99: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
100: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
101: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,

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

96: p_postmark_date IN DATE DEFAULT NULL,
97: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
98: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
99: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
100: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
101: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
102: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
103: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
104: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,

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

101: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
102: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
103: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
104: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
105: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
106: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
107: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,
108: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
109: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,

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

102: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
103: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
104: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
105: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
106: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
107: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,
108: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
109: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
110: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,

Line 107: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,

103: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
104: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
105: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
106: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
107: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,
108: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
109: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
110: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
111: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

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

106: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
107: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,
108: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
109: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
110: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
111: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
112: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
113: p_doc_sequence_value IN NUMBER DEFAULT NULL,
114: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,

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

107: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,
108: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
109: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
110: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
111: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
112: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
113: p_doc_sequence_value IN NUMBER DEFAULT NULL,
114: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
115: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,

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

110: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
111: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
112: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
113: p_doc_sequence_value IN NUMBER DEFAULT NULL,
114: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
115: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
116: p_called_from IN VARCHAR2 DEFAULT NULL,
117: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
118: DEFAULT ar_receipt_api_pub.attribute_rec_const,

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

111: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
112: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
113: p_doc_sequence_value IN NUMBER DEFAULT NULL,
114: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
115: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
116: p_called_from IN VARCHAR2 DEFAULT NULL,
117: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
118: DEFAULT ar_receipt_api_pub.attribute_rec_const,
119: -- ******* Global Flexfield parameters *******

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

120: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
121: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
122: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
123: -- *** Notes Receivable Additional Information ***
124: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
125: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
126: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
127: -- ** OUT NOCOPY variables for Creating receipt
128: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

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

121: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
122: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
123: -- *** Notes Receivable Additional Information ***
124: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
125: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
126: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
127: -- ** OUT NOCOPY variables for Creating receipt
128: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
129: -- Receipt application parameters

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

122: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
123: -- *** Notes Receivable Additional Information ***
124: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
125: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
126: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
127: -- ** OUT NOCOPY variables for Creating receipt
128: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
129: -- Receipt application parameters
130: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

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

124: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
125: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
126: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
127: -- ** OUT NOCOPY variables for Creating receipt
128: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
129: -- Receipt application parameters
130: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
131: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
132: p_application_ref_type IN VARCHAR2 DEFAULT NULL,

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

146: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
147: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
148: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
149: -- processor such as iPayments
150: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
151: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
152:
153: ---Bug 3220078 Change the parameter to TRUE
154: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,

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

147: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
148: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
149: -- processor such as iPayments
150: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
151: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
152:
153: ---Bug 3220078 Change the parameter to TRUE
154: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,
155:

Line 162: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL

158: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
159: p_payment_set_id IN OUT NOCOPY NUMBER,
160: p_org_id IN NUMBER DEFAULT NULL,
161: -- bug 4491278 payment uptake project
162: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL
163: );
164: /*#
165: * Use this procedure to calculate the amount of all the installments of
166: * a given payment term.