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

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

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

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

119: (p_worksheet_id => p_worksheet_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_budget_version_id,hr_api.g_number)
124: <> nvl(pqh_wks_shd.g_old_rec.budget_version_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if budget_version_id value exists in pqh_budget_versions table

Line 124: <> nvl(pqh_wks_shd.g_old_rec.budget_version_id,hr_api.g_number)

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

Line 198: and nvl(p_budget_id,hr_api.g_number)

194: (p_worksheet_id => p_worksheet_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_budget_id,hr_api.g_number)
199: <> nvl(pqh_wks_shd.g_old_rec.budget_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if budget_id value exists in pqh_budgets table

Line 199: <> nvl(pqh_wks_shd.g_old_rec.budget_id,hr_api.g_number)

195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_budget_id,hr_api.g_number)
199: <> nvl(pqh_wks_shd.g_old_rec.budget_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if budget_id value exists in pqh_budgets table
203: --

Line 270: <> nvl(pqh_wks_shd.g_old_rec.worksheet_mode_cd,hr_api.g_varchar2)

266: p_object_version_number => p_object_version_number);
267: --
268: if (l_api_updating
269: and p_worksheet_mode_cd
270: <> nvl(pqh_wks_shd.g_old_rec.worksheet_mode_cd,hr_api.g_varchar2)
271: or not l_api_updating)
272: and p_worksheet_mode_cd is not null then
273: --
274: -- check if value of lookup falls within lookup type.

Line 276: if hr_api.not_exists_in_hr_lookups

272: and p_worksheet_mode_cd is not null then
273: --
274: -- check if value of lookup falls within lookup type.
275: --
276: if hr_api.not_exists_in_hr_lookups
277: (p_lookup_type => 'PQH_WORKSHEET_MODE',
278: p_lookup_code => p_worksheet_mode_cd,
279: p_effective_date => p_effective_date) then
280: --

Line 338: <> nvl(pqh_wks_shd.g_old_rec.transaction_status,hr_api.g_varchar2)

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

Line 344: if hr_api.not_exists_in_hr_lookups

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

Line 406: <> nvl(pqh_wks_shd.g_old_rec.propagation_method,hr_api.g_varchar2)

402: p_object_version_number => p_object_version_number);
403: --
404: if (l_api_updating
405: and p_propagation_method
406: <> nvl(pqh_wks_shd.g_old_rec.propagation_method,hr_api.g_varchar2)
407: or not l_api_updating)
408: and p_propagation_method is not null then
409: --
410: -- check if value of lookup falls within lookup type.

Line 412: if hr_api.not_exists_in_hr_lookups

408: and p_propagation_method is not null then
409: --
410: -- check if value of lookup falls within lookup type.
411: --
412: if hr_api.not_exists_in_hr_lookups
413: (p_lookup_type => 'PQH_WORKSHEET_PROPAGATE_METHOD',
414: p_lookup_code => p_propagation_method,
415: p_effective_date => p_effective_date) then
416: --

Line 482: <> nvl(pqh_wks_shd.g_old_rec.version_number,hr_api.g_number)

478: p_object_version_number => p_object_version_number);
479: --
480: if (l_api_updating
481: and p_version_number
482: <> nvl(pqh_wks_shd.g_old_rec.version_number,hr_api.g_number)
483: or not l_api_updating)
484: and p_version_number is not null then
485: --
486: -- check if value of lookup falls within lookup type.