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_ADMIN_PKG dependencies on AME_ATTRIBUTE_PKG

Line 1659: ame_attribute_pkg.changeUsage(attributeIdIn => attributeIdIn,

1655: end loop;
1656: newStripeSet2(applicationIdIn => applicationIdIn,
1657: newStripedAttributesSetIn => newStripingAttributeIds);
1658: tempDate := sysdate;
1659: ame_attribute_pkg.changeUsage(attributeIdIn => attributeIdIn,
1660: applicationIdIn => applicationIdIn,
1661: staticUsageIn =>
1662: ame_attribute_pkg.getStaticUsage(attributeIdIn => attributeIdIn,
1663: applicationIdIn => applicationIdIn),

Line 1662: ame_attribute_pkg.getStaticUsage(attributeIdIn => attributeIdIn,

1658: tempDate := sysdate;
1659: ame_attribute_pkg.changeUsage(attributeIdIn => attributeIdIn,
1660: applicationIdIn => applicationIdIn,
1661: staticUsageIn =>
1662: ame_attribute_pkg.getStaticUsage(attributeIdIn => attributeIdIn,
1663: applicationIdIn => applicationIdIn),
1664: queryStringIn =>
1665: ame_attribute_pkg.getQueryString(attributeIdIn => attributeIdIn,
1666: applicationIdIn => applicationIdIn),

Line 1665: ame_attribute_pkg.getQueryString(attributeIdIn => attributeIdIn,

1661: staticUsageIn =>
1662: ame_attribute_pkg.getStaticUsage(attributeIdIn => attributeIdIn,
1663: applicationIdIn => applicationIdIn),
1664: queryStringIn =>
1665: ame_attribute_pkg.getQueryString(attributeIdIn => attributeIdIn,
1666: applicationIdIn => applicationIdIn),
1667: endDateIn => tempDate,
1668: newStartDateIn => tempDate,
1669: lineItemAttributeIn =>

Line 1670: ame_attribute_pkg.getLineItem(attributeIdIn => attributeIdIn),

1666: applicationIdIn => applicationIdIn),
1667: endDateIn => tempDate,
1668: newStartDateIn => tempDate,
1669: lineItemAttributeIn =>
1670: ame_attribute_pkg.getLineItem(attributeIdIn => attributeIdIn),
1671: isStripingAttributeIn => ame_util.booleanTrue);
1672: exception
1673: when existingSAException then
1674: rollback;

Line 1678: ame_attribute_pkg.getName(attributeIdIn => attributeIdIn) ||

1674: rollback;
1675: errorCode := -20001;
1676: errorMessage :=
1677: 'The attribute ' ||
1678: ame_attribute_pkg.getName(attributeIdIn => attributeIdIn) ||
1679: ' is already a striping attribute for this transaction type. ';
1680: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1681: routineNameIn => 'addStripingAttribute',
1682: exceptionNumberIn => errorCode,

Line 2770: stripingAttributeNamesOut(1) := ame_attribute_pkg.getName(attributeIdIn => attributeId1);

2766: return;
2767: end;
2768: if(attributeId1 is not null) then
2769: stripingAttributeIdsOut(1) := attributeId1;
2770: stripingAttributeNamesOut(1) := ame_attribute_pkg.getName(attributeIdIn => attributeId1);
2771: end if;
2772: if(attributeId2 is not null) then
2773: stripingAttributeIdsOut(2) := attributeId2;
2774: stripingAttributeNamesOut(2) := ame_attribute_pkg.getName(attributeIdIn => attributeId2);

Line 2774: stripingAttributeNamesOut(2) := ame_attribute_pkg.getName(attributeIdIn => attributeId2);

2770: stripingAttributeNamesOut(1) := ame_attribute_pkg.getName(attributeIdIn => attributeId1);
2771: end if;
2772: if(attributeId2 is not null) then
2773: stripingAttributeIdsOut(2) := attributeId2;
2774: stripingAttributeNamesOut(2) := ame_attribute_pkg.getName(attributeIdIn => attributeId2);
2775: end if;
2776: if (attributeId3 is not null) then
2777: stripingAttributeIdsOut(3) := attributeId3;
2778: stripingAttributeNamesOut(3) := ame_attribute_pkg.getName(attributeIdIn => attributeId3);

Line 2778: stripingAttributeNamesOut(3) := ame_attribute_pkg.getName(attributeIdIn => attributeId3);

2774: stripingAttributeNamesOut(2) := ame_attribute_pkg.getName(attributeIdIn => attributeId2);
2775: end if;
2776: if (attributeId3 is not null) then
2777: stripingAttributeIdsOut(3) := attributeId3;
2778: stripingAttributeNamesOut(3) := ame_attribute_pkg.getName(attributeIdIn => attributeId3);
2779: end if;
2780: if (attributeId4 is not null) then
2781: stripingAttributeIdsOut(4) := attributeId4;
2782: stripingAttributeNamesOut(4) := ame_attribute_pkg.getName(attributeIdIn => attributeId4);

Line 2782: stripingAttributeNamesOut(4) := ame_attribute_pkg.getName(attributeIdIn => attributeId4);

2778: stripingAttributeNamesOut(3) := ame_attribute_pkg.getName(attributeIdIn => attributeId3);
2779: end if;
2780: if (attributeId4 is not null) then
2781: stripingAttributeIdsOut(4) := attributeId4;
2782: stripingAttributeNamesOut(4) := ame_attribute_pkg.getName(attributeIdIn => attributeId4);
2783: end if;
2784: if(attributeId5 is not null) then
2785: stripingAttributeIdsOut(5) := attributeId5;
2786: stripingAttributeNamesOut(5) := ame_attribute_pkg.getName(attributeIdIn => attributeId5);

Line 2786: stripingAttributeNamesOut(5) := ame_attribute_pkg.getName(attributeIdIn => attributeId5);

2782: stripingAttributeNamesOut(4) := ame_attribute_pkg.getName(attributeIdIn => attributeId4);
2783: end if;
2784: if(attributeId5 is not null) then
2785: stripingAttributeIdsOut(5) := attributeId5;
2786: stripingAttributeNamesOut(5) := ame_attribute_pkg.getName(attributeIdIn => attributeId5);
2787: end if;
2788: exception
2789: when others then
2790: rollback;

Line 3249: stripingAttributeNamesOut(i) := ame_attribute_pkg.getName(attributeIdIn => valueColumns(i));

3245: for i in 1 .. 5 loop
3246: if(valueColumns(i) is null) then
3247: exit;
3248: end if;
3249: stripingAttributeNamesOut(i) := ame_attribute_pkg.getName(attributeIdIn => valueColumns(i));
3250: end loop;
3251: exception
3252: when others then
3253: rollback;

Line 3304: stripingAttributeNamesOut(i) := ame_attribute_pkg.getName(attributeIdIn => attributeIds(i));

3300: if(attributeIds(i) is null) then
3301: exit;
3302: end if;
3303: stripingAttributeIdsOut(i) := attributeIds(i);
3304: stripingAttributeNamesOut(i) := ame_attribute_pkg.getName(attributeIdIn => attributeIds(i));
3305: end loop;
3306: upperLimit := stripingAttributeIdsOut.count;
3307: for i in 1 .. upperLimit loop
3308: tempValueList.delete;

Line 3410: stripingAttributeNamesOut(i) := ame_attribute_pkg.getName(attributeIdIn => attributeIds(i));

3406: if(attributeIds(i) is null) then
3407: exit;
3408: end if;
3409: stripingAttributeIdsOut(i) := attributeIds(i);
3410: stripingAttributeNamesOut(i) := ame_attribute_pkg.getName(attributeIdIn => attributeIds(i));
3411: end loop;
3412: upperLimit := stripingAttributeIdsOut.count;
3413: for i in 1 .. upperLimit loop
3414: tempValueList.delete;

Line 4583: ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.evalPrioritiesPerItemAttribute);

4579: attributeIds := attributeIdsIn;
4580: versionStartDates := versionStartDatesIn;
4581: tempIndex2 := (attributeIds.count + 1);
4582: evalPrioritiesPerItemAttId :=
4583: ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.evalPrioritiesPerItemAttribute);
4584: evalPriorityStartDate :=
4585: ame_attribute_pkg.getStartDate(attributeIdIn => evalPrioritiesPerItemAttId);
4586: attributeIds(tempIndex2) := evalPrioritiesPerItemAttId;
4587: queryStrings(tempIndex2) := ame_util.booleanAttributeFalse;

Line 4585: ame_attribute_pkg.getStartDate(attributeIdIn => evalPrioritiesPerItemAttId);

4581: tempIndex2 := (attributeIds.count + 1);
4582: evalPrioritiesPerItemAttId :=
4583: ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.evalPrioritiesPerItemAttribute);
4584: evalPriorityStartDate :=
4585: ame_attribute_pkg.getStartDate(attributeIdIn => evalPrioritiesPerItemAttId);
4586: attributeIds(tempIndex2) := evalPrioritiesPerItemAttId;
4587: queryStrings(tempIndex2) := ame_util.booleanAttributeFalse;
4588: staticUsages(tempIndex2) := ame_util.booleanTrue;
4589: versionStartDates(tempIndex2) := evalPriorityStartDate;

