APPS.AME_CON_BUS dependencies on AME_ATTRIBUTES

Line 124: -- Else attribute_id must be already defined in ame_attributes table and

120: -- Description:
121: -- This procedure ensure that one of the following combinations are entered
122: --
123: -- If condition_type is ListModificationType then attribute_id must be 0
124: -- Else attribute_id must be already defined in ame_attributes table and
125: -- must be valid over the given date ranges
126: --
127: -- Pre-Requisites:
128: -- chk_condition_type must have been validated.

Line 141: -- defined in ame_attributes table

137: --
138: -- Post Failure:
139: -- An application error is raised if the attribute_id is not equal to zero
140: -- (for a ListModificationType condition) or when the attribute_id is not
141: -- defined in ame_attributes table
142: --
143: -- Access Status:
144: -- Internal Row Handler Use Only.
145: --

Line 155: from ame_attributes

151: ) IS
152: --
153: cursor csr_name is
154: select attribute_id
155: from ame_attributes
156: where attribute_id=p_attribute_id
157: and p_effective_date between start_date
158: and nvl(end_date - ame_util.oneSecond, p_effective_date);
159: l_proc varchar2(72) := g_package || 'CHK_ATTRIBUTE_ID';

Line 244: from ame_attributes

240: ) IS
241: --
242: cursor csr_atr_type is
243: select attribute_type
244: from ame_attributes
245: where attribute_id = p_attribute_id
246: and p_effective_date between start_date
247: and nvl(end_date - ame_util.oneSecond, p_effective_date);
248: l_proc varchar2(72) := g_package || 'CHK_PARAMETER_ONE';

Line 337: from ame_attributes

333: ) IS
334: --
335: cursor csr_atr_type is
336: select attribute_type,approver_type_id
337: from ame_attributes
338: where attribute_id = p_attribute_id
339: and p_effective_date between start_date
340: and nvl(end_date - ame_util.oneSecond, p_effective_date);
341: cursor csr_wf_role(p_name varchar2,p_date date) is

Line 476: from ame_attributes

472: ) IS
473: --
474: cursor csr_atr_type is
475: select attribute_type
476: from ame_attributes
477: where attribute_id = p_attribute_id
478: and p_effective_date between start_date
479: and nvl(end_date - ame_util.oneSecond, p_effective_date);
480: cursor csr_cur_code(p_currency_code varchar2) is

Line 580: from ame_attributes

576: and p_effective_date between start_date
577: and nvl(end_date - ame_util.oneSecond, p_effective_date)
578: and attribute_id = p_rec.attribute_id
579: and attribute_id not in ( select attribute_id
580: from ame_attributes
581: where attribute_type = ame_util.stringAttributeType
582: and p_effective_date between
583: start_date and
584: nvl(end_date - ame_util.oneSecond, p_effective_date)

Line 674: from ame_attributes

670: ) IS
671: --
672: cursor csr_atr_type is
673: select attribute_type
674: from ame_attributes
675: where attribute_id = p_attribute_id
676: and p_effective_date between start_date
677: and nvl(end_date - ame_util.oneSecond, p_effective_date);
678: l_proc varchar2(72) := g_package || 'CHK_LIMITS';