DBA Data[Home] [Help]

APPS.AME_APPROVAL_GROUP_PKG dependencies on AME_ACTION_PKG

Line 826: actionTypeId := ame_action_pkg.getPreApprovalActionTypeId;

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

Line 829: ame_util.versionStringToDate(stringDateIn => ame_action_pkg.getParentVersionStartDate(actionTypeIdIn => actionTypeId));

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 :=

Line 831: actionTypeId := ame_action_pkg.getPostApprovalActionTypeId;

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

Line 834: 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
836: actionTypeId := ame_action_pkg.getGroupChainActionTypeId;
837: actionDescription := ame_util.getLabel(ame_util.perFndAppId,'AME_REQ_APPROVAL') || ' ' ||nameIn;
838: parentVersionStartDate :=

Line 836: actionTypeId := ame_action_pkg.getGroupChainActionTypeId;

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;

Line 839: 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;
841: if(updateActionIn) then
842: select action_id into actionId
843: from ame_actions

Line 861: actionId := ame_action_pkg.newAction(actionTypeIdIn => actionTypeId,

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,

Line 870: actionId := ame_action_pkg.newAction(actionTypeIdIn => actionTypeId,

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,