DBA Data[Home] [Help]

APPS.PV_PRGM_APPROVAL_PVT dependencies on AME_UTIL2

Line 596: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;

592: -- and set the flag to true if you find any.
593: ----DBMS_OUTPUT.PUT_LINE('before get all approvers');
594:
595: /** Following is required as we expect AME to return their new statuses. Bug # 4879218 **/
596: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;
597:
598: ame_api2.getAllApprovers1
599: ( applicationIdIn =>691,
600: transactionTypeIn => 'ENRQ',

Line 3341: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;

3337: CLOSE c_enrl_cur;
3338:
3339:
3340: /** Following is required as we expect AME to return their new statuses. Bug # 4879218 **/
3341: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;
3342:
3343: AME_API2.getNextApprovers3
3344: ( applicationIdIn => 691
3345: , transactionTypeIn => 'ENRQ'

Line 3362: If x_approvalProcessCompleteYNOut=ame_util2.completeFullyApproved THEN

3358: , transVariableValuesOut => xtransVariableValuesOut
3359: );
3360:
3361:
3362: If x_approvalProcessCompleteYNOut=ame_util2.completeFullyApproved THEN
3363: -- This means there are no more approvers to approve and approval is complete
3364: l_check_row_pa:=check_pending_approval(enrl_request_id);--this should be queried with status 'pending approval'
3365: IF l_check_row_pa =true AND g_isApproverInList=true THEN
3366:

Line 3460: ELSIF x_approvalProcessCompleteYNOut=ame_util2.completeNoApprovers THEN

3456:
3457: END IF;
3458:
3459:
3460: ELSIF x_approvalProcessCompleteYNOut=ame_util2.completeNoApprovers THEN
3461: -- This means no appprovers are returned by OAM which means route the request to default approver
3462:
3463: /**this means that there is no rule satisfying the criteria. so find OUT the
3464: the default approver from the profile value and send the FYI

Line 3745: ELSIF x_approvalProcessCompleteYNOut = ame_util2.notCompleted THEN

3741: ) ;
3742: END IF;
3743: ----DBMS_OUTPUT.PUT_LINE('after finishing workflow process');
3744:
3745: ELSIF x_approvalProcessCompleteYNOut = ame_util2.notCompleted THEN
3746: /* We need to update temp approvers table record with approved status
3747: for the logged in user for this enrollment request. The approval status
3748: for the logged in user can be only approved in this scenario.
3749: */

Line 3870: IF x_nextApproversOut.COUNT>0 and x_approvalProcessCompleteYNOut=ame_util2.notCompleted THEN

3866: approvers has any record with 'PENDING_APPROVAL' status, then it needs to be updated
3867: with status 'PEER_RESPONDED'
3868: */
3869:
3870: IF x_nextApproversOut.COUNT>0 and x_approvalProcessCompleteYNOut=ame_util2.notCompleted THEN
3871: l_approver_rec:=NULL;
3872: FOR x in pending_appovers_csr(enrl_request_id) LOOP
3873: l_approver_rec.entity_approver_id :=x.entity_approver_id;
3874: l_approver_rec.object_version_number:=x.object_version_number;

Line 4282: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;

4278:
4279: IF g_isApproverInList=true THEN
4280:
4281: /** Following is required as we expect AME to return their new statuses. Bug # 4879218 **/
4282: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;
4283:
4284: ame_api2.updateApprovalStatus2
4285: ( applicationIdIn => 691
4286: , transactionTypeIn => 'ENRQ'