APPS.PA_PURGE_PUB dependencies on PJI_SYSTEM_DEBUG_MSG

Line 1636: -- PJI_SYSTEM_DEBUG_MSG

1632: , p_procedure_name => 'PURGE_PJI_DEBUG'
1633: , p_error_text => SUBSTRB(SQLERRM,1,240));
1634: END;
1635:
1636: -- PJI_SYSTEM_DEBUG_MSG
1637: BEGIN
1638: LOOP
1639: DELETE FROM PJI_SYSTEM_DEBUG_MSG WHERE ROWNUM <= p_commit_size;
1640: EXIT WHEN sql%rowcount < p_commit_size;

Line 1639: DELETE FROM PJI_SYSTEM_DEBUG_MSG WHERE ROWNUM <= p_commit_size;

1635:
1636: -- PJI_SYSTEM_DEBUG_MSG
1637: BEGIN
1638: LOOP
1639: DELETE FROM PJI_SYSTEM_DEBUG_MSG WHERE ROWNUM <= p_commit_size;
1640: EXIT WHEN sql%rowcount < p_commit_size;
1641:
1642: l_rows3 := l_rows3 + nvl(sql%rowcount,0);
1643: COMMIT; -- Clear rollback segment

Line 1665: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_SYSTEM_DEBUG_MSG ' || l_rows3 ;

1661: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_EXTR_PLAN_LINES_DEBUG ' || l_rows1 ;
1662: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1663: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_XBS_ACCUM_TMP1_DEBUG ' || l_rows2 ;
1664: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1665: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_SYSTEM_DEBUG_MSG ' || l_rows3 ;
1666: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1667: END IF;
1668:
1669: PA_PURGE_PUB.INSERT_PURGE_LOG

Line 1700: p_table_name => 'PJI_SYSTEM_DEBUG_MSG',

1696:
1697: PA_PURGE_PUB.INSERT_PURGE_LOG
1698: (
1699: p_request_id => p_request_id ,
1700: p_table_name => 'PJI_SYSTEM_DEBUG_MSG',
1701: p_rows_deleted => l_rows3,
1702: x_return_status => x_return_status ,
1703: x_msg_count => x_msg_count,
1704: x_msg_data => x_msg_data