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.PQP_EXR_BUS dependencies on PQP_EXR_SHD

Line 249: (p_rec in pqp_exr_shd.g_rec_type

245: --
246: -- {End Of Comments}
247: -- ----------------------------------------------------------------------------
248: Procedure chk_non_updateable_args
249: (p_rec in pqp_exr_shd.g_rec_type
250: ) IS
251: --
252: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
253: l_error EXCEPTION;

Line 261: IF NOT pqp_exr_shd.api_updating

257: --
258: -- Only proceed with the validation if a row exists for the current
259: -- record in the HR Schema.
260: --
261: IF NOT pqp_exr_shd.api_updating
262: (p_exception_report_id => p_rec.exception_report_id
263: ,p_object_version_number => p_rec.object_version_number
264: ) THEN
265: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 272: nvl (pqp_exr_shd.g_old_rec.business_group_id, hr_api.g_number) THEN

268: fnd_message.raise_error;
269: END IF;
270:
271: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
272: nvl (pqp_exr_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
273: l_argument := 'business_group_id';
274: RAISE l_error;
275: END IF;
276:

Line 278: nvl (pqp_exr_shd.g_old_rec.legislation_code, hr_api.g_varchar2) THEN

274: RAISE l_error;
275: END IF;
276:
277: IF nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
278: nvl (pqp_exr_shd.g_old_rec.legislation_code, hr_api.g_varchar2) THEN
279: l_argument := 'legislation_code';
280: RAISE l_error;
281: END IF;
282:

Line 383: l_api_updating := pqp_exr_shd.api_updating

379: -- a) The g_old_rec is current and
380: -- b) The currency code value has changed
381: --
382:
383: l_api_updating := pqp_exr_shd.api_updating
384: (p_exception_report_id => p_exception_report_id
385: ,p_object_version_number => p_object_version_number);
386:
387: --

Line 389: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.currency_code, hr_api.g_varchar2) <>

385: ,p_object_version_number => p_object_version_number);
386:
387: --
388:
389: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.currency_code, hr_api.g_varchar2) <>
390: nvl(p_currency_code, hr_api.g_varchar2))) or
391: (NOT l_api_updating)) THEN
392:
393: --

Line 492: l_api_updating := pqp_exr_shd.api_updating

488: -- a) The g_old_rec is current and
489: -- b) The balance type id value has changed
490: --
491:
492: l_api_updating := pqp_exr_shd.api_updating
493: (p_exception_report_id => p_exception_report_id
494: ,p_object_version_number => p_object_version_number);
495:
496: --

Line 498: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.balance_type_id, hr_api.g_number) <>

494: ,p_object_version_number => p_object_version_number);
495:
496: --
497:
498: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.balance_type_id, hr_api.g_number) <>
499: nvl(p_balance_type_id, hr_api.g_number))) or
500: (NOT l_api_updating)) THEN
501:
502: --

Line 599: l_api_updating := pqp_exr_shd.api_updating

595: -- a) The g_old_rec is current and
596: -- b) The balance dimension id value has changed
597: --
598:
599: l_api_updating := pqp_exr_shd.api_updating
600: (p_exception_report_id => p_exception_report_id
601: ,p_object_version_number => p_object_version_number);
602:
603: --

Line 605: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.balance_dimension_id, hr_api.g_number) <>

601: ,p_object_version_number => p_object_version_number);
602:
603: --
604:
605: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.balance_dimension_id, hr_api.g_number) <>
606: nvl(p_balance_dimension_id, hr_api.g_number))) or
607: (NOT l_api_updating)) THEN
608:
609: --

Line 692: l_api_updating := pqp_exr_shd.api_updating

688: -- a) The g_old_rec is current and
689: -- b) The variance type value has changed
690: --
691:
692: l_api_updating := pqp_exr_shd.api_updating
693: (p_exception_report_id => p_exception_report_id
694: ,p_object_version_number => p_object_version_number);
695:
696: --

Line 698: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.variance_type, hr_api.g_varchar2) <>

694: ,p_object_version_number => p_object_version_number);
695:
696: --
697:
698: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.variance_type, hr_api.g_varchar2) <>
699: nvl(p_variance_type, hr_api.g_varchar2))) or
700: (NOT l_api_updating)) THEN
701:
702: IF p_variance_type is not null THEN

Line 795: l_api_updating := pqp_exr_shd.api_updating

791: -- a) The g_old_rec is current and
792: -- b) The output_format type value has changed
793: --
794:
795: l_api_updating := pqp_exr_shd.api_updating
796: (p_exception_report_id => p_exception_report_id
797: ,p_object_version_number => p_object_version_number);
798:
799: --

Line 800: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.output_format_type, hr_api.g_varchar2) <>

796: (p_exception_report_id => p_exception_report_id
797: ,p_object_version_number => p_object_version_number);
798:
799: --
800: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.output_format_type, hr_api.g_varchar2) <>
801: nvl(p_output_format_type, hr_api.g_varchar2))) or
802: (NOT l_api_updating)) THEN
803:
804: IF p_output_format_type is not null THEN

Line 917: l_api_updating := pqp_exr_shd.api_updating

913: --
914:
915: IF p_variance_type = 'P' and
916: p_variance_value is not null THEN
917: l_api_updating := pqp_exr_shd.api_updating
918: (p_exception_report_id => p_exception_report_id
919: ,p_object_version_number => p_object_version_number);
920:
921: --

Line 924: and (nvl(pqp_exr_shd.g_old_rec.variance_value, hr_api.g_number) <> nvl(p_variance_value, hr_api.g_number)))

920:
921: --
922:
923: /* IF ((l_api_updating
924: and (nvl(pqp_exr_shd.g_old_rec.variance_value, hr_api.g_number) <> nvl(p_variance_value, hr_api.g_number)))
925: OR (NOT l_api_updating))
926: THEN */ -- commented by pjavaji
927:
928: --

Line 1021: l_api_updating := pqp_exr_shd.api_updating

1017: -- a) The g_old_rec is current and
1018: -- b) The comparison type value has changed
1019: --
1020:
1021: l_api_updating := pqp_exr_shd.api_updating
1022: (p_exception_report_id => p_exception_report_id
1023: ,p_object_version_number => p_object_version_number);
1024:
1025: --

Line 1026: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_type, hr_api.g_varchar2) <>

1022: (p_exception_report_id => p_exception_report_id
1023: ,p_object_version_number => p_object_version_number);
1024:
1025: --
1026: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_type, hr_api.g_varchar2) <>
1027: nvl(p_comparison_type, hr_api.g_varchar2))) or
1028: (NOT l_api_updating)) THEN
1029:
1030: IF p_comparison_type is not null THEN

Line 1156: l_api_updating := pqp_exr_shd.api_updating

1152: -- a) The g_old_rec is current and
1153: -- b) The variance_operator type value has changed
1154: --
1155:
1156: l_api_updating := pqp_exr_shd.api_updating
1157: (p_exception_report_id => p_exception_report_id
1158: ,p_object_version_number => p_object_version_number);
1159:
1160: --

Line 1161: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.variance_operator, hr_api.g_varchar2) <>

1157: (p_exception_report_id => p_exception_report_id
1158: ,p_object_version_number => p_object_version_number);
1159:
1160: --
1161: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.variance_operator, hr_api.g_varchar2) <>
1162: nvl(p_variance_operator, hr_api.g_varchar2))) or
1163: (NOT l_api_updating)) THEN
1164:
1165: IF p_variance_operator is not null THEN

Line 1272: l_api_updating := pqp_exr_shd.api_updating

1268: --
1269:
1270: IF substr(p_comparison_type,2,1) = 'P' THEN
1271:
1272: l_api_updating := pqp_exr_shd.api_updating
1273: (p_exception_report_id => p_exception_report_id
1274: ,p_object_version_number => p_object_version_number);
1275:
1276: --

Line 1277: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_value, hr_api.g_number) <>

1273: (p_exception_report_id => p_exception_report_id
1274: ,p_object_version_number => p_object_version_number);
1275:
1276: --
1277: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_value, hr_api.g_number) <>
1278: nvl(p_comparison_value, hr_api.g_number))) or
1279: (NOT l_api_updating)) THEN
1280:
1281:

Line 1303: l_api_updating := pqp_exr_shd.api_updating

1299: --
1300: --Added by sshetty
1301: IF substr(p_comparison_type,2,1) = 'C' THEN
1302:
1303: l_api_updating := pqp_exr_shd.api_updating
1304: (p_exception_report_id => p_exception_report_id
1305: ,p_object_version_number => p_object_version_number);
1306:
1307: --

Line 1308: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_value, hr_api.g_number) <>

1304: (p_exception_report_id => p_exception_report_id
1305: ,p_object_version_number => p_object_version_number);
1306:
1307: --
1308: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_value, hr_api.g_number) <>
1309: nvl(p_comparison_value, hr_api.g_number))) or
1310: (NOT l_api_updating)) THEN
1311:
1312:

Line 1413: l_api_updating := pqp_exr_shd.api_updating

1409: -- a) The g_old_rec is current and
1410: -- b) The report name has changed
1411: --
1412:
1413: l_api_updating := pqp_exr_shd.api_updating
1414: (p_exception_report_id => p_exception_report_id
1415: ,p_object_version_number => p_object_version_number);
1416:
1417: --

Line 1418: IF ((l_api_updating and (pqp_exr_shd.g_old_rec.exception_report_name) <>

1414: (p_exception_report_id => p_exception_report_id
1415: ,p_object_version_number => p_object_version_number);
1416:
1417: --
1418: IF ((l_api_updating and (pqp_exr_shd.g_old_rec.exception_report_name) <>
1419: (p_exception_report_name)) or
1420: (NOT l_api_updating)) THEN
1421:
1422: --

Line 1522: Procedure chk_del_seed_report ( p_rec in pqp_exr_shd.g_rec_type)

1518: --This procedure is introduced when a bug was detected
1519: --while deleteing the seeded report which was throwing
1520: --core message.
1521:
1522: Procedure chk_del_seed_report ( p_rec in pqp_exr_shd.g_rec_type)
1523: IS
1524:
1525: BEGIN
1526:

Line 1537: Procedure chk_upd_seed_report ( p_rec in pqp_exr_shd.g_rec_type)

1533:
1534: END;
1535:
1536:
1537: Procedure chk_upd_seed_report ( p_rec in pqp_exr_shd.g_rec_type)
1538: IS
1539:
1540: BEGIN
1541: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN

Line 1556: (p_rec in pqp_exr_shd.g_rec_type

1552: -- ----------------------------------------------------------------------------
1553: -- |---------------------------< insert_validate >----------------------------|
1554: -- ----------------------------------------------------------------------------
1555: Procedure insert_validate
1556: (p_rec in pqp_exr_shd.g_rec_type
1557: ) is
1558: --
1559:
1560: l_proc varchar2(72) := g_package||'insert_validate';

Line 1709: (p_rec in pqp_exr_shd.g_rec_type

1705: -- ----------------------------------------------------------------------------
1706: -- |---------------------------< update_validate >----------------------------|
1707: -- ----------------------------------------------------------------------------
1708: Procedure update_validate
1709: (p_rec in pqp_exr_shd.g_rec_type
1710: ) is
1711: --
1712: l_proc varchar2(72) := g_package||'update_validate';
1713: --

Line 1878: (p_rec in pqp_exr_shd.g_rec_type

1874: -- ----------------------------------------------------------------------------
1875: -- |---------------------------< delete_validate >----------------------------|
1876: -- ----------------------------------------------------------------------------
1877: Procedure delete_validate
1878: (p_rec in pqp_exr_shd.g_rec_type
1879: ) is
1880: --
1881: l_proc varchar2(72) := g_package||'delete_validate';
1882: --

Line 1887: IF pqp_exr_shd.g_old_rec.business_group_id IS NOT NULL THEN

1883: Begin
1884: hr_utility.set_location('Entering:'||l_proc, 5);
1885: --
1886: --
1887: IF pqp_exr_shd.g_old_rec.business_group_id IS NOT NULL THEN
1888: chk_startup_action(p_insert =>false
1889: ,p_business_group_id =>pqp_exr_shd.g_old_rec.business_group_id
1890: ,p_legislation_code =>pqp_exr_shd.g_old_rec.legislation_code
1891: ,p_legislation_subgroup =>NULL

Line 1889: ,p_business_group_id =>pqp_exr_shd.g_old_rec.business_group_id

1885: --
1886: --
1887: IF pqp_exr_shd.g_old_rec.business_group_id IS NOT NULL THEN
1888: chk_startup_action(p_insert =>false
1889: ,p_business_group_id =>pqp_exr_shd.g_old_rec.business_group_id
1890: ,p_legislation_code =>pqp_exr_shd.g_old_rec.legislation_code
1891: ,p_legislation_subgroup =>NULL
1892: );
1893: END IF;

Line 1890: ,p_legislation_code =>pqp_exr_shd.g_old_rec.legislation_code

1886: --
1887: IF pqp_exr_shd.g_old_rec.business_group_id IS NOT NULL THEN
1888: chk_startup_action(p_insert =>false
1889: ,p_business_group_id =>pqp_exr_shd.g_old_rec.business_group_id
1890: ,p_legislation_code =>pqp_exr_shd.g_old_rec.legislation_code
1891: ,p_legislation_subgroup =>NULL
1892: );
1893: END IF;
1894:

Line 1902: chk_del_seed_report ( p_rec=>pqp_exr_shd.g_old_rec);

1898:
1899: --
1900: -- Check whether exception record group exists for this report id
1901: --
1902: chk_del_seed_report ( p_rec=>pqp_exr_shd.g_old_rec);
1903: hr_multi_message.end_validation_set;
1904: hr_utility.set_location(l_proc, 10);
1905: chk_report_grp_exists(p_exception_report_id => p_rec.exception_report_id);
1906: Exception