APPS.FEM_INTG_BAL_ENG_LOAD_PKG dependencies on GL_TRACK_DELTA_BALANCES

Line 1536: -- First, insert rows into GL_TRACK_DELTA_BALANCES to flag that delta

1532: v_actual_flag := 'E';
1533: END IF;
1534:
1535:
1536: -- First, insert rows into GL_TRACK_DELTA_BALANCES to flag that delta
1537: -- balances should be tracked from now in GL
1538: INSERT INTO GL_TRACK_DELTA_BALANCES(
1539: ledger_id, program_code, period_name, actual_flag,
1540: extract_level_code, currency_type_code, enabled_flag, last_update_date,

Line 1538: INSERT INTO GL_TRACK_DELTA_BALANCES(

1534:
1535:
1536: -- First, insert rows into GL_TRACK_DELTA_BALANCES to flag that delta
1537: -- balances should be tracked from now in GL
1538: INSERT INTO GL_TRACK_DELTA_BALANCES(
1539: ledger_id, program_code, period_name, actual_flag,
1540: extract_level_code, currency_type_code, enabled_flag, last_update_date,
1541: last_updated_by, creation_date, created_by, last_update_login)
1542: SELECT DISTINCT FEM_GL_POST_PROCESS_PKG.pv_ledger_id,

Line 1559: FROM GL_TRACK_DELTA_BALANCES tdb

1555: WHERE param.error_code IS NULL
1556: AND param.request_id IS NOT NULL
1557: AND NOT EXISTS
1558: (SELECT 1
1559: FROM GL_TRACK_DELTA_BALANCES tdb
1560: WHERE tdb.ledger_id = FEM_GL_POST_PROCESS_PKG.pv_ledger_id
1561: AND tdb.program_code = 'FEM'
1562: AND tdb.period_name = param.period_name
1563: AND tdb.actual_flag = v_actual_flag

Line 1572: ' rows into GL_TRACK_DELTA_BALANCES');

1568: FEM_ENGINES_PKG.Tech_Message(
1569: p_severity => pc_log_level_statement,
1570: p_module => v_module,
1571: p_msg_text => 'Inserted ' || TO_CHAR(SQL%ROWCOUNT) ||
1572: ' rows into GL_TRACK_DELTA_BALANCES');
1573:
1574:
1575: -- Now, remove rows from FEM_INTG_DELTA_LOADS if previously errored
1576: -- delta runs were successfully loaded