DBA Data[Home] [Help]

APPS.AME_API3 dependencies on AME_APPROVER_TYPE_PKG

Line 137: anchorList := anchorList || ame_approver_type_pkg.getApproverDescription(nameList(i));

133: transactionIdIn => transactionIdIn,
134: transactionTypeIdIn => transactionTypeIn);
135: anchorList := '';
136: for i in 1 .. nameList.count loop
137: anchorList := anchorList || ame_approver_type_pkg.getApproverDescription(nameList(i));
138: if i <> nameList.count then
139: anchorList := anchorList || '; ';
140: end if;
141: end loop;

Line 146: tokenValueOneIn => ame_approver_type_pkg.getApproverDescription(anchorName),

142: errorCode := -20001;
143: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
144: messageNameIn => 'AME_400651_ANCHORS_EXIST',
145: tokenNameOneIn => 'APPROVER',
146: tokenValueOneIn => ame_approver_type_pkg.getApproverDescription(anchorName),
147: tokenNameTwoIn => 'ANCHORED_APPROVERS',
148: tokenValueTwoIn => anchorList);
149: ame_util.runtimeException(packageNameIn => 'ame_api3',
150: routineNameIn => 'clearInsertion',

Line 759: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name

755: upper(parameter_name),
756: query_string,
757: decode(parameter_name,
758: ame_util.approverOamGroupId, null,
759: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
760: from ame_approval_group_members
761: where
762: approval_group_id = groupIdIn
763: order by order_number;

Line 878: ame_approver_type_pkg.getApproverDisplayName2(

874: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1)+1),
875: (instrb(tempGroupMembers(j), ':', 1, 2)-1));
876: end if;
877: memberDisplayNamesOut(outputIndex) :=
878: ame_approver_type_pkg.getApproverDisplayName2(
879: origSystemIn => memberOrigSystem,
880: origSystemIdIn => memberOrigSystemId);
881: end loop;
882: else /* Copy the static group into the engGroup caches. */

Line 964: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,

960: upper(parameter_name),
961: query_string,
962: decode(parameter_name,
963: ame_util.approverOamGroupId, null,
964: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
965: decode(parameter_name,
966: ame_util.approverOamGroupId, null,
967: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
968: from ame_approval_group_members

Line 967: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name

963: ame_util.approverOamGroupId, null,
964: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
965: decode(parameter_name,
966: ame_util.approverOamGroupId, null,
967: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
968: from ame_approval_group_members
969: where
970: approval_group_id = groupIdIn
971: order by order_number;

Line 1089: ame_approver_type_pkg.getWfRolesNameAndDisplayName(

1085: memberOrigSystemId :=
1086: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1)+1),
1087: (instrb(tempGroupMembers(j), ':', 1, 2)-1));
1088: end if;
1089: ame_approver_type_pkg.getWfRolesNameAndDisplayName(
1090: origSystemIn => memberOrigSystem,
1091: origSystemIdIn => memberOrigSystemId,
1092: nameOut => memberNamesOut(outputIndex),
1093: displayNameOut => memberDisplayNamesOut(outputIndex));

Line 1177: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,

1173: query_string,
1174: order_number,
1175: decode(parameter_name,
1176: ame_util.approverOamGroupId, null,
1177: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
1178: decode(parameter_name,
1179: ame_util.approverOamGroupId, null,
1180: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
1181: from ame_approval_group_members

Line 1180: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name

1176: ame_util.approverOamGroupId, null,
1177: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
1178: decode(parameter_name,
1179: ame_util.approverOamGroupId, null,
1180: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
1181: from ame_approval_group_members
1182: where
1183: approval_group_id = groupIdIn
1184: order by order_number;

Line 1304: ame_approver_type_pkg.getWfRolesNameAndDisplayName(

1300: memberOrigSystemId :=
1301: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1)+1),
1302: (instrb(tempGroupMembers(j), ':', 1, 2)-1));
1303: end if;
1304: ame_approver_type_pkg.getWfRolesNameAndDisplayName(
1305: origSystemIn => memberOrigSystem,
1306: origSystemIdIn => memberOrigSystemId,
1307: nameOut => memberNamesOut(outputIndex),
1308: displayNameOut => memberDisplayNamesOut(outputIndex));

Line 1397: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,

1393: query_string,
1394: order_number,
1395: decode(parameter_name,
1396: ame_util.approverOamGroupId, null,
1397: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
1398: decode(parameter_name,
1399: ame_util.approverOamGroupId, null,
1400: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
1401: from ame_approval_group_members

Line 1400: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name

1396: ame_util.approverOamGroupId, null,
1397: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
1398: decode(parameter_name,
1399: ame_util.approverOamGroupId, null,
1400: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
1401: from ame_approval_group_members
1402: where
1403: approval_group_id = groupIdIn
1404: order by order_number;

Line 1524: ame_approver_type_pkg.getWfRolesNameAndDisplayName(

1520: memberOrigSystemIdsOut(outputIndex) :=
1521: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1)+1),
1522: (instrb(tempGroupMembers(j), ':', 1, 2)-1));
1523: end if;
1524: ame_approver_type_pkg.getWfRolesNameAndDisplayName(
1525: origSystemIn => memberOrigSystemsOut(outputIndex),
1526: origSystemIdIn => memberOrigSystemIdsOut(outputIndex),
1527: nameOut => memberNamesOut(outputIndex),
1528: displayNameOut => memberDisplayNamesOut(outputIndex));

Line 1686: ame_approver_type_pkg.getApproverOrigSystemAndId

1682: oldApproversOut(tempIndex).approval_status := tempOldApprover.approval_status;
1683: oldApproversOut(tempIndex).action_type_id := tempOldApprover.action_type_id;
1684: oldApproversOut(tempIndex).group_or_chain_id := tempOldApprover.group_or_chain_id;
1685: oldApproversOut(tempIndex).occurrence := tempOldApprover.occurrence;
1686: ame_approver_type_pkg.getApproverOrigSystemAndId
1687: (nameIn => tempOldApprover.name
1688: ,origSystemOut => oldApproversOut(tempIndex).orig_system
1689: ,origSystemIdOut => oldApproversOut(tempIndex).orig_system_id);
1690: /*

Line 2385: anchorList := anchorList || ame_approver_type_pkg.getApproverDescription(nameList(i));

2381: transactionIdIn => transactionIdIn,
2382: transactionTypeIdIn => transactionTypeIn);
2383: anchorList := '';
2384: for i in 1 .. nameList.count loop
2385: anchorList := anchorList || ame_approver_type_pkg.getApproverDescription(nameList(i));
2386: if i <> nameList.count then
2387: anchorList := anchorList || '; ';
2388: end if;
2389: end loop;

Line 2394: tokenValueOneIn => ame_approver_type_pkg.getApproverDescription(anchorName),

2390: errorCode := -20001;
2391: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2392: messageNameIn => 'AME_400651_ANCHORS_EXIST',
2393: tokenNameOneIn => 'APPROVER',
2394: tokenValueOneIn => ame_approver_type_pkg.getApproverDescription(anchorName),
2395: tokenNameTwoIn => 'ANCHORED_APPROVERS',
2396: tokenValueTwoIn => anchorList);
2397: ame_util.runtimeException(packageNameIn => 'ame_api3',
2398: routineNameIn => 'suppressApprover',