APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_RUN

Line 3154: FROM fv_facts_run

3150: CURSOR c_maf_seq IS
3151: SELECT TO_CHAR(DECODE(vp_run_mode,'F',
3152: (DECODE(MAX(maf_seq_num), NULL, 0,MAX(maf_seq_num)+1)),'P',
3153: (NVL(MAX(maf_seq_num), 0))))
3154: FROM fv_facts_run
3155: WHERE treasury_symbol = vp_treasury_symbol
3156: AND treasury_symbol_id = v_treasury_symbol_id
3157: AND facts_run_period = v_period_num
3158: AND facts_run_year = vp_report_fiscal_yr ;

Line 3224: -- Insert a new row in FV_FACTS_RUN Table based on the run mode

3220: vp_address_1 || vp_address_2 || vp_city || vp_state || vp_zip||
3221: vp_supervisor_name || vp_supervisor_phone||vp_supervisor_extn||
3222: vp_contact_email || vp_contact_fax || vp_contact_maiden ) ;
3223:
3224: -- Insert a new row in FV_FACTS_RUN Table based on the run mode
3225: IF vp_run_mode = 'F' Then
3226: UPDATE fv_facts_run
3227: SET maf_seq_num = to_number(vc_maf_seq_num),
3228: last_run_date = sysdate

Line 3226: UPDATE fv_facts_run

3222: vp_contact_email || vp_contact_fax || vp_contact_maiden ) ;
3223:
3224: -- Insert a new row in FV_FACTS_RUN Table based on the run mode
3225: IF vp_run_mode = 'F' Then
3226: UPDATE fv_facts_run
3227: SET maf_seq_num = to_number(vc_maf_seq_num),
3228: last_run_date = sysdate
3229: WHERE treasury_symbol_id = v_treasury_symbol_id ;
3230: IF SQL%NOTFOUND THEN

Line 3232: INSERT INTO fv_facts_run

3228: last_run_date = sysdate
3229: WHERE treasury_symbol_id = v_treasury_symbol_id ;
3230: IF SQL%NOTFOUND THEN
3231: BEGIN
3232: INSERT INTO fv_facts_run
3233: (treasury_symbol_id,
3234: treasury_symbol,
3235: facts_run_period,
3236: facts_run_year,

Line 3251: l_module_name||'.insert_fv_facts_run', vp_errbuf) ;

3247: WHEN OTHERS THEN
3248: vp_retcode := sqlcode ;
3249: vp_errbuf := sqlerrm || '[FACTS RUN UPDATE]' ;
3250: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
3251: l_module_name||'.insert_fv_facts_run', vp_errbuf) ;
3252: RETURN ;
3253: END ;
3254: END IF ;
3255: END IF ;