DBA Data[Home] [Help]

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: -------------------------------BEGIN-------------------------------------------
503: BEGIN

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: -------------------------------BEGIN-------------------------------------------
503: BEGIN
504: hr_utility.set_location('Entering: '|| l_proc,5);

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: -------------------------------BEGIN-------------------------------------------
503: BEGIN
504: hr_utility.set_location('Entering: '|| l_proc,5);
505: -- validate the session

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

558: -- check for the default approver flag
559: if(p_approver_flag(I)='N') then
560: -- details for the record insertion into AME
561: c_next_approver_rec.person_id:=c_additional_approver_rec(i).person_id;
562: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;
563: c_next_approver_rec.authority:=ame_util.authorityApprover;
564:
565: -- details for the insertion order for the AME record.
566: c_additional_approver_order.order_type:=ame_util.absoluteOrder;

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

559: if(p_approver_flag(I)='N') then
560: -- details for the record insertion into AME
561: c_next_approver_rec.person_id:=c_additional_approver_rec(i).person_id;
562: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;
563: c_next_approver_rec.authority:=ame_util.authorityApprover;
564:
565: -- details for the insertion order for the AME record.
566: c_additional_approver_order.order_type:=ame_util.absoluteOrder;
567: c_additional_approver_order.parameter:=I;

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

562: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;
563: c_next_approver_rec.authority:=ame_util.authorityApprover;
564:
565: -- details for the insertion order for the AME record.
566: c_additional_approver_order.order_type:=ame_util.absoluteOrder;
567: c_additional_approver_order.parameter:=I;
568: c_additional_approver_order.description:=p_approver_name(I);
569:
570: ame_api.insertApprover(applicationIdIn =>c_application_id,

Line 1573: c_next_approver_rec ame_util.approverRecord;

1569: -- Variables for AME API
1570: c_application_id integer;
1571: c_transaction_id varchar2(25);
1572: c_transaction_type varchar2(25);
1573: c_next_approver_rec ame_util.approverRecord;
1574: c_default_approvers ame_util.approversTable;
1575:
1576:
1577: BEGIN

Line 1574: c_default_approvers ame_util.approversTable;

1570: c_application_id integer;
1571: c_transaction_id varchar2(25);
1572: c_transaction_type varchar2(25);
1573: c_next_approver_rec ame_util.approverRecord;
1574: c_default_approvers ame_util.approversTable;
1575:
1576:
1577: BEGIN
1578: hr_utility.set_location('Entering: '|| l_proc,5);

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

1619: for i in 1..c_default_approvers.count LOOP
1620: lv_job_title:=NULL;
1621: -- get the next approver from the list
1622: -- Check if the AME approver is authority approver
1623: if(c_default_approvers(i).api_insertion <> ame_util.apiInsertion) then
1624: lv_forward_to_id := c_default_approvers(i).person_id;
1625: -- get assignment id for the approver
1626: lrt_assignment_details := hr_misc_web.get_assignment_id (p_person_id =>lv_forward_to_id);
1627: ln_assignment_id := lrt_assignment_details.assignment_id;

Line 1707: c_next_approver_rec ame_util.approverRecord;

1703: -- Variables for AME API
1704: c_application_id integer;
1705: c_transaction_id varchar2(25);
1706: c_transaction_type varchar2(25);
1707: c_next_approver_rec ame_util.approverRecord;
1708: c_all_approvers ame_util.approversTable;
1709:
1710:
1711:

Line 1708: c_all_approvers ame_util.approversTable;

1704: c_application_id integer;
1705: c_transaction_id varchar2(25);
1706: c_transaction_type varchar2(25);
1707: c_next_approver_rec ame_util.approverRecord;
1708: c_all_approvers ame_util.approversTable;
1709:
1710:
1711:
1712: BEGIN

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

1747: ln_approver_index := c_all_approvers.count;
1748: hr_utility.trace('Going into (FOR I IN 1..ln_approver_index ): '|| l_proc);
1749: FOR I IN 1..ln_approver_index LOOP
1750: -- 11510 specific changes, bug 3841261
1751: if(nvl(c_all_approvers(i).approval_status,'NULL') not in(ame_util.suppressedStatus,ame_util.repeatedStatus)) then
1752: ln_approver_list_index:= ln_approver_list_index + 1;
1753: lv_job_title := NULL;
1754: ln_person_id := c_all_approvers(i).person_id;
1755:

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

1767: p_assignment_id=>ln_assignment_id,
1768: p_effective_date=>p_effective_date);
1769:
1770:
1771: if(c_all_approvers(i).api_insertion <> ame_util.apiInsertion) then
1772: grt_approver_details_table(ln_approver_list_index).default_approver := 'Y';
1773: ELSE
1774: grt_approver_details_table(ln_approver_list_index).default_approver := 'N';
1775: END IF; -- for lv_default_approver

Line 2039: c_next_approver_rec ame_util.approverRecord;

2035: -- Variables for AME API
2036: c_application_id integer;
2037: c_transaction_id varchar2(25);
2038: c_transaction_type varchar2(25);
2039: c_next_approver_rec ame_util.approverRecord;
2040: c_default_approvers ame_util.approversTable;
2041:
2042:
2043: BEGIN

Line 2040: c_default_approvers ame_util.approversTable;

2036: c_application_id integer;
2037: c_transaction_id varchar2(25);
2038: c_transaction_type varchar2(25);
2039: c_next_approver_rec ame_util.approverRecord;
2040: c_default_approvers ame_util.approversTable;
2041:
2042:
2043: BEGIN
2044: hr_utility.set_location('Entering: '|| l_proc,5);

Line 3467: c_next_approver_rec ame_util.approverRecord;

3463: -- Variables for AME API
3464: c_application_id integer;
3465: c_transaction_id varchar2(25);
3466: c_transaction_type varchar2(25);
3467: c_next_approver_rec ame_util.approverRecord;
3468:
3469: --
3470:
3471: BEGIN

Line 3807: c_next_approver_rec ame_util.approverRecord;

3803: -- Variables required for AME API
3804: c_application_id integer;
3805: c_transaction_id varchar2(25);
3806: c_transaction_type varchar2(25);
3807: c_next_approver_rec ame_util.approverRecord;
3808:
3809: --
3810:
3811: BEGIN

Line 3864: approvalStatusIn =>ame_util.approvedStatus,

3860: if(l_forward_to_person_id is not null) then
3861: -- call AME update approval status as approved
3862: ame_api.updateApprovalStatus2(applicationIdIn =>c_application_id,
3863: transactionIdIn =>c_transaction_id,
3864: approvalStatusIn =>ame_util.approvedStatus,
3865: approverPersonIdIn =>l_forward_to_person_id,
3866: approverUserIdIn =>null,
3867: transactionTypeIn =>c_transaction_type,
3868: forwardeeIn =>null);

Line 5412: c_next_approver_rec ame_util.approverRecord;

5408: -- Variables required for AME API
5409: c_application_id integer;
5410: c_transaction_id varchar2(25);
5411: c_transaction_type varchar2(25);
5412: c_next_approver_rec ame_util.approverRecord;
5413: c_additional_approver_order ame_util.orderRecord;
5414: c_additional_approver_rec ame_util.approversTable;
5415:
5416:

Line 5413: c_additional_approver_order ame_util.orderRecord;

5409: c_application_id integer;
5410: c_transaction_id varchar2(25);
5411: c_transaction_type varchar2(25);
5412: c_next_approver_rec ame_util.approverRecord;
5413: c_additional_approver_order ame_util.orderRecord;
5414: c_additional_approver_rec ame_util.approversTable;
5415:
5416:
5417: BEGIN

Line 5414: c_additional_approver_rec ame_util.approversTable;

5410: c_transaction_id varchar2(25);
5411: c_transaction_type varchar2(25);
5412: c_next_approver_rec ame_util.approverRecord;
5413: c_additional_approver_order ame_util.orderRecord;
5414: c_additional_approver_rec ame_util.approversTable;
5415:
5416:
5417: BEGIN
5418: hr_utility.set_location('Entering: '|| l_proc,5);

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

5453: -- check for the default approver flag
5454: if(p_default_approvers_list(i).default_approver='N') then
5455: -- details for the record insertion into AME
5456: c_next_approver_rec.person_id:=p_default_approvers_list(i).person_id;
5457: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;
5458: c_next_approver_rec.authority:=ame_util.authorityApprover;
5459:
5460: -- details for the insertion order for the AME record.
5461: c_additional_approver_order.order_type:=ame_util.absoluteOrder;

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

5454: if(p_default_approvers_list(i).default_approver='N') then
5455: -- details for the record insertion into AME
5456: c_next_approver_rec.person_id:=p_default_approvers_list(i).person_id;
5457: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;
5458: c_next_approver_rec.authority:=ame_util.authorityApprover;
5459:
5460: -- details for the insertion order for the AME record.
5461: c_additional_approver_order.order_type:=ame_util.absoluteOrder;
5462: c_additional_approver_order.parameter:=I;

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

5457: c_next_approver_rec.api_insertion:= ame_util.apiInsertion;
5458: c_next_approver_rec.authority:=ame_util.authorityApprover;
5459:
5460: -- details for the insertion order for the AME record.
5461: c_additional_approver_order.order_type:=ame_util.absoluteOrder;
5462: c_additional_approver_order.parameter:=I;
5463: -- commented the code for UTF8 fixes
5464: --c_additional_approver_order.description:=p_default_approvers_list(i).full_name ||':'||p_default_approvers_list(i).job_title;
5465: c_additional_approver_order.description:= null;