APPS.FV_GTAS_INTERFACE dependencies on FV_GTAS_RUN

Line 420: UPDATE fv_gtas_run

416:
417: END IF;
418:
419: IF gbl_error_code = 0 THEN
420: UPDATE fv_gtas_run
421: SET status = 'Y',
422: run_fed_flag = 'I',
423: process_date = sysdate,
424: begin_bal_diff_flag = 'Y',

Line 1963: from fv_gtas_run

1959:
1960: begin
1961: select decode(period_num,null,'Y',0,'Y','N'),period_num into
1962: l_populate_flag, l_int_run_month
1963: from fv_gtas_run
1964: WHERE set_of_books_id = gbl_set_of_books_id
1965: AND fiscal_year = p_period_year;
1966: exception
1967: when no_data_found then

Line 2116: from fv_gtas_run

2112: l_diff_flag := 'N';
2113:
2114: begin
2115: select NVL(begin_bal_diff_flag , 'N') into l_diff_flag
2116: from fv_gtas_run
2117: where set_of_books_id = gbl_set_of_books_id
2118: and fiscal_year = gbl_fiscal_year;
2119:
2120: -- To delete the erroneous record

Line 2581: -- Update fv_gtas_run only if there were records

2577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No data found for this period year.');
2578: END IF;
2579:
2580:
2581: -- Update fv_gtas_run only if there were records
2582: -- found for the interface process.
2583: IF l_rec_count > 0 THEN
2584: log(l_module_name, 'Updating GTAS run status.');
2585: UPDATE fv_gtas_run

Line 2585: UPDATE fv_gtas_run

2581: -- Update fv_gtas_run only if there were records
2582: -- found for the interface process.
2583: IF l_rec_count > 0 THEN
2584: log(l_module_name, 'Updating GTAS run status.');
2585: UPDATE fv_gtas_run
2586: SET status = l_run_status,
2587: process_date = sysdate,
2588: run_fed_flag = 'I',
2589: begin_bal_diff_flag = 'Y',

Line 3131: UPDATE fv_gtas_run

3127:
3128: l_module_name := g_module_name || 'UPDATE_GTAS_RUN';
3129: log(l_module_name, 'In '||l_module_name);
3130:
3131: UPDATE fv_gtas_run
3132: SET run_fed_flag = 'A',
3133: process_date = sysdate
3134: WHERE set_of_books_id = p_set_of_books_id
3135: AND fiscal_year = p_period_year;

Line 3141: INSERT INTO fv_gtas_run(set_of_books_id, fiscal_year,

3137:
3138: --If running for first time, row will not exist above
3139: --then insert a new row
3140: IF SQL%ROWCOUNT = 0 THEN
3141: INSERT INTO fv_gtas_run(set_of_books_id, fiscal_year,
3142: status, process_date,
3143: run_fed_flag,posted_date)
3144: VALUES(gbl_set_of_books_id, p_period_year, 'A', sysdate,'A' ,
3145: l_posted_date);