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.OKC_REP_WF_PVT dependencies on AME_UTIL

Line 283: l_next_approvers ame_util.approversTable2;

279: ) IS
280: l_api_name VARCHAR2(30);
281: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
282: l_process_complete_yn varchar2(1);
283: l_next_approvers ame_util.approversTable2;
284: l_item_indexes ame_util.idList;
285: l_item_classes ame_util.stringList;
286: l_item_ids ame_util.stringList;
287: l_item_sources ame_util.longStringList;

Line 284: l_item_indexes ame_util.idList;

280: l_api_name VARCHAR2(30);
281: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
282: l_process_complete_yn varchar2(1);
283: l_next_approvers ame_util.approversTable2;
284: l_item_indexes ame_util.idList;
285: l_item_classes ame_util.stringList;
286: l_item_ids ame_util.stringList;
287: l_item_sources ame_util.longStringList;
288: l_user_names varchar2(4000);

Line 285: l_item_classes ame_util.stringList;

281: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
282: l_process_complete_yn varchar2(1);
283: l_next_approvers ame_util.approversTable2;
284: l_item_indexes ame_util.idList;
285: l_item_classes ame_util.stringList;
286: l_item_ids ame_util.stringList;
287: l_item_sources ame_util.longStringList;
288: l_user_names varchar2(4000);
289: l_role_name varchar2(4000);

Line 286: l_item_ids ame_util.stringList;

282: l_process_complete_yn varchar2(1);
283: l_next_approvers ame_util.approversTable2;
284: l_item_indexes ame_util.idList;
285: l_item_classes ame_util.stringList;
286: l_item_ids ame_util.stringList;
287: l_item_sources ame_util.longStringList;
288: l_user_names varchar2(4000);
289: l_role_name varchar2(4000);
290: l_role_display_name varchar2(4000);

Line 287: l_item_sources ame_util.longStringList;

283: l_next_approvers ame_util.approversTable2;
284: l_item_indexes ame_util.idList;
285: l_item_classes ame_util.stringList;
286: l_item_ids ame_util.stringList;
287: l_item_sources ame_util.longStringList;
288: l_user_names varchar2(4000);
289: l_role_name varchar2(4000);
290: l_role_display_name varchar2(4000);
291:

Line 330: flagApproversAsNotifiedIn => ame_util.booleanFalse,

