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_WDT_BUS dependencies on PQH_WORKSHEET_DETAILS

Line 56: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_PK');

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

Line 66: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_PK');

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

Line 111: from pqh_worksheet_details a

107: l_dummy varchar2(1);
108: --
109: cursor c1 is
110: select null
111: from pqh_worksheet_details a
112: where a.worksheet_detail_id = p_parent_worksheet_detail_id;
113: --
114: Begin
115: --

Line 128: -- check if parent_worksheet_detail_id value exists in pqh_worksheet_details table

124: <> nvl(pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_parent_worksheet_detail_id is not null then
127: --
128: -- check if parent_worksheet_detail_id value exists in pqh_worksheet_details table
129: --
130: open c1;
131: --
132: fetch c1 into l_dummy;

Line 137: -- raise error as FK does not relate to PK in pqh_worksheet_details

133: if c1%notfound then
134: --
135: close c1;
136: --
137: -- raise error as FK does not relate to PK in pqh_worksheet_details
138: -- table.
139: --
140: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK8');
141: --

Line 140: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK8');

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

Line 215: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK7');

211: --
212: -- raise error as FK does not relate to PK in pqh_worksheets
213: -- table.
214: --
215: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK7');
216: --
217: end if;
218: --
219: close c1;

Line 326: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK6');

322: --
323: -- raise error as FK does not relate to PK in per_grades
324: -- table.
325: --
326: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK6');
327: --
328: end if;
329: --
330: close c1;

Line 402: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK5');

398: --
399: -- raise error as FK does not relate to PK in per_jobs
400: -- table.
401: --
402: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK5');
403: --
404: end if;
405: --
406: close c1;

Line 478: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK4');

474: --
475: -- raise error as FK does not relate to PK in pqh_position_transactions
476: -- table.
477: --
478: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK4');
479: --
480: end if;
481: --
482: close c1;

Line 554: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK3');

550: --
551: -- raise error as FK does not relate to PK in pqh_budget_details
552: -- table.
553: --
554: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK3');
555: --
556: end if;
557: --
558: close c1;

Line 648: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK2');

644: --
645: -- raise error as FK does not relate to PK in hr_organization_units
646: -- table.
647: --
648: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK2');
649: --
650: end if;
651: --
652: close c1;