822: /* insert into ame_actions proper values for the approval group */
823: if(approvalGroupIdIn is null or updateActionIn) then
824: for i in 1..3 loop
825: if i = 1 then
826: actionTypeId := ame_action_pkg.getPreApprovalActionTypeId;
827: actionDescription := ame_util.getLabel(ame_util.perFndAppId,'AME_REQ_PRE_APPROVAL') || ' ' ||nameIn;
828: parentVersionStartDate :=
829: ame_util.versionStringToDate(stringDateIn => ame_action_pkg.getParentVersionStartDate(actionTypeIdIn => actionTypeId));
830: elsif i = 2 then
825: if i = 1 then
826: actionTypeId := ame_action_pkg.getPreApprovalActionTypeId;
827: actionDescription := ame_util.getLabel(ame_util.perFndAppId,'AME_REQ_PRE_APPROVAL') || ' ' ||nameIn;
828: parentVersionStartDate :=
829: ame_util.versionStringToDate(stringDateIn => ame_action_pkg.getParentVersionStartDate(actionTypeIdIn => actionTypeId));
830: elsif i = 2 then
831: actionTypeId := ame_action_pkg.getPostApprovalActionTypeId;
832: actionDescription := ame_util.getLabel(ame_util.perFndAppId,'AME_REQ_POST_APPROVAL') || ' ' ||nameIn;
833: parentVersionStartDate :=
827: actionDescription := ame_util.getLabel(ame_util.perFndAppId,'AME_REQ_PRE_APPROVAL') || ' ' ||nameIn;
828: parentVersionStartDate :=
829: ame_util.versionStringToDate(stringDateIn => ame_action_pkg.getParentVersionStartDate(actionTypeIdIn => actionTypeId));
830: elsif i = 2 then
831: actionTypeId := ame_action_pkg.getPostApprovalActionTypeId;
832: actionDescription := ame_util.getLabel(ame_util.perFndAppId,'AME_REQ_POST_APPROVAL') || ' ' ||nameIn;
833: parentVersionStartDate :=
834: ame_util.versionStringToDate(stringDateIn => ame_action_pkg.getParentVersionStartDate(actionTypeIdIn => actionTypeId));
835: else
830: elsif i = 2 then
831: actionTypeId := ame_action_pkg.getPostApprovalActionTypeId;
832: actionDescription := ame_util.getLabel(ame_util.perFndAppId,'AME_REQ_POST_APPROVAL') || ' ' ||nameIn;
833: parentVersionStartDate :=
834: ame_util.versionStringToDate(stringDateIn => ame_action_pkg.getParentVersionStartDate(actionTypeIdIn => actionTypeId));
835: else
836: actionTypeId := ame_action_pkg.getGroupChainActionTypeId;
837: actionDescription := ame_util.getLabel(ame_util.perFndAppId,'AME_REQ_APPROVAL') || ' ' ||nameIn;
838: parentVersionStartDate :=
832: actionDescription := ame_util.getLabel(ame_util.perFndAppId,'AME_REQ_POST_APPROVAL') || ' ' ||nameIn;
833: parentVersionStartDate :=
834: ame_util.versionStringToDate(stringDateIn => ame_action_pkg.getParentVersionStartDate(actionTypeIdIn => actionTypeId));
835: else
836: actionTypeId := ame_action_pkg.getGroupChainActionTypeId;
837: actionDescription := ame_util.getLabel(ame_util.perFndAppId,'AME_REQ_APPROVAL') || ' ' ||nameIn;
838: parentVersionStartDate :=
839: ame_util.versionStringToDate(stringDateIn => ame_action_pkg.getParentVersionStartDate(actionTypeIdIn => actionTypeId));
840: end if;
835: else
836: actionTypeId := ame_action_pkg.getGroupChainActionTypeId;
837: actionDescription := ame_util.getLabel(ame_util.perFndAppId,'AME_REQ_APPROVAL') || ' ' ||nameIn;
838: parentVersionStartDate :=
839: ame_util.versionStringToDate(stringDateIn => ame_action_pkg.getParentVersionStartDate(actionTypeIdIn => actionTypeId));
840: end if;
841: if(updateActionIn) then
842: select action_id into actionId
843: from ame_actions
857: parameter = to_char(approvalGroupId) and
858: action_type_id = actionTypeId and
859: processingDate between start_date and
860: nvl(end_date - ame_util.oneSecond, processingDate) ;
861: actionId := ame_action_pkg.newAction(actionTypeIdIn => actionTypeId,
862: descriptionIn => actionDescription,
863: updateParentObjectIn => true,
864: parameterIn => approvalGroupId,
865: newStartDateIn => processingDate,
866: finalizeIn => true,
867: parentVersionStartDateIn => parentVersionStartDate,
868: actionIdIn => actionId);
869: else
870: actionId := ame_action_pkg.newAction(actionTypeIdIn => actionTypeId,
871: descriptionIn => actionDescription,
872: updateParentObjectIn => true,
873: parameterIn => approvalGroupId,
874: newStartDateIn => processingDate,