APPS.FV_FACTS1_PKG dependencies on FV_FACTS1_RUN

Line 382: UPDATE fv_facts1_run

378:
379: --IF l_edit_check_status = 'Y' THEN
380: --UPDATE_FACTS1_RUN(GBL_PERIOD_NUM_HIGH, GBL_FISCAL_YEAR, GBL_SET_OF_BOOKS_ID, 'S');
381:
382: UPDATE fv_facts1_run
383: SET status = decode(l_edit_check_status , 'Y', 'S' , 'F'),
384: run_fed_flag = 'I',
385: process_date = sysdate,
386: begin_bal_diff_flag = 'Y',

Line 2255: from fv_facts1_run

2251:
2252: begin
2253: select decode(period_num,null,'Y',0,'Y','N'),period_num into
2254: l_populate_flag, l_int_run_month
2255: from fv_facts1_run
2256: WHERE set_of_books_id = gbl_set_of_books_id
2257: AND fiscal_year = p_period_year;
2258: exception
2259: when no_data_found then

Line 2419: from fv_facts1_run

2415: l_diff_flag := 'N';
2416:
2417: begin
2418: select NVL(begin_bal_diff_flag , 'N') into l_diff_flag
2419: from fv_facts1_run
2420: where set_of_books_id = gbl_set_of_books_id
2421: and fiscal_year = gbl_fiscal_year;
2422:
2423: -- To delete the erroneous record

Line 2977: -- Update fv_facts1_run only if there were records

2973: FV_UTILITY.LOG_MESG('No data found for this period year.');
2974: END IF;
2975:
2976:
2977: -- Update fv_facts1_run only if there were records
2978: -- found for the attribute creation process.
2979: IF l_rec_count > 0 THEN
2980: FV_UTILITY.LOG_MESG('Updating facts1 run status.');
2981: UPDATE fv_facts1_run

Line 2981: UPDATE fv_facts1_run

2977: -- Update fv_facts1_run only if there were records
2978: -- found for the attribute creation process.
2979: IF l_rec_count > 0 THEN
2980: FV_UTILITY.LOG_MESG('Updating facts1 run status.');
2981: UPDATE fv_facts1_run
2982: SET status = l_run_status,
2983: process_date = sysdate,
2984: run_fed_flag = 'I',
2985: begin_bal_diff_flag = 'Y',

Line 3023: UPDATE fv_facts1_run

3019:
3020: l_module_name := g_module_name || 'UPDATE_FACTS1_RUN';
3021: FV_UTILITY.LOG_MESG('In '||l_module_name);
3022:
3023: UPDATE fv_facts1_run
3024: SET run_fed_flag = 'A',
3025: process_date = sysdate
3026: WHERE set_of_books_id = p_set_of_books_id
3027: AND fiscal_year = p_period_year

Line 3066: FV_UTILITY.LOG_MESG('Initialzied fv_facts1_run with ' );

3062: WHERE ledger_id = gbl_set_of_books_id;
3063:
3064: if l_posted_date is not null then
3065:
3066: FV_UTILITY.LOG_MESG('Initialzied fv_facts1_run with ' );
3067: FV_UTILITY.LOG_MESG(' from period ' || gbl_period_name);
3068: FV_UTILITY.LOG_MESG(' Header_id ' || l_je_header_id);
3069: FV_UTILITY.LOG_MESG(' posted_date ' || l_posted_date );
3070:

Line 3071: INSERT INTO fv_facts1_run(set_of_books_id, fiscal_year, status, table_indicator,process_date,

3067: FV_UTILITY.LOG_MESG(' from period ' || gbl_period_name);
3068: FV_UTILITY.LOG_MESG(' Header_id ' || l_je_header_id);
3069: FV_UTILITY.LOG_MESG(' posted_date ' || l_posted_date );
3070:
3071: INSERT INTO fv_facts1_run(set_of_books_id, fiscal_year, status, table_indicator,process_date,
3072: run_fed_flag ,je_header_id,posted_date)
3073: values(gbl_set_of_books_id, p_period_year, 'A', 'N',sysdate,'A' ,
3074: l_je_header_id ,l_posted_date);
3075: else

Line 3315: from fv_facts1_RUN

3311:
3312: l_je_header_id := 0;
3313:
3314: select nvl(je_header_id,0),nvl(jc_run_month,0) into l_je_header_id,l_period_num
3315: from fv_facts1_RUN
3316: where set_of_books_id = gbl_set_of_books_id
3317: AND fiscal_year = gbl_fiscal_year;
3318:
3319: