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.HR_QSN_BUS dependencies on HR_QSN_SHD

Line 69: (p_rec in hr_qsn_shd.g_rec_type

65: -- ----------------------------------------------------------------------------
66: -- |---------------------< chk_non_updateable_args >--------------------------|
67: -- ----------------------------------------------------------------------------
68: Procedure chk_non_updateable_args
69: (p_rec in hr_qsn_shd.g_rec_type
70: ) is
71: --
72: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
73: --

Line 80: if not hr_qsn_shd.api_updating

76: --
77: -- Only proceed with validation if a row exists for
78: -- the current record in the HR Schema
79: --
80: if not hr_qsn_shd.api_updating
81: (p_questionnaire_template_id => p_rec.questionnaire_template_id
82: ,p_object_version_number => p_rec.object_version_number
83: ) then
84: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');

Line 91: if nvl(p_rec.name,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.name then

87: fnd_message.raise_error;
88: end if;
89: hr_utility.set_location(l_proc,30);
90: --
91: if nvl(p_rec.name,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.name then
92: hr_api.argument_changed_error
93: (p_api_name => l_proc
94: ,p_argument => 'NAME'
95: ,p_base_table => hr_qsn_shd.g_tab_nam

Line 95: ,p_base_table => hr_qsn_shd.g_tab_nam

91: if nvl(p_rec.name,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.name then
92: hr_api.argument_changed_error
93: (p_api_name => l_proc
94: ,p_argument => 'NAME'
95: ,p_base_table => hr_qsn_shd.g_tab_nam
96: );
97: end if;
98: hr_utility.set_location(l_proc,40);
99: --

Line 101: if nvl(p_rec.text,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.text then

97: end if;
98: hr_utility.set_location(l_proc,40);
99: --
100: /**
101: if nvl(p_rec.text,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.text then
102: hr_api.argument_changed_error
103: (p_api_name => l_proc
104: ,p_argument => 'TEXT'
105: ,p_base_table => hr_qsn_shd.g_tab_nam

Line 105: ,p_base_table => hr_qsn_shd.g_tab_nam

101: if nvl(p_rec.text,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.text then
102: hr_api.argument_changed_error
103: (p_api_name => l_proc
104: ,p_argument => 'TEXT'
105: ,p_base_table => hr_qsn_shd.g_tab_nam
106: );
107: end if;
108: hr_utility.set_location(l_proc,50);
109: --

Line 111: hr_qsn_shd.g_old_rec.business_group_id then

107: end if;
108: hr_utility.set_location(l_proc,50);
109: --
110: if nvl(p_rec.business_group_id, hr_api.g_number) <>
111: hr_qsn_shd.g_old_rec.business_group_id then
112: hr_api.argument_changed_error
113: (p_api_name => l_proc
114: ,p_argument => 'BUSINESS_GROUP_ID'
115: ,p_base_table => hr_qsn_shd.g_tab_nam

Line 115: ,p_base_table => hr_qsn_shd.g_tab_nam

111: hr_qsn_shd.g_old_rec.business_group_id then
112: hr_api.argument_changed_error
113: (p_api_name => l_proc
114: ,p_argument => 'BUSINESS_GROUP_ID'
115: ,p_base_table => hr_qsn_shd.g_tab_nam
116: );
117: end if;
118: **/
119: --

Line 155: hr_qsn_shd.constraint_error('HR_QUESTIONNAIRES_UK1');

151: fetch csr_unique_name into l_exists;
152: if csr_unique_name%FOUND then
153: -- Name is not unique - raise error by calling constraint error
154: close csr_unique_name;
155: hr_qsn_shd.constraint_error('HR_QUESTIONNAIRES_UK1');
156: end if;
157: close csr_unique_name;
158: else
159: -- Name is null - raise error

Line 237: l_api_updating := hr_qsn_shd.api_updating

233: begin
234: --
235: hr_utility.set_location('Entering: '||l_proc,10);
236: --
237: l_api_updating := hr_qsn_shd.api_updating
238: (p_questionnaire_template_id => p_questionnaire_template_id
239: ,p_object_version_number => p_object_version_number);
240: hr_utility.set_location(l_proc,20);
241: --

Line 243: (hr_qsn_shd.g_old_rec.available_flag

239: ,p_object_version_number => p_object_version_number);
240: hr_utility.set_location(l_proc,20);
241: --
242: if l_api_updating AND
243: (hr_qsn_shd.g_old_rec.available_flag
244: <> nvl(p_available_flag,hr_api.g_varchar2)) then
245: -- During update, and available_flag has changed
246: --
247: if hr_api.not_exists_in_hr_lookups

Line 253: hr_qsn_shd.constraint_error('HR_QUEST_AVAILABLE_FLAG_CHK');

249: ,p_lookup_type => 'YES_NO'
250: ,p_lookup_code => p_available_flag
251: ) then
252: -- Invalid lookup, raise error
253: hr_qsn_shd.constraint_error('HR_QUEST_AVAILABLE_FLAG_CHK');
254: end if;
255: -- We are allowing users in V4 SSHR to publish the questionnaire
256: -- during the process of creation itself. hence foll. check is not required
257: /* elsif not l_api_updating then

Line 331: Procedure insert_validate(p_rec in hr_qsn_shd.g_rec_type

327: end chk_row_delete;
328: -- ----------------------------------------------------------------------------
329: -- |---------------------------< insert_validate >----------------------------|
330: -- ----------------------------------------------------------------------------
331: Procedure insert_validate(p_rec in hr_qsn_shd.g_rec_type
332: ,p_effective_date in date
333: ) is
334: --
335: l_proc varchar2(72) := g_package||'insert_validate';

Line 345: ,p_associated_column1 => hr_qsn_shd.g_tab_nam

341: --
342: if p_rec.business_group_id is not null then
343: hr_api.validate_bus_grp_id
344: (p_rec.business_group_id
345: ,p_associated_column1 => hr_qsn_shd.g_tab_nam
346: || '.BUSINESS_GROUP_ID');
347: end if;
348: chk_name(p_name => p_rec.name
349: ,p_business_group_id => p_rec.business_group_id

Line 370: Procedure update_validate(p_rec in hr_qsn_shd.g_rec_type

366: --
367: -- ----------------------------------------------------------------------------
368: -- |---------------------------< update_validate >----------------------------|
369: -- ----------------------------------------------------------------------------
370: Procedure update_validate(p_rec in hr_qsn_shd.g_rec_type
371: ,p_effective_date in date
372: ) is
373: --
374: l_proc varchar2(72) := g_package||'update_validate';

Line 384: ,p_associated_column1 => hr_qsn_shd.g_tab_nam

380: --
381: if p_rec.business_group_id is not null then
382: hr_api.validate_bus_grp_id
383: (p_business_group_id => p_rec.business_group_id
384: ,p_associated_column1 => hr_qsn_shd.g_tab_nam
385: || '.BUSINESS_GROUP_ID');
386: end if;
387: hr_multi_message.end_validation_set;
388:

Line 403: Procedure delete_validate(p_rec in hr_qsn_shd.g_rec_type) is

399: --
400: -- ----------------------------------------------------------------------------
401: -- |---------------------------< delete_validate >----------------------------|
402: -- ----------------------------------------------------------------------------
403: Procedure delete_validate(p_rec in hr_qsn_shd.g_rec_type) is
404: --
405: l_proc varchar2(72) := g_package||'delete_validate';
406: --
407: Begin