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

Line 21: ,p_is_static in varchar2 default ame_util.booleanTrue

17: ,p_attribute_type in varchar2
18: ,p_item_class_id in number
19: ,p_approver_type_id in number default null
20: ,p_application_id in number default null
21: ,p_is_static in varchar2 default ame_util.booleanTrue
22: ,p_query_string in varchar2 default null
23: ,p_user_editable in varchar2 default ame_util.booleanTrue
24: ,p_value_set_id in number default null
25: ,p_attribute_id out nocopy number

Line 23: ,p_user_editable in varchar2 default ame_util.booleanTrue

19: ,p_approver_type_id in number default null
20: ,p_application_id in number default null
21: ,p_is_static in varchar2 default ame_util.booleanTrue
22: ,p_query_string in varchar2 default null
23: ,p_user_editable in varchar2 default ame_util.booleanTrue
24: ,p_value_set_id in number default null
25: ,p_attribute_id out nocopy number
26: ,p_atr_object_version_number out nocopy number
27: ,p_atr_start_date out nocopy date

Line 208: ,p_is_static in varchar2 default ame_util.booleanTrue

204: procedure create_ame_attribute_usage
205: (p_validate in boolean default false
206: ,p_attribute_id in number
207: ,p_application_id in number
208: ,p_is_static in varchar2 default ame_util.booleanTrue
209: ,p_query_string in varchar2 default null
210: ,p_user_editable in varchar2 default ame_util.booleanTrue
211: ,p_value_set_id in number default null
212: ,p_object_version_number out nocopy number

Line 210: ,p_user_editable in varchar2 default ame_util.booleanTrue

206: ,p_attribute_id in number
207: ,p_application_id in number
208: ,p_is_static in varchar2 default ame_util.booleanTrue
209: ,p_query_string in varchar2 default null
210: ,p_user_editable in varchar2 default ame_util.booleanTrue
211: ,p_value_set_id in number default null
212: ,p_object_version_number out nocopy number
213: ,p_start_date out nocopy date
214: ,p_end_date out nocopy date

Line 480: ,p_is_static in varchar2 default ame_util.booleanTrue

476: procedure update_ame_attribute_usage
477: (p_validate in boolean default false
478: ,p_attribute_id in number
479: ,p_application_id in number
480: ,p_is_static in varchar2 default ame_util.booleanTrue
481: ,p_query_string in varchar2 default null
482: ,p_value_set_id in number default null
483: ,p_object_version_number in out nocopy number
484: ,p_start_date out nocopy date

Line 638: nvl(end_date - ame_util.oneSecond,sysdate);

634: select condition_id, object_version_number
635: from ame_conditions
636: where attribute_id = p_attribute_id
637: and sysdate between start_date and
638: nvl(end_date - ame_util.oneSecond,sysdate);
639:
640: cursor c_sel2 is
641: select null
642: from ame_mandatory_attributes

Line 645: nvl(end_date - ame_util.oneSecond, sysdate) ;

641: select null
642: from ame_mandatory_attributes
643: where attribute_id = p_attribute_id and
644: sysdate between start_date and
645: nvl(end_date - ame_util.oneSecond, sysdate) ;
646:
647: begin
648:
649: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 696: nvl(end_date - ame_util.oneSecond,sysdate);

692: into l_usage_count
693: from ame_attribute_usages
694: where attribute_id = p_attribute_id
695: and l_effective_date between start_date and
696: nvl(end_date - ame_util.oneSecond,sysdate);
697:
698: if l_usage_count = 0 then
699: /* if this is a REQUIRED attribute, do not delete its conditions and the attribute itself
700: otherwise, delete all the conditions and the attribute itself, as no other usage exists

Line 722: and nvl(end_date - ame_util.oneSecond,sysdate);

718: into l_atr_object_version_number
719: from ame_attributes
720: where attribute_id = p_attribute_id
721: and l_effective_date between start_date
722: and nvl(end_date - ame_util.oneSecond,sysdate);
723:
724: ame_atr_del.del(p_effective_date => sysdate
725: ,p_datetrack_mode => 'DELETE'
726: ,p_attribute_id => p_attribute_id

Line 808: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or

804: from ame_rule_usages
805: where
806: ame_rule_usages.item_id = applicationIdIn and
807: ((sysdate between ame_rule_usages.start_date and
808: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
809: (sysdate < ame_rule_usages.start_date and
810: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
811: ame_rule_usages.start_date + ame_util.oneSecond)));
812: ruleCount integer;

Line 811: ame_rule_usages.start_date + ame_util.oneSecond)));

807: ((sysdate between ame_rule_usages.start_date and
808: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
809: (sysdate < ame_rule_usages.start_date and
810: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
811: ame_rule_usages.start_date + ame_util.oneSecond)));
812: ruleCount integer;
813: tempCount integer;
814: useCount integer;
815: begin

Line 828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

824: ame_conditions.attribute_id = attributeIdIn and
825: ame_conditions.condition_id = ame_condition_usages.condition_id and
826: ame_condition_usages.rule_id = tempRule.rule_id and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
829: ((sysdate between ame_condition_usages.start_date and
830: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
831: (sysdate < ame_condition_usages.start_date and
832: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

Line 830: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

826: ame_condition_usages.rule_id = tempRule.rule_id and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
829: ((sysdate between ame_condition_usages.start_date and
830: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
831: (sysdate < ame_condition_usages.start_date and
832: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
833: ame_condition_usages.start_date + ame_util.oneSecond)));
834: if(tempCount > 0) then

Line 833: ame_condition_usages.start_date + ame_util.oneSecond)));

829: ((sysdate between ame_condition_usages.start_date and
830: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
831: (sysdate < ame_condition_usages.start_date and
832: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
833: ame_condition_usages.start_date + ame_util.oneSecond)));
834: if(tempCount > 0) then
835: useCount := useCount + 1;
836: else
837: select count(*)

Line 849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and

845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
846: ame_actions.action_id = ame_action_usages.action_id and
847: ame_action_usages.rule_id = tempRule.rule_id and
848: sysdate between ame_mandatory_attributes.start_date and
849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
850: sysdate between ame_actions.start_date and
851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
852: ((sysdate between ame_action_usages.start_date and
853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and

847: ame_action_usages.rule_id = tempRule.rule_id and
848: sysdate between ame_mandatory_attributes.start_date and
849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
850: sysdate between ame_actions.start_date and
851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
852: ((sysdate between ame_action_usages.start_date and
853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
854: (sysdate < ame_action_usages.start_date and
855: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

Line 853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
850: sysdate between ame_actions.start_date and
851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
852: ((sysdate between ame_action_usages.start_date and
853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
854: (sysdate < ame_action_usages.start_date and
855: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
856: ame_action_usages.start_date + ame_util.oneSecond)));
857: if(tempCount > 0) then

Line 856: ame_action_usages.start_date + ame_util.oneSecond)));

852: ((sysdate between ame_action_usages.start_date and
853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
854: (sysdate < ame_action_usages.start_date and
855: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
856: ame_action_usages.start_date + ame_util.oneSecond)));
857: if(tempCount > 0) then
858: useCount := useCount + 1;
859: end if;
860: end if;