eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_ISC_BUS dependencies on PER_QUALIFICATION_TYPES

Line 1215: -- per_qualification_types.

1211: -- {Start Of Comments}
1212: --
1213: -- Description:
1214: -- This procedure ensures that min_qual_level exists in
1215: -- per_qualification_types.
1216: --
1217: -- Pre Conditions:
1218: -- g_old_rec has been populated with details of the values currently in
1219: -- the database.

Line 1245: select null from per_qualification_types pqt

1241: l_min_qual_level varchar2(1);
1242: l_api_updating boolean;
1243: --
1244: cursor csr_min_qual_level is
1245: select null from per_qualification_types pqt
1246: where pqt.qualification_type_id = p_min_qual_level;
1247: --
1248: begin
1249: hr_utility.set_location('Entering:'||l_proc,10);

Line 1267: -- Check that min_qual_level exists in per_qualification_types

1263: hr_utility.set_location(l_proc,40);
1264: open csr_min_qual_level;
1265: fetch csr_min_qual_level into l_min_qual_level ;
1266: hr_utility.set_location(l_proc,50);
1267: -- Check that min_qual_level exists in per_qualification_types
1268: if csr_min_qual_level%NOTFOUND then
1269: close csr_min_qual_level;
1270: fnd_message.set_name('PER','IRC_412016_BAD_MIN_QUAL_LEVEL');
1271: fnd_message.raise_error;

Line 1296: -- based on values of rank in PER_QUALIFICATION_TYPES.

1292: -- {Start Of Comments}
1293: --
1294: -- Description:
1295: -- This procedure ensures that max_qual_level is greater than min_qual_level
1296: -- based on values of rank in PER_QUALIFICATION_TYPES.
1297: --
1298: -- Pre Conditions:
1299: --
1300: -- In Arguments:

Line 1319: l_min_qual_rank per_qualification_types.rank%TYPE;

1315: , p_max_qual_level in irc_search_criteria.max_qual_level%TYPE
1316: ) IS
1317: --
1318: l_proc varchar2(72):= g_package|| 'chk_qual_rank';
1319: l_min_qual_rank per_qualification_types.rank%TYPE;
1320: l_max_qual_rank per_qualification_types.rank%TYPE;
1321: --
1322: cursor csr_qual_rank(c_qual_type_id per_qualification_types.qualification_type_id%TYPE) is
1323: select rank from per_qualification_types where qualification_type_id = c_qual_type_id;

Line 1320: l_max_qual_rank per_qualification_types.rank%TYPE;

1316: ) IS
1317: --
1318: l_proc varchar2(72):= g_package|| 'chk_qual_rank';
1319: l_min_qual_rank per_qualification_types.rank%TYPE;
1320: l_max_qual_rank per_qualification_types.rank%TYPE;
1321: --
1322: cursor csr_qual_rank(c_qual_type_id per_qualification_types.qualification_type_id%TYPE) is
1323: select rank from per_qualification_types where qualification_type_id = c_qual_type_id;
1324: --

Line 1322: cursor csr_qual_rank(c_qual_type_id per_qualification_types.qualification_type_id%TYPE) is

1318: l_proc varchar2(72):= g_package|| 'chk_qual_rank';
1319: l_min_qual_rank per_qualification_types.rank%TYPE;
1320: l_max_qual_rank per_qualification_types.rank%TYPE;
1321: --
1322: cursor csr_qual_rank(c_qual_type_id per_qualification_types.qualification_type_id%TYPE) is
1323: select rank from per_qualification_types where qualification_type_id = c_qual_type_id;
1324: --
1325: begin
1326: hr_utility.set_location('Entering:'||l_proc,10);

Line 1323: select rank from per_qualification_types where qualification_type_id = c_qual_type_id;

1319: l_min_qual_rank per_qualification_types.rank%TYPE;
1320: l_max_qual_rank per_qualification_types.rank%TYPE;
1321: --
1322: cursor csr_qual_rank(c_qual_type_id per_qualification_types.qualification_type_id%TYPE) is
1323: select rank from per_qualification_types where qualification_type_id = c_qual_type_id;
1324: --
1325: begin
1326: hr_utility.set_location('Entering:'||l_proc,10);
1327: -- Only proceed with rank validation when multiple message list does not