326: ame_api2.getNextApprovers1(
327: applicationIdIn => G_APPLICATION_ID,
328: transactionTypeIn => G_TRANSACTION_TYPE,
329: transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
330: flagApproversAsNotifiedIn => ame_util.booleanFalse,
331: approvalProcessCompleteYNOut => l_process_complete_yn,
332: nextApproversOut => l_next_approvers,
333: itemIndexesOut => l_item_indexes,
334: itemClassesOut => l_item_classes,

Line 489: l_next_approvers ame_util.approversTable2;

485: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
486: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;
487: l_contract_attachments varchar2(4000);
488: l_process_complete_yn varchar2(1);
489: l_next_approvers ame_util.approversTable2;
490: l_item_indexes ame_util.idList;
491: l_item_classes ame_util.stringList;
492: l_item_ids ame_util.stringList;
493: l_item_sources ame_util.longStringList;

Line 490: l_item_indexes ame_util.idList;

486: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;
487: l_contract_attachments varchar2(4000);
488: l_process_complete_yn varchar2(1);
489: l_next_approvers ame_util.approversTable2;
490: l_item_indexes ame_util.idList;
491: l_item_classes ame_util.stringList;
492: l_item_ids ame_util.stringList;
493: l_item_sources ame_util.longStringList;
494: l_user_name varchar2(4000);

Line 491: l_item_classes ame_util.stringList;

487: l_contract_attachments varchar2(4000);
488: l_process_complete_yn varchar2(1);
489: l_next_approvers ame_util.approversTable2;
490: l_item_indexes ame_util.idList;
491: l_item_classes ame_util.stringList;
492: l_item_ids ame_util.stringList;
493: l_item_sources ame_util.longStringList;
494: l_user_name varchar2(4000);
495: l_role_name varchar2(4000);

Line 492: l_item_ids ame_util.stringList;

488: l_process_complete_yn varchar2(1);
489: l_next_approvers ame_util.approversTable2;
490: l_item_indexes ame_util.idList;
491: l_item_classes ame_util.stringList;
492: l_item_ids ame_util.stringList;
493: l_item_sources ame_util.longStringList;
494: l_user_name varchar2(4000);
495: l_role_name varchar2(4000);
496: l_role_display_name varchar2(4000);

Line 493: l_item_sources ame_util.longStringList;

489: l_next_approvers ame_util.approversTable2;
490: l_item_indexes ame_util.idList;
491: l_item_classes ame_util.stringList;
492: l_item_ids ame_util.stringList;
493: l_item_sources ame_util.longStringList;
494: l_user_name varchar2(4000);
495: l_role_name varchar2(4000);
496: l_role_display_name varchar2(4000);
497: l_item_key wf_items.item_key%TYPE;

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

534: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
535: g_module || l_api_name,
536: 'Calling ame_api2.getNextApprover1 to get the approver id');
537: END IF;
538: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;
539: ame_api2.getNextApprovers1(
540: applicationIdIn => G_APPLICATION_ID,
541: transactionTypeIn => G_TRANSACTION_TYPE,
542: transactionIdIn => fnd_number.number_to_canonical(l_contract_id),

Line 543: flagApproversAsNotifiedIn => ame_util.booleanTrue,

539: ame_api2.getNextApprovers1(
540: applicationIdIn => G_APPLICATION_ID,
541: transactionTypeIn => G_TRANSACTION_TYPE,
542: transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
543: flagApproversAsNotifiedIn => ame_util.booleanTrue,
544: approvalProcessCompleteYNOut => l_process_complete_yn,
545: nextApproversOut => l_next_approvers,
546: itemIndexesOut => l_item_indexes,
547: itemClassesOut => l_item_classes,

Line 594: IF (l_next_approvers(i).orig_system = ame_util.posOrigSystem) THEN

590: IF l_next_approvers.exists(i) THEN
591: --kkolukul : Change code to support HR positions approval hierarchy
592: l_approver_type := l_next_approvers(i).orig_system;
593:
594: IF (l_next_approvers(i).orig_system = ame_util.posOrigSystem) THEN
595:
596: BEGIN
597: -----------------------------------------------------------------------
598: -- SQL What: Get the person assigned to position returned by AME.

Line 652: END IF; --g_next_approvers(l_approver_index).orig_system = ame_util.posOrigSystem

648: l_user_name := l_next_approvers(i).name;
649: --Bug 16231003
650: l_group_id := l_next_approvers(i).group_or_chain_id;
651:
652: END IF; --g_next_approvers(l_approver_index).orig_system = ame_util.posOrigSystem
653:
654: -- l_user_name := l_next_approvers(i).name;
655: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 928: l_approver_record2 ame_util.approverRecord2;

924: ) IS
925:
926: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;
927: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;
928: l_approver_record2 ame_util.approverRecord2;
929: l_approver_id number;
930: l_approval_status VARCHAR2(30);
931: l_recipient_name FND_USER.user_name%type;
932: l_action_code OKC_REP_CON_APPROVALS.action_code%type;

Line 939: l_next_approvers ame_util.approversTable2;

935: l_return_status VARCHAR2(1);
936: l_msg_count NUMBER;
937: l_msg_data VARCHAR2(2000);
938: l_process_complete_yn varchar2(1);
939: l_next_approvers ame_util.approversTable2;
940: l_item_indexes ame_util.idList;
941: l_item_classes ame_util.stringList;
942: l_item_class_names ame_util.stringList;
943: l_item_ids ame_util.stringList;

Line 940: l_item_indexes ame_util.idList;

936: l_msg_count NUMBER;
937: l_msg_data VARCHAR2(2000);
938: l_process_complete_yn varchar2(1);
939: l_next_approvers ame_util.approversTable2;
940: l_item_indexes ame_util.idList;
941: l_item_classes ame_util.stringList;
942: l_item_class_names ame_util.stringList;
943: l_item_ids ame_util.stringList;
944: l_item_sources ame_util.longStringList;

Line 941: l_item_classes ame_util.stringList;

937: l_msg_data VARCHAR2(2000);
938: l_process_complete_yn varchar2(1);
939: l_next_approvers ame_util.approversTable2;
940: l_item_indexes ame_util.idList;
941: l_item_classes ame_util.stringList;
942: l_item_class_names ame_util.stringList;
943: l_item_ids ame_util.stringList;
944: l_item_sources ame_util.longStringList;
945:

Line 942: l_item_class_names ame_util.stringList;

938: l_process_complete_yn varchar2(1);
939: l_next_approvers ame_util.approversTable2;
940: l_item_indexes ame_util.idList;
941: l_item_classes ame_util.stringList;
942: l_item_class_names ame_util.stringList;
943: l_item_ids ame_util.stringList;
944: l_item_sources ame_util.longStringList;
945:
946: l_approver_type VARCHAR2(100);

Line 943: l_item_ids ame_util.stringList;

939: l_next_approvers ame_util.approversTable2;
940: l_item_indexes ame_util.idList;
941: l_item_classes ame_util.stringList;
942: l_item_class_names ame_util.stringList;
943: l_item_ids ame_util.stringList;
944: l_item_sources ame_util.longStringList;
945:
946: l_approver_type VARCHAR2(100);
947: l_approver_name VARCHAR2(100);

Line 944: l_item_sources ame_util.longStringList;

940: l_item_indexes ame_util.idList;
941: l_item_classes ame_util.stringList;
942: l_item_class_names ame_util.stringList;
943: l_item_ids ame_util.stringList;
944: l_item_sources ame_util.longStringList;
945:
946: l_approver_type VARCHAR2(100);
947: l_approver_name VARCHAR2(100);
948:

Line 1033: IF (l_approver_type = ame_util.posOrigSystem) THEN

1029: 'Approver Name is : ' || notif_rec.user_name);
1030: END IF;
1031: -- l_approver_record2.name := notif_rec.user_name;
1032: --14758583 : kkolukul : HR position support
1033: IF (l_approver_type = ame_util.posOrigSystem) THEN
1034: l_approver_record2.name := l_approver_name;
1035: ELSE
1036: l_approver_record2.name := notif_rec.original_user_name;
1037: END IF;