Line 4591: ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.restrictiveItemEvalAttribute);

4587: queryStrings(tempIndex2) := ame_util.booleanAttributeFalse;
4588: staticUsages(tempIndex2) := ame_util.booleanTrue;
4589: versionStartDates(tempIndex2) := evalPriorityStartDate;
4590: useRestrItemEvalAttId :=
4591: ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.restrictiveItemEvalAttribute);
4592: useRestrStartDate :=
4593: ame_attribute_pkg.getStartDate(attributeIdIn => useRestrItemEvalAttId);
4594: tempIndex2 := (tempIndex2 + 1);
4595: attributeIds(tempIndex2) := useRestrItemEvalAttId;

Line 4593: ame_attribute_pkg.getStartDate(attributeIdIn => useRestrItemEvalAttId);

4589: versionStartDates(tempIndex2) := evalPriorityStartDate;
4590: useRestrItemEvalAttId :=
4591: ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.restrictiveItemEvalAttribute);
4592: useRestrStartDate :=
4593: ame_attribute_pkg.getStartDate(attributeIdIn => useRestrItemEvalAttId);
4594: tempIndex2 := (tempIndex2 + 1);
4595: attributeIds(tempIndex2) := useRestrItemEvalAttId;
4596: queryStrings(tempIndex2) := ame_util.booleanAttributeFalse;
4597: staticUsages(tempIndex2) := ame_util.booleanTrue;

