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 PQH_TCT_SHD

Line 46: l_api_updating := pqh_tct_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_tct_shd.api_updating
47: (p_transaction_category_id => p_transaction_category_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> pqh_tct_shd.g_old_rec.transaction_category_id) then

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: --
56: pqh_tct_shd.constraint_error('PQH_TRANSACTION_CATEGORIES_PK');

Line 56: pqh_tct_shd.constraint_error('PQH_TRANSACTION_CATEGORIES_PK');

52: <> pqh_tct_shd.g_old_rec.transaction_category_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_tct_shd.constraint_error('PQH_TRANSACTION_CATEGORIES_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pqh_tct_shd.constraint_error('PQH_TRANSACTION_CATEGORIES_PK');

62: if p_transaction_category_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_tct_shd.constraint_error('PQH_TRANSACTION_CATEGORIES_PK');
67: --
68: end if;
69: --
70: end if;

Line 118: l_api_updating := pqh_tct_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_tct_shd.api_updating
119: (p_transaction_category_id => p_transaction_category_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating

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 139: pqh_tct_shd.constraint_error('PQH_TRANSACTION_CATEGORIES_FK1');

135: --
136: -- raise error as FK does not relate to PK in pqh_table_route
137: -- table.
138: --
139: pqh_tct_shd.constraint_error('PQH_TRANSACTION_CATEGORIES_FK1');
140: --
141: end if;
142: --
143: close c1;

Line 194: l_api_updating := pqh_tct_shd.api_updating

190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_tct_shd.api_updating
195: (p_transaction_category_id => p_transaction_category_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating

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 216: pqh_tct_shd.constraint_error('PQH_TRANSACTION_CATEGORIES_FK2');

212: --
213: -- raise error as FK does not relate to PK in pqh_table_route
214: -- table.
215: --
216: pqh_tct_shd.constraint_error('PQH_TRANSACTION_CATEGORIES_FK2');
217: --
218: --
219: end if;
220: --

Line 260: l_api_updating := pqh_tct_shd.api_updating

256: Begin
257: --
258: hr_utility.set_location('Entering:'||l_proc,5);
259: --
260: l_api_updating := pqh_tct_shd.api_updating
261: (p_transaction_category_id => p_transaction_category_id,
262: p_object_version_number => p_object_version_number);
263: --
264: if (l_api_updating

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 331: l_api_updating := pqh_tct_shd.api_updating

327: Begin
328: --
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: l_api_updating := pqh_tct_shd.api_updating
332: (p_transaction_category_id => p_transaction_category_id,
333: p_object_version_number => p_object_version_number);
334: --
335: if (l_api_updating

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 401: l_api_updating := pqh_tct_shd.api_updating

397: Begin
398: --
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: l_api_updating := pqh_tct_shd.api_updating
402: (p_transaction_category_id => p_transaction_category_id,
403: p_object_version_number => p_object_version_number);
404: --
405: if (l_api_updating

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 469: l_api_updating := pqh_tct_shd.api_updating

465: Begin
466: --
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: --
469: l_api_updating := pqh_tct_shd.api_updating
470: (p_transaction_category_id => p_transaction_category_id,
471: p_object_version_number => p_object_version_number);
472: --
473: if (l_api_updating

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 538: l_api_updating := pqh_tct_shd.api_updating

534: Begin
535: --
536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: l_api_updating := pqh_tct_shd.api_updating
539: (p_transaction_category_id => p_transaction_category_id,
540: p_object_version_number => p_object_version_number);
541: --
542: if (l_api_updating

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 607: l_api_updating := pqh_tct_shd.api_updating

603: Begin
604: --
605: hr_utility.set_location('Entering:'||l_proc, 5);
606: --
607: l_api_updating := pqh_tct_shd.api_updating
608: (p_transaction_category_id => p_transaction_category_id,
609: p_object_version_number => p_object_version_number);
610: --
611: if (l_api_updating

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 709: l_api_updating := pqh_tct_shd.api_updating

705: Begin
706: --
707: hr_utility.set_location('Entering:'||l_proc, 5);
708: --
709: l_api_updating := pqh_tct_shd.api_updating
710: (p_transaction_category_id => p_transaction_category_id,
711: p_object_version_number => p_object_version_number);
712: --
713: if (l_api_updating

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 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 791: l_api_updating := pqh_tct_shd.api_updating

787: Begin
788: --
789: hr_utility.set_location('Entering:'||l_proc, 5);
790: --
791: l_api_updating := pqh_tct_shd.api_updating
792: (p_transaction_category_id => p_transaction_category_id,
793: p_object_version_number => p_object_version_number);
794: --
795: if (l_api_updating

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 1102: l_api_updating := pqh_tct_shd.api_updating

1098: Begin
1099: --
1100: hr_utility.set_location('Entering:'||l_proc, 5);
1101: --
1102: l_api_updating := pqh_tct_shd.api_updating
1103: (p_transaction_category_id => p_transaction_category_id,
1104: p_object_version_number => p_object_version_number);
1105: --
1106: if (l_api_updating

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 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 1261: l_api_updating := pqh_tct_shd.api_updating

1257: Begin
1258: --
1259: hr_utility.set_location('Entering:'||l_proc, 5);
1260: --
1261: l_api_updating := pqh_tct_shd.api_updating
1262: (p_transaction_category_id => p_transaction_category_id,
1263: p_object_version_number => p_object_version_number);
1264: --
1265: -- Raise error if Trying to update details of a frozen transaction category ,

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 1274: if pqh_tct_shd.g_old_rec.freeze_status_cd = 'FREEZE_CATEGORY' then

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
1275: --
1276: hr_utility.set_message(8302,'PQH_NO_UPD_FROZEN_TCT');
1277: hr_utility.raise_error;
1278: --

Line 1551: Procedure insert_validate(p_rec in pqh_tct_shd.g_rec_type

1547: --
1548: -- ----------------------------------------------------------------------------
1549: -- |---------------------------< insert_validate >----------------------------|
1550: -- ----------------------------------------------------------------------------
1551: Procedure insert_validate(p_rec in pqh_tct_shd.g_rec_type
1552: ,p_effective_date in date) is
1553: --
1554: l_proc varchar2(72) := g_package||'insert_validate';
1555: --

Line 1643: Procedure update_validate(p_rec in pqh_tct_shd.g_rec_type

1639: --
1640: -- ----------------------------------------------------------------------------
1641: -- |---------------------------< update_validate >----------------------------|
1642: -- ----------------------------------------------------------------------------
1643: Procedure update_validate(p_rec in pqh_tct_shd.g_rec_type
1644: ,p_effective_date in date) is
1645: --
1646: l_proc varchar2(72) := g_package||'update_validate';
1647: --

Line 1735: Procedure delete_validate(p_rec in pqh_tct_shd.g_rec_type

1731: --
1732: -- ----------------------------------------------------------------------------
1733: -- |---------------------------< delete_validate >----------------------------|
1734: -- ----------------------------------------------------------------------------
1735: Procedure delete_validate(p_rec in pqh_tct_shd.g_rec_type
1736: ,p_effective_date in date) is
1737: --
1738: l_proc varchar2(72) := g_package||'delete_validate';
1739: --