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.ARP_CR_UTIL dependencies on AR_DISTRIBUTIONS

Line 8: P_source_table IN ar_distributions.source_table%TYPE,

4: --
5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
6:
7: PROCEDURE get_dist_ccid( P_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
8: P_source_table IN ar_distributions.source_table%TYPE,
9: P_source_type IN ar_distributions.source_type%TYPE,
10: P_rma_rec IN ar_receipt_method_accounts%ROWTYPE,
11: P_ccid OUT NOCOPY ar_distributions.code_combination_id%TYPE)
12: IS

Line 9: P_source_type IN ar_distributions.source_type%TYPE,

5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
6:
7: PROCEDURE get_dist_ccid( P_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
8: P_source_table IN ar_distributions.source_table%TYPE,
9: P_source_type IN ar_distributions.source_type%TYPE,
10: P_rma_rec IN ar_receipt_method_accounts%ROWTYPE,
11: P_ccid OUT NOCOPY ar_distributions.code_combination_id%TYPE)
12: IS
13: l_ccid ar_distributions.code_combination_id%TYPE;

Line 11: P_ccid OUT NOCOPY ar_distributions.code_combination_id%TYPE)

7: PROCEDURE get_dist_ccid( P_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
8: P_source_table IN ar_distributions.source_table%TYPE,
9: P_source_type IN ar_distributions.source_type%TYPE,
10: P_rma_rec IN ar_receipt_method_accounts%ROWTYPE,
11: P_ccid OUT NOCOPY ar_distributions.code_combination_id%TYPE)
12: IS
13: l_ccid ar_distributions.code_combination_id%TYPE;
14: --
15: CURSOR ar_get_crh_ccid_C IS

Line 13: l_ccid ar_distributions.code_combination_id%TYPE;

9: P_source_type IN ar_distributions.source_type%TYPE,
10: P_rma_rec IN ar_receipt_method_accounts%ROWTYPE,
11: P_ccid OUT NOCOPY ar_distributions.code_combination_id%TYPE)
12: IS
13: l_ccid ar_distributions.code_combination_id%TYPE;
14: --
15: CURSOR ar_get_crh_ccid_C IS
16: SELECT dist.code_combination_id ccid
17: FROM ar_distributions dist,

Line 17: FROM ar_distributions dist,

13: l_ccid ar_distributions.code_combination_id%TYPE;
14: --
15: CURSOR ar_get_crh_ccid_C IS
16: SELECT dist.code_combination_id ccid
17: FROM ar_distributions dist,
18: ar_cash_receipt_history crh
19: WHERE dist.source_table = 'CRH'
20: AND dist.source_id = crh.cash_receipt_history_id
21: AND dist.source_type = P_source_type

Line 88: P_source_type OUT NOCOPY ar_distributions.source_type%TYPE,

84: --
85: PROCEDURE get_creation_info( P_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
86: P_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
87: P_history_status OUT NOCOPY ar_cash_receipt_history.status%TYPE,
88: P_source_type OUT NOCOPY ar_distributions.source_type%TYPE,
89: P_ccid OUT NOCOPY ar_distributions.code_combination_id%TYPE,
90: P_override_remit_account_flag OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE) IS
91: l_history_status ar_cash_receipt_history.status%TYPE;
92: l_source_type ar_distributions.source_type%TYPE;

Line 89: P_ccid OUT NOCOPY ar_distributions.code_combination_id%TYPE,

85: PROCEDURE get_creation_info( P_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
86: P_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
87: P_history_status OUT NOCOPY ar_cash_receipt_history.status%TYPE,
88: P_source_type OUT NOCOPY ar_distributions.source_type%TYPE,
89: P_ccid OUT NOCOPY ar_distributions.code_combination_id%TYPE,
90: P_override_remit_account_flag OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE) IS
91: l_history_status ar_cash_receipt_history.status%TYPE;
92: l_source_type ar_distributions.source_type%TYPE;
93: l_ccid ar_distributions.code_combination_id%TYPE;

Line 92: l_source_type ar_distributions.source_type%TYPE;

88: P_source_type OUT NOCOPY ar_distributions.source_type%TYPE,
89: P_ccid OUT NOCOPY ar_distributions.code_combination_id%TYPE,
90: P_override_remit_account_flag OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE) IS
91: l_history_status ar_cash_receipt_history.status%TYPE;
92: l_source_type ar_distributions.source_type%TYPE;
93: l_ccid ar_distributions.code_combination_id%TYPE;
94: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
95: --
96: BEGIN

Line 93: l_ccid ar_distributions.code_combination_id%TYPE;

89: P_ccid OUT NOCOPY ar_distributions.code_combination_id%TYPE,
90: P_override_remit_account_flag OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE) IS
91: l_history_status ar_cash_receipt_history.status%TYPE;
92: l_source_type ar_distributions.source_type%TYPE;
93: l_ccid ar_distributions.code_combination_id%TYPE;
94: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
95: --
96: BEGIN
97: --