5: G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
6: G_MODULE CONSTANT VARCHAR2(250) := 'oks.plsql.'||g_pkg_name||'.';
7:
8: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
9: l_approver_record2 ame_util.approverRecord2;
10: l_forwardee ame_util.approverRecord2;
11: l_process_complete_yn varchar2(1);
12: l_next_approvers ame_util.approversTable2;
13: l_all_approvers ame_util.approversTable2;
6: G_MODULE CONSTANT VARCHAR2(250) := 'oks.plsql.'||g_pkg_name||'.';
7:
8: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
9: l_approver_record2 ame_util.approverRecord2;
10: l_forwardee ame_util.approverRecord2;
11: l_process_complete_yn varchar2(1);
12: l_next_approvers ame_util.approversTable2;
13: l_all_approvers ame_util.approversTable2;
14: G_APPLICATION_ID CONSTANT NUMBER := 515;
8: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
9: l_approver_record2 ame_util.approverRecord2;
10: l_forwardee ame_util.approverRecord2;
11: l_process_complete_yn varchar2(1);
12: l_next_approvers ame_util.approversTable2;
13: l_all_approvers ame_util.approversTable2;
14: G_APPLICATION_ID CONSTANT NUMBER := 515;
15: G_TRANSACTION_TYPE CONSTANT VARCHAR2(200) := 'OKS_INTERNAL_APPROVAL';
16:
9: l_approver_record2 ame_util.approverRecord2;
10: l_forwardee ame_util.approverRecord2;
11: l_process_complete_yn varchar2(1);
12: l_next_approvers ame_util.approversTable2;
13: l_all_approvers ame_util.approversTable2;
14: G_APPLICATION_ID CONSTANT NUMBER := 515;
15: G_TRANSACTION_TYPE CONSTANT VARCHAR2(200) := 'OKS_INTERNAL_APPROVAL';
16:
17: l_item_indexes ame_util.idList;
13: l_all_approvers ame_util.approversTable2;
14: G_APPLICATION_ID CONSTANT NUMBER := 515;
15: G_TRANSACTION_TYPE CONSTANT VARCHAR2(200) := 'OKS_INTERNAL_APPROVAL';
16:
17: l_item_indexes ame_util.idList;
18: l_item_classes ame_util.stringList;
19: l_item_ids ame_util.stringList;
20: l_item_sources ame_util.longStringList;
21: l_name varchar2(150);
14: G_APPLICATION_ID CONSTANT NUMBER := 515;
15: G_TRANSACTION_TYPE CONSTANT VARCHAR2(200) := 'OKS_INTERNAL_APPROVAL';
16:
17: l_item_indexes ame_util.idList;
18: l_item_classes ame_util.stringList;
19: l_item_ids ame_util.stringList;
20: l_item_sources ame_util.longStringList;
21: l_name varchar2(150);
22:
15: G_TRANSACTION_TYPE CONSTANT VARCHAR2(200) := 'OKS_INTERNAL_APPROVAL';
16:
17: l_item_indexes ame_util.idList;
18: l_item_classes ame_util.stringList;
19: l_item_ids ame_util.stringList;
20: l_item_sources ame_util.longStringList;
21: l_name varchar2(150);
22:
23: ------------------------------------------------------------------------------
16:
17: l_item_indexes ame_util.idList;
18: l_item_classes ame_util.stringList;
19: l_item_ids ame_util.stringList;
20: l_item_sources ame_util.longStringList;
21: l_name varchar2(150);
22:
23: ------------------------------------------------------------------------------
24: -- EXCEPTIONS
205: l_approver varchar2(100) :=
206: NVL(wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME'),
207: wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME'));
208: l_id number;
209: l_item_classes ame_util.stringList;
210: l_item_ids ame_util.stringList;
211: l_completed ame_util.charList;
212: l_user_names varchar2(2000);
213: l_role_name varchar2(1000);
206: NVL(wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME'),
207: wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME'));
208: l_id number;
209: l_item_classes ame_util.stringList;
210: l_item_ids ame_util.stringList;
211: l_completed ame_util.charList;
212: l_user_names varchar2(2000);
213: l_role_name varchar2(1000);
214: l_role_display_name varchar2(1000);
207: wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME'));
208: l_id number;
209: l_item_classes ame_util.stringList;
210: l_item_ids ame_util.stringList;
211: l_completed ame_util.charList;
212: l_user_names varchar2(2000);
213: l_role_name varchar2(1000);
214: l_role_display_name varchar2(1000);
215: --
301: ame_api2.getNextApprovers1( -- Get the next approver
302: applicationIdIn => G_APPLICATION_ID,
303: transactionTypeIn => G_TRANSACTION_TYPE,
304: transactionIdIn => l_id,
305: flagApproversAsNotifiedIn => ame_util.booleanTrue,
306: approvalProcessCompleteYNOut => l_process_complete_yn,
307: nextApproversOut => l_next_approvers,
308: itemIndexesOut => l_item_indexes,
309: itemClassesOut => l_item_classes,
1371: ame_api2.updateApprovalStatus2(
1372: applicationIdIn => G_APPLICATION_ID,
1373: transactionTypeIn => G_TRANSACTION_TYPE,
1374: transactionIdIn => wf_engine.GetItemAttrText(itemtype,itemkey,'CONTRACT_ID'),
1375: approvalStatusIn => ame_util.approvedStatus,
1376: approverNameIn => wf_engine.GetItemAttrText(itemtype,itemkey,'ACTUAL_PERFORMER'),
1377: forwardeeIn => ame_util.emptyApproverRecord2
1378: );
1379:
1373: transactionTypeIn => G_TRANSACTION_TYPE,
1374: transactionIdIn => wf_engine.GetItemAttrText(itemtype,itemkey,'CONTRACT_ID'),
1375: approvalStatusIn => ame_util.approvedStatus,
1376: approverNameIn => wf_engine.GetItemAttrText(itemtype,itemkey,'ACTUAL_PERFORMER'),
1377: forwardeeIn => ame_util.emptyApproverRecord2
1378: );
1379:
1380: end;
1381: