APPS.FV_SF224_TRANSACTIONS dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 2589: /* Start for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */

2585: l_row := dbms_sql.EXECUTE(l_cur);
2586: dbms_sql.close_cursor(l_cur);
2587: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
2588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables, based on ar_cash_receipt_history_all');
2589: /* Start for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2590:
2591: l_string2 := ' SELECT glb.je_batch_id,
2592: ffp.fund_value,
2593: ffp.description,

Line 2639: AR_RECEIVABLE_APPLICATIONS_ALL arr,

2635: fv_report_definitions frd,
2636: fv_fund_parameters ffp,
2637: fv_treasury_symbols fts,
2638: ar_distributions_all ard,
2639: AR_RECEIVABLE_APPLICATIONS_ALL arr,
2640: gl_import_references glir,
2641: xla_ae_headers xah,
2642: xla_ae_lines xal,
2643: xla_events xet,

Line 2701: /* END for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */

2697: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2698: l_row := dbms_sql.EXECUTE(l_cur);
2699: dbms_sql.close_cursor(l_cur);
2700:
2701: /* END for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2702: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL ');
2703: /* Start for for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2704:
2705: l_string2 := ' SELECT glb.je_batch_id,

Line 2702: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL ');

2698: l_row := dbms_sql.EXECUTE(l_cur);
2699: dbms_sql.close_cursor(l_cur);
2700:
2701: /* END for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2702: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL ');
2703: /* Start for for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2704:
2705: l_string2 := ' SELECT glb.je_batch_id,
2706: ffp.fund_value,

Line 3450: 'Checking in Ar_Receivable_Applications_All table.');

3446: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3447: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOR TRADE RECEIPT: '||
3448: 'Cash Receipt Hist Id does not '||
3449: 'exist in Ar_Cash_Receipt_History_All table.'||
3450: 'Checking in Ar_Receivable_Applications_All table.');
3451: END IF;
3452: l_exists := 'C';
3453: END IF;
3454: WHEN INVALID_NUMBER OR VALUE_ERROR Then

Line 3463: FROM Ar_Receivable_Applications_All

3459: IF((l_je_category <> 'Misc Receipts') AND (l_exists = 'C')) THEN
3460: BEGIN
3461: SELECT cash_receipt_history_id
3462: INTO l_temp_cr_hist_id
3463: FROM Ar_Receivable_Applications_All
3464: WHERE receivable_application_id = TO_NUMBER(l_cash_receipt_hist_id);
3465: l_cash_receipt_hist_id := l_temp_cr_hist_id;
3466: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||

Line 3468: 'Ar_Receivable_Applications_All table and is '||

3464: WHERE receivable_application_id = TO_NUMBER(l_cash_receipt_hist_id);
3465: l_cash_receipt_hist_id := l_temp_cr_hist_id;
3466: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||
3468: 'Ar_Receivable_Applications_All table and is '||
3469: TO_NUMBER(l_cash_receipt_hist_id)||'.Checking in '||
3470: 'Ar_Cash_Receipt_History_All to see if it is a valid '||
3471: 'cash receipt hist id.');
3472: END IF;