APPS.FV_GTAS_GL_PKG dependencies on FV_GTAS_PROCESSED_JE_HDRS

Line 518: FROM fv_gtas_processed_je_hdrs e

514: AND gjh.status = 'P'
515: AND gjh.actual_flag = 'A'
516: AND NOT EXISTS
517: (SELECT 'x'
518: FROM fv_gtas_processed_je_hdrs e
519: WHERE e.set_of_books_id = gjh.ledger_id
520: AND e.je_header_id = gjh.je_header_id
521: ) ;
522:

Line 2751: INSERT INTO fv_gtas_processed_je_hdrs

2747: BEGIN
2748: l_module_name := g_module_name||'UPDATE_GTAS_RUN';
2749: log(l_module_name, 'Begin '||l_module_name);
2750:
2751: INSERT INTO fv_gtas_processed_je_hdrs
2752: (je_header_id,set_of_books_id)
2753: SELECT DISTINCT je_header_id,set_of_books_id FROM fv_gtas_header_id_gt;
2754:
2755: log(l_module_name,'Inserted in fv_gtas_processed_je_hdrs: '||SQL%ROWCOUNT);

Line 2755: log(l_module_name,'Inserted in fv_gtas_processed_je_hdrs: '||SQL%ROWCOUNT);

2751: INSERT INTO fv_gtas_processed_je_hdrs
2752: (je_header_id,set_of_books_id)
2753: SELECT DISTINCT je_header_id,set_of_books_id FROM fv_gtas_header_id_gt;
2754:
2755: log(l_module_name,'Inserted in fv_gtas_processed_je_hdrs: '||SQL%ROWCOUNT);
2756: log(l_module_name,'Updating GTAS run ' );
2757:
2758: UPDATE fv_gtas_run
2759: SET process_date = SYSDATE,

Line 2837: log(l_module_name, 'Deleting from fv_gtas_processed_je_hdrs');

2833: log(l_module_name, 'No rows found to dete from fv_gtas_activity_balances.');
2834: END;
2835:
2836: BEGIN
2837: log(l_module_name, 'Deleting from fv_gtas_processed_je_hdrs');
2838: DELETE fv_gtas_processed_je_hdrs
2839: WHERE set_of_books_id = gbl_sob_id
2840: AND je_header_id IN (SELECT je_header_id
2841: FROM gl_je_headers

Line 2838: DELETE fv_gtas_processed_je_hdrs

2834: END;
2835:
2836: BEGIN
2837: log(l_module_name, 'Deleting from fv_gtas_processed_je_hdrs');
2838: DELETE fv_gtas_processed_je_hdrs
2839: WHERE set_of_books_id = gbl_sob_id
2840: AND je_header_id IN (SELECT je_header_id
2841: FROM gl_je_headers
2842: WHERE ledger_id = gbl_sob_id

Line 2850: log(l_module_name, 'No rows found to dete from fv_gtas_processed_je_hdrs.');

2846: WHERE ledger_id = gbl_sob_id
2847: AND period_year = gbl_period_year));
2848: log(l_module_name, 'Deleted : '||sql%rowcount||' row/s.');
2849: EXCEPTION WHEN NO_DATA_FOUND THEN
2850: log(l_module_name, 'No rows found to dete from fv_gtas_processed_je_hdrs.');
2851: END;
2852:
2853: log(l_module_name, 'Updatin fv_gtas_run');
2854: UPDATE fv_gtas_run