Line 1073: l_approver_record2.approval_status := ame_util.approvedStatus;

1069: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1070: RAISE OKC_API.G_EXCEPTION_ERROR;
1071: END IF;
1072: --------------------------------------------------------
1073: l_approver_record2.approval_status := ame_util.approvedStatus;
1074: ame_api2.updateApprovalStatus(
1075: applicationIdIn => G_APPLICATION_ID,
1076: transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
1077: approverIn => l_approver_record2,

Line 1116: l_approver_record2.approval_status := ame_util.rejectStatus;

1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: END IF;
1114: --------------------------------------------------------
1115:
1116: l_approver_record2.approval_status := ame_util.rejectStatus;
1117: -- Update AME approval status
1118: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1119: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1120: g_module || l_api_name,

Line 1189: l_approver_record2.approval_status := ame_util.noResponseStatus;

1185: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1186: RAISE OKC_API.G_EXCEPTION_ERROR;
1187: END IF;
1188: --------------------------------------------------------
1189: l_approver_record2.approval_status := ame_util.noResponseStatus;
1190:
1191: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1192: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1193: g_module || l_api_name,

Line 1262: l_approver_record2 ame_util.approverRecord2;

1258: ) IS
1259:
1260: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;
1261: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;
1262: l_approver_record2 ame_util.approverRecord2;
1263: l_notification_record ame_util2.notificationRecord;
1264: l_approver_id number;
1265: l_approval_status VARCHAR2(30);
1266: l_recipient_name FND_USER.user_name%type;

Line 1263: l_notification_record ame_util2.notificationRecord;

1259:
1260: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;
1261: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;
1262: l_approver_record2 ame_util.approverRecord2;
1263: l_notification_record ame_util2.notificationRecord;
1264: l_approver_id number;
1265: l_approval_status VARCHAR2(30);
1266: l_recipient_name FND_USER.user_name%type;
1267: l_action_code OKC_REP_CON_APPROVALS.action_code%type;

