[Home] [Help]
5358: tempGroupMembers dbms_sql.Varchar2_Table;
5359: upperParameterNames ame_util.stringList;
5360: tempApproverType ame_util.stringType;
5361: tempApproverId ame_util.stringType;
5362: tempname wf_roles.name%type;
5363: begin
5364: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5365: fnd_log.string
5366: (fnd_log.level_statement
7378: engEffectiveRuleDate between
7379: ame_condition_usages.start_date and
7380: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7381: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
7382: /* Check for an invalid wf_roles.name value in parameter_two. */
7383: if(parameterTwo = ame_util.invalidApproverWfRolesName) then
7384: raise invalidNameException;
7385: end if;
7386: /* Cache the values. */
10558: begin
10559: /*
10560: This procedure does two things: (1) suppress repeated approvers, and (2) aggregate various
10561: approver-related data in appropriate engSt package variables. The aggregation has to occur
10562: for all occurrences of a wf_roles.name value in engStApprovers, at once; so this procedure's
10563: outer loop iterates through engStApprovers, doing the aggregation. The inner loop suppresses
10564: repeated approvers.
10565: */
10566: tempEngStItemIndex := 0; /* pre-increment */
10587: for i in 1 .. engStApproversCount loop
10588: /*
10589: We only want to process an approver if the approver has not been previously processed and
10590: has not been suppressed. If an approver was suppressed, they can't aggregate the approvals
10591: requirements of subsequent occurrences of the same wf_roles.name in engStApprovers. If an
10592: approver was previously processed, we don't want to duplicate their data in the engStItem
10593: variables.
10594: */
10595: tempProcessApprover := true;
11064: /* Now handle the non-empty case. */
11065: tempIndex := 1; /* post-increment */
11066: loop
11067: if(engStApprovers(tempIndex).approval_status = ame_util.noResponseStatus) then
11068: /* Fetch surrogate's wf_roles-specific data. */
11069: ame_approver_type_pkg.getSurrogate(origSystemIn => engStApprovers(tempIndex).orig_system,
11070: origSystemIdIn => engStApprovers(tempIndex).orig_system_id,
11071: origSystemIdOut => tempSurrogateApprover.orig_system_id,
11072: wfRolesNameOut => tempSurrogateApprover.name,