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_PKG dependencies on AME_ATTRIBUTES_S

Line 211: sysdate between ame_attributes.start_date and

207: into approverTypeId
208: from ame_attributes
209: where
210: attribute_id = attributeIdIn and
211: sysdate between ame_attributes.start_date and
212: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
213: return(approverTypeId);
214: exception
215: when others then

Line 239: sysdate between ame_attributes.start_date and

235: where
236: ame_attributes.attribute_id = ame_conditions.attribute_id and
237: ame_attributes.attribute_id = attributeIdIn and
238: ame_conditions.condition_type = conditionTypeIn and
239: sysdate between ame_attributes.start_date and
240: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
241: sysdate between ame_conditions.start_date and
242: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
243: return(attributeConditionCnt);

Line 275: sysdate between ame_attributes.start_date and

271: ame_rules.rule_id = ame_condition_usages.rule_id and
272: ame_rules.rule_id = ruleIdIn and
273: ame_attributes.attribute_id = attributeIdIn and
274: ame_conditions.condition_type = conditionTypeIn and
275: sysdate between ame_attributes.start_date and
276: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
277: sysdate between ame_conditions.start_date and
278: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
279: ((sysdate between ame_condition_usages.start_date and

Line 311: sysdate between ame_attributes.start_date and

307: ame_mandatory_attributes
308: where
309: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
310: ame_mandatory_attributes.action_type_id = actionTypeIdIn and
311: sysdate between ame_attributes.start_date and
312: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
313: sysdate between ame_mandatory_attributes.start_date and
314: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
315: order by ame_attributes.name;

Line 1195: select ame_attributes_s.nextval into attributeId from dual;

1191: createdBy := currentUserId;
1192: else
1193: createdBy := createdByIn;
1194: end if;
1195: select ame_attributes_s.nextval into attributeId from dual;
1196: else
1197: attributeId := attributeIdIn;
1198: select count(*)
1199: into tempCount

Line 1480: sysdate between ame_attributes.start_date and

1476: ame_attribute_usages.query_string = queryString and
1477: (nameIn is null or name = upper(nameIn)) and
1478: (attributeType is null or upper(attribute_type) = upper(attributeType)) and
1479: (descriptionIn is null or description = descriptionIn) and
1480: sysdate between ame_attributes.start_date and
1481: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1482: sysdate between ame_attribute_usages.start_date and
1483: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) ;
1484: if(tempCount > 0) then

Line 1710: sysdate between ame_attributes.start_date and

1706: where
1707: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1708: ame_attribute_usages.application_id = applicationIdIn and
1709: use_count > 0 and
1710: sysdate between ame_attributes.start_date and
1711: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1712: sysdate between ame_attribute_usages.start_date and
1713: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1714: order by name;

Line 1725: sysdate between ame_attributes.start_date and

1721: ame_mandatory_attributes
1722: where
1723: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
1724: ame_mandatory_attributes.action_type_id = -1 and
1725: sysdate between ame_attributes.start_date and
1726: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1727: sysdate between ame_mandatory_attributes.start_date and
1728: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
1729: order by name;

Line 1771: sysdate between ame_attributes.start_date and

1767: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1768: ame_attribute_usages.application_id = applicationIdIn and
1769: ame_attributes.item_class_id = itemClassIdIn and
1770: use_count > 0 and
1771: sysdate between ame_attributes.start_date and
1772: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1773: sysdate between ame_attribute_usages.start_date and
1774: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1775: order by name;

Line 1788: sysdate between ame_attributes.start_date and

1784: where
1785: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
1786: ame_attributes.item_class_id = itemClassIdIn and
1787: ame_mandatory_attributes.action_type_id = -1 and
1788: sysdate between ame_attributes.start_date and
1789: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1790: sysdate between ame_mandatory_attributes.start_date and
1791: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
1792: order by name;

Line 1899: sysdate between ame_attributes.start_date and

1895: from ame_mandatory_attributes
1896: where action_type_id = ame_util.mandAttActionTypeId and
1897: sysdate between start_date and
1898: nvl(end_date - ame_util.oneSecond, sysdate)) and
1899: sysdate between ame_attributes.start_date and
1900: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1901: sysdate between ame_attribute_usages.start_date and
1902: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1903: order by name;

Line 1941: sysdate between ame_attributes.start_date and

1937: where
1938: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1939: ame_attribute_usages.application_id = applicationIdIn and
1940: ame_attributes.attribute_type = ame_util.stringAttributeType and
1941: sysdate between ame_attributes.start_date and
1942: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1943: sysdate between ame_attribute_usages.start_date and
1944: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1945: order by name;

Line 2042: sysdate between ame_attributes.start_date and

2038: ame_conditions.attribute_id = ame_attributes.attribute_id and
2039: ame_attribute_usages.application_id = applicationIdIn and
2040: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
2041: ame_conditions.condition_type = decode(ruleTypeIn, 1, ame_util.ordinaryConditionType, 2, ame_util.exceptionConditionType) and
2042: sysdate between ame_attributes.start_date and
2043: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2044: sysdate between ame_attribute_usages.start_date and
2045: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2046: sysdate between ame_conditions.start_date and

Line 2098: sysdate between ame_attributes.start_date and

2094: ame_attribute_usages.application_id = applicationIdIn and
2095: ame_attributes.item_class_id = itemClassIdIn and
2096: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
2097: ame_conditions.condition_type = decode(ruleTypeIn, 1, ame_util.ordinaryConditionType, 2, ame_util.exceptionConditionType) and
2098: sysdate between ame_attributes.start_date and
2099: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2100: sysdate between ame_attribute_usages.start_date and
2101: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2102: sysdate between ame_conditions.start_date and

Line 2155: sysdate between ame_attributes.start_date and

2151: ame_conditions.attribute_id = ame_attributes.attribute_id and
2152: ame_attribute_usages.application_id = applicationIdIn and
2153: ame_attributes.item_class_id = itemClassIdIn and
2154: ame_conditions.condition_type = conditionTypeIn and
2155: sysdate between ame_attributes.start_date and
2156: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2157: sysdate between ame_attribute_usages.start_date and
2158: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2159: sysdate between ame_conditions.start_date and

Line 2241: sysdate between ame_attributes.start_date and

2237: (action_type_id = actionTypeIdIn or
2238: action_type_id = ame_util.mandAttActionTypeId) and
2239: sysdate between ame_mandatory_attributes.start_date and
2240: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)) and
2241: sysdate between ame_attributes.start_date and
2242: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
2243: order by name;
2244: tempIndex integer;
2245: begin

Line 2285: sysdate between ame_attributes.start_date and

2281: where
2282: action_type_id = -1 and
2283: sysdate between ame_mandatory_attributes.start_date and
2284: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)) and
2285: sysdate between ame_attributes.start_date and
2286: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2287: sysdate between ame_attribute_usages.start_date and
2288: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2289: order by name;

Line 2323: ame_attributes.start_date

2319: select
2320: ame_attributes.attribute_id,
2321: ame_attributes.attribute_type,
2322: ame_attributes.name,
2323: ame_attributes.start_date
2324: from
2325: ame_attributes,
2326: ame_mandatory_attributes
2327: where

Line 2330: sysdate between ame_attributes.start_date and

2326: ame_mandatory_attributes
2327: where
2328: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2329: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2330: sysdate between ame_attributes.start_date and
2331: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2332: sysdate between ame_mandatory_attributes.start_date and
2333: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
2334: order by name;

Line 2373: sysdate between ame_attributes.start_date and

2369: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2370: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2371: ame_attribute_usages.application_id = applicationIdIn and
2372: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2373: sysdate between ame_attributes.start_date and
2374: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2375: sysdate between ame_attribute_usages.start_date and
2376: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2377: sysdate between ame_mandatory_attributes.start_date and

Line 2408: ame_attributes.start_date

2404: select
2405: ame_attributes.attribute_id,
2406: ame_attributes.attribute_type,
2407: ame_attributes.name,
2408: ame_attributes.start_date
2409: from
2410: ame_attributes,
2411: ame_mandatory_attributes
2412: where

Line 2417: sysdate between ame_attributes.start_date and

2413: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2414: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2415: ame_attributes.name not in (ame_util.evalPrioritiesPerItemAttribute,
2416: ame_util.restrictiveItemEvalAttribute) and
2417: sysdate between ame_attributes.start_date and
2418: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2419: sysdate between ame_mandatory_attributes.start_date and
2420: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
2421: order by name;

Line 2458: sysdate between ame_attributes.start_date and

2454: where
2455: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2456: ame_attributes.item_class_id = itemClassIdIn and
2457: ame_attribute_usages.application_id = applicationIdIn and
2458: sysdate between ame_attributes.start_date and
2459: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2460: sysdate between ame_attribute_usages.start_date and
2461: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2462: order by name;

Line 2501: sysdate between ame_attributes.start_date and

2497: where
2498: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2499: ame_attributes.item_class_id = itemClassIdIn and
2500: ame_attribute_usages.application_id = applicationIdIn and
2501: sysdate between ame_attributes.start_date and
2502: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2503: sysdate between ame_attribute_usages.start_date and
2504: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2505: order by name;

Line 2539: sysdate between ame_attributes.start_date and

2535: ame_mandatory_attributes
2536: where
2537: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2538: ame_mandatory_attributes.action_type_id = actionTypeIdIn and
2539: sysdate between ame_attributes.start_date and
2540: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2541: sysdate between ame_mandatory_attributes.start_date and
2542: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
2543: order by name;

Line 2584: (ame_attributes.start_date <= sysdate and

2580: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2581: ame_attribute_usages.application_id = applicationIdIn and
2582: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2583: nvl(ame_attribute_usages.is_striping_attribute, ame_util.booleanFalse) = isStripingAttributeIn and
2584: (ame_attributes.start_date <= sysdate and
2585: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date)) and
2586: (ame_attribute_usages.start_date <= sysdate and
2587: (ame_attribute_usages.end_date is null or sysdate < ame_attribute_usages.end_date))
2588: order by name;

Line 2628: sysdate between ame_attributes.start_date and

2624: where
2625: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2626: ame_attribute_usages.application_id = applicationIdIn and
2627: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2628: sysdate between ame_attributes.start_date and
2629: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2630: sysdate between ame_attribute_usages.start_date and
2631: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2632: order by name;

Line 2668: sysdate between ame_attributes.start_date and

2664: where
2665: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2666: ame_attribute_usages.application_id = applicationIdIn and
2667: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2668: sysdate between ame_attributes.start_date and
2669: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2670: sysdate between ame_attribute_usages.start_date and
2671: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2672: order by name;

Line 2718: (ame_attributes.start_date <= sysdate and

2714: (select attribute_id from ame_mandatory_attributes
2715: where action_type_id = -1 and
2716: (ame_mandatory_attributes.start_date <= sysdate and
2717: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date))) and
2718: (ame_attributes.start_date <= sysdate and
2719: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date)) and
2720: (ame_attribute_usages.start_date <= sysdate and
2721: (ame_attribute_usages.end_date is null or sysdate < ame_attribute_usages.end_date))
2722: order by name;

Line 2767: sysdate between ame_attributes.start_date and

2763: (select attribute_id from ame_mandatory_attributes
2764: where action_type_id = -1 and
2765: sysdate between ame_mandatory_attributes.start_date and
2766: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and
2767: sysdate between ame_attributes.start_date and
2768: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2769: sysdate between ame_attribute_usages.start_date and
2770: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2771: order by name;

Line 2816: sysdate between ame_attributes.start_date and

2812: (select attribute_id from ame_mandatory_attributes
2813: where action_type_id = -1 and
2814: sysdate between ame_mandatory_attributes.start_date and
2815: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and
2816: sysdate between ame_attributes.start_date and
2817: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2818: sysdate between ame_attribute_usages.start_date and
2819: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2820: sysdate between ame_item_classes.start_date and

Line 2863: sysdate between ame_attributes.start_date and

2859: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2860: ame_attribute_usages.application_id = applicationIdIn and
2861: ame_attributes.attribute_type = ame_util.stringAttributeType and
2862: ame_attribute_usages.is_striping_attribute = ame_util.booleanTrue and
2863: sysdate between ame_attributes.start_date and
2864: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2865: sysdate between ame_attribute_usages.start_date and
2866: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2867: order by ame_attributes.attribute_id;

Line 2901: (ame_attributes.start_date <= sysdate and

2897: from
2898: ame_attributes
2899: where
2900: item_class_id = itemClassIdIn and
2901: (ame_attributes.start_date <= sysdate and
2902: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2903: minus
2904: select
2905: ame_attributes.attribute_id attribute_id,

Line 2913: sysdate between ame_attributes.start_date and

2909: ame_attribute_usages
2910: where
2911: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2912: ame_attribute_usages.application_id = applicationIdIn and
2913: sysdate between ame_attributes.start_date and
2914: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2915: sysdate between ame_attribute_usages.start_date and
2916: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2917: order by name;

Line 2929: (ame_attributes.start_date <= sysdate and

2925: from
2926: ame_attributes
2927: where
2928: item_class_id = itemClassIdIn and
2929: (ame_attributes.start_date <= sysdate and
2930: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2931: minus
2932: select
2933: ame_attributes.attribute_id attribute_id,

Line 2941: sysdate between ame_attributes.start_date and

2937: ame_attribute_usages
2938: where
2939: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2940: ame_attribute_usages.application_id = applicationIdIn and
2941: sysdate between ame_attributes.start_date and
2942: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2943: sysdate between ame_attribute_usages.start_date and
2944: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2945: minus

Line 2953: (ame_attributes.start_date <= sysdate and

2949: from
2950: ame_attributes
2951: where
2952: approver_type_id not in (perApproverTypeIdIn, fndUserApproverTypeIdIn) and
2953: (ame_attributes.start_date <= sysdate and
2954: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2955: order by name;
2956: allowAllApproverTypes ame_util.stringType;
2957: fndUserApproverTypeId integer;

Line 3016: sysdate between ame_attributes.start_date and

3012: where
3013: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3014: ame_attribute_usages.application_id = applicationIdIn and
3015: ame_attributes.item_class_id = itemClassIdIn and
3016: sysdate between ame_attributes.start_date and
3017: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
3018: sysdate between ame_attribute_usages.start_date and
3019: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
3020: order by name;

Line 3063: sysdate between ame_attributes.start_date and

3059: where
3060: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3061: ame_attribute_usages.application_id = applicationIdIn and
3062: ame_attributes.item_class_id = itemClassIdIn and
3063: sysdate between ame_attributes.start_date and
3064: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
3065: sysdate between ame_attribute_usages.start_date and
3066: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
3067: order by name;

Line 4184: (ame_attributes.start_date <= sysdate and

4180: ame_attribute_usages.application_id = applicationIdIn and
4181: ame_attribute_usages.is_striping_attribute = ame_util.booleanTrue and
4182: (ame_attribute_usages.start_date <= sysdate and
4183: (ame_attribute_usages.end_date is null or sysdate < ame_attribute_usages.end_date)) and
4184: (ame_attributes.start_date <= sysdate and
4185: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date));
4186: endDate date;
4187: oldAttributeCount integer;
4188: startDate varchar2(50);