[Home] [Help]
1345: --
1346: FETCH csr_int INTO l_param_list_app_id, l_param_list_code, l_content_code;
1347: --
1348: IF csr_int%FOUND THEN
1349: IF l_param_list_code <> 'HR_STANDARD' Then
1350: --
1351: -- Parameter list exists for this content, so delete it.
1352: --
1353: l_sql := 'BEGIN ' ||
1380: -- Update content to reflect deleted param list
1381: l_sql := 'BEGIN ' ||
1382: ' UPDATE bne_contents_b ' ||
1383: ' SET param_list_app_id = 800 ' ||
1384: ' , param_list_code = ''HR_STANDARD'' ' ||
1385: ' , object_version_number = object_version_number + 1 ' ||
1386: ' WHERE integrator_app_id = :1 ' ||
1387: ' AND integrator_code = :2; ' ||
1388: 'END; ';