APPS.ARP_PROCESS_MISC_RECEIPTS dependencies on AR_CASH_RECEIPTS

Line 184: l_cr_rec ar_cash_receipts%ROWTYPE;

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

Line 189: l_override_dummy ar_cash_receipts.override_remit_account_flag%TYPE;

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

Line 193: l_old_distribution_set_id ar_cash_receipts.distribution_set_id%TYPE;

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

Line 585: FROM AR_CASH_RECEIPTS_V

581: INTO p_new_status,
582: p_new_status_dsp,
583: p_new_state,
584: p_new_state_dsp
585: FROM AR_CASH_RECEIPTS_V
586: WHERE cash_receipt_id = p_cash_receipt_id; */
587:
588: SELECT cr.status,
589: l_cr_status.meaning,

Line 598: ar_cash_receipts cr,

594: p_new_state,
595: p_new_state_dsp
596: FROM
597: ar_cash_receipt_history crh_current,
598: ar_cash_receipts cr,
599: ar_lookups l_cr_status,
600: ar_lookups l_crh_status
601: WHERE
602: cr.cash_receipt_id = p_cash_receipt_id

Line 743: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE ) IS

739: p_tax_rate IN NUMBER,
740: p_gl_tax_acct IN VARCHAR2 , /* Bug fix 2300268 */
741: p_crh_id OUT NOCOPY NUMBER, /* Bug fix 2742388 */
742: p_legal_entity_id IN NUMBER,
743: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE ) IS
744: l_creation_status ar_cash_receipt_history.status%TYPE;
745: l_cr_rec ar_cash_receipts%ROWTYPE;
746: l_crh_rec ar_cash_receipt_history%ROWTYPE;
747: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;

Line 745: l_cr_rec ar_cash_receipts%ROWTYPE;

741: p_crh_id OUT NOCOPY NUMBER, /* Bug fix 2742388 */
742: p_legal_entity_id IN NUMBER,
743: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE ) IS
744: l_creation_status ar_cash_receipt_history.status%TYPE;
745: l_cr_rec ar_cash_receipts%ROWTYPE;
746: l_crh_rec ar_cash_receipt_history%ROWTYPE;
747: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
748: l_source_type ar_distributions.source_type%TYPE;
749: l_override_remit_account_flag

Line 811: from ar_cash_receipts

807: l_cr_rec.customer_bank_account_id,
808: l_cr_rec.customer_site_use_id,
809: l_cr_rec.payment_server_order_num,
810: l_cr_rec.approval_code
811: from ar_cash_receipts
812: where cash_receipt_id = p_reference_id;
813:
814:
815: EXCEPTION

Line 944: FROM ar_cash_receipts

940: -- get the ROWID out NOCOPY parameter:
941:
942: SELECT rowid
943: INTO p_row_id
944: FROM ar_cash_receipts
945: WHERE cash_receipt_id = l_cr_rec.cash_receipt_id;
946:
947: -- determine accounted amount
948: -- Changes for triangulation: If exchange rate type is not user, call