Line 1274: l_next_approvers ame_util.approversTable2;

1270: l_return_status VARCHAR2(1);
1271: l_msg_count NUMBER;
1272: l_msg_data VARCHAR2(2000);
1273: l_process_complete_yn varchar2(1);
1274: l_next_approvers ame_util.approversTable2;
1275: l_item_indexes ame_util.idList;
1276: l_item_classes ame_util.stringList;
1277: l_item_class_names ame_util.stringList;
1278: l_item_ids ame_util.stringList;

Line 1275: l_item_indexes ame_util.idList;

1271: l_msg_count NUMBER;
1272: l_msg_data VARCHAR2(2000);
1273: l_process_complete_yn varchar2(1);
1274: l_next_approvers ame_util.approversTable2;
1275: l_item_indexes ame_util.idList;
1276: l_item_classes ame_util.stringList;
1277: l_item_class_names ame_util.stringList;
1278: l_item_ids ame_util.stringList;
1279: l_item_sources ame_util.longStringList;

Line 1276: l_item_classes ame_util.stringList;

1272: l_msg_data VARCHAR2(2000);
1273: l_process_complete_yn varchar2(1);
1274: l_next_approvers ame_util.approversTable2;
1275: l_item_indexes ame_util.idList;
1276: l_item_classes ame_util.stringList;
1277: l_item_class_names ame_util.stringList;
1278: l_item_ids ame_util.stringList;
1279: l_item_sources ame_util.longStringList;
1280:

Line 1277: l_item_class_names ame_util.stringList;

1273: l_process_complete_yn varchar2(1);
1274: l_next_approvers ame_util.approversTable2;
1275: l_item_indexes ame_util.idList;
1276: l_item_classes ame_util.stringList;
1277: l_item_class_names ame_util.stringList;
1278: l_item_ids ame_util.stringList;
1279: l_item_sources ame_util.longStringList;
1280:
1281: l_action_code_fwd VARCHAR2(250);

Line 1278: l_item_ids ame_util.stringList;

1274: l_next_approvers ame_util.approversTable2;
1275: l_item_indexes ame_util.idList;
1276: l_item_classes ame_util.stringList;
1277: l_item_class_names ame_util.stringList;
1278: l_item_ids ame_util.stringList;
1279: l_item_sources ame_util.longStringList;
1280:
1281: l_action_code_fwd VARCHAR2(250);
1282: l_recipient_id NUMBER;

Line 1279: l_item_sources ame_util.longStringList;

1275: l_item_indexes ame_util.idList;
1276: l_item_classes ame_util.stringList;
1277: l_item_class_names ame_util.stringList;
1278: l_item_ids ame_util.stringList;
1279: l_item_sources ame_util.longStringList;
1280:
1281: l_action_code_fwd VARCHAR2(250);
1282: l_recipient_id NUMBER;
1283: l_recipient_record2 ame_util.approverRecord2;

Line 1283: l_recipient_record2 ame_util.approverRecord2;

1279: l_item_sources ame_util.longStringList;
1280:
1281: l_action_code_fwd VARCHAR2(250);
1282: l_recipient_id NUMBER;
1283: l_recipient_record2 ame_util.approverRecord2;
1284: l_approver_type VARCHAR2(100);
1285: l_approver_name VARCHAR2(100);
1286:
1287: l_forwardTo varchar2(240);

Line 1383: IF (l_approver_type = ame_util.posOrigSystem) THEN

1379: 'Approver Name is : ' || notif_rec.user_name);
1380: END IF;
1381: -- l_approver_record2.name := notif_rec.user_name;
1382: -- 14758583 : kkolukul : HR position support
1383: IF (l_approver_type = ame_util.posOrigSystem) THEN
1384: l_approver_record2.name := l_approver_name;
1385: ELSE
1386: l_approver_record2.name := notif_rec.original_user_name;
1387: END IF;

Line 1430: l_approver_record2.approval_status := ame_util.approvedStatus;

