DBA Data[Home] [Help]

APPS.AME_UTIL dependencies on AME_ATTRIBUTE_PKG

Line 3184: workflowItemKeyAttId := ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.workflowItemKeyAttribute);

3180: workflowItemTypeAttId integer;
3181: begin
3182: /* Fetch the Workflow item key. */
3183: attributeName := workflowItemKeyAttribute;
3184: workflowItemKeyAttId := ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.workflowItemKeyAttribute);
3185: dynamicQuery := ame_attribute_pkg.getQueryString(attributeIdIn => workflowItemKeyAttId,
3186: applicationIdIn => applicationIdIn);
3187: if(ame_attribute_pkg.getStaticUsage(attributeIdIn => workflowItemKeyAttId,
3188: applicationIdIn => applicationIdIn) = ame_util.booleanTrue) then

Line 3185: dynamicQuery := ame_attribute_pkg.getQueryString(attributeIdIn => workflowItemKeyAttId,

3181: begin
3182: /* Fetch the Workflow item key. */
3183: attributeName := workflowItemKeyAttribute;
3184: workflowItemKeyAttId := ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.workflowItemKeyAttribute);
3185: dynamicQuery := ame_attribute_pkg.getQueryString(attributeIdIn => workflowItemKeyAttId,
3186: applicationIdIn => applicationIdIn);
3187: if(ame_attribute_pkg.getStaticUsage(attributeIdIn => workflowItemKeyAttId,
3188: applicationIdIn => applicationIdIn) = ame_util.booleanTrue) then
3189: workflowItemKeyOut := dynamicQuery;

Line 3187: if(ame_attribute_pkg.getStaticUsage(attributeIdIn => workflowItemKeyAttId,

3183: attributeName := workflowItemKeyAttribute;
3184: workflowItemKeyAttId := ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.workflowItemKeyAttribute);
3185: dynamicQuery := ame_attribute_pkg.getQueryString(attributeIdIn => workflowItemKeyAttId,
3186: applicationIdIn => applicationIdIn);
3187: if(ame_attribute_pkg.getStaticUsage(attributeIdIn => workflowItemKeyAttId,
3188: applicationIdIn => applicationIdIn) = ame_util.booleanTrue) then
3189: workflowItemKeyOut := dynamicQuery;
3190: else
3191: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) = 0) then /* The bind variable is not present. */

Line 3199: workflowItemTypeAttId := ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.workflowItemTypeAttribute);

3195: end if;
3196: end if;
3197: /* Fetch the Workflow item type. */
3198: attributeName := workflowItemTypeAttribute;
3199: workflowItemTypeAttId := ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.workflowItemTypeAttribute);
3200: dynamicQuery := ame_attribute_pkg.getQueryString(attributeIdIn => workflowItemTypeAttId,
3201: applicationIdIn => applicationIdIn);
3202: if(ame_attribute_pkg.getStaticUsage(attributeIdIn => workflowItemTypeAttId,
3203: applicationIdIn => applicationIdIn) = ame_util.booleanTrue) then

Line 3200: dynamicQuery := ame_attribute_pkg.getQueryString(attributeIdIn => workflowItemTypeAttId,

3196: end if;
3197: /* Fetch the Workflow item type. */
3198: attributeName := workflowItemTypeAttribute;
3199: workflowItemTypeAttId := ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.workflowItemTypeAttribute);
3200: dynamicQuery := ame_attribute_pkg.getQueryString(attributeIdIn => workflowItemTypeAttId,
3201: applicationIdIn => applicationIdIn);
3202: if(ame_attribute_pkg.getStaticUsage(attributeIdIn => workflowItemTypeAttId,
3203: applicationIdIn => applicationIdIn) = ame_util.booleanTrue) then
3204: workflowItemTypeOut := dynamicQuery;

Line 3202: if(ame_attribute_pkg.getStaticUsage(attributeIdIn => workflowItemTypeAttId,

3198: attributeName := workflowItemTypeAttribute;
3199: workflowItemTypeAttId := ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.workflowItemTypeAttribute);
3200: dynamicQuery := ame_attribute_pkg.getQueryString(attributeIdIn => workflowItemTypeAttId,
3201: applicationIdIn => applicationIdIn);
3202: if(ame_attribute_pkg.getStaticUsage(attributeIdIn => workflowItemTypeAttId,
3203: applicationIdIn => applicationIdIn) = ame_util.booleanTrue) then
3204: workflowItemTypeOut := dynamicQuery;
3205: else
3206: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) = 0) then /* The bind variable is not present. */

Line 3933: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIdIn);

3929: if(comma1Location = 0 or
3930: comma2Location = 0 or
3931: comma1Location < 2 or
3932: comma2Location < 4) then
3933: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIdIn);
3934: raise badStaticCurUsageException;
3935: end if;
3936: amountOut := substrb(attributeValueIn, 1, comma1Location - 1);
3937: currencyOut := substrb(attributeValueIn, comma1Location + 1, comma2Location - comma1Location - 1);