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.PQH_RCT_BUS dependencies on HR_API

Line 52: and nvl(p_routing_category_id,hr_api.g_number)

48: (p_routing_category_id => p_routing_category_id,
49: p_object_version_number => p_object_version_number);
50: --
51: if (l_api_updating
52: and nvl(p_routing_category_id,hr_api.g_number)
53: <> pqh_rct_shd.g_old_rec.routing_category_id) then
54: --
55: -- raise error as PK has changed
56: --

Line 126: nvl(p_transaction_category_id,hr_api.g_number)

122: (p_routing_category_id => p_routing_category_id,
123: p_object_version_number => p_object_version_number);
124: --
125: if (l_api_updating AND
126: nvl(p_transaction_category_id,hr_api.g_number)
127: = nvl(pqh_rct_shd.g_old_rec.transaction_category_id,hr_api.g_number)
128: or not l_api_updating) then
129: --
130: -- check if transaction_category_id value exists in

Line 127: = nvl(pqh_rct_shd.g_old_rec.transaction_category_id,hr_api.g_number)

123: p_object_version_number => p_object_version_number);
124: --
125: if (l_api_updating AND
126: nvl(p_transaction_category_id,hr_api.g_number)
127: = nvl(pqh_rct_shd.g_old_rec.transaction_category_id,hr_api.g_number)
128: or not l_api_updating) then
129: --
130: -- check if transaction_category_id value exists in
131: -- pqh_transaction_categories table

Line 207: <> nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

203: p_object_version_number => p_object_version_number);
204: --
205: if (l_api_updating
206: and p_enable_flag
207: <> nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
208: or not l_api_updating)
209: and p_enable_flag is not null then
210: --
211: -- check if value of lookup falls within lookup type.

Line 213: if hr_api.not_exists_in_hr_lookups

209: and p_enable_flag is not null then
210: --
211: -- check if value of lookup falls within lookup type.
212: --
213: if hr_api.not_exists_in_hr_lookups
214: (p_lookup_type => 'YES_NO',
215: p_lookup_code => p_enable_flag,
216: p_effective_date => p_effective_date) then
217: --

Line 234: p_enable_flag <> nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

230: -- overlap with any other rule in the same transaction category.
231: --
232: if l_api_updating and
233: p_enable_flag = 'Y' and
234: p_enable_flag <> nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
235: then
236: --
237: hr_utility.set_location('Enable allow :'||l_proc,8);
238: --

Line 311: <> nvl(pqh_rct_shd.g_old_rec.default_flag,hr_api.g_varchar2)

307: p_object_version_number => p_object_version_number);
308: --
309: if (l_api_updating
310: and p_default_flag
311: <> nvl(pqh_rct_shd.g_old_rec.default_flag,hr_api.g_varchar2)
312: or not l_api_updating)
313: and p_default_flag is not null then
314: --
315: -- check if value of lookup falls within lookup type.

Line 317: if hr_api.not_exists_in_hr_lookups

313: and p_default_flag is not null then
314: --
315: -- check if value of lookup falls within lookup type.
316: --
317: if hr_api.not_exists_in_hr_lookups
318: (p_lookup_type => 'YES_NO',
319: p_lookup_code => p_default_flag,
320: p_effective_date => p_effective_date) then
321: --

Line 381: <> nvl(pqh_rct_shd.g_old_rec.delete_flag,hr_api.g_varchar2)

377: p_object_version_number => p_object_version_number);
378: --
379: if (l_api_updating
380: and p_delete_flag
381: <> nvl(pqh_rct_shd.g_old_rec.delete_flag,hr_api.g_varchar2)
382: or not l_api_updating)
383: and p_delete_flag is not null then
384: --
385: -- check if value of lookup falls within lookup type.

Line 387: if hr_api.not_exists_in_hr_lookups

383: and p_delete_flag is not null then
384: --
385: -- check if value of lookup falls within lookup type.
386: --
387: if hr_api.not_exists_in_hr_lookups
388: (p_lookup_type => 'YES_NO',
389: p_lookup_code => p_delete_flag,
390: p_effective_date => p_effective_date) then
391: --

Line 426: select nvl(freeze_status_cd,hr_api.g_varchar2)

422: l_dummy varchar2(1);
423: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;
424: --
425: cursor c1 is
426: select nvl(freeze_status_cd,hr_api.g_varchar2)
427: from pqh_transaction_categories a
428: where a.transaction_category_id = p_transaction_category_id;
429: --
430: Begin

Line 442: nvl(p_transaction_category_id,hr_api.g_number)

438: -- Raise Error if trying to update the transaction category of the
439: -- routing category.
440: --
441: if (l_api_updating AND
442: nvl(p_transaction_category_id,hr_api.g_number)
443: <> nvl(pqh_rct_shd.g_old_rec.transaction_category_id,hr_api.g_number)) then
444: --
445: -- Cannot update the transaction category id
446: --

Line 443: <> nvl(pqh_rct_shd.g_old_rec.transaction_category_id,hr_api.g_number)) then

439: -- routing category.
440: --
441: if (l_api_updating AND
442: nvl(p_transaction_category_id,hr_api.g_number)
443: <> nvl(pqh_rct_shd.g_old_rec.transaction_category_id,hr_api.g_number)) then
444: --
445: -- Cannot update the transaction category id
446: --
447: hr_utility.set_message(8302,'PQH_NO_UPD_TRAN_CAT_OF_RCAT');

Line 500: nvl(p_enable_flag,hr_api.g_varchar2)

496: -- Raise Error,if trying to update details of a routing category other
497: -- than its enable flag.
498: --
499: if l_api_updating AND
500: nvl(p_enable_flag,hr_api.g_varchar2)
501: = nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2) then
502: --
503: hr_utility.set_message(8302,'PQH_NO_UPDATE_ROUT_CAT');
504: hr_utility.raise_error;

Line 501: = nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2) then

497: -- than its enable flag.
498: --
499: if l_api_updating AND
500: nvl(p_enable_flag,hr_api.g_varchar2)
501: = nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2) then
502: --
503: hr_utility.set_message(8302,'PQH_NO_UPDATE_ROUT_CAT');
504: hr_utility.raise_error;
505: --

Line 598: nvl(p_routing_list_id,hr_api.g_number)

594: hr_utility.set_message(8302,'PQH_ROUTING_LIST_ID_IS_NULL');
595: hr_utility.raise_error;
596: Else
597: if (l_api_updating AND
598: nvl(p_routing_list_id,hr_api.g_number)
599: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number)) then
600: --
601: -- Disallow updates to routing list id field, if detail recs exist
602: --

Line 599: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number)) then

595: hr_utility.raise_error;
596: Else
597: if (l_api_updating AND
598: nvl(p_routing_list_id,hr_api.g_number)
599: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number)) then
600: --
601: -- Disallow updates to routing list id field, if detail recs exist
602: --
603: open c2;

Line 628: nvl(p_position_structure_id,hr_api.g_number)

624: hr_utility.set_message(8302,'PQH_POS_STRUCT_ID_IS_NULL');
625: hr_utility.raise_error;
626: Else
627: if (l_api_updating AND
628: nvl(p_position_structure_id,hr_api.g_number)
629: <> nvl(pqh_rct_shd.g_old_rec.position_structure_id,hr_api.g_number)) then
630: --
631: -- Disallow updates to position_structure_id field, if detail recs exist
632: --

Line 629: <> nvl(pqh_rct_shd.g_old_rec.position_structure_id,hr_api.g_number)) then

625: hr_utility.raise_error;
626: Else
627: if (l_api_updating AND
628: nvl(p_position_structure_id,hr_api.g_number)
629: <> nvl(pqh_rct_shd.g_old_rec.position_structure_id,hr_api.g_number)) then
630: --
631: -- Disallow updates to position_structure_id field, if detail recs exist
632: --
633: open c2;

Line 662: if l_api_updating and nvl(p_routing_list_id,hr_api.g_number)

658: --
659: **/
660:
661: --
662: if l_api_updating and nvl(p_routing_list_id,hr_api.g_number)
663: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number) then
664: --
665: -- Disallow any updates to the routing list id if there are any
666: -- child records for this routing category.

Line 663: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number) then

659: **/
660:
661: --
662: if l_api_updating and nvl(p_routing_list_id,hr_api.g_number)
663: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number) then
664: --
665: -- Disallow any updates to the routing list id if there are any
666: -- child records for this routing category.
667: --

Line 683: if (l_api_updating and nvl(p_routing_list_id,hr_api.g_number)

679: --
680: -- Inserting a new routing category or updating the list id of an existing
681: -- category.
682: --
683: if (l_api_updating and nvl(p_routing_list_id,hr_api.g_number)
684: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number))
685: OR NOT l_api_updating then
686: --
687: -- Validate if the member_cd matches the list id and a list_id that

Line 684: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number))

680: -- Inserting a new routing category or updating the list id of an existing
681: -- category.
682: --
683: if (l_api_updating and nvl(p_routing_list_id,hr_api.g_number)
684: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number))
685: OR NOT l_api_updating then
686: --
687: -- Validate if the member_cd matches the list id and a list_id that
688: -- mismatches the member_cd is not supplied

Line 781: and nvl(p_routing_list_id,hr_api.g_number)

777: (p_routing_category_id => p_routing_category_id,
778: p_object_version_number => p_object_version_number);
779: --
780: if (l_api_updating
781: and nvl(p_routing_list_id,hr_api.g_number)
782: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number)
783: or not l_api_updating) and
784: p_routing_list_id is not null then
785: --