1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1427: RAISE OKC_API.G_EXCEPTION_ERROR;
1428: END IF;
1429: --------------------------------------------------------
1430: l_approver_record2.approval_status := ame_util.approvedStatus;
1431: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1432: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1433: g_module || l_api_name,
1434: 'Calling ame_api6.updateApprovalStatus');

Line 1479: l_approver_record2.approval_status := ame_util.rejectStatus;

1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: --------------------------------------------------------
1478:
1479: l_approver_record2.approval_status := ame_util.rejectStatus;
1480: -- Update AME approval status
1481: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1482: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1483: g_module || l_api_name,

Line 1546: l_approver_record2.approval_status := ame_util.approveAndForwardStatus;

1542: WHERE user_name = l_recipient_record2.name;
1543: --l_recipient_record2.name := l_recipient;
1544:
1545:
1546: l_approver_record2.approval_status := ame_util.approveAndForwardStatus;
1547:
1548:
1549: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1550: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,

Line 1581: -- l_approver_record2.approval_status := ame_util.forwardStatus;

1577: RAISE OKC_API.G_EXCEPTION_ERROR;
1578: END IF;
1579: --------------------------------------------------------
1580:
1581: -- l_approver_record2.approval_status := ame_util.forwardStatus;
1582: -- Update AME approval status
1583: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1584: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1585: g_module || l_api_name,

Line 1660: l_approver_record2.approval_status := ame_util.noResponseStatus;

1656: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1657: RAISE OKC_API.G_EXCEPTION_ERROR;
1658: END IF;
1659: --------------------------------------------------------
1660: l_approver_record2.approval_status := ame_util.noResponseStatus;
1661:
1662: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1663: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1664: g_module || l_api_name,

Line 1697: l_approver_record2.approval_status := ame_util.forwardStatus;

1693: IF funcmode = 'FORWARD' THEN
1694: l_action_code := G_WF_STATUS_DELEGATED;
1695: ELSIF funcmode = 'TRANSFER' THEN
1696: l_action_code := G_WF_STATUS_TRANSFERRED;
1697: l_approver_record2.approval_status := ame_util.forwardStatus;
1698: END IF;
1699:
1700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1701: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,

Line 1731: -- l_approver_record2.approval_status := ame_util.forwardStatus;

1727: RAISE OKC_API.G_EXCEPTION_ERROR;
1728: END IF;
1729: --------------------------------------------------------
1730:
1731: -- l_approver_record2.approval_status := ame_util.forwardStatus;
1732: -- Update AME approval status
1733: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1734: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1735: g_module || l_api_name,

Line 2277: l_next_approvers ame_util.approversTable2;

2273:
2274: l_api_name VARCHAR2(30);
2275: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2276: l_process_complete_yn varchar2(1);
2277: l_next_approvers ame_util.approversTable2;
2278: l_item_indexes ame_util.idList;
2279: l_item_classes ame_util.stringList;
2280: l_item_ids ame_util.stringList;
2281: l_item_sources ame_util.longStringList;

Line 2278: l_item_indexes ame_util.idList;

2274: l_api_name VARCHAR2(30);
2275: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2276: l_process_complete_yn varchar2(1);
2277: l_next_approvers ame_util.approversTable2;
2278: l_item_indexes ame_util.idList;
2279: l_item_classes ame_util.stringList;
2280: l_item_ids ame_util.stringList;
2281: l_item_sources ame_util.longStringList;
2282: l_user_names varchar2(4000);

Line 2279: l_item_classes ame_util.stringList;

2275: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2276: l_process_complete_yn varchar2(1);
2277: l_next_approvers ame_util.approversTable2;
2278: l_item_indexes ame_util.idList;
2279: l_item_classes ame_util.stringList;
2280: l_item_ids ame_util.stringList;
2281: l_item_sources ame_util.longStringList;
2282: l_user_names varchar2(4000);
2283:

Line 2280: l_item_ids ame_util.stringList;

2276: l_process_complete_yn varchar2(1);
2277: l_next_approvers ame_util.approversTable2;
2278: l_item_indexes ame_util.idList;
2279: l_item_classes ame_util.stringList;
2280: l_item_ids ame_util.stringList;
2281: l_item_sources ame_util.longStringList;
2282: l_user_names varchar2(4000);
2283:
2284: BEGIN

Line 2281: l_item_sources ame_util.longStringList;

2277: l_next_approvers ame_util.approversTable2;
2278: l_item_indexes ame_util.idList;
2279: l_item_classes ame_util.stringList;
2280: l_item_ids ame_util.stringList;
2281: l_item_sources ame_util.longStringList;
2282: l_user_names varchar2(4000);
2283:
2284: BEGIN
2285:

Line 2322: flagApproversAsNotifiedIn => ame_util.booleanFalse,

2318: ame_api2.getNextApprovers1(
2319: applicationIdIn => G_APPLICATION_ID,
2320: transactionTypeIn => G_TRANSACTION_TYPE,
2321: transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
2322: flagApproversAsNotifiedIn => ame_util.booleanFalse,
2323: approvalProcessCompleteYNOut => l_process_complete_yn,
2324: nextApproversOut => l_next_approvers,
2325: itemIndexesOut => l_item_indexes,
2326: itemClassesOut => l_item_classes,

Line 2338: IF (l_process_complete_yn = ame_util.booleanTrue) THEN

2334: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2335: g_module || l_api_name,
2336: 'l_process_complete_yn is is_contract_approved: ' || l_process_complete_yn);
2337: END IF;
2338: IF (l_process_complete_yn = ame_util.booleanTrue) THEN
2339: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2340: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
2341: 'The contract is approved');
2342: END IF;

Line 2427: l_next_approvers ame_util.approversTable2;

2423:
2424: l_api_name VARCHAR2(30);
2425: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2426: l_process_complete_yn varchar2(1);
2427: l_next_approvers ame_util.approversTable2;
2428: l_item_indexes ame_util.idList;
2429: l_item_classes ame_util.stringList;
2430: l_item_ids ame_util.stringList;
2431: l_item_sources ame_util.longStringList;

Line 2428: l_item_indexes ame_util.idList;

2424: l_api_name VARCHAR2(30);
2425: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2426: l_process_complete_yn varchar2(1);
2427: l_next_approvers ame_util.approversTable2;
2428: l_item_indexes ame_util.idList;
2429: l_item_classes ame_util.stringList;
2430: l_item_ids ame_util.stringList;
2431: l_item_sources ame_util.longStringList;
2432: l_user_names varchar2(4000);

Line 2429: l_item_classes ame_util.stringList;

2425: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2426: l_process_complete_yn varchar2(1);
2427: l_next_approvers ame_util.approversTable2;
2428: l_item_indexes ame_util.idList;
2429: l_item_classes ame_util.stringList;
2430: l_item_ids ame_util.stringList;
2431: l_item_sources ame_util.longStringList;
2432: l_user_names varchar2(4000);
2433:

Line 2430: l_item_ids ame_util.stringList;

2426: l_process_complete_yn varchar2(1);
2427: l_next_approvers ame_util.approversTable2;
2428: l_item_indexes ame_util.idList;
2429: l_item_classes ame_util.stringList;
2430: l_item_ids ame_util.stringList;
2431: l_item_sources ame_util.longStringList;
2432: l_user_names varchar2(4000);
2433:
2434: CURSOR wf_process_csr IS

Line 2431: l_item_sources ame_util.longStringList;

2427: l_next_approvers ame_util.approversTable2;
2428: l_item_indexes ame_util.idList;
2429: l_item_classes ame_util.stringList;
2430: l_item_ids ame_util.stringList;
2431: l_item_sources ame_util.longStringList;
2432: l_user_names varchar2(4000);
2433:
2434: CURSOR wf_process_csr IS
2435: SELECT item_key FROM wf_items

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

