APPS.FV_SF224_TRANSACTIONS dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

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

2459: l_row := dbms_sql.EXECUTE(l_cur);
2460: dbms_sql.close_cursor(l_cur);
2461: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
2462: 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');
2463: /* Start for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2464:
2465: l_string2 := ' SELECT glb.je_batch_id,
2466: ffp.fund_value,
2467: ffp.description,

Line 2513: AR_RECEIVABLE_APPLICATIONS_ALL arr,

2509: fv_report_definitions frd,
2510: fv_fund_parameters ffp,
2511: fv_treasury_symbols fts,
2512: ar_distributions_all ard,
2513: AR_RECEIVABLE_APPLICATIONS_ALL arr,
2514: gl_import_references glir,
2515: xla_ae_headers xah,
2516: xla_ae_lines xal,
2517: xla_events xet,

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

2570: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2571: l_row := dbms_sql.EXECUTE(l_cur);
2572: dbms_sql.close_cursor(l_cur);
2573:
2574: /* END for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2575: 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 ');
2576: /* Start for for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2577:
2578: l_string2 := ' SELECT glb.je_batch_id,

Line 2575: 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 ');

2571: l_row := dbms_sql.EXECUTE(l_cur);
2572: dbms_sql.close_cursor(l_cur);
2573:
2574: /* END for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2575: 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 ');
2576: /* Start for for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2577:
2578: l_string2 := ' SELECT glb.je_batch_id,
2579: ffp.fund_value,

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

3311: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3312: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOR TRADE RECEIPT: '||
3313: 'Cash Receipt Hist Id does not '||
3314: 'exist in Ar_Cash_Receipt_History_All table.'||
3315: 'Checking in Ar_Receivable_Applications_All table.');
3316: END IF;
3317: l_exists := 'C';
3318: END IF;
3319: WHEN INVALID_NUMBER OR VALUE_ERROR Then

Line 3328: FROM Ar_Receivable_Applications_All

3324: IF((l_je_category <> 'Misc Receipts') AND (l_exists = 'C')) THEN
3325: BEGIN
3326: SELECT cash_receipt_history_id
3327: INTO l_temp_cr_hist_id
3328: FROM Ar_Receivable_Applications_All
3329: WHERE receivable_application_id = TO_NUMBER(l_cash_receipt_hist_id);
3330: l_cash_receipt_hist_id := l_temp_cr_hist_id;
3331: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3332: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||

Line 3333: 'Ar_Receivable_Applications_All table and is '||

3329: WHERE receivable_application_id = TO_NUMBER(l_cash_receipt_hist_id);
3330: l_cash_receipt_hist_id := l_temp_cr_hist_id;
3331: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3332: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||
3333: 'Ar_Receivable_Applications_All table and is '||
3334: TO_NUMBER(l_cash_receipt_hist_id)||'.Checking in '||
3335: 'Ar_Cash_Receipt_History_All to see if it is a valid '||
3336: 'cash receipt hist id.');
3337: END IF;