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_ACT_BUS dependencies on AME_UTIL

Line 45: actionTypeIds ame_util.idList;

41: createdBy ame_actions.created_by%type;
42: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
43: l_error EXCEPTION;
44: l_argument varchar2(30);
45: actionTypeIds ame_util.idList;
46: approvalGroup boolean;
47: --
48: Cursor c_sel1 is
49: select action_type_id

Line 52: name in (ame_util.preApprovalTypeName,

48: Cursor c_sel1 is
49: select action_type_id
50: from ame_action_types
51: where
52: name in (ame_util.preApprovalTypeName,
53: ame_util.postApprovalTypeName,
54: ame_util.groupChainApprovalTypeName) and
55: p_effective_date between start_date and
56: nvl(end_date - ame_util.oneSecond, p_effective_date);

Line 53: ame_util.postApprovalTypeName,

49: select action_type_id
50: from ame_action_types
51: where
52: name in (ame_util.preApprovalTypeName,
53: ame_util.postApprovalTypeName,
54: ame_util.groupChainApprovalTypeName) and
55: p_effective_date between start_date and
56: nvl(end_date - ame_util.oneSecond, p_effective_date);
57: Begin

Line 54: ame_util.groupChainApprovalTypeName) and

50: from ame_action_types
51: where
52: name in (ame_util.preApprovalTypeName,
53: ame_util.postApprovalTypeName,
54: ame_util.groupChainApprovalTypeName) and
55: p_effective_date between start_date and
56: nvl(end_date - ame_util.oneSecond, p_effective_date);
57: Begin
58: --

Line 56: nvl(end_date - ame_util.oneSecond, p_effective_date);

52: name in (ame_util.preApprovalTypeName,
53: ame_util.postApprovalTypeName,
54: ame_util.groupChainApprovalTypeName) and
55: p_effective_date between start_date and
56: nvl(end_date - ame_util.oneSecond, p_effective_date);
57: Begin
58: --
59: -- Only proceed with the validation if a row exists for the current
60: -- record in the HR Schema.

Line 77: select ame_utility_pkg.is_seed_user(created_by)

73: --
74: -- EDIT_HERE: Add checks to ensure non-updateable args have
75: -- not been updated.
76: /* Seeded actions cannot be deleted. */
77: select ame_utility_pkg.is_seed_user(created_by)
78: into createdBy
79: from ame_actions
80: where
81: action_id = p_rec.action_id and

Line 83: nvl(end_date - ame_util.oneSecond, p_effective_date);

79: from ame_actions
80: where
81: action_id = p_rec.action_id and
82: p_effective_date between start_date and
83: nvl(end_date - ame_util.oneSecond, p_effective_date);
84: OPEN c_sel1;
85: FETCH c_sel1 BULK COLLECT INTO actionTypeIds;
86: approvalGroup := false;
87: FOR i in 1 .. actionTypeIds.count LOOP

Line 104: ELSIF(createdBy = ame_util.seededDataCreatedById

100: l_argument := 'parameter';
101: RAISE l_error;
102: END IF;
103: /* Descriptions for seeded actions cannot be updated. */
104: ELSIF(createdBy = ame_util.seededDataCreatedById
105: and ame_utility_pkg.check_seeddb = 'N') THEN
106: IF
107: nvl(p_rec.description,
108: hr_api.g_number) <>

Line 105: and ame_utility_pkg.check_seeddb = 'N') THEN

101: RAISE l_error;
102: END IF;
103: /* Descriptions for seeded actions cannot be updated. */
104: ELSIF(createdBy = ame_util.seededDataCreatedById
105: and ame_utility_pkg.check_seeddb = 'N') THEN
106: IF
107: nvl(p_rec.description,
108: hr_api.g_number) <>
109: nvl(ame_act_shd.g_old_rec.description,

Line 172: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

168: from ame_action_types
169: where
170: action_type_id = p_action_type_id and
171: p_effective_date between start_date and
172: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
173: l_exists varchar2(1);
174: begin
175: open c_sel1;
176: fetch c_sel1 into l_exists;

Line 290: nvl(end_date - ame_util.oneSecond, p_effective_date) and

286: where action_type_id = p_action_type_id and
287: parameter = p_parameter and
288: ((parameter_two is null and p_parameter_two is null) or parameter_two = p_parameter_two) and
289: p_effective_date between start_date and
290: nvl(end_date - ame_util.oneSecond, p_effective_date) and
291: (p_action_id is null or
292: action_id <> p_action_id);
293: if(l_par_count <> 0) then
294: fnd_message.set_name('PER','AME_400604_DUP_ACTION_PARAM');

Line 302: nvl(end_date - ame_util.oneSecond, p_effective_date);

298: into l_action_type_name
299: from ame_action_types
300: where action_type_id = p_action_type_id
301: and p_effective_date between start_date and
302: nvl(end_date - ame_util.oneSecond, p_effective_date);
303: if(l_action_type_name = 'substitution'
304: or l_action_type_name = 'hr position') then
305: open c_sel1(p_name => p_parameter);
306: fetch c_sel1 into l_exists;

Line 406: -- ame_action_types.dynamic_descripton is set to ame_util.booleanFalse.

402: -- {Start Of Comments}
403: --
404: -- Description:
405: -- Validates that the ame_actions.description is not null if the
406: -- ame_action_types.dynamic_descripton is set to ame_util.booleanFalse.
407: --
408: -- Prerequisites:
409: -- None.
410: --

Line 444: nvl(end_date - ame_util.oneSecond, p_effective_date);

440: from ame_action_types
441: where
442: action_type_id = p_action_type_id and
443: p_effective_date between start_date and
444: nvl(end_date - ame_util.oneSecond, p_effective_date);
445: IF dynamicDescription = ame_util.booleanFalse THEN
446: IF p_description is null THEN
447: fnd_message.set_name('PER','AME_400606_DYN_ACT_TYP_ACT_DES');
448: -- Message needed

Line 445: IF dynamicDescription = ame_util.booleanFalse THEN

441: where
442: action_type_id = p_action_type_id and
443: p_effective_date between start_date and
444: nvl(end_date - ame_util.oneSecond, p_effective_date);
445: IF dynamicDescription = ame_util.booleanFalse THEN
446: IF p_description is null THEN
447: fnd_message.set_name('PER','AME_400606_DYN_ACT_TYP_ACT_DES');
448: -- Message needed
449: fnd_message.raise_error;

Line 509: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and

505: select null
506: from ame_actions
507: where
508: action_id = p_action_id and
509: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
510: ame_utility_pkg.check_seeddb = 'N';
511: l_exists varchar2(1);
512: begin
513: -- Seeded actions cannot be deleted

Line 510: ame_utility_pkg.check_seeddb = 'N';

506: from ame_actions
507: where
508: action_id = p_action_id and
509: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
510: ame_utility_pkg.check_seeddb = 'N';
511: l_exists varchar2(1);
512: begin
513: -- Seeded actions cannot be deleted
514: open c_sel1;