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_CONDITION_PKG dependencies on AME_CONDITIONS_S

Line 40: sysdate between ame_conditions.start_date and

36: ame_conditions.condition_id = conditionIdIn and
37: ame_conditions.attribute_id = ame_attributes.attribute_id and
38: sysdate between ame_attributes.start_date and
39: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
40: sysdate between ame_conditions.start_date and
41: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
42: return(attributeName);
43: exception
44: when others then

Line 69: sysdate between ame_conditions.start_date and

65: ame_conditions.condition_id = conditionIdIn and
66: ame_attributes.attribute_id = ame_conditions.attribute_id and
67: sysdate between ame_attributes.start_date and
68: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
69: sysdate between ame_conditions.start_date and
70: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
71: return(attributeType);
72: exception
73: when others then

Line 533: sysdate between ame_conditions.start_date and

529: ame_conditions
530: where
531: ame_conditions.condition_id = conditionIdIn and
532: ame_attributes.attribute_id = ame_conditions.attribute_id and
533: sysdate between ame_conditions.start_date and
534: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
535: sysdate between ame_attributes.start_date and
536: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;
537: if attributeType = ame_util.stringAttributeType then

Line 827: sysdate between ame_conditions.start_date and

823: ame_attribute_usages.start_date < nvl(ame_attribute_usages.end_date,
824: ame_attribute_usages.start_date + ame_util.oneSecond))) and
825: sysdate between ame_attributes.start_date and
826: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) ;
829: if(lineItemCount > 0) then
830: return(true);
831: end if;

Line 1020: select ame_conditions_s.nextval into conditionId from dual;

1016: conditionId := -1;
1017: end if;
1018: end if;
1019: else
1020: select ame_conditions_s.nextval into conditionId from dual;
1021: end if;
1022: else
1023: conditionId := conditionIdIn;
1024: select count(*)

Line 1739: sysdate between ame_conditions.start_date and

1735: ame_conditions.attribute_id = ame_attribute_usages.attribute_id and
1736: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1737: ame_attributes.item_class_id = itemClassIdIn and
1738: ame_conditions.condition_type in (ame_util.ordinaryConditionType,ame_util.exceptionConditionType) and
1739: sysdate between ame_conditions.start_date and
1740: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1741: sysdate between ame_attributes.start_date and
1742: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1743: sysdate between ame_attribute_usages.start_date and

Line 1815: sysdate between ame_conditions.start_date and

1811: ame_conditions.attribute_id = ame_attributes.attribute_id and
1812: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1813: ame_attributes.attribute_id = attributeIdIn and
1814: condition_type = conditionTypeIn and
1815: sysdate between ame_conditions.start_date and
1816: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1817: sysdate between ame_attributes.start_date and
1818: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1819: order by description;

Line 1865: sysdate between ame_conditions.start_date and

1861: ame_conditions.attribute_id = ame_attributes.attribute_id and
1862: ame_attributes.attribute_id = attributeIdIn and
1863: condition_type = conditionTypeIn and
1864: ame_attributes.item_class_id = itemClassIdIn and
1865: sysdate between ame_conditions.start_date and
1866: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1867: sysdate between ame_attributes.start_date and
1868: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1869: order by description;

Line 1920: sysdate between ame_conditions.start_date and

1916: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1917: ame_attributes.attribute_id = attributeIdIn and
1918: ame_attributes.item_class_id = itemClassIdIn and
1919: condition_type = conditionTypeIn and
1920: sysdate between ame_conditions.start_date and
1921: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1922: sysdate between ame_attributes.start_date and
1923: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1924: order by description;

Line 2147: sysdate between ame_conditions.start_date and

2143: from
2144: ame_conditions
2145: where
2146: ame_conditions.condition_type = ame_util.listModConditionType and
2147: sysdate between ame_conditions.start_date and
2148: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
2149: isApproverValid boolean;
2150: tempDescription ame_util.longStringType;
2151: tempIndex integer;

Line 2194: sysdate between ame_conditions.start_date and

2190: ame_conditions
2191: where
2192: ame_conditions.condition_type = ame_util.listModConditionType and
2193: ame_conditions.parameter_one = lmApproverTypeIn and
2194: sysdate between ame_conditions.start_date and
2195: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
2196: isApproverValid boolean;
2197: tempDescription ame_util.longStringType;
2198: tempIndex integer;