eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on AME_UTIL

Line 499: c_next_approver_rec ame_util.approverRecord;

495: -- Variables required for AME API
496: c_application_id integer;
497: c_transaction_id varchar2(25);
498: c_transaction_type varchar2(25);
499: c_next_approver_rec ame_util.approverRecord;
500: c_additional_approver_order ame_util.orderRecord;
501: c_additional_approver_rec ame_util.approversTable;
502:
503: v_next_approver_rec ame_util.approverRecord2;

Line 500: c_additional_approver_order ame_util.orderRecord;

496: c_application_id integer;
497: c_transaction_id varchar2(25);
498: c_transaction_type varchar2(25);
499: c_next_approver_rec ame_util.approverRecord;
500: c_additional_approver_order ame_util.orderRecord;
501: c_additional_approver_rec ame_util.approversTable;
502:
503: v_next_approver_rec ame_util.approverRecord2;
504: v_additional_approver_order ame_util.insertionRecord2;

Line 501: c_additional_approver_rec ame_util.approversTable;

497: c_transaction_id varchar2(25);
498: c_transaction_type varchar2(25);
499: c_next_approver_rec ame_util.approverRecord;
500: c_additional_approver_order ame_util.orderRecord;
501: c_additional_approver_rec ame_util.approversTable;
502:
503: v_next_approver_rec ame_util.approverRecord2;
504: v_additional_approver_order ame_util.insertionRecord2;
505:

Line 503: v_next_approver_rec ame_util.approverRecord2;

499: c_next_approver_rec ame_util.approverRecord;
500: c_additional_approver_order ame_util.orderRecord;
501: c_additional_approver_rec ame_util.approversTable;
502:
503: v_next_approver_rec ame_util.approverRecord2;
504: v_additional_approver_order ame_util.insertionRecord2;
505:
506: -------------------------------BEGIN-------------------------------------------
507: BEGIN

Line 504: v_additional_approver_order ame_util.insertionRecord2;

500: c_additional_approver_order ame_util.orderRecord;
501: c_additional_approver_rec ame_util.approversTable;
502:
503: v_next_approver_rec ame_util.approverRecord2;
504: v_additional_approver_order ame_util.insertionRecord2;
505:
506: -------------------------------BEGIN-------------------------------------------
507: BEGIN
508: hr_utility.set_location('Entering: '|| l_proc,5);

Line 570: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;

566: -- check for the default approver flag
567: if(p_approver_flag(I)='N') then
568: -- details for the record insertion into AME
569: c_next_approver_rec.person_id:=c_additional_approver_rec(i).person_id;
570: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;
571: c_next_approver_rec.authority:=ame_util.authorityApprover;
572:
573:
574: ame_util.apprRecordToApprRecord2(approverRecordIn => c_next_approver_rec,

Line 571: c_next_approver_rec.authority:=ame_util.authorityApprover;

567: if(p_approver_flag(I)='N') then
568: -- details for the record insertion into AME
569: c_next_approver_rec.person_id:=c_additional_approver_rec(i).person_id;
570: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;
571: c_next_approver_rec.authority:=ame_util.authorityApprover;
572:
573:
574: ame_util.apprRecordToApprRecord2(approverRecordIn => c_next_approver_rec,
575: itemIdIn => c_transaction_id,

Line 574: ame_util.apprRecordToApprRecord2(approverRecordIn => c_next_approver_rec,

570: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;
571: c_next_approver_rec.authority:=ame_util.authorityApprover;
572:
573:
574: ame_util.apprRecordToApprRecord2(approverRecordIn => c_next_approver_rec,
575: itemIdIn => c_transaction_id,
576: approverRecord2Out =>v_next_approver_rec);
577:
578: -- details for the insertion order for the AME record.

Line 579: c_additional_approver_order.order_type:=ame_util.absoluteOrder;

575: itemIdIn => c_transaction_id,
576: approverRecord2Out =>v_next_approver_rec);
577:
578: -- details for the insertion order for the AME record.
579: c_additional_approver_order.order_type:=ame_util.absoluteOrder;
580: c_additional_approver_order.parameter:=I;
581: c_additional_approver_order.description:=p_approver_name(I);
582:
583: ame_util.ordRecordToInsRecord2(orderRecordIn =>c_additional_approver_order,

Line 583: ame_util.ordRecordToInsRecord2(orderRecordIn =>c_additional_approver_order,

579: c_additional_approver_order.order_type:=ame_util.absoluteOrder;
580: c_additional_approver_order.parameter:=I;
581: c_additional_approver_order.description:=p_approver_name(I);
582:
583: ame_util.ordRecordToInsRecord2(orderRecordIn =>c_additional_approver_order,
584: transactionIdIn => c_transaction_id,
585: approverIn => c_next_approver_rec,
586: insertionRecord2Out => v_additional_approver_order);
587:

Line 1609: c_next_approver_rec ame_util.approverRecord;

1605: -- Variables for AME API
1606: c_application_id integer;
1607: c_transaction_id varchar2(25);
1608: c_transaction_type varchar2(25);
1609: c_next_approver_rec ame_util.approverRecord;
1610: c_default_approvers ame_util.approversTable;
1611:
1612: v_approvalProcessCompleteYNOut varchar2(10);
1613: v_default_approvers ame_util.approversTable2;

Line 1610: c_default_approvers ame_util.approversTable;

1606: c_application_id integer;
1607: c_transaction_id varchar2(25);
1608: c_transaction_type varchar2(25);
1609: c_next_approver_rec ame_util.approverRecord;
1610: c_default_approvers ame_util.approversTable;
1611:
1612: v_approvalProcessCompleteYNOut varchar2(10);
1613: v_default_approvers ame_util.approversTable2;
1614:

Line 1613: v_default_approvers ame_util.approversTable2;

1609: c_next_approver_rec ame_util.approverRecord;
1610: c_default_approvers ame_util.approversTable;
1611:
1612: v_approvalProcessCompleteYNOut varchar2(10);
1613: v_default_approvers ame_util.approversTable2;
1614:
1615:
1616: BEGIN
1617: hr_utility.set_location('Entering: '|| l_proc,5);

Line 1658: ame_util.apprTable2ToApprTable(approversTable2In => v_default_approvers,

1654: transactionIdIn =>c_transaction_id,
1655: approvalProcessCompleteYNOut=>v_approvalProcessCompleteYNOut ,
1656: approversOut=>v_default_approvers );
1657:
1658: ame_util.apprTable2ToApprTable(approversTable2In => v_default_approvers,
1659: approversTableOut => c_default_approvers);
1660:
1661:
1662: end if;

Line 1672: if(c_default_approvers(i).api_insertion <> ame_util.apiInsertion) then

1668: for i in 1..c_default_approvers.count LOOP
1669: lv_job_title:=NULL;
1670: -- get the next approver from the list
1671: -- Check if the AME approver is authority approver
1672: if(c_default_approvers(i).api_insertion <> ame_util.apiInsertion) then
1673: lv_forward_to_id := c_default_approvers(i).person_id;
1674: -- get assignment id for the approver
1675: lrt_assignment_details := hr_misc_web.get_assignment_id (p_person_id =>lv_forward_to_id);
1676: ln_assignment_id := lrt_assignment_details.assignment_id;

Line 1756: c_next_approver_rec ame_util.approverRecord;

1752: -- Variables for AME API
1753: c_application_id integer;
1754: c_transaction_id varchar2(25);
1755: c_transaction_type varchar2(25);
1756: c_next_approver_rec ame_util.approverRecord;
1757: c_all_approvers ame_util.approversTable;
1758:
1759:
1760: v_approvalProcessCompleteYNOut varchar2(10);

Line 1757: c_all_approvers ame_util.approversTable;

1753: c_application_id integer;
1754: c_transaction_id varchar2(25);
1755: c_transaction_type varchar2(25);
1756: c_next_approver_rec ame_util.approverRecord;
1757: c_all_approvers ame_util.approversTable;
1758:
1759:
1760: v_approvalProcessCompleteYNOut varchar2(10);
1761: v_all_approvers ame_util.approversTable2;

Line 1761: v_all_approvers ame_util.approversTable2;

1757: c_all_approvers ame_util.approversTable;
1758:
1759:
1760: v_approvalProcessCompleteYNOut varchar2(10);
1761: v_all_approvers ame_util.approversTable2;
1762:
1763:
1764:
1765: BEGIN

Line 1804: ame_util.apprTable2ToApprTable(approversTable2In => v_all_approvers,

1800: transactionIdIn =>c_transaction_id,
1801: approvalProcessCompleteYNOut=>v_approvalProcessCompleteYNOut ,
1802: approversOut=>v_all_approvers );
1803:
1804: ame_util.apprTable2ToApprTable(approversTable2In => v_all_approvers,
1805: approversTableOut => c_all_approvers);
1806:
1807: end if;
1808:

Line 1813: if(nvl(c_all_approvers(i).approval_status,'NULL') not in(ame_util.suppressedStatus,ame_util.repeatedStatus)) then

1809: ln_approver_index := c_all_approvers.count;
1810: hr_utility.trace('Going into (FOR I IN 1..ln_approver_index ): '|| l_proc);
1811: FOR I IN 1..ln_approver_index LOOP
1812: -- 11510 specific changes, bug 3841261
1813: if(nvl(c_all_approvers(i).approval_status,'NULL') not in(ame_util.suppressedStatus,ame_util.repeatedStatus)) then
1814: ln_approver_list_index:= ln_approver_list_index + 1;
1815: lv_job_title := NULL;
1816: ln_person_id := c_all_approvers(i).person_id;
1817:

Line 1833: if(c_all_approvers(i).api_insertion <> ame_util.apiInsertion) then

1829: p_assignment_id=>ln_assignment_id,
1830: p_effective_date=>p_effective_date);
1831:
1832:
1833: if(c_all_approvers(i).api_insertion <> ame_util.apiInsertion) then
1834: grt_approver_details_table(ln_approver_list_index).default_approver := 'Y';
1835: ELSE
1836: grt_approver_details_table(ln_approver_list_index).default_approver := 'N';
1837: END IF; -- for lv_default_approver

Line 2100: c_next_approver_rec ame_util.approverRecord;

2096: -- Variables for AME API
2097: c_application_id integer;
2098: c_transaction_id varchar2(25);
2099: c_transaction_type varchar2(25);
2100: c_next_approver_rec ame_util.approverRecord;
2101: --c_default_approvers ame_util.approversTable;
2102:
2103: v_approvalProcessCompleteYNOut varchar2(10);
2104: v_default_approvers ame_util.approversTable2;

Line 2101: --c_default_approvers ame_util.approversTable;

2097: c_application_id integer;
2098: c_transaction_id varchar2(25);
2099: c_transaction_type varchar2(25);
2100: c_next_approver_rec ame_util.approverRecord;
2101: --c_default_approvers ame_util.approversTable;
2102:
2103: v_approvalProcessCompleteYNOut varchar2(10);
2104: v_default_approvers ame_util.approversTable2;
2105:

Line 2104: v_default_approvers ame_util.approversTable2;

2100: c_next_approver_rec ame_util.approverRecord;
2101: --c_default_approvers ame_util.approversTable;
2102:
2103: v_approvalProcessCompleteYNOut varchar2(10);
2104: v_default_approvers ame_util.approversTable2;
2105:
2106: BEGIN
2107: hr_utility.set_location('Entering: '|| l_proc,5);
2108: -- validate the session

Line 3537: c_next_approver_rec ame_util.approverRecord;

3533: -- Variables for AME API
3534: c_application_id integer;
3535: c_transaction_id varchar2(25);
3536: c_transaction_type varchar2(25);
3537: c_next_approver_rec ame_util.approverRecord;
3538:
3539: --
3540: v_approvalprocesscompleteynout varchar2(5);
3541: v_next_approver_rec ame_util.approverstable2;

Line 3541: v_next_approver_rec ame_util.approverstable2;

3537: c_next_approver_rec ame_util.approverRecord;
3538:
3539: --
3540: v_approvalprocesscompleteynout varchar2(5);
3541: v_next_approver_rec ame_util.approverstable2;
3542:
3543: BEGIN
3544: hr_utility.set_location('Entering: '|| l_proc,5);
3545: --

Line 3767: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

3763: ame_api2.getNextApprovers4
3764: (applicationIdIn => c_application_id
3765: ,transactionTypeIn => c_transaction_type
3766: ,transactionIdIn => c_transaction_id
3767: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse
3768: ,approvalProcessCompleteYNOut => v_approvalprocesscompleteynout
3769: ,nextApproversOut => v_next_approver_rec);
3770:
3771: --l_forward_to_person_id :=c_next_approver_rec.person_id;

Line 3891: --c_next_approver_rec ame_util.approverRecord;

3887: -- Variables required for AME API
3888: c_application_id integer;
3889: c_transaction_id varchar2(25);
3890: c_transaction_type varchar2(25);
3891: --c_next_approver_rec ame_util.approverRecord;
3892:
3893: --
3894: l_current_forward_to_username wf_users.name%type;
3895: v_approvalprocesscompleteynout varchar2(5);

Line 3896: v_next_approver_rec ame_util.approverstable2;

3892:
3893: --
3894: l_current_forward_to_username wf_users.name%type;
3895: v_approvalprocesscompleteynout varchar2(5);
3896: v_next_approver_rec ame_util.approverstable2;
3897:
3898: BEGIN
3899: hr_utility.set_location('Entering: '|| l_proc,5);
3900: --

Line 3958: approvalStatusIn =>ame_util.approvedStatus,

3954: -- call AME update approval status as approved
3955: /*
3956: ame_api.updateApprovalStatus2(applicationIdIn =>c_application_id,
3957: transactionIdIn =>c_transaction_id,
3958: approvalStatusIn =>ame_util.approvedStatus,
3959: approverPersonIdIn =>l_forward_to_person_id,
3960: approverUserIdIn =>null,
3961: transactionTypeIn =>c_transaction_type,
3962: forwardeeIn =>null); */

Line 3967: approvalStatusIn =>ame_util.approvedStatus,

3963:
3964: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
3965: transactionTypeIn =>c_transaction_type,
3966: transactionIdIn=>c_transaction_id,
3967: approvalStatusIn =>ame_util.approvedStatus,
3968: approverNameIn =>l_current_forward_to_username,
3969: itemClassIn => null,
3970: itemIdIn =>null,
3971: actionTypeIdIn=> null,

Line 3974: forwardeeIn =>ame_util.emptyApproverRecord2,

3970: itemIdIn =>null,
3971: actionTypeIdIn=> null,
3972: groupOrChainIdIn =>null,
3973: occurrenceIn =>null,
3974: forwardeeIn =>ame_util.emptyApproverRecord2,
3975: updateItemIn =>false);
3976: end if; -- call for AME update status
3977:
3978: -- call AME to get next approver

Line 3989: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

3985: ame_api2.getNextApprovers4
3986: (applicationIdIn => c_application_id
3987: ,transactionTypeIn => c_transaction_type
3988: ,transactionIdIn => c_transaction_id
3989: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse
3990: ,approvalProcessCompleteYNOut => v_approvalprocesscompleteynout
3991: ,nextApproversOut => v_next_approver_rec);
3992:
3993: -- check if the person_id of the next approver is null

Line 5528: c_next_approver_rec ame_util.approverRecord;

5524: -- Variables required for AME API
5525: c_application_id integer;
5526: c_transaction_id varchar2(25);
5527: c_transaction_type varchar2(25);
5528: c_next_approver_rec ame_util.approverRecord;
5529: c_additional_approver_order ame_util.orderRecord;
5530: c_additional_approver_rec ame_util.approversTable;
5531:
5532: v_next_approver_rec ame_util.approverRecord2;

Line 5529: c_additional_approver_order ame_util.orderRecord;

5525: c_application_id integer;
5526: c_transaction_id varchar2(25);
5527: c_transaction_type varchar2(25);
5528: c_next_approver_rec ame_util.approverRecord;
5529: c_additional_approver_order ame_util.orderRecord;
5530: c_additional_approver_rec ame_util.approversTable;
5531:
5532: v_next_approver_rec ame_util.approverRecord2;
5533: v_additional_approver_order ame_util.insertionRecord2;

Line 5530: c_additional_approver_rec ame_util.approversTable;

5526: c_transaction_id varchar2(25);
5527: c_transaction_type varchar2(25);
5528: c_next_approver_rec ame_util.approverRecord;
5529: c_additional_approver_order ame_util.orderRecord;
5530: c_additional_approver_rec ame_util.approversTable;
5531:
5532: v_next_approver_rec ame_util.approverRecord2;
5533: v_additional_approver_order ame_util.insertionRecord2;
5534:

Line 5532: v_next_approver_rec ame_util.approverRecord2;

5528: c_next_approver_rec ame_util.approverRecord;
5529: c_additional_approver_order ame_util.orderRecord;
5530: c_additional_approver_rec ame_util.approversTable;
5531:
5532: v_next_approver_rec ame_util.approverRecord2;
5533: v_additional_approver_order ame_util.insertionRecord2;
5534:
5535:
5536: BEGIN

Line 5533: v_additional_approver_order ame_util.insertionRecord2;

5529: c_additional_approver_order ame_util.orderRecord;
5530: c_additional_approver_rec ame_util.approversTable;
5531:
5532: v_next_approver_rec ame_util.approverRecord2;
5533: v_additional_approver_order ame_util.insertionRecord2;
5534:
5535:
5536: BEGIN
5537: hr_utility.set_location('Entering: '|| l_proc,5);

Line 5580: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;

5576: -- check for the default approver flag
5577: if(p_default_approvers_list(i).default_approver='N') then
5578: -- details for the record insertion into AME
5579: c_next_approver_rec.person_id:=p_default_approvers_list(i).person_id;
5580: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;
5581: c_next_approver_rec.authority:=ame_util.authorityApprover;
5582:
5583:
5584: ame_util.apprRecordToApprRecord2(approverRecordIn => c_next_approver_rec,

Line 5581: c_next_approver_rec.authority:=ame_util.authorityApprover;

5577: if(p_default_approvers_list(i).default_approver='N') then
5578: -- details for the record insertion into AME
5579: c_next_approver_rec.person_id:=p_default_approvers_list(i).person_id;
5580: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;
5581: c_next_approver_rec.authority:=ame_util.authorityApprover;
5582:
5583:
5584: ame_util.apprRecordToApprRecord2(approverRecordIn => c_next_approver_rec,
5585: itemIdIn => c_transaction_id,

Line 5584: ame_util.apprRecordToApprRecord2(approverRecordIn => c_next_approver_rec,

5580: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;
5581: c_next_approver_rec.authority:=ame_util.authorityApprover;
5582:
5583:
5584: ame_util.apprRecordToApprRecord2(approverRecordIn => c_next_approver_rec,
5585: itemIdIn => c_transaction_id,
5586: approverRecord2Out =>v_next_approver_rec);
5587:
5588: -- details for the insertion order for the AME record.

Line 5589: c_additional_approver_order.order_type:=ame_util.absoluteOrder;

5585: itemIdIn => c_transaction_id,
5586: approverRecord2Out =>v_next_approver_rec);
5587:
5588: -- details for the insertion order for the AME record.
5589: c_additional_approver_order.order_type:=ame_util.absoluteOrder;
5590: c_additional_approver_order.parameter:=I;
5591: c_additional_approver_order.description:=null;
5592: ame_util.ordRecordToInsRecord2(orderRecordIn =>c_additional_approver_order,
5593: transactionIdIn => c_transaction_id,

Line 5592: ame_util.ordRecordToInsRecord2(orderRecordIn =>c_additional_approver_order,

5588: -- details for the insertion order for the AME record.
5589: c_additional_approver_order.order_type:=ame_util.absoluteOrder;
5590: c_additional_approver_order.parameter:=I;
5591: c_additional_approver_order.description:=null;
5592: ame_util.ordRecordToInsRecord2(orderRecordIn =>c_additional_approver_order,
5593: transactionIdIn => c_transaction_id,
5594: approverIn => c_next_approver_rec,
5595: insertionRecord2Out => v_additional_approver_order);
5596: