APPS.PA_PURGE_PUB dependencies on PJI_FM_EXTR_PLAN_LINES_DEBUG

Line 1607: -- PJI_FM_EXTR_PLAN_LINES_DEBUG

1603: pa_debug.g_err_stage:= 'Entering PURGE_PJI_DEBUG API';
1604: Pa_Debug.WRITE('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1605: END IF;
1606:
1607: -- PJI_FM_EXTR_PLAN_LINES_DEBUG
1608: BEGIN
1609: LOOP
1610: DELETE FROM PJI_FM_EXTR_PLAN_LINES_DEBUG WHERE ROWNUM <= p_commit_size;
1611: EXIT WHEN sql%rowcount < p_commit_size;

Line 1610: DELETE FROM PJI_FM_EXTR_PLAN_LINES_DEBUG WHERE ROWNUM <= p_commit_size;

1606:
1607: -- PJI_FM_EXTR_PLAN_LINES_DEBUG
1608: BEGIN
1609: LOOP
1610: DELETE FROM PJI_FM_EXTR_PLAN_LINES_DEBUG WHERE ROWNUM <= p_commit_size;
1611: EXIT WHEN sql%rowcount < p_commit_size;
1612:
1613: l_rows1 := l_rows1 + nvl(sql%rowcount,0);
1614: COMMIT; -- Clear rollback segment

Line 1680: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_EXTR_PLAN_LINES_DEBUG ' || l_rows1 ;

1676: , p_error_text => SUBSTRB(SQLERRM,1,240));
1677: END;
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 ;

Line 1691: p_table_name => 'PJI_FM_EXTR_PLAN_LINES_DEBUG' ,

1687:
1688: PA_PURGE_PUB.INSERT_PURGE_LOG
1689: (
1690: p_request_id => p_request_id ,
1691: p_table_name => 'PJI_FM_EXTR_PLAN_LINES_DEBUG' ,
1692: p_rows_deleted => l_rows1 ,
1693: x_return_status => x_return_status ,
1694: x_msg_count => x_msg_count,
1695: x_msg_data => x_msg_data