APPS.FV_SF224_TRANSACTIONS dependencies on FV_TREASURY_CONFIRMATIONS_ALL

Line 2311: fv_treasury_confirmations_all ftc,

2307: gl_import_references glir,
2308: xla_ae_headers xah,
2309: xla_ae_lines xal,
2310: xla_distribution_links xdl,
2311: fv_treasury_confirmations_all ftc,
2312: xla_events xle
2313: WHERE glb.status = ''P''
2314: AND glb.actual_flag = ''A''
2315: AND glb.je_batch_id = glh.je_batch_id

Line 2342: AND xdl.source_distribution_type = ''FV_TREASURY_CONFIRMATIONS_ALL''

2338: AND xle.event_id = xah.event_id
2339: AND ftc.treasury_confirmation_id = xdl.APPLIED_TO_SOURCE_ID_NUM_1
2340: AND xdl.ae_header_id = xah.ae_header_id
2341: AND xdl.ae_line_num = xal.ae_line_num
2342: AND xdl.source_distribution_type = ''FV_TREASURY_CONFIRMATIONS_ALL''
2343: AND xdl.source_distribution_id_num_1 = aphd.payment_hist_dist_id
2344: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
2345: AND xdl.application_id = 8901 ' ;
2346: --IF (p_previous_run_date = g_lo_date) THEN

Line 3178: from Fv_treasury_confirmations_all

3174: ELSIF l_reference_1 IS NOT NULL THEN -- ref1
3175: BEGIN
3176: select 'Y'
3177: into l_exists
3178: from Fv_treasury_confirmations_all
3179: Where treasury_confirmation_id = to_number(l_REFERENCE_1) ;
3180: EXCEPTION
3181: When no_data_found then
3182: x_name := 'Invalid Treasury Confirmation Id - '

Line 3898: FROM Fv_Treasury_Confirmations_All

3894: END IF;
3895: BEGIN
3896: SELECT checkrun_name,treasury_doc_date,org_id
3897: INTO vl_checkrun_name, l_accomplish_date, l_org_id
3898: FROM Fv_Treasury_Confirmations_All
3899: WHERE treasury_confirmation_id = TO_NUMBER(l_reference_1);
3900: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3901: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3902: 'FOUND THE CHECKRUN_NAME,DOC_DATE,ORG_ID');

Line 3908: 'Fv_Treasury_Confirmations_All table.';

3904: EXCEPTION
3905: WHEN OTHERS THEN
3906: error_buf := SQLERRM||'- Error while deriving the '||
3907: 'checkrun_name,treasury_doc_date from '||
3908: 'Fv_Treasury_Confirmations_All table.';
3909: error_code := 2;
3910: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error15', error_buf) ;
3911: RETURN;
3912: END;

Line 3923: FROM Fv_Treasury_Confirmations_All

3919: l_accomplish_date := l_reference_6;
3920: BEGIN
3921: SELECT checkrun_name,org_id
3922: INTO vl_checkrun_name,l_org_id
3923: FROM Fv_Treasury_Confirmations_All
3924: WHERE treasury_confirmation_id = TO_NUMBER(l_reference_1);
3925: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3926: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3927: 'FOUND THE CHECKRUN_NAME,ORG_ID');

Line 3932: 'checkrun_name from Fv_Treasury_Confirmations_All table.';

3928: END IF;
3929: EXCEPTION
3930: WHEN OTHERS THEN
3931: error_buf := SQLERRM||'- Error while deriving the '||
3932: 'checkrun_name from Fv_Treasury_Confirmations_All table.';
3933: error_code := 2;
3934: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error16', error_buf);
3935: RETURN;
3936: END;

Line 3981: FROM Fv_Treasury_Confirmations_All

3977: END IF;
3978: BEGIN
3979: SELECT treasury_doc_date
3980: INTO l_accomplish_date
3981: FROM Fv_Treasury_Confirmations_All
3982: WHERE treasury_confirmation_id = TO_NUMBER(l_reference_1);
3983: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3984: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOUND TREASURY_DOC_DATE');
3985: END IF;

Line 3989: 'treasury_doc_date from Fv_Treasury_Confirmations_All table.';

3985: END IF;
3986: EXCEPTION
3987: WHEN OTHERS THEN
3988: error_buf := SQLERRM||'- Error while deriving the '||
3989: 'treasury_doc_date from Fv_Treasury_Confirmations_All table.';
3990: error_code := 2;
3991: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error18', error_buf) ;
3992: RETURN;
3993: END;