APPS.PA_PURGE_PUB dependencies on PJI_FM_XBS_ACCUM_TMP1_DEBUG

Line 1631: -- PJI_FM_XBS_ACCUM_TMP1_DEBUG

1627: , p_procedure_name => 'PURGE_PJI_DEBUG'
1628: , p_error_text => SUBSTRB(SQLERRM,1,240));
1629: END;
1630:
1631: -- PJI_FM_XBS_ACCUM_TMP1_DEBUG
1632: BEGIN
1633: LOOP
1634: DELETE FROM PJI_FM_XBS_ACCUM_TMP1_DEBUG WHERE ROWNUM <= p_commit_size;
1635: EXIT WHEN sql%rowcount < p_commit_size;

Line 1634: DELETE FROM PJI_FM_XBS_ACCUM_TMP1_DEBUG WHERE ROWNUM <= p_commit_size;

1630:
1631: -- PJI_FM_XBS_ACCUM_TMP1_DEBUG
1632: BEGIN
1633: LOOP
1634: DELETE FROM PJI_FM_XBS_ACCUM_TMP1_DEBUG WHERE ROWNUM <= p_commit_size;
1635: EXIT WHEN sql%rowcount < p_commit_size;
1636:
1637: l_rows2 := l_rows2 + nvl(sql%rowcount,0);
1638: COMMIT; -- Clear rollback segment

Line 1682: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_XBS_ACCUM_TMP1_DEBUG ' || l_rows2 ;

1678:
1679: IF p_debug_mode = 'Y' THEN
1680: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_EXTR_PLAN_LINES_DEBUG ' || l_rows1 ;
1681: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1682: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_XBS_ACCUM_TMP1_DEBUG ' || l_rows2 ;
1683: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1684: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_SYSTEM_DEBUG_MSG ' || l_rows3 ;
1685: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1686: END IF;

Line 1705: p_table_name => 'PJI_FM_XBS_ACCUM_TMP1_DEBUG',

1701:
1702: PA_PURGE_PUB.INSERT_PURGE_LOG
1703: (
1704: p_request_id => p_request_id ,
1705: p_table_name => 'PJI_FM_XBS_ACCUM_TMP1_DEBUG',
1706: p_rows_deleted => l_rows2,
1707: x_return_status => x_return_status ,
1708: x_msg_count => x_msg_count,
1709: x_msg_data => x_msg_data