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_MANDATORY_ATTRIBUTES

Line 125: ame_mandatory_attributes,

121: else
122: select count(*)
123: into tempCount
124: from
125: ame_mandatory_attributes,
126: ame_actions,
127: ame_action_usages
128: where
129: ame_mandatory_attributes.attribute_id = attributeIdIn and

Line 129: ame_mandatory_attributes.attribute_id = attributeIdIn and

125: ame_mandatory_attributes,
126: ame_actions,
127: ame_action_usages
128: where
129: ame_mandatory_attributes.attribute_id = attributeIdIn and
130: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
131: ame_actions.action_id = ame_action_usages.action_id and
132: ame_action_usages.rule_id = tempRule.rule_id and
133: sysdate between ame_mandatory_attributes.start_date and

Line 130: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and

126: ame_actions,
127: ame_action_usages
128: where
129: ame_mandatory_attributes.attribute_id = attributeIdIn and
130: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
131: ame_actions.action_id = ame_action_usages.action_id and
132: ame_action_usages.rule_id = tempRule.rule_id and
133: sysdate between ame_mandatory_attributes.start_date and
134: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 133: sysdate between ame_mandatory_attributes.start_date and

129: ame_mandatory_attributes.attribute_id = attributeIdIn and
130: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
131: ame_actions.action_id = ame_action_usages.action_id and
132: ame_action_usages.rule_id = tempRule.rule_id and
133: sysdate between ame_mandatory_attributes.start_date and
134: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
135: sysdate between ame_actions.start_date and
136: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
137: ((sysdate between ame_action_usages.start_date and

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

130: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
131: ame_actions.action_id = ame_action_usages.action_id and
132: ame_action_usages.rule_id = tempRule.rule_id and
133: sysdate between ame_mandatory_attributes.start_date and
134: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
135: sysdate between ame_actions.start_date and
136: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
137: ((sysdate between ame_action_usages.start_date and
138: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 167: ame_mandatory_attributes

163: select
164: ame_action_types.name
165: from
166: ame_action_types,
167: ame_mandatory_attributes
168: where
169: ame_action_types.action_type_id = ame_mandatory_attributes.action_type_id and
170: ame_mandatory_attributes.attribute_id = attributeIdIn and
171: sysdate between ame_action_types.start_date and

Line 169: ame_action_types.action_type_id = ame_mandatory_attributes.action_type_id and

165: from
166: ame_action_types,
167: ame_mandatory_attributes
168: where
169: ame_action_types.action_type_id = ame_mandatory_attributes.action_type_id and
170: ame_mandatory_attributes.attribute_id = attributeIdIn and
171: sysdate between ame_action_types.start_date and
172: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
173: sysdate between ame_mandatory_attributes.start_date and

Line 170: ame_mandatory_attributes.attribute_id = attributeIdIn and

166: ame_action_types,
167: ame_mandatory_attributes
168: where
169: ame_action_types.action_type_id = ame_mandatory_attributes.action_type_id and
170: ame_mandatory_attributes.attribute_id = attributeIdIn and
171: sysdate between ame_action_types.start_date and
172: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
173: sysdate between ame_mandatory_attributes.start_date and
174: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)

Line 173: sysdate between ame_mandatory_attributes.start_date and

169: ame_action_types.action_type_id = ame_mandatory_attributes.action_type_id and
170: ame_mandatory_attributes.attribute_id = attributeIdIn and
171: sysdate between ame_action_types.start_date and
172: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
173: sysdate between ame_mandatory_attributes.start_date and
174: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
175: order by name;
176: tempCount integer;
177: approvalTypeNames varchar2(500);

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

170: ame_mandatory_attributes.attribute_id = attributeIdIn and
171: sysdate between ame_action_types.start_date and
172: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
173: sysdate between ame_mandatory_attributes.start_date and
174: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
175: order by name;
176: tempCount integer;
177: approvalTypeNames varchar2(500);
178: begin

Line 307: ame_mandatory_attributes

303: function getAttributeNames(actionTypeIdIn in integer) return varchar2 as
304: cursor getAttributeNames(actionTypeIdIn in integer) is
305: select ame_attributes.name
306: from ame_attributes,
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

Line 309: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

305: select ame_attributes.name
306: from ame_attributes,
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

Line 310: ame_mandatory_attributes.action_type_id = actionTypeIdIn and

306: from ame_attributes,
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)

Line 313: sysdate between ame_mandatory_attributes.start_date and

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;
316: tempCount integer;
317: attributeNames varchar2(500);

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

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;
316: tempCount integer;
317: attributeNames varchar2(500);
318: begin

Line 963: from ame_mandatory_attributes

959: mandatoryCount integer;
960: begin
961: select count(*)
962: into mandatoryCount
963: from ame_mandatory_attributes
964: where action_type_id = -1 and
965: attribute_id = attributeIdIn and
966: sysdate between start_date and
967: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 1018: from ame_mandatory_attributes

1014: requiredCount integer;
1015: begin
1016: select count(*)
1017: into requiredCount
1018: from ame_mandatory_attributes
1019: where
1020: action_type_id <> -1 and
1021: attribute_id = attributeIdIn and
1022: sysdate between start_date and

Line 1721: ame_mandatory_attributes

1717: ame_attributes.attribute_id attribute_id,
1718: ame_attributes.name name
1719: from
1720: ame_attributes,
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

Line 1723: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

1719: from
1720: ame_attributes,
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

Line 1724: ame_mandatory_attributes.action_type_id = -1 and

1720: ame_attributes,
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)

Line 1727: sysdate between ame_mandatory_attributes.start_date and

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;
1730: tempIndex integer;
1731: begin

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

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;
1730: tempIndex integer;
1731: begin
1732: tempIndex := 1;

Line 1783: ame_mandatory_attributes

1779: ame_attributes.attribute_id attribute_id,
1780: ame_attributes.name name
1781: from
1782: ame_attributes,
1783: ame_mandatory_attributes
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

Line 1785: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

1781: from
1782: ame_attributes,
1783: ame_mandatory_attributes
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

Line 1787: ame_mandatory_attributes.action_type_id = -1 and

1783: ame_mandatory_attributes
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)

Line 1790: sysdate between ame_mandatory_attributes.start_date 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;
1793: itemClassId integer;
1794: tempIndex integer;

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

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;
1793: itemClassId integer;
1794: tempIndex integer;
1795: begin

Line 1895: from ame_mandatory_attributes

1891: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1892: ame_attributes.item_class_id = itemClassIdIn and
1893: ame_attribute_usages.application_id = applicationIdIn and
1894: ame_attributes.attribute_id not in (select attribute_id
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

Line 2235: (select attribute_id from ame_mandatory_attributes

2231: from
2232: ame_attributes
2233: where
2234: ame_attributes.attribute_id not in
2235: (select attribute_id from ame_mandatory_attributes
2236: where
2237: (action_type_id = actionTypeIdIn or
2238: action_type_id = ame_util.mandAttActionTypeId) and
2239: sysdate between ame_mandatory_attributes.start_date and

Line 2239: sysdate between ame_mandatory_attributes.start_date and

2235: (select attribute_id from ame_mandatory_attributes
2236: where
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;

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

2236: where
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;

Line 2280: (select attribute_id from ame_mandatory_attributes

2276: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2277: ame_attributes.item_class_id = headerItemClassIdIn and
2278: ame_attribute_usages.application_id = applicationIdIn and
2279: ame_attributes.attribute_id not in
2280: (select attribute_id from ame_mandatory_attributes
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

Line 2283: sysdate between ame_mandatory_attributes.start_date and

2279: ame_attributes.attribute_id not in
2280: (select attribute_id from ame_mandatory_attributes
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

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

2280: (select attribute_id from ame_mandatory_attributes
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)

Line 2326: ame_mandatory_attributes

2322: ame_attributes.name,
2323: ame_attributes.start_date
2324: from
2325: ame_attributes,
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

Line 2328: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

2324: from
2325: ame_attributes,
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

Line 2329: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and

2325: ame_attributes,
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)

Line 2332: sysdate between ame_mandatory_attributes.start_date and

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;
2335: tempIndex integer;
2336: begin

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

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;
2335: tempIndex integer;
2336: begin
2337: tempIndex := 1;

Line 2367: ame_mandatory_attributes

2363: ame_attributes.name
2364: from
2365: ame_attributes,
2366: ame_attribute_usages,
2367: ame_mandatory_attributes
2368: where
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

Line 2369: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

2365: ame_attributes,
2366: ame_attribute_usages,
2367: ame_mandatory_attributes
2368: where
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

Line 2372: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and

2368: where
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

Line 2377: sysdate between ame_mandatory_attributes.start_date 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
2378: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
2379: order by name;
2380: tempIndex integer;
2381: begin

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

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
2378: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
2379: order by name;
2380: tempIndex integer;
2381: begin
2382: tempIndex := 1;

Line 2411: ame_mandatory_attributes

2407: ame_attributes.name,
2408: ame_attributes.start_date
2409: from
2410: ame_attributes,
2411: ame_mandatory_attributes
2412: where
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,

Line 2413: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

2409: from
2410: ame_attributes,
2411: ame_mandatory_attributes
2412: where
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

Line 2414: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and

2410: ame_attributes,
2411: ame_mandatory_attributes
2412: where
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

Line 2419: sysdate between ame_mandatory_attributes.start_date 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;
2422: tempIndex integer;
2423: begin

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

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;
2422: tempIndex integer;
2423: begin
2424: tempIndex := 1;

Line 2535: ame_mandatory_attributes

2531: cursor attributeCursor(actionTypeIdIn in integer) is
2532: select ame_attributes.attribute_id,
2533: ame_attributes.name
2534: from ame_attributes,
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

Line 2537: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

2533: ame_attributes.name
2534: from ame_attributes,
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

Line 2538: ame_mandatory_attributes.action_type_id = actionTypeIdIn and

2534: from ame_attributes,
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)

Line 2541: sysdate between ame_mandatory_attributes.start_date and

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;
2544: tempIndex integer;
2545: begin

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

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;
2544: tempIndex integer;
2545: begin
2546: tempIndex := 1;

Line 2714: (select attribute_id from ame_mandatory_attributes

2710: ame_attribute_usages.application_id = applicationIdIn and
2711: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2712: nvl(ame_attribute_usages.is_striping_attribute, ame_util.booleanFalse) = isStripingAttributeIn and
2713: ame_attributes.attribute_id not in
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

Line 2716: (ame_mandatory_attributes.start_date <= sysdate and

2712: nvl(ame_attribute_usages.is_striping_attribute, ame_util.booleanFalse) = isStripingAttributeIn and
2713: ame_attributes.attribute_id not in
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

Line 2717: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date))) and

2713: ame_attributes.attribute_id not in
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))

Line 2763: (select attribute_id from ame_mandatory_attributes

2759: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2760: ame_attribute_usages.application_id = applicationIdIn and
2761: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2762: ame_attributes.attribute_id not in
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

Line 2765: sysdate between ame_mandatory_attributes.start_date and

2761: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2762: ame_attributes.attribute_id not in
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

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

2762: ame_attributes.attribute_id not in
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)

Line 2812: (select attribute_id from ame_mandatory_attributes

2808: ame_item_classes.item_class_id = headerItemClassIdIn and
2809: ame_attribute_usages.application_id = applicationIdIn and
2810: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2811: ame_attributes.attribute_id not in
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

Line 2814: sysdate between ame_mandatory_attributes.start_date and

2810: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2811: ame_attributes.attribute_id not in
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

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

2811: ame_attributes.attribute_id not in
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

Line 3750: from ame_mandatory_attributes

3746: end if;
3747: end loop;
3748: select count(*)
3749: into tempCount
3750: from ame_mandatory_attributes
3751: where
3752: attribute_id = attributeIdIn and
3753: action_type_id = actionTypeIdIn and
3754: sysdate between start_date and

Line 3765: insert into ame_mandatory_attributes

3761: createdBy := currentUserId;
3762: else
3763: createdBy := createdByIn;
3764: end if;
3765: insert into ame_mandatory_attributes
3766: (attribute_id,
3767: action_type_id,
3768: created_by,
3769: creation_date,

Line 3888: update ame_mandatory_attributes

3884: processingDate date;
3885: begin
3886: processingDate := sysdate;
3887: currentUserId := ame_util.getCurrentUserId;
3888: update ame_mandatory_attributes
3889: set
3890: last_updated_by = currentUserId,
3891: last_update_date = processingDate,
3892: last_update_login = currentUserId,