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_PTX_BUS dependencies on PQH_POSITION_TRANSACTIONS

Line 56: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_PK');

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

Line 66: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_PK');

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

Line 140: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK9');

136: --
137: -- raise error as FK does not relate to PK in hr_all_organization_units
138: -- table.
139: --
140: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK9');
141: --
142: end if;
143: --
144: close c1;

Line 216: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK6');

212: --
213: -- raise error as FK does not relate to PK in per_position_definitions
214: -- table.
215: --
216: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK6');
217: --
218: end if;
219: --
220: close c1;

Line 292: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK5');

288: --
289: -- raise error as FK does not relate to PK in per_jobs
290: -- table.
291: --
292: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK5');
293: --
294: end if;
295: --
296: close c1;

Line 368: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK4');

364: --
365: -- raise error as FK does not relate to PK in hr_locations_all
366: -- table.
367: --
368: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK4');
369: --
370: end if;
371: --
372: close c1;

Line 444: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK12');

440: --
441: -- raise error as FK does not relate to PK in per_shared_types
442: -- table.
443: --
444: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK12');
445: --
446: end if;
447: --
448: close c1;

Line 520: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK11');

516: --
517: -- raise error as FK does not relate to PK in per_grades
518: -- table.
519: --
520: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK11');
521: --
522: end if;
523: --
524: close c1;

Line 1046: from pqh_position_transactions

1042: l_dummy varchar2(10);
1043: --
1044: cursor c_position_transactions(p_position_id number) is
1045: select 'x'
1046: from pqh_position_transactions
1047: where position_id = p_position_id
1048: and position_transaction_id <> p_position_transaction_id
1049: and transaction_status not in ('TERMINATE', 'APPLIED', 'REJECT');
1050: Begin

Line 2403: pqh_position_transactions b

2399: --
2400: cursor csr_leg_code is
2401: select a.legislation_code
2402: from per_business_groups a,
2403: pqh_position_transactions b
2404: where b.position_transaction_id = p_position_transaction_id
2405: and a.business_group_id = b.business_group_id;
2406: --
2407: -- Declare local variables