DBA Data[Home] [Help]

APPS.PA_PURGE_PUB dependencies on PA_PURGE_PRJ_DETAILS

Line 1784: FROM PA_PURGE_PRJ_DETAILS

1780: IS
1781:
1782: CURSOR c_purge_details IS
1783: SELECT table_name, num_recs_purged
1784: FROM PA_PURGE_PRJ_DETAILS
1785: WHERE purge_batch_id = p_request_id
1786: AND project_id = 0
1787: ORDER BY table_name ;
1788:

Line 1903: Pa_Debug.WRITE('PA_PURGE_PUB','Before inserting into PA_PURGE_PRJ_DETAILS',l_debug_level3);

1899: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1900:
1901: IF l_debug_mode = 'Y' THEN
1902: pa_debug.set_curr_function( p_function => 'INSERT_PURGE_LOG', p_debug_mode => 'Y');
1903: Pa_Debug.WRITE('PA_PURGE_PUB','Before inserting into PA_PURGE_PRJ_DETAILS',l_debug_level3);
1904: END IF;
1905:
1906: INSERT INTO PA_PURGE_PRJ_DETAILS
1907: (

Line 1906: INSERT INTO PA_PURGE_PRJ_DETAILS

1902: pa_debug.set_curr_function( p_function => 'INSERT_PURGE_LOG', p_debug_mode => 'Y');
1903: Pa_Debug.WRITE('PA_PURGE_PUB','Before inserting into PA_PURGE_PRJ_DETAILS',l_debug_level3);
1904: END IF;
1905:
1906: INSERT INTO PA_PURGE_PRJ_DETAILS
1907: (
1908: PURGE_BATCH_ID
1909: ,PROJECT_ID
1910: ,TABLE_NAME