DBA Data[Home] [Help]

APPS.AME_TEST_UTILITY_PKG dependencies on AME_APPROVER

Line 14: approverName := AME_APPROVER_TYPE_PKG.getWfRolesName

10: approverTypeId := ame_attribute_pkg.getApproverTypeId
11: (attributeIdIn => attributeIdIn);
12: if(approverTypeId is not null and attributeValueIn is not null)
13: then
14: approverName := AME_APPROVER_TYPE_PKG.getWfRolesName
15: (origSystemIn => approverTypeId
16: ,origSystemIdIn => attributeValueIn
17: ,raiseNoDataFoundIn => 'true');
18: end if;

Line 91: where fl.lookup_type = 'AME_APPROVER_CATEGORY'

87: begin
88: select meaning
89: into approvalCategoryDesc
90: from fnd_lookups fl
91: where fl.lookup_type = 'AME_APPROVER_CATEGORY'
92: and fl.enabled_flag = 'Y'
93: and fl.lookup_code = categoryIn
94: and trunc(sysdate) between start_date_active
95: and nvl(end_date_active, trunc(sysdate));

Line 1098: ,approversOut out nocopy ame_approvers_list

1094: ,transactionIdIn in varchar2
1095: ,isRealTransaction in varchar2 -- 'Y' for a real transaction
1096: -- 'N' for a test transaction
1097: ,approverListStageIn in integer
1098: ,approversOut out nocopy ame_approvers_list
1099: ,errString out nocopy varchar2) as
1100: approverList ame_util.approversTable2;
1101: productionIndexes ame_util.idList;
1102: variableNames ame_util.stringList;

Line 1104: approverObjList ame_approvers_list := ame_approvers_list();

1100: approverList ame_util.approversTable2;
1101: productionIndexes ame_util.idList;
1102: variableNames ame_util.stringList;
1103: variableValues ame_util.stringList;
1104: approverObjList ame_approvers_list := ame_approvers_list();
1105: approver ame_approver;
1106: effectiveRuleDate date;
1107: tempActionTypeName ame_util.stringType;
1108: tempGroupName ame_util.stringType;

Line 1105: approver ame_approver;

1101: productionIndexes ame_util.idList;
1102: variableNames ame_util.stringList;
1103: variableValues ame_util.stringList;
1104: approverObjList ame_approvers_list := ame_approvers_list();
1105: approver ame_approver;
1106: effectiveRuleDate date;
1107: tempActionTypeName ame_util.stringType;
1108: tempGroupName ame_util.stringType;
1109: approverSource varchar2(500);

Line 1128: tempActionTypeName := getActionTypeName(approverList(i).action_type_id);

1124: --+
1125: effectiveRuleDate := ame_engine.getEffectiveRuleDate;
1126: --+
1127: for i in 1 .. approverList.count loop
1128: tempActionTypeName := getActionTypeName(approverList(i).action_type_id);
1129: if(tempActionTypeName in (ame_util.groupChainApprovalTypeName
1130: ,ame_util.preApprovalTypeName
1131: ,ame_util.postApprovalTypeName))then
1132: tempGroupName := getApproverGroupName(approverList(i).group_or_chain_id);

Line 1132: tempGroupName := getApproverGroupName(approverList(i).group_or_chain_id);

1128: tempActionTypeName := getActionTypeName(approverList(i).action_type_id);
1129: if(tempActionTypeName in (ame_util.groupChainApprovalTypeName
1130: ,ame_util.preApprovalTypeName
1131: ,ame_util.postApprovalTypeName))then
1132: tempGroupName := getApproverGroupName(approverList(i).group_or_chain_id);
1133: else
1134: tempGroupName := 'Chain '||approverList(i).group_or_chain_id;
1135: end if;
1136: ame_util.parseSourceValue(sourceValueIn => approverList(i).source

Line 1162: approver := ame_approver(approverList(i).name

1158: if approverListStageIn = 5 and
1159: approverList(i).approval_status like '%'||ame_util.repeatedStatus then
1160: approverList(i).approval_status :=ame_util.repeatedStatus;
1161: end if;
1162: approver := ame_approver(approverList(i).name
1163: ,approverList(i).orig_system
1164: ,approverList(i).orig_system_id
1165: ,approverList(i).display_name
1166: ,approverList(i).approver_category

Line 1174: ,getItemClassName(approverList(i).item_class)

1170: ,approverList(i).action_type_id
1171: ,approverList(i).group_or_chain_id
1172: ,approverList(i).occurrence
1173: ,approverSource
1174: ,getItemClassName(approverList(i).item_class)
1175: ,approverList(i).item_id
1176: ,approverList(i).item_class_order_number
1177: ,approverList(i).item_order_number
1178: ,approverList(i).sub_list_order_number