APPS.ARP_PROCESS_MISC_RECEIPTS dependencies on AR_CASH_RECEIPTS

Line 185: l_cr_rec ar_cash_receipts%ROWTYPE;

181: p_tax_rate IN NUMBER,
182: p_gl_tax_acct IN VARCHAR2, /* Bug fix 2300268 */
183: p_legal_entity_id IN NUMBER ) IS
184:
185: l_cr_rec ar_cash_receipts%ROWTYPE;
186: l_crh_rec ar_cash_receipt_history%ROWTYPE;
187: l_dist_rec ar_distributions%ROWTYPE;
188: l_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
189: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;

Line 190: l_override_dummy ar_cash_receipts.override_remit_account_flag%TYPE;

186: l_crh_rec ar_cash_receipt_history%ROWTYPE;
187: l_dist_rec ar_distributions%ROWTYPE;
188: l_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
189: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
190: l_override_dummy ar_cash_receipts.override_remit_account_flag%TYPE;
191: l_dummy NUMBER;
192: l_source_type ar_distributions.source_type%TYPE;
193: l_creation_status ar_cash_receipt_history.status%TYPE;
194: l_old_distribution_set_id ar_cash_receipts.distribution_set_id%TYPE;

Line 194: l_old_distribution_set_id ar_cash_receipts.distribution_set_id%TYPE;

190: l_override_dummy ar_cash_receipts.override_remit_account_flag%TYPE;
191: l_dummy NUMBER;
192: l_source_type ar_distributions.source_type%TYPE;
193: l_creation_status ar_cash_receipt_history.status%TYPE;
194: l_old_distribution_set_id ar_cash_receipts.distribution_set_id%TYPE;
195: l_dist_set_changed_flag BOOLEAN;
196: l_amount_changed_flag BOOLEAN;
197: l_gl_date_changed_flag BOOLEAN;
198: l_receipt_date_changed_flag BOOLEAN;

Line 373: from ar_cash_receipts

369: l_cr_rec.customer_bank_account_id,
370: l_cr_rec.customer_site_use_id,
371: l_cr_rec.payment_server_order_num,
372: l_cr_rec.approval_code
373: from ar_cash_receipts
374: where cash_receipt_id = p_reference_id;
375:
376: EXCEPTION
377: WHEN no_data_found THEN

Line 612: FROM AR_CASH_RECEIPTS_V

608: INTO p_new_status,
609: p_new_status_dsp,
610: p_new_state,
611: p_new_state_dsp
612: FROM AR_CASH_RECEIPTS_V
613: WHERE cash_receipt_id = p_cash_receipt_id; */
614:
615: SELECT cr.status,
616: l_cr_status.meaning,

Line 625: ar_cash_receipts cr,

621: p_new_state,
622: p_new_state_dsp
623: FROM
624: ar_cash_receipt_history crh_current,
625: ar_cash_receipts cr,
626: ar_lookups l_cr_status,
627: ar_lookups l_crh_status
628: WHERE
629: cr.cash_receipt_id = p_cash_receipt_id

Line 770: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE,

766: p_tax_rate IN NUMBER,
767: p_gl_tax_acct IN VARCHAR2 , /* Bug fix 2300268 */
768: p_crh_id OUT NOCOPY NUMBER, /* Bug fix 2742388 */
769: p_legal_entity_id IN NUMBER,
770: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE,
771: p_postmark_date IN DATE /* Bug Fix 13084383 */
772: ) IS
773: l_creation_status ar_cash_receipt_history.status%TYPE;
774: l_cr_rec ar_cash_receipts%ROWTYPE;

Line 774: l_cr_rec ar_cash_receipts%ROWTYPE;

770: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE,
771: p_postmark_date IN DATE /* Bug Fix 13084383 */
772: ) IS
773: l_creation_status ar_cash_receipt_history.status%TYPE;
774: l_cr_rec ar_cash_receipts%ROWTYPE;
775: l_crh_rec ar_cash_receipt_history%ROWTYPE;
776: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
777: l_source_type ar_distributions.source_type%TYPE;
778: l_override_remit_account_flag

Line 847: from ar_cash_receipts

843: l_cr_rec.customer_bank_account_id,
844: l_cr_rec.customer_site_use_id,
845: l_cr_rec.payment_server_order_num,
846: l_cr_rec.approval_code
847: from ar_cash_receipts
848: where cash_receipt_id = p_reference_id;
849:
850:
851: EXCEPTION

Line 980: FROM ar_cash_receipts

976: -- get the ROWID out NOCOPY parameter:
977:
978: SELECT rowid
979: INTO p_row_id
980: FROM ar_cash_receipts
981: WHERE cash_receipt_id = l_cr_rec.cash_receipt_id;
982:
983: -- determine accounted amount
984: -- Changes for triangulation: If exchange rate type is not user, call