DBA Data[Home] [Help]

APPS.AME_ENGINE dependencies on AME_APPROVER_TYPE_PKG

Line 5581: tempName := ame_approver_type_pkg.getWfRolesName(ame_util.perOrigSystem,tempApproverId);

5577: tempApproverType := substrb(tempGroupMembers(j), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1));
5578: begin
5579: if tempApproverType is not null and upper(tempApproverType) = upper(ame_util.approverPersonId)
5580: and tempApproverId is not null then
5581: tempName := ame_approver_type_pkg.getWfRolesName(ame_util.perOrigSystem,tempApproverId);
5582: elsif tempApproverType is not null and upper(tempApproverType) = upper(ame_util.approverUserId)
5583: and tempApproverId is not null then
5584: tempName := ame_approver_type_pkg.getWfRolesName(ame_util.fndUserOrigSystem,tempApproverId);
5585: elsif tempApproverType is not null and tempApproverId is not null then

Line 5584: tempName := ame_approver_type_pkg.getWfRolesName(ame_util.fndUserOrigSystem,tempApproverId);

5580: and tempApproverId is not null then
5581: tempName := ame_approver_type_pkg.getWfRolesName(ame_util.perOrigSystem,tempApproverId);
5582: elsif tempApproverType is not null and upper(tempApproverType) = upper(ame_util.approverUserId)
5583: and tempApproverId is not null then
5584: tempName := ame_approver_type_pkg.getWfRolesName(ame_util.fndUserOrigSystem,tempApproverId);
5585: elsif tempApproverType is not null and tempApproverId is not null then
5586: tempName := ame_approver_type_pkg.getWfRolesName(tempApproverType,tempApproverId);
5587: end if;
5588: /*following changes added for bpo instance fnd user change*/

Line 5586: tempName := ame_approver_type_pkg.getWfRolesName(tempApproverType,tempApproverId);

5582: elsif tempApproverType is not null and upper(tempApproverType) = upper(ame_util.approverUserId)
5583: and tempApproverId is not null then
5584: tempName := ame_approver_type_pkg.getWfRolesName(ame_util.fndUserOrigSystem,tempApproverId);
5585: elsif tempApproverType is not null and tempApproverId is not null then
5586: tempName := ame_approver_type_pkg.getWfRolesName(tempApproverType,tempApproverId);
5587: end if;
5588: /*following changes added for bpo instance fnd user change*/
5589: processFndUser := true;
5590: if ame_multi_tenancy_pkg.is_multi_tenant_system = ame_util.booleanTrue then

