APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_RUN

Line 3107: FROM fv_facts_run

3103: CURSOR c_maf_seq IS
3104: SELECT TO_CHAR(DECODE(vp_run_mode,'F',
3105: (DECODE(MAX(maf_seq_num), NULL, 0,MAX(maf_seq_num)+1)),'P',
3106: (NVL(MAX(maf_seq_num), 0))))
3107: FROM fv_facts_run
3108: WHERE treasury_symbol = vp_treasury_symbol
3109: AND treasury_symbol_id = v_treasury_symbol_id
3110: AND facts_run_period = v_period_num
3111: AND facts_run_year = vp_report_fiscal_yr ;

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

3173: vp_address_1 || vp_address_2 || vp_city || vp_state || vp_zip||
3174: vp_supervisor_name || vp_supervisor_phone||vp_supervisor_extn||
3175: vp_contact_email || vp_contact_fax || vp_contact_maiden ) ;
3176:
3177: -- Insert a new row in FV_FACTS_RUN Table based on the run mode
3178: IF vp_run_mode = 'F' Then
3179: UPDATE fv_facts_run
3180: SET maf_seq_num = to_number(vc_maf_seq_num),
3181: last_run_date = sysdate

Line 3179: UPDATE fv_facts_run

3175: vp_contact_email || vp_contact_fax || vp_contact_maiden ) ;
3176:
3177: -- Insert a new row in FV_FACTS_RUN Table based on the run mode
3178: IF vp_run_mode = 'F' Then
3179: UPDATE fv_facts_run
3180: SET maf_seq_num = to_number(vc_maf_seq_num),
3181: last_run_date = sysdate
3182: WHERE treasury_symbol_id = v_treasury_symbol_id ;
3183: IF SQL%NOTFOUND THEN

Line 3185: INSERT INTO fv_facts_run

3181: last_run_date = sysdate
3182: WHERE treasury_symbol_id = v_treasury_symbol_id ;
3183: IF SQL%NOTFOUND THEN
3184: BEGIN
3185: INSERT INTO fv_facts_run
3186: (treasury_symbol_id,
3187: treasury_symbol,
3188: facts_run_period,
3189: facts_run_year,

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

3200: WHEN OTHERS THEN
3201: vp_retcode := sqlcode ;
3202: vp_errbuf := sqlerrm || '[FACTS RUN UPDATE]' ;
3203: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
3204: l_module_name||'.insert_fv_facts_run', vp_errbuf) ;
3205: RETURN ;
3206: END ;
3207: END IF ;
3208: END IF ;