DBA Data[Home] [Help]

APPS.AME_API7 dependencies on AME_APPROVER_TYPE_PKG

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

136: upper(parameter_name),
137: query_string,
138: decode(parameter_name,
139: ame_util.approverOamGroupId, null,
140: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
141: from ame_approval_group_members
142: where
143: approval_group_id = groupIdIn
144: order by order_number;

Line 257: ame_approver_type_pkg.getApproverDisplayName2(

253: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1)+1),
254: (instrb(tempGroupMembers(j), ':', 1, 2)-1));
255: end if;
256: memberDisplayNamesOut(outputIndex) :=
257: ame_approver_type_pkg.getApproverDisplayName2(
258: origSystemIn => memberOrigSystem,
259: origSystemIdIn => memberOrigSystemId);
260: end loop;
261: else /* Copy the static group into the engGroup caches. */

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

339: upper(parameter_name),
340: query_string,
341: decode(parameter_name,
342: ame_util.approverOamGroupId, null,
343: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
344: decode(parameter_name,
345: ame_util.approverOamGroupId, null,
346: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
347: from ame_approval_group_members

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

342: ame_util.approverOamGroupId, null,
343: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
344: decode(parameter_name,
345: ame_util.approverOamGroupId, null,
346: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
347: from ame_approval_group_members
348: where
349: approval_group_id = groupIdIn
350: order by order_number;

Line 466: ame_approver_type_pkg.getWfRolesNameAndDisplayName(

462: memberOrigSystemId :=
463: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1)+1),
464: (instrb(tempGroupMembers(j), ':', 1, 2)-1));
465: end if;
466: ame_approver_type_pkg.getWfRolesNameAndDisplayName(
467: origSystemIn => memberOrigSystem,
468: origSystemIdIn => memberOrigSystemId,
469: nameOut => memberNamesOut(outputIndex),
470: displayNameOut => memberDisplayNamesOut(outputIndex));

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

548: query_string,
549: order_number,
550: decode(parameter_name,
551: ame_util.approverOamGroupId, null,
552: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
553: decode(parameter_name,
554: ame_util.approverOamGroupId, null,
555: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
556: from ame_approval_group_members

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

551: ame_util.approverOamGroupId, null,
552: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
553: decode(parameter_name,
554: ame_util.approverOamGroupId, null,
555: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
556: from ame_approval_group_members
557: where
558: approval_group_id = groupIdIn
559: order by order_number;

Line 677: ame_approver_type_pkg.getWfRolesNameAndDisplayName(

673: memberOrigSystemId :=
674: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1)+1),
675: (instrb(tempGroupMembers(j), ':', 1, 2)-1));
676: end if;
677: ame_approver_type_pkg.getWfRolesNameAndDisplayName(
678: origSystemIn => memberOrigSystem,
679: origSystemIdIn => memberOrigSystemId,
680: nameOut => memberNamesOut(outputIndex),
681: displayNameOut => memberDisplayNamesOut(outputIndex));

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

764: query_string,
765: order_number,
766: decode(parameter_name,
767: ame_util.approverOamGroupId, null,
768: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
769: decode(parameter_name,
770: ame_util.approverOamGroupId, null,
771: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
772: from ame_approval_group_members

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

767: ame_util.approverOamGroupId, null,
768: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
769: decode(parameter_name,
770: ame_util.approverOamGroupId, null,
771: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
772: from ame_approval_group_members
773: where
774: approval_group_id = groupIdIn
775: order by order_number;

Line 893: ame_approver_type_pkg.getWfRolesNameAndDisplayName(

889: memberOrigSystemIdsOut(outputIndex) :=
890: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1)+1),
891: (instrb(tempGroupMembers(j), ':', 1, 2)-1));
892: end if;
893: ame_approver_type_pkg.getWfRolesNameAndDisplayName(
894: origSystemIn => memberOrigSystemsOut(outputIndex),
895: origSystemIdIn => memberOrigSystemIdsOut(outputIndex),
896: nameOut => memberNamesOut(outputIndex),
897: displayNameOut => memberDisplayNamesOut(outputIndex));