APPS.PA_PURGE_PUB dependencies on PA_REPORTING_EXCEPTIONS

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

1120: --
1121: -- PROCEDURE
1122: -- PURGE_REPORTING_EXCEPTIONS
1123: -- PURPOSE
1124: -- This API will purge unused reporting exception data from pa_reporting_exceptions
1125: --
1126: -- Parameter Name In/Out Data Type Null? Default Value Description
1127: -- ------------- ------ ---------- ------ ------------- ---------------------------------
1128: -- P_DEBUG_MODE IN VARCHAR2 NOT NULL 'N' Indicates the debug option.

Line 1165: FROM pa_reporting_exceptions

1161: l_local_error_flag VARCHAR2(1) :='N'; -- 5201806
1162:
1163: CURSOR c_get_request_id IS
1164: SELECT request_id
1165: FROM pa_reporting_exceptions
1166: WHERE request_id not in
1167: (SELECT request_id
1168: FROM fnd_concurrent_requests)
1169: AND nvl(request_id,0) > 0;

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

1167: (SELECT request_id
1168: FROM fnd_concurrent_requests)
1169: AND nvl(request_id,0) > 0;
1170:
1171: --Technically if the pa_reporting_exceptions.request_id does not exist in fnd_concurrent_requests.request_id,
1172: --then the record is eligible to be purged. Note - the code must exclude request_id < 0 as the
1173: --mass assignment flows populate this table using request_id = -1.
1174:
1175: BEGIN

Line 1195: DELETE FROM pa_reporting_exceptions

1191: EXIT WHEN l_request_id_tbl.COUNT <= 0 ;
1192:
1193: BEGIN
1194: FORALL i IN l_request_id_tbl.FIRST..l_request_id_tbl.LAST
1195: DELETE FROM pa_reporting_exceptions
1196: WHERE request_id = l_request_id_tbl (i);
1197:
1198: l_rows1 :=l_rows1+nvl(sql%rowcount,0);
1199: COMMIT;

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

1215: END LOOP;
1216: CLOSE c_get_request_id;
1217:
1218: IF p_debug_mode = 'Y' THEN
1219: pa_debug.g_err_stage:= 'No. of rows deleted from pa_reporting_exceptions ' || l_rows1 ;
1220: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1221: END IF;
1222:
1223:

Line 1227: p_table_name => 'PA_REPORTING_EXCEPTIONS' ,

1223:
1224: PA_PURGE_PUB.INSERT_PURGE_LOG
1225: (
1226: p_request_id => p_request_id ,
1227: p_table_name => 'PA_REPORTING_EXCEPTIONS' ,
1228: p_rows_deleted => l_rows1 ,
1229: x_return_status => x_return_status ,
1230: x_msg_count => x_msg_count,
1231: x_msg_data => x_msg_data

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

1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242:
1243: IF p_debug_mode = 'Y' THEN
1244: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to pa_reporting_exceptions';
1245: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1246: pa_debug.g_err_stage:= 'Exiting PURGE_REPORTING_EXCEPTIONS';
1247: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1248: Pa_Debug.reset_curr_function;