Line 782: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number)

778: p_object_version_number => p_object_version_number);
779: --
780: if (l_api_updating
781: and nvl(p_routing_list_id,hr_api.g_number)
782: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number)
783: or not l_api_updating) and
784: p_routing_list_id is not null then
785: --
786: -- check if routing_list_id value exists in pqh_routing_lists table

Line 867: and nvl(p_override_role_id,hr_api.g_number)

863: (p_routing_category_id => p_routing_category_id,
864: p_object_version_number => p_object_version_number);
865: --
866: if (l_api_updating
867: and nvl(p_override_role_id,hr_api.g_number)
868: <> nvl(pqh_rct_shd.g_old_rec.override_role_id,hr_api.g_number)
869: or not l_api_updating) and
870: p_override_role_id is not null then
871: --

Line 868: <> nvl(pqh_rct_shd.g_old_rec.override_role_id,hr_api.g_number)

864: p_object_version_number => p_object_version_number);
865: --
866: if (l_api_updating
867: and nvl(p_override_role_id,hr_api.g_number)
868: <> nvl(pqh_rct_shd.g_old_rec.override_role_id,hr_api.g_number)
869: or not l_api_updating) and
870: p_override_role_id is not null then
871: --
872: -- check if override_role_id value exists in

Line 963: and nvl(p_override_user_id,hr_api.g_number)

959: (p_routing_category_id => p_routing_category_id,
960: p_object_version_number => p_object_version_number);
961: --
962: if (l_api_updating
963: and nvl(p_override_user_id,hr_api.g_number)
964: <> nvl(pqh_rct_shd.g_old_rec.override_user_id,hr_api.g_number)
965: or not l_api_updating) and
966: p_override_user_id is not null then
967: --

Line 964: <> nvl(pqh_rct_shd.g_old_rec.override_user_id,hr_api.g_number)

960: p_object_version_number => p_object_version_number);
961: --
962: if (l_api_updating
963: and nvl(p_override_user_id,hr_api.g_number)
964: <> nvl(pqh_rct_shd.g_old_rec.override_user_id,hr_api.g_number)
965: or not l_api_updating) and
966: p_override_user_id is not null then
967: --
968: -- check if override_user_id value exists in

Line 1075: and nvl(p_position_structure_id,hr_api.g_number)

1071: (p_routing_category_id => p_routing_category_id,
1072: p_object_version_number => p_object_version_number);
1073: --
1074: if (l_api_updating
1075: and nvl(p_position_structure_id,hr_api.g_number)
1076: <> nvl(pqh_rct_shd.g_old_rec.position_structure_id,hr_api.g_number)
1077: or not l_api_updating) and
1078: p_position_structure_id is not null then
1079: --

Line 1076: <> nvl(pqh_rct_shd.g_old_rec.position_structure_id,hr_api.g_number)

1072: p_object_version_number => p_object_version_number);
1073: --
1074: if (l_api_updating
1075: and nvl(p_position_structure_id,hr_api.g_number)
1076: <> nvl(pqh_rct_shd.g_old_rec.position_structure_id,hr_api.g_number)
1077: or not l_api_updating) and
1078: p_position_structure_id is not null then
1079: --
1080: -- check if position_structure_id value exists in per_position_structures table

Line 1164: and nvl(p_override_position_id,hr_api.g_number)

1160: (p_routing_category_id => p_routing_category_id,
1161: p_object_version_number => p_object_version_number);
1162: --
1163: if (l_api_updating
1164: and nvl(p_override_position_id,hr_api.g_number)
1165: <> nvl(pqh_rct_shd.g_old_rec.override_position_id,hr_api.g_number)
1166: or not l_api_updating) and
1167: p_override_position_id is not null then
1168: --

Line 1165: <> nvl(pqh_rct_shd.g_old_rec.override_position_id,hr_api.g_number)

1161: p_object_version_number => p_object_version_number);
1162: --
1163: if (l_api_updating
1164: and nvl(p_override_position_id,hr_api.g_number)
1165: <> nvl(pqh_rct_shd.g_old_rec.override_position_id,hr_api.g_number)
1166: or not l_api_updating) and
1167: p_override_position_id is not null then
1168: --
1169: -- check if override_position_id value exists in hr_all_positions_f table

Line 1279: l_prev_range_name := hr_api.g_varchar2; -- some random value

1275: Close csr_routing_type;
1276: --
1277: l_prev_routing_cat := NULL;
1278: l_prev_list_name := NULL;
1279: l_prev_range_name := hr_api.g_varchar2; -- some random value
1280: null_rule_flag := 'N';
1281: --
1282: If l_routing_type = 'R' then
1283: sql_stmt := 'select b.routing_category_id,RLT.routing_list_name list_name,';