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_TCT_BUS dependencies on HR_API

Line 51: and nvl(p_transaction_category_id,hr_api.g_number)

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

Line 123: and nvl(p_consolidated_table_route_id,hr_api.g_number)

119: (p_transaction_category_id => p_transaction_category_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_consolidated_table_route_id,hr_api.g_number)
124: <> nvl(pqh_tct_shd.g_old_rec.consolidated_table_route_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if consolidated_table_route_id value exists in pqh_table_route table

Line 124: <> nvl(pqh_tct_shd.g_old_rec.consolidated_table_route_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_consolidated_table_route_id,hr_api.g_number)
124: <> nvl(pqh_tct_shd.g_old_rec.consolidated_table_route_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if consolidated_table_route_id value exists in pqh_table_route table
128: --

Line 199: and nvl(p_master_table_route_id,hr_api.g_number)

195: (p_transaction_category_id => p_transaction_category_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_master_table_route_id,hr_api.g_number)
200: <> nvl(pqh_tct_shd.g_old_rec.master_table_route_id,hr_api.g_number)
201: or not l_api_updating)
202: and p_master_table_route_id IS NOT NULL then
203: --

Line 200: <> nvl(pqh_tct_shd.g_old_rec.master_table_route_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_master_table_route_id,hr_api.g_number)
200: <> nvl(pqh_tct_shd.g_old_rec.master_table_route_id,hr_api.g_number)
201: or not l_api_updating)
202: and p_master_table_route_id IS NOT NULL then
203: --
204: -- check if master_table_route_id value exists in pqh_table_route table

Line 265: and nvl(p_business_group_id,hr_api.g_number)

261: (p_transaction_category_id => p_transaction_category_id,
262: p_object_version_number => p_object_version_number);
263: --
264: if (l_api_updating
265: and nvl(p_business_group_id,hr_api.g_number)
266: <> nvl(pqh_tct_shd.g_old_rec.business_group_id,hr_api.g_number)
267: or not l_api_updating)
268: and p_business_group_id is not null then
269: --

Line 266: <> nvl(pqh_tct_shd.g_old_rec.business_group_id,hr_api.g_number)

262: p_object_version_number => p_object_version_number);
263: --
264: if (l_api_updating
265: and nvl(p_business_group_id,hr_api.g_number)
266: <> nvl(pqh_tct_shd.g_old_rec.business_group_id,hr_api.g_number)
267: or not l_api_updating)
268: and p_business_group_id is not null then
269: --
270: -- check if business_group_id exists in hr_all_organization_units table

Line 337: <> nvl(pqh_tct_shd.g_old_rec.setup_type_cd,hr_api.g_varchar2)

333: p_object_version_number => p_object_version_number);
334: --
335: if (l_api_updating
336: and p_setup_type_cd
337: <> nvl(pqh_tct_shd.g_old_rec.setup_type_cd,hr_api.g_varchar2)
338: or not l_api_updating)
339: and p_setup_type_cd is not null then
340: --
341: -- check if value of lookup falls within lookup type.

Line 343: if hr_api.not_exists_in_hr_lookups

339: and p_setup_type_cd is not null then
340: --
341: -- check if value of lookup falls within lookup type.
342: --
343: if hr_api.not_exists_in_hr_lookups
344: (p_lookup_type => 'PQH_TXN_CAT_SETUP_TYPE',
345: p_lookup_code => p_setup_type_cd,
346: p_effective_date => p_effective_date) then
347: --

Line 407: <> nvl(pqh_tct_shd.g_old_rec.route_validated_txn_flag,hr_api.g_varchar2)

403: p_object_version_number => p_object_version_number);
404: --
405: if (l_api_updating
406: and p_route_validated_txn_flag
407: <> nvl(pqh_tct_shd.g_old_rec.route_validated_txn_flag,hr_api.g_varchar2)
408: or not l_api_updating) then
409: --
410: -- check if value of lookup falls within lookup type.
411: --

Line 413: if hr_api.not_exists_in_hr_lookups

409: --
410: -- check if value of lookup falls within lookup type.
411: --
412: --
413: if hr_api.not_exists_in_hr_lookups
414: (p_lookup_type => 'YES_NO',
415: p_lookup_code => p_route_validated_txn_flag,
416: p_effective_date => p_effective_date) then
417: --

Line 475: <> nvl(pqh_tct_shd.g_old_rec.workflow_enable_flag,hr_api.g_varchar2)

471: p_object_version_number => p_object_version_number);
472: --
473: if (l_api_updating
474: and p_workflow_enable_flag
475: <> nvl(pqh_tct_shd.g_old_rec.workflow_enable_flag,hr_api.g_varchar2)
476: or not l_api_updating) and
477: p_workflow_enable_flag is NOT NULL then
478: --
479: -- check if value of lookup falls within lookup type.

Line 482: if hr_api.not_exists_in_hr_lookups

478: --
479: -- check if value of lookup falls within lookup type.
480: --
481: --
482: if hr_api.not_exists_in_hr_lookups
483: (p_lookup_type => 'YES_NO',
484: p_lookup_code => p_workflow_enable_flag,
485: p_effective_date => p_effective_date) then
486: --

Line 544: <> nvl(pqh_tct_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

540: p_object_version_number => p_object_version_number);
541: --
542: if (l_api_updating
543: and p_enable_flag
544: <> nvl(pqh_tct_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
545: or not l_api_updating) and
546: p_enable_flag is NOT NULL then
547: --
548: -- check if value of lookup falls within lookup type.

Line 551: if hr_api.not_exists_in_hr_lookups

547: --
548: -- check if value of lookup falls within lookup type.
549: --
550: --
551: if hr_api.not_exists_in_hr_lookups
552: (p_lookup_type => 'YES_NO',
553: p_lookup_code => p_enable_flag,
554: p_effective_date => p_effective_date) then
555: --

Line 613: <> nvl(pqh_tct_shd.g_old_rec.post_style_cd,hr_api.g_varchar2)

609: p_object_version_number => p_object_version_number);
610: --
611: if (l_api_updating
612: and p_post_style_cd
613: <> nvl(pqh_tct_shd.g_old_rec.post_style_cd,hr_api.g_varchar2)
614: or not l_api_updating) then
615: --
616: -- check if value of lookup falls within lookup type.
617: --

Line 619: if hr_api.not_exists_in_hr_lookups

615: --
616: -- check if value of lookup falls within lookup type.
617: --
618: --
619: if hr_api.not_exists_in_hr_lookups
620: (p_lookup_type => 'PQH_POST_STYLE',
621: p_lookup_code => p_post_style_cd,
622: p_effective_date => p_effective_date) then
623: --

Line 715: <> nvl(pqh_tct_shd.g_old_rec.member_cd,hr_api.g_varchar2)

711: p_object_version_number => p_object_version_number);
712: --
713: if (l_api_updating
714: and p_member_cd
715: <> nvl(pqh_tct_shd.g_old_rec.member_cd,hr_api.g_varchar2)
716: or not l_api_updating) then
717: --
718: -- check if value of lookup falls within lookup type.
719: --

Line 721: if hr_api.not_exists_in_hr_lookups

717: --
718: -- check if value of lookup falls within lookup type.
719: --
720: --
721: if hr_api.not_exists_in_hr_lookups
722: (p_lookup_type => 'PQH_MEMBER_CD',
723: p_lookup_code => p_member_cd,
724: p_effective_date => p_effective_date) then
725: --

Line 741: <> nvl(pqh_tct_shd.g_old_rec.member_cd,hr_api.g_varchar2) then

