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.AME_GCF_INS dependencies on AME_APPROVAL_GROUP_CONFIG

Line 93: from ame_approval_group_config t

89: -- Cursor to select 'old' created AOL who column values
90: --
91: Cursor C_Sel1 Is
92: select t.creation_date
93: from ame_approval_group_config t
94: where t.approval_group_id = p_rec.approval_group_id
95: and t.application_id = p_rec.application_id
96: and t.start_date =
97: ame_gcf_shd.g_old_rec.start_date

Line 102: from ame_approval_group_config t

98: and t.end_date = p_validation_start_date;
99: --
100: Cursor C_Sel2 Is
101: select created_by
102: from ame_approval_group_config t
103: where t.approval_group_id = p_rec.approval_group_id
104: and t.application_id = p_rec.application_id
105: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
106: and rownum < 2;

Line 109: l_created_by ame_approval_group_config.created_by%TYPE;

105: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
106: and rownum < 2;
107: --
108: l_proc varchar2(72) := g_package||'dt_insert_dml';
109: l_created_by ame_approval_group_config.created_by%TYPE;
110: l_creation_date ame_approval_group_config.creation_date%TYPE;
111: l_last_update_date ame_approval_group_config.last_update_date%TYPE;
112: l_last_updated_by ame_approval_group_config.last_updated_by%TYPE;
113: l_last_update_login ame_approval_group_config.last_update_login%TYPE;

Line 110: l_creation_date ame_approval_group_config.creation_date%TYPE;

106: and rownum < 2;
107: --
108: l_proc varchar2(72) := g_package||'dt_insert_dml';
109: l_created_by ame_approval_group_config.created_by%TYPE;
110: l_creation_date ame_approval_group_config.creation_date%TYPE;
111: l_last_update_date ame_approval_group_config.last_update_date%TYPE;
112: l_last_updated_by ame_approval_group_config.last_updated_by%TYPE;
113: l_last_update_login ame_approval_group_config.last_update_login%TYPE;
114: l_current_user_id integer;

Line 111: l_last_update_date ame_approval_group_config.last_update_date%TYPE;

107: --
108: l_proc varchar2(72) := g_package||'dt_insert_dml';
109: l_created_by ame_approval_group_config.created_by%TYPE;
110: l_creation_date ame_approval_group_config.creation_date%TYPE;
111: l_last_update_date ame_approval_group_config.last_update_date%TYPE;
112: l_last_updated_by ame_approval_group_config.last_updated_by%TYPE;
113: l_last_update_login ame_approval_group_config.last_update_login%TYPE;
114: l_current_user_id integer;
115: l_temp_count integer;

Line 112: l_last_updated_by ame_approval_group_config.last_updated_by%TYPE;

108: l_proc varchar2(72) := g_package||'dt_insert_dml';
109: l_created_by ame_approval_group_config.created_by%TYPE;
110: l_creation_date ame_approval_group_config.creation_date%TYPE;
111: l_last_update_date ame_approval_group_config.last_update_date%TYPE;
112: l_last_updated_by ame_approval_group_config.last_updated_by%TYPE;
113: l_last_update_login ame_approval_group_config.last_update_login%TYPE;
114: l_current_user_id integer;
115: l_temp_count integer;
116: --

Line 113: l_last_update_login ame_approval_group_config.last_update_login%TYPE;

109: l_created_by ame_approval_group_config.created_by%TYPE;
110: l_creation_date ame_approval_group_config.creation_date%TYPE;
111: l_last_update_date ame_approval_group_config.last_update_date%TYPE;
112: l_last_updated_by ame_approval_group_config.last_updated_by%TYPE;
113: l_last_update_login ame_approval_group_config.last_update_login%TYPE;
114: l_current_user_id integer;
115: l_temp_count integer;
116: --
117: Begin

Line 192: -- Insert the row into: ame_approval_group_config

188: End If;
189: --
190: --
191: --
192: -- Insert the row into: ame_approval_group_config
193: --
194: insert into ame_approval_group_config
195: (application_id
196: ,approval_group_id

Line 194: insert into ame_approval_group_config

190: --
191: --
192: -- Insert the row into: ame_approval_group_config
193: --
194: insert into ame_approval_group_config
195: (application_id
196: ,approval_group_id
197: ,voting_regime
198: ,order_number

Line 312: from ame_approval_group_config

308: begin
309: if p_order_number is null then
310: select nvl(max(order_number),0)
311: into l_temp_count
312: from ame_approval_group_config
313: where application_id = p_application_id
314: and p_effective_date between start_date and nvl(end_date - (1/84600),sysdate);
315: l_temp_count := l_temp_count + 1;
316: p_order_number := l_temp_count;

Line 380: -- Cursor C_Sel1 is select ame_approval_group_config_s.nextval from sys.dual;

376: ,p_validation_start_date in date
377: ,p_validation_end_date in date
378: ) is
379: --
380: -- Cursor C_Sel1 is select ame_approval_group_config_s.nextval from sys.dual;
381: --
382: Cursor C_Sel2 is
383: Select null
384: from ame_approval_group_config

Line 384: from ame_approval_group_config

380: -- Cursor C_Sel1 is select ame_approval_group_config_s.nextval from sys.dual;
381: --
382: Cursor C_Sel2 is
383: Select null
384: from ame_approval_group_config
385: where application_id =
386: ame_gcf_ins.g_application_id_i
387: and approval_group_id =
388: ame_gcf_ins.g_approval_group_id_i

Line 411: fnd_message.set_token('TABLE_NAME','ame_approval_group_config');

407: --
408: -- The primary key values are already in use.
409: --
410: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
411: fnd_message.set_token('TABLE_NAME','ame_approval_group_config');
412: fnd_message.raise_error;
413: End If;
414: Close C_Sel2;
415: --

Line 521: (p_module_name => 'AME_APPROVAL_GROUP_CONFIG'

517: --
518: when hr_api.cannot_find_prog_unit then
519: --
520: hr_api.cannot_find_prog_unit_error
521: (p_module_name => 'AME_APPROVAL_GROUP_CONFIG'
522: ,p_hook_type => 'AI');
523: --
524: end;
525: --