APPS.PA_PURGE_PUB dependencies on PJI_FM_XBS_ACCUM_TMP1_DEBUG

Line 1612: -- PJI_FM_XBS_ACCUM_TMP1_DEBUG

1608: , p_procedure_name => 'PURGE_PJI_DEBUG'
1609: , p_error_text => SUBSTRB(SQLERRM,1,240));
1610: END;
1611:
1612: -- PJI_FM_XBS_ACCUM_TMP1_DEBUG
1613: BEGIN
1614: LOOP
1615: DELETE FROM PJI_FM_XBS_ACCUM_TMP1_DEBUG WHERE ROWNUM <= p_commit_size;
1616: EXIT WHEN sql%rowcount < p_commit_size;

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

1611:
1612: -- PJI_FM_XBS_ACCUM_TMP1_DEBUG
1613: BEGIN
1614: LOOP
1615: DELETE FROM PJI_FM_XBS_ACCUM_TMP1_DEBUG WHERE ROWNUM <= p_commit_size;
1616: EXIT WHEN sql%rowcount < p_commit_size;
1617:
1618: l_rows2 := l_rows2 + nvl(sql%rowcount,0);
1619: COMMIT; -- Clear rollback segment

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

1659:
1660: IF p_debug_mode = 'Y' THEN
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;

Line 1686: p_table_name => 'PJI_FM_XBS_ACCUM_TMP1_DEBUG',

1682:
1683: PA_PURGE_PUB.INSERT_PURGE_LOG
1684: (
1685: p_request_id => p_request_id ,
1686: p_table_name => 'PJI_FM_XBS_ACCUM_TMP1_DEBUG',
1687: p_rows_deleted => l_rows2,
1688: x_return_status => x_return_status ,
1689: x_msg_count => x_msg_count,
1690: x_msg_data => x_msg_data