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 2309: from fv_facts1_run

2305:
2306: begin
2307: select decode(period_num,null,'Y',0,'Y','N'),period_num into
2308: l_populate_flag, l_int_run_month
2309: from fv_facts1_run
2310: WHERE set_of_books_id = gbl_set_of_books_id
2311: AND fiscal_year = p_period_year;
2312: exception
2313: when no_data_found then

Line 2475: from fv_facts1_run

2471: l_diff_flag := 'N';
2472:
2473: begin
2474: select NVL(begin_bal_diff_flag , 'N') into l_diff_flag
2475: from fv_facts1_run
2476: where set_of_books_id = gbl_set_of_books_id
2477: and fiscal_year = gbl_fiscal_year;
2478:
2479: -- To delete the erroneous record

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

3051: FV_UTILITY.LOG_MESG('No data found for this period year.');
3052: END IF;
3053:
3054:
3055: -- Update fv_facts1_run only if there were records
3056: -- found for the attribute creation process.
3057: IF l_rec_count > 0 THEN
3058: FV_UTILITY.LOG_MESG('Updating facts1 run status.');
3059: UPDATE fv_facts1_run

Line 3059: UPDATE fv_facts1_run

3055: -- Update fv_facts1_run only if there were records
3056: -- found for the attribute creation process.
3057: IF l_rec_count > 0 THEN
3058: FV_UTILITY.LOG_MESG('Updating facts1 run status.');
3059: UPDATE fv_facts1_run
3060: SET status = l_run_status,
3061: process_date = sysdate,
3062: run_fed_flag = 'I',
3063: begin_bal_diff_flag = 'Y',

Line 3101: UPDATE fv_facts1_run

3097:
3098: l_module_name := g_module_name || 'UPDATE_FACTS1_RUN';
3099: FV_UTILITY.LOG_MESG('In '||l_module_name);
3100:
3101: UPDATE fv_facts1_run
3102: SET run_fed_flag = 'A',
3103: process_date = sysdate
3104: WHERE set_of_books_id = p_set_of_books_id
3105: AND fiscal_year = p_period_year

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

3140: WHERE ledger_id = gbl_set_of_books_id;
3141:
3142: if l_posted_date is not null then
3143:
3144: FV_UTILITY.LOG_MESG('Initialzied fv_facts1_run with ' );
3145: FV_UTILITY.LOG_MESG(' from period ' || gbl_period_name);
3146: FV_UTILITY.LOG_MESG(' Header_id ' || l_je_header_id);
3147: FV_UTILITY.LOG_MESG(' posted_date ' || l_posted_date );
3148:

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

3145: FV_UTILITY.LOG_MESG(' from period ' || gbl_period_name);
3146: FV_UTILITY.LOG_MESG(' Header_id ' || l_je_header_id);
3147: FV_UTILITY.LOG_MESG(' posted_date ' || l_posted_date );
3148:
3149: INSERT INTO fv_facts1_run(set_of_books_id, fiscal_year, status, table_indicator,process_date,
3150: run_fed_flag ,je_header_id,posted_date)
3151: values(gbl_set_of_books_id, p_period_year, 'A', 'N',sysdate,'A' ,
3152: l_je_header_id ,l_posted_date);
3153: else

Line 3393: from fv_facts1_RUN

3389:
3390: l_je_header_id := 0;
3391:
3392: select nvl(je_header_id,0),nvl(jc_run_month,0) into l_je_header_id,l_period_num
3393: from fv_facts1_RUN
3394: where set_of_books_id = gbl_set_of_books_id
3395: AND fiscal_year = gbl_fiscal_year;
3396:
3397: