DBA Data[Home] [Help]

APPS.AME_ACT_BUS dependencies on AME_UTILITY_PKG

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 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 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;