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 66: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,

62: x_msg_count OUT NOCOPY NUMBER,
63: x_msg_data OUT NOCOPY VARCHAR2,
64: -- Receipt info. parameters
65: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
66: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
67: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
68: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
69: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
70: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,

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

64: -- Receipt info. parameters
65: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
66: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
67: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
68: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
69: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
70: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
71: p_amount IN ar_cash_receipts.amount%TYPE,
72: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,

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

65: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
66: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
67: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
68: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
69: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
70: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
71: p_amount IN ar_cash_receipts.amount%TYPE,
72: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
73:

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

66: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
67: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
68: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
69: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
70: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
71: p_amount IN ar_cash_receipts.amount%TYPE,
72: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
73:
74: -------Multiple Prepay project: Receipt Number should be IN OUT

Line 71: p_amount IN ar_cash_receipts.amount%TYPE,

67: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
68: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
69: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
70: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
71: p_amount IN ar_cash_receipts.amount%TYPE,
72: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
73:
74: -------Multiple Prepay project: Receipt Number should be IN OUT
75: p_receipt_number IN OUT NOCOPY ar_cash_receipts.receipt_number%TYPE ,

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

68: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
69: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
70: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
71: p_amount IN ar_cash_receipts.amount%TYPE,
72: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
73:
74: -------Multiple Prepay project: Receipt Number should be IN OUT
75: p_receipt_number IN OUT NOCOPY ar_cash_receipts.receipt_number%TYPE ,
76:

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

71: p_amount IN ar_cash_receipts.amount%TYPE,
72: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
73:
74: -------Multiple Prepay project: Receipt Number should be IN OUT
75: p_receipt_number IN OUT NOCOPY ar_cash_receipts.receipt_number%TYPE ,
76:
77: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
78: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
79: p_maturity_date IN DATE DEFAULT NULL,

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

73:
74: -------Multiple Prepay project: Receipt Number should be IN OUT
75: p_receipt_number IN OUT NOCOPY ar_cash_receipts.receipt_number%TYPE ,
76:
77: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
78: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
79: p_maturity_date IN DATE DEFAULT NULL,
80: p_postmark_date IN DATE DEFAULT NULL,
81: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

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

77: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
78: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
79: p_maturity_date IN DATE DEFAULT NULL,
80: p_postmark_date IN DATE DEFAULT NULL,
81: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
82: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
83: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
84: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
85: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,

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

80: p_postmark_date IN DATE DEFAULT NULL,
81: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
82: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
83: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
84: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
85: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
86: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
87: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
88: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,

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

85: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
86: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
87: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
88: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
89: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
90: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
91: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,
92: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
93: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,

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

86: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
87: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
88: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
89: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
90: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
91: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,
92: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
93: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
94: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,

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

87: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
88: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
89: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
90: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
91: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,
92: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
93: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
94: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
95: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

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

90: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
91: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,
92: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
93: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
94: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
95: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
96: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
97: p_doc_sequence_value IN NUMBER DEFAULT NULL,
98: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,

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

91: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,
92: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
93: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
94: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
95: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
96: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
97: p_doc_sequence_value IN NUMBER DEFAULT NULL,
98: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
99: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,

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

94: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
95: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
96: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
97: p_doc_sequence_value IN NUMBER DEFAULT NULL,
98: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
99: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
100: p_called_from IN VARCHAR2 DEFAULT NULL,
101: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
102: DEFAULT ar_receipt_api_pub.attribute_rec_const,

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

95: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
96: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
97: p_doc_sequence_value IN NUMBER DEFAULT NULL,
98: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
99: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
100: p_called_from IN VARCHAR2 DEFAULT NULL,
101: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
102: DEFAULT ar_receipt_api_pub.attribute_rec_const,
103: -- ******* Global Flexfield parameters *******

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

104: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
105: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
106: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
107: -- *** Notes Receivable Additional Information ***
108: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
109: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
110: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
111: -- ** OUT NOCOPY variables for Creating receipt
112: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

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

105: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
106: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
107: -- *** Notes Receivable Additional Information ***
108: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
109: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
110: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
111: -- ** OUT NOCOPY variables for Creating receipt
112: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
113: -- Receipt application parameters

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

106: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
107: -- *** Notes Receivable Additional Information ***
108: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
109: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
110: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
111: -- ** OUT NOCOPY variables for Creating receipt
112: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
113: -- Receipt application parameters
114: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

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

108: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
109: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
110: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
111: -- ** OUT NOCOPY variables for Creating receipt
112: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
113: -- Receipt application parameters
114: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
115: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
116: p_application_ref_type IN VARCHAR2 DEFAULT NULL,

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

130: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
131: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
132: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
133: -- processor such as iPayments
134: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
135: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
136:
137: ---Bug 3220078 Change the parameter to TRUE
138: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,

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

131: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
132: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
133: -- processor such as iPayments
134: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
135: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
136:
137: ---Bug 3220078 Change the parameter to TRUE
138: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,
139:

Line 145: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE

141: -- OUT NOCOPY parameter for the Application
142: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
143: p_payment_set_id IN OUT NOCOPY NUMBER ,
144: p_org_id IN NUMBER DEFAULT NULL,
145: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE
146: ) IS
147:
148:
149: l_cash_receipt_id NUMBER(15);

Line 180: FROM ar_cash_receipts_all cr,

176: cr.payment_trxn_extension_id,
177: party.party_id,
178: cr.pay_from_customer,
179: cr.customer_site_use_id
180: FROM ar_cash_receipts_all cr,
181: ar_receipt_methods rm,
182: ar_receipt_classes rc,
183: hz_cust_accounts hca,
184: hz_parties party

Line 192: l_cr_rec ar_cash_receipts_all%ROWTYPE;

188: AND cr.receipt_method_id = rm.receipt_method_id
189: and rm.receipt_class_id = rc.receipt_class_id;
190:
191: rct_info rct_info_cur%ROWTYPE;
192: l_cr_rec ar_cash_receipts_all%ROWTYPE;
193: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
194: l_action VARCHAR2(80);
195: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
196: l_msg_count NUMBER;

Line 200: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

196: l_msg_count NUMBER;
197: l_msg_data VARCHAR2(2000);
198: l_iby_msg_data VARCHAR2(2000);
199: l_vend_msg_data VARCHAR2(2000);
200: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
201:
202: /* DECLARE the variables required for the payment engine (CPY ) all the REC TYPES */
203: p_trxn_entity_id NUMBER;
204: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;

Line 798: FROM ar_cash_receipts cr, ar_receipt_classes rc,

794:
795: ----get the status and payment method of of the receipt -----
796: SELECT rc.creation_status , nvl(rm.payment_channel_code, 'CHECK')
797: INTO l_cash_receipt_status, l_payment_type
798: FROM ar_cash_receipts cr, ar_receipt_classes rc,
799: ar_receipt_methods rm
800: WHERE cr.cash_receipt_id = l_cash_receipt_id
801: AND cr.receipt_method_id = rm.receipt_method_id
802: AND rm.receipt_class_id = rc.receipt_class_id;