737: --
738: /****
739: if l_api_updating
740: and p_member_cd
741: <> nvl(pqh_tct_shd.g_old_rec.member_cd,hr_api.g_varchar2) then
742: --
743: chk_member_cd_upd_allowed
744: (p_transaction_category_id => p_transaction_category_id);
745: --

Line 797: <> nvl(pqh_tct_shd.g_old_rec.future_action_cd,hr_api.g_varchar2)

793: p_object_version_number => p_object_version_number);
794: --
795: if (l_api_updating
796: and p_future_action_cd
797: <> nvl(pqh_tct_shd.g_old_rec.future_action_cd,hr_api.g_varchar2)
798: or not l_api_updating) then
799: --
800: -- check if value of lookup falls within lookup type.
801: --

Line 803: if hr_api.not_exists_in_hr_lookups

799: --
800: -- check if value of lookup falls within lookup type.
801: --
802: --
803: if hr_api.not_exists_in_hr_lookups
804: (p_lookup_type => 'PQH_FUTURE_ACTION',
805: p_lookup_code => p_future_action_cd,
806: p_effective_date => p_effective_date) then
807: --

Line 1108: <> nvl(pqh_tct_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)

1104: p_object_version_number => p_object_version_number);
1105: --
1106: if (l_api_updating
1107: and p_freeze_status_cd
1108: <> nvl(pqh_tct_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)
1109: or not l_api_updating)
1110: and p_freeze_status_cd is not null then
1111: --
1112: -- check if value of lookup falls within lookup type.

Line 1114: if hr_api.not_exists_in_hr_lookups

1110: and p_freeze_status_cd is not null then
1111: --
1112: -- check if value of lookup falls within lookup type.
1113: --
1114: if hr_api.not_exists_in_hr_lookups
1115: (p_lookup_type => 'PQH_CATEGORY_FREEZE_STATUS',
1116: p_lookup_code => p_freeze_status_cd,
1117: p_effective_date => p_effective_date) then
1118: --

Line 1152: nvl(p_freeze_status_cd,hr_api.g_varchar2)

1148: /*** This check is available in PQHWSTCT. Removing from api as they are not
1149: applicable for the wizard.
1150: --
1151: if (l_api_updating AND
1152: nvl(p_freeze_status_cd,hr_api.g_varchar2)
1153: <> nvl(pqh_tct_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2))
1154: or NOT l_api_updating then
1155: --
1156: --

Line 1153: <> nvl(pqh_tct_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2))

1149: applicable for the wizard.
1150: --
1151: if (l_api_updating AND
1152: nvl(p_freeze_status_cd,hr_api.g_varchar2)
1153: <> nvl(pqh_tct_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2))
1154: or NOT l_api_updating then
1155: --
1156: --
1157: --

Line 1164: If nvl(pqh_tct_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2) =

1160: -- previously frozen.
1161: --
1162: if p_freeze_status_cd IS NULL then
1163: --
1164: If nvl(pqh_tct_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2) =
1165: 'FREEZE_ATTRIBUTES' then
1166: --
1167: l_active_txn_exists_flag := chk_active_transaction_exists
1168: (p_transaction_category_id => p_transaction_category_id);

Line 1269: (nvl(p_freeze_status_cd,hr_api.g_varchar2)

1265: -- Raise error if Trying to update details of a frozen transaction category ,
1266: -- If we are trying to unfreeze the category then allow updation
1267: --
1268: if l_api_updating AND
1269: (nvl(p_freeze_status_cd,hr_api.g_varchar2)
1270: = nvl(pqh_tct_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)) then
1271: --
1272: -- Disallow changing details of frozen category
1273: --

Line 1270: = nvl(pqh_tct_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)) then

1266: -- If we are trying to unfreeze the category then allow updation
1267: --
1268: if l_api_updating AND
1269: (nvl(p_freeze_status_cd,hr_api.g_varchar2)
1270: = nvl(pqh_tct_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)) then
1271: --
1272: -- Disallow changing details of frozen category
1273: --
1274: if pqh_tct_shd.g_old_rec.freeze_status_cd = 'FREEZE_CATEGORY' then

Line 1521: Open c2 for sql_stmt using hr_api.g_varchar2;

1517: ||')' ;
1518: --
1519: Begin
1520: --
1521: Open c2 for sql_stmt using hr_api.g_varchar2;
1522: --
1523: Fetch c2 into l_dummy;
1524: --
1525: If c2%found then