Line 5613: ame_approver_type_pkg.getWfRolesNameAndDisplayName(

5609: engGroupMemberOrigSystems(outputIndex) := tempApproverType;
5610: engGroupMemberOrigSystemIds(outputIndex) := tempApproverId;
5611: end if;
5612: begin
5613: ame_approver_type_pkg.getWfRolesNameAndDisplayName(
5614: origSystemIn => engGroupMemberOrigSystems(outputIndex),
5615: origSystemIdIn => engGroupMemberOrigSystemIds(outputIndex),
5616: nameOut => engGroupMemberNames(outputIndex),
5617: displayNameOut => engGroupMemberDisplayNames(outputIndex));

Line 5672: ame_approver_type_pkg.getWfRolesNameAndDisplayName(

5668: end;
5669: end loop;
5670: else /* Copy the static group into the engGroup caches. */
5671: begin
5672: ame_approver_type_pkg.getWfRolesNameAndDisplayName(
5673: origSystemIn => origSystems(i),
5674: origSystemIdIn => origSystemIds(i),
5675: nameOut => l_name_out,
5676: displayNameOut => l_display_name_out);

Line 6152: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(nameIn => engInsertedApproverList(i).name,

6148: for i in 1 .. engInsertedApproverList.count loop
6149: if(engInsertionParameterList(i) = parameter) then
6150: nameOut := engInsertedApproverList(i).name;
6151: begin
6152: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(nameIn => engInsertedApproverList(i).name,
6153: origSystemOut => origSystemOut,
6154: origSystemIdOut => origSystemIdOut,
6155: displayNameOut => displayNameOut);
6156: exception

Line 6221: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(nameIn => engInsertedApproverList(i).name,

6217: engInsertionOrderTypeList(i) = ame_util.afterApprover and
6218: engInsertionParameterList(i) = parameter) then
6219: nameOut := engInsertedApproverList(i).name;
6220: begin
6221: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(nameIn => engInsertedApproverList(i).name,
6222: origSystemOut => origSystemOut,
6223: origSystemIdOut => origSystemIdOut,
6224: displayNameOut => displayNameOut);
6225: exception

Line 6920: ame_approver_type_pkg.getApproverDisplayName(nameIn => engStApprovers(positionIn - 1).name);

6916: prevApproverDescription := null;
6917: else
6918: begin
6919: prevApproverDescription :=
6920: ame_approver_type_pkg.getApproverDisplayName(nameIn => engStApprovers(positionIn - 1).name);
6921:
6922: exception
6923: when others then
6924: l_error_code := sqlcode;

Line 7015: ame_approver_type_pkg.getApproverDisplayName(nameIn => engStApprovers(positionIn).name);

7011: nextApproverDescription := null;
7012: else
7013: begin
7014: nextApproverDescription :=
7015: ame_approver_type_pkg.getApproverDisplayName(nameIn => engStApprovers(positionIn).name);
7016: exception
7017: when others then
7018: l_error_code := sqlcode;
7019: if l_error_code = -20213 then

Line 10025: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(nameIn => engInsertedApproverList(i).name,

10021: for i in 1 .. engInsertedApproverList.count loop
10022: if(engInsertedApproverList(i).authority <> ame_util.authorityApprover or
10023: engInsertedApproverList(i).api_insertion = ame_util.apiInsertion) then
10024: begin
10025: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(nameIn => engInsertedApproverList(i).name,
10026: origSystemOut => engInsertedApproverList(i).orig_system,
10027: origSystemIdOut => engInsertedApproverList(i).orig_system_id,
10028: displayNameOut => engInsertedApproverList(i).display_name);
10029: exception

Line 11506: ame_approver_type_pkg.getSurrogate(origSystemIn => engStApprovers(tempIndex).orig_system,

11502: tempIndex := 1; /* post-increment */
11503: loop
11504: if(engStApprovers(tempIndex).approval_status = ame_util.noResponseStatus) then
11505: /* Fetch surrogate's wf_roles-specific data. */
11506: ame_approver_type_pkg.getSurrogate(origSystemIn => engStApprovers(tempIndex).orig_system,
11507: origSystemIdIn => engStApprovers(tempIndex).orig_system_id,
11508: origSystemIdOut => tempSurrogateApprover.orig_system_id,
11509: wfRolesNameOut => tempSurrogateApprover.name,
11510: displayNameOut => tempSurrogateApprover.display_name);

Line 12041: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(

12037: errorMessage ame_util.longestStringType;
12038: begin
12039: /* Look up the orig_system, orig_system_id, and display_name values corresponding to nameIn. */
12040: begin
12041: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(
12042: nameIn => nameIn,
12043: origSystemOut => engStApprovers(approverIndexIn).orig_system,
12044: origSystemIdOut => engStApprovers(approverIndexIn).orig_system_id,
12045: displayNameOut => engStApprovers(approverIndexIn).display_name);

Line 12752: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(nameIn =>forwardee.name,

12748: if(forwardee.orig_system is null or
12749: forwardee.orig_system_id is null or
12750: forwardee.display_name is null) then
12751: begin
12752: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(nameIn =>forwardee.name,
12753: origSystemOut => forwardee.orig_system,
12754: origSystemIdOut => forwardee.orig_system_id,
12755: displayNameOut => forwardee.display_name);
12756: exception

Line 13264: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(nameIn =>forwardee.name,

13260: forwardee.orig_system_id is null or
13261: forwardee.display_name is null) then
13262:
13263: begin
13264: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(nameIn =>forwardee.name,
13265: origSystemOut => forwardee.orig_system,
13266: origSystemIdOut => forwardee.orig_system_id,
13267: displayNameOut => forwardee.display_name);
13268: exception

Line 13357: ame_approver_type_pkg.isASubordinate(approverIn => approver,

13353: end loop;
13354: if(forwarderType = ame_util.chainOfAuthorityForwarder and
13355: (forwardeeType is null or
13356: forwardeeType = ame_util.alreadyInListForwardee) and
13357: ame_approver_type_pkg.isASubordinate(approverIn => approver,
13358: possibleSubordApproverIn => forwardee)) then
13359: forwardeeType := ame_util.subordSameHierarchyForwardee;
13360: end if;
13361: if(forwardeeType = ame_util.previousSameChainForwardee) then

Line 13605: ame_approver_type_pkg.getSuperior(approverIn => insertedApprover,

13601: /* Iterate through the forwardee's chain of authority. */
13602: loop
13603: /* Get the next superior to insert. */
13604: tempReason := ame_approver_deviation_pkg.forwardEngInsReason;
13605: ame_approver_type_pkg.getSuperior(approverIn => insertedApprover,
13606: superiorOut => superiorApprover);
13607: if(superiorApprover.name = approver.name) then
13608: forwarderFound := true;
13609: tempReason := ame_approver_deviation_pkg.forwardForwardeeReason;

Line 13614: ame_approver_type_pkg.getSuperior(approverIn => approver,

13610: if(forwardingBehavior = ame_util.skipForwarder) then
13611: tempReason := ame_approver_deviation_pkg.forwardEngInsReason;
13612: --insertedApprover.name := approver.name;
13613: --insertedApprover.orig_system_id := approver.orig_system_id;
13614: ame_approver_type_pkg.getSuperior(approverIn => approver,
13615: superiorOut => superiorApprover);
13616: end if;
13617: end if;
13618: /* Calculate insertedApprover.occurrence. */