2474: 'Calling ame_api.getNextApprover to get the approver id');
2475: END IF;
2476: -- Using this API to determine if process is complete. Complete process from AME implies
2477: -- Contract is Approved.
2478: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;
2479: ame_api2.getNextApprovers1(
2480: applicationIdIn => G_APPLICATION_ID,
2481: transactionTypeIn => G_TRANSACTION_TYPE,
2482: transactionIdIn => fnd_number.number_to_canonical(l_contract_id),

Line 2483: flagApproversAsNotifiedIn => ame_util.booleanFalse,

2479: ame_api2.getNextApprovers1(
2480: applicationIdIn => G_APPLICATION_ID,
2481: transactionTypeIn => G_TRANSACTION_TYPE,
2482: transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
2483: flagApproversAsNotifiedIn => ame_util.booleanFalse,
2484: approvalProcessCompleteYNOut => l_process_complete_yn,
2485: nextApproversOut => l_next_approvers,
2486: itemIndexesOut => l_item_indexes,
2487: itemClassesOut => l_item_classes,

Line 2906: l_approversOut ame_util.approversTable;

2902:
2903:
2904: l_is_valid VARCHAR2(1) := 'N';
2905: l_usr_resp_pending VARCHAR2(1) := 'N';
2906: l_approversOut ame_util.approversTable;
2907:
2908: x_approvalProcessCompleteYNOut VARCHAR2(10);
2909: x_nextApproversOut ame_util.approversTable2; -- New API approverOut
2910: currApprRec ame_util.approverRecord2;

Line 2909: x_nextApproversOut ame_util.approversTable2; -- New API approverOut

2905: l_usr_resp_pending VARCHAR2(1) := 'N';
2906: l_approversOut ame_util.approversTable;
2907:
2908: x_approvalProcessCompleteYNOut VARCHAR2(10);
2909: x_nextApproversOut ame_util.approversTable2; -- New API approverOut
2910: currApprRec ame_util.approverRecord2;
2911:
2912: xitemIndexesOut ame_util.idList;
2913: xitemClassesOut ame_util.stringList;

Line 2910: currApprRec ame_util.approverRecord2;

2906: l_approversOut ame_util.approversTable;
2907:
2908: x_approvalProcessCompleteYNOut VARCHAR2(10);
2909: x_nextApproversOut ame_util.approversTable2; -- New API approverOut
2910: currApprRec ame_util.approverRecord2;
2911:
2912: xitemIndexesOut ame_util.idList;
2913: xitemClassesOut ame_util.stringList;
2914: xitemIdsOut ame_util.stringList;

Line 2912: xitemIndexesOut ame_util.idList;

2908: x_approvalProcessCompleteYNOut VARCHAR2(10);
2909: x_nextApproversOut ame_util.approversTable2; -- New API approverOut
2910: currApprRec ame_util.approverRecord2;
2911:
2912: xitemIndexesOut ame_util.idList;
2913: xitemClassesOut ame_util.stringList;
2914: xitemIdsOut ame_util.stringList;
2915: xitemSourcesOut ame_util.longStringList;
2916: l_person_id NUMBER;

Line 2913: xitemClassesOut ame_util.stringList;

2909: x_nextApproversOut ame_util.approversTable2; -- New API approverOut
2910: currApprRec ame_util.approverRecord2;
2911:
2912: xitemIndexesOut ame_util.idList;
2913: xitemClassesOut ame_util.stringList;
2914: xitemIdsOut ame_util.stringList;
2915: xitemSourcesOut ame_util.longStringList;
2916: l_person_id NUMBER;
2917: l_api_name VARCHAR2(50):='check_current_approver';

Line 2914: xitemIdsOut ame_util.stringList;

2910: currApprRec ame_util.approverRecord2;
2911:
2912: xitemIndexesOut ame_util.idList;
2913: xitemClassesOut ame_util.stringList;
2914: xitemIdsOut ame_util.stringList;
2915: xitemSourcesOut ame_util.longStringList;
2916: l_person_id NUMBER;
2917: l_api_name VARCHAR2(50):='check_current_approver';
2918: CURSOR csr_person_id is

Line 2915: xitemSourcesOut ame_util.longStringList;

2911:
2912: xitemIndexesOut ame_util.idList;
2913: xitemClassesOut ame_util.stringList;
2914: xitemIdsOut ame_util.stringList;
2915: xitemSourcesOut ame_util.longStringList;
2916: l_person_id NUMBER;
2917: l_api_name VARCHAR2(50):='check_current_approver';
2918: CURSOR csr_person_id is
2919: select decode(category, 'EMPLOYEE', source_id, null) person_id from jtf_rs_resource_extns where user_id =p_user_id ;