Line 4609: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIds(i));

4605: /* verifies that the mandatory attribute has not been updated */
4606: /* the versionStartDate is in sync with the start date due to how the data
4607: was retrieved for each */
4608: if(versionStartDates(tempIndex) = startDate) then
4609: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIds(i));
4610: if(attributeName = ame_util.evalPrioritiesPerItemAttribute) then
4611: evalAttributeId := attributeIds(i);
4612: evalQueryString := queryStrings(tempIndex);
4613: evalStaticUsage := staticUsages(tempIndex);

Line 4615: ame_attribute_pkg.newAttributeUsage(attributeIdIn => attributeIds(i),

4611: evalAttributeId := attributeIds(i);
4612: evalQueryString := queryStrings(tempIndex);
4613: evalStaticUsage := staticUsages(tempIndex);
4614: else
4615: ame_attribute_pkg.newAttributeUsage(attributeIdIn => attributeIds(i),
4616: applicationIdIn => applicationId,
4617: queryStringIn => queryStrings(tempIndex),
4618: staticUsageIn => staticUsages(tempIndex),
4619: updateParentObjectIn => true,

Line 4622: ame_attribute_pkg.newAttributeUsage(attributeIdIn => evalAttributeId,

4618: staticUsageIn => staticUsages(tempIndex),
4619: updateParentObjectIn => true,
4620: finalizeIn => false);
4621: if(attributeName = ame_util.restrictiveItemEvalAttribute) then
4622: ame_attribute_pkg.newAttributeUsage(attributeIdIn => evalAttributeId,
4623: applicationIdIn => applicationId,
4624: queryStringIn => evalQueryString,
4625: staticUsageIn => evalStaticUsage,
4626: updateParentObjectIn => true,

Line 5364: ame_attribute_pkg.getApplicationAttributes(applicationIdIn => applicationIdIn,

5360: usageStartDateIn => tempRows.start_date,
5361: parentVersionStartDateIn => versionStartDate,
5362: finalizeIn => false);
5363: end loop;
5364: ame_attribute_pkg.getApplicationAttributes(applicationIdIn => applicationIdIn,
5365: attributeIdOut => attributeIdsList);
5366: tempIndex := attributeIdsList.count;
5367: for i in 1 .. tempIndex loop
5368: parentVersionStartDate := ame_util.versionStringToDate(stringDateIn =>

Line 5369: ame_attribute_pkg.getParentVersionStartDate(attributeIdIn => attributeIdsList(i)));

5365: attributeIdOut => attributeIdsList);
5366: tempIndex := attributeIdsList.count;
5367: for i in 1 .. tempIndex loop
5368: parentVersionStartDate := ame_util.versionStringToDate(stringDateIn =>
5369: ame_attribute_pkg.getParentVersionStartDate(attributeIdIn => attributeIdsList(i)));
5370: childVersionStartDate := ame_util.versionStringToDate(stringDateIn =>
5371: ame_attribute_pkg.getChildVersionStartDate(attributeIdIn => attributeIdsList(i),
5372: applicationIdIn => applicationIdIn));
5373: itemClassId := ame_attribute_pkg.getItemClassId(attributeIdIn => attributeIdsList(i));

Line 5371: ame_attribute_pkg.getChildVersionStartDate(attributeIdIn => attributeIdsList(i),

5367: for i in 1 .. tempIndex loop
5368: parentVersionStartDate := ame_util.versionStringToDate(stringDateIn =>
5369: ame_attribute_pkg.getParentVersionStartDate(attributeIdIn => attributeIdsList(i)));
5370: childVersionStartDate := ame_util.versionStringToDate(stringDateIn =>
5371: ame_attribute_pkg.getChildVersionStartDate(attributeIdIn => attributeIdsList(i),
5372: applicationIdIn => applicationIdIn));
5373: itemClassId := ame_attribute_pkg.getItemClassId(attributeIdIn => attributeIdsList(i));
5374: ame_attribute_pkg.removeUsage(attributeIdIn => attributeIdsList(i),
5375: applicationIdIn => applicationIdIn,

Line 5373: itemClassId := ame_attribute_pkg.getItemClassId(attributeIdIn => attributeIdsList(i));

5369: ame_attribute_pkg.getParentVersionStartDate(attributeIdIn => attributeIdsList(i)));
5370: childVersionStartDate := ame_util.versionStringToDate(stringDateIn =>
5371: ame_attribute_pkg.getChildVersionStartDate(attributeIdIn => attributeIdsList(i),
5372: applicationIdIn => applicationIdIn));
5373: itemClassId := ame_attribute_pkg.getItemClassId(attributeIdIn => attributeIdsList(i));
5374: ame_attribute_pkg.removeUsage(attributeIdIn => attributeIdsList(i),
5375: applicationIdIn => applicationIdIn,
5376: parentVersionStartDateIn => parentVersionStartDate,
5377: childVersionStartDateIn => childVersionStartDate,

Line 5374: ame_attribute_pkg.removeUsage(attributeIdIn => attributeIdsList(i),

5370: childVersionStartDate := ame_util.versionStringToDate(stringDateIn =>
5371: ame_attribute_pkg.getChildVersionStartDate(attributeIdIn => attributeIdsList(i),
5372: applicationIdIn => applicationIdIn));
5373: itemClassId := ame_attribute_pkg.getItemClassId(attributeIdIn => attributeIdsList(i));
5374: ame_attribute_pkg.removeUsage(attributeIdIn => attributeIdsList(i),
5375: applicationIdIn => applicationIdIn,
5376: parentVersionStartDateIn => parentVersionStartDate,
5377: childVersionStartDateIn => childVersionStartDate,
5378: allowAttributeUsageDeleteIn => true,

Line 5555: ame_attribute_pkg.changeUsage(attributeIdIn => newStripingAttributeIds(i),

5551: null,
5552: null);
5553: for i in 1..newStripingAttributeIds.count loop
5554: if(newStripingAttributeIds(i) is not null) then
5555: ame_attribute_pkg.changeUsage(attributeIdIn => newStripingAttributeIds(i),
5556: applicationIdIn => applicationIdIn,
5557: staticUsageIn =>
5558: ame_attribute_pkg.getStaticUsage(attributeIdIn => newStripingAttributeIds(i),
5559: applicationIdIn => applicationIdIn),

Line 5558: ame_attribute_pkg.getStaticUsage(attributeIdIn => newStripingAttributeIds(i),

5554: if(newStripingAttributeIds(i) is not null) then
5555: ame_attribute_pkg.changeUsage(attributeIdIn => newStripingAttributeIds(i),
5556: applicationIdIn => applicationIdIn,
5557: staticUsageIn =>
5558: ame_attribute_pkg.getStaticUsage(attributeIdIn => newStripingAttributeIds(i),
5559: applicationIdIn => applicationIdIn),
5560: queryStringIn =>
5561: ame_attribute_pkg.getQueryString(attributeIdIn => newStripingAttributeIds(i),
5562: applicationIdIn => applicationIdIn),

Line 5561: ame_attribute_pkg.getQueryString(attributeIdIn => newStripingAttributeIds(i),

5557: staticUsageIn =>
5558: ame_attribute_pkg.getStaticUsage(attributeIdIn => newStripingAttributeIds(i),
5559: applicationIdIn => applicationIdIn),
5560: queryStringIn =>
5561: ame_attribute_pkg.getQueryString(attributeIdIn => newStripingAttributeIds(i),
5562: applicationIdIn => applicationIdIn),
5563: endDateIn => sysdate - ame_util.oneSecond,
5564: newStartDateIn => sysdate,
5565: lineItemAttributeIn =>

Line 5566: ame_attribute_pkg.getLineItem(attributeIdIn => newStripingAttributeIds(i)),

5562: applicationIdIn => applicationIdIn),
5563: endDateIn => sysdate - ame_util.oneSecond,
5564: newStartDateIn => sysdate,
5565: lineItemAttributeIn =>
5566: ame_attribute_pkg.getLineItem(attributeIdIn => newStripingAttributeIds(i)),
5567: isStripingAttributeIn => ame_util.booleanTrue);
5568: end if;
5569: end loop;
5570: commit;

Line 5601: queryString := ame_attribute_pkg.getQueryString(applicationIdIn => applicationIdIn,

5597: attributeCount := stripingAttributeIds.count;
5598: for i in 1..attributeCount loop
5599: endDate := sysdate - ame_util.oneSecond;
5600: newStartDate := sysdate;
5601: queryString := ame_attribute_pkg.getQueryString(applicationIdIn => applicationIdIn,
5602: attributeIdIn => stripingAttributeIds(i));
5603: staticUsage := ame_attribute_pkg.getStaticUsage(applicationIdIn => applicationIdIn,
5604: attributeIdIn => stripingAttributeIds(i));
5605: lineItemAttribute := ame_attribute_pkg.getLineItem(attributeIdIn => stripingAttributeIds(i));

Line 5603: staticUsage := ame_attribute_pkg.getStaticUsage(applicationIdIn => applicationIdIn,

5599: endDate := sysdate - ame_util.oneSecond;
5600: newStartDate := sysdate;
5601: queryString := ame_attribute_pkg.getQueryString(applicationIdIn => applicationIdIn,
5602: attributeIdIn => stripingAttributeIds(i));
5603: staticUsage := ame_attribute_pkg.getStaticUsage(applicationIdIn => applicationIdIn,
5604: attributeIdIn => stripingAttributeIds(i));
5605: lineItemAttribute := ame_attribute_pkg.getLineItem(attributeIdIn => stripingAttributeIds(i));
5606: ame_attribute_pkg.changeUsage(attributeIdIn => stripingAttributeIds(i),
5607: applicationIdIn => applicationIdIn,

Line 5605: lineItemAttribute := ame_attribute_pkg.getLineItem(attributeIdIn => stripingAttributeIds(i));

5601: queryString := ame_attribute_pkg.getQueryString(applicationIdIn => applicationIdIn,
5602: attributeIdIn => stripingAttributeIds(i));
5603: staticUsage := ame_attribute_pkg.getStaticUsage(applicationIdIn => applicationIdIn,
5604: attributeIdIn => stripingAttributeIds(i));
5605: lineItemAttribute := ame_attribute_pkg.getLineItem(attributeIdIn => stripingAttributeIds(i));
5606: ame_attribute_pkg.changeUsage(attributeIdIn => stripingAttributeIds(i),
5607: applicationIdIn => applicationIdIn,
5608: staticUsageIn => staticUsage,
5609: queryStringIn => queryString,

Line 5606: ame_attribute_pkg.changeUsage(attributeIdIn => stripingAttributeIds(i),

5602: attributeIdIn => stripingAttributeIds(i));
5603: staticUsage := ame_attribute_pkg.getStaticUsage(applicationIdIn => applicationIdIn,
5604: attributeIdIn => stripingAttributeIds(i));
5605: lineItemAttribute := ame_attribute_pkg.getLineItem(attributeIdIn => stripingAttributeIds(i));
5606: ame_attribute_pkg.changeUsage(attributeIdIn => stripingAttributeIds(i),
5607: applicationIdIn => applicationIdIn,
5608: staticUsageIn => staticUsage,
5609: queryStringIn => queryString,
5610: endDateIn => endDate,