APPS.PA_PURGE_PUB dependencies on PA_REPORTING_EXCEPTIONS

Line 1143: -- This API will purge unused reporting exception data from pa_reporting_exceptions

1139: --
1140: -- PROCEDURE
1141: -- PURGE_REPORTING_EXCEPTIONS
1142: -- PURPOSE
1143: -- This API will purge unused reporting exception data from pa_reporting_exceptions
1144: --
1145: -- Parameter Name In/Out Data Type Null? Default Value Description
1146: -- ------------- ------ ---------- ------ ------------- ---------------------------------
1147: -- P_DEBUG_MODE IN VARCHAR2 NOT NULL 'N' Indicates the debug option.

Line 1184: FROM pa_reporting_exceptions

1180: l_local_error_flag VARCHAR2(1) :='N'; -- 5201806
1181:
1182: CURSOR c_get_request_id IS
1183: SELECT request_id
1184: FROM pa_reporting_exceptions
1185: WHERE request_id not in
1186: (SELECT request_id
1187: FROM fnd_concurrent_requests)
1188: AND nvl(request_id,0) > 0;

Line 1190: --Technically if the pa_reporting_exceptions.request_id does not exist in fnd_concurrent_requests.request_id,

1186: (SELECT request_id
1187: FROM fnd_concurrent_requests)
1188: AND nvl(request_id,0) > 0;
1189:
1190: --Technically if the pa_reporting_exceptions.request_id does not exist in fnd_concurrent_requests.request_id,
1191: --then the record is eligible to be purged. Note - the code must exclude request_id < 0 as the
1192: --mass assignment flows populate this table using request_id = -1.
1193:
1194: BEGIN

Line 1214: DELETE FROM pa_reporting_exceptions

1210: EXIT WHEN l_request_id_tbl.COUNT <= 0 ;
1211:
1212: BEGIN
1213: FORALL i IN l_request_id_tbl.FIRST..l_request_id_tbl.LAST
1214: DELETE FROM pa_reporting_exceptions
1215: WHERE request_id = l_request_id_tbl (i);
1216:
1217: l_rows1 :=l_rows1+nvl(sql%rowcount,0);
1218: COMMIT;

Line 1238: pa_debug.g_err_stage:= 'No. of rows deleted from pa_reporting_exceptions ' || l_rows1 ;

1234: END LOOP;
1235: CLOSE c_get_request_id;
1236:
1237: IF p_debug_mode = 'Y' THEN
1238: pa_debug.g_err_stage:= 'No. of rows deleted from pa_reporting_exceptions ' || l_rows1 ;
1239: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1240: END IF;
1241:
1242:

Line 1246: p_table_name => 'PA_REPORTING_EXCEPTIONS' ,

1242:
1243: PA_PURGE_PUB.INSERT_PURGE_LOG
1244: (
1245: p_request_id => p_request_id ,
1246: p_table_name => 'PA_REPORTING_EXCEPTIONS' ,
1247: p_rows_deleted => l_rows1 ,
1248: x_return_status => x_return_status ,
1249: x_msg_count => x_msg_count,
1250: x_msg_data => x_msg_data

Line 1263: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to pa_reporting_exceptions';

1259: RAISE FND_API.G_EXC_ERROR;
1260: END IF;
1261:
1262: IF p_debug_mode = 'Y' THEN
1263: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to pa_reporting_exceptions';
1264: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1265: pa_debug.g_err_stage:= 'Exiting PURGE_REPORTING_EXCEPTIONS';
1266: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1267: Pa_Debug.reset_curr_function;