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

Line 97: l_result ame_util.stringlist;

93: actid IN NUMBER,
94: funcmode IN VARCHAR2,
95: resultout OUT NOCOPY VARCHAR2) IS
96:
97: l_result ame_util.stringlist;
98: l_reason ame_util.stringlist;
99: l_invoice_id NUMBER;
100: l_h_hist ap_iaw_pkg.r_inv_aprvl_hist;
101: l_tr_reason VARCHAR2(240);

Line 98: l_reason ame_util.stringlist;

94: funcmode IN VARCHAR2,
95: resultout OUT NOCOPY VARCHAR2) IS
96:
97: l_result ame_util.stringlist;
98: l_reason ame_util.stringlist;
99: l_invoice_id NUMBER;
100: l_h_hist ap_iaw_pkg.r_inv_aprvl_hist;
101: l_tr_reason VARCHAR2(240);
102: l_api_name CONSTANT VARCHAR2(200) := 'Check_Header_Requirements';

Line 343: l_result ame_util.stringlist;

339: WHERE po_header_id is not null
340: AND invoice_id = l_invoice_id
341: AND wfapproval_status = 'INITIATED';
342:
343: l_result ame_util.stringlist;
344: l_reason ame_util.stringlist;
345: l_invoice_id NUMBER;
346: l_l_hist ap_iaw_pkg.r_line_aprvl_hist;
347: l_tr_reason VARCHAR2(240);

Line 344: l_reason ame_util.stringlist;

340: AND invoice_id = l_invoice_id
341: AND wfapproval_status = 'INITIATED';
342:
343: l_result ame_util.stringlist;
344: l_reason ame_util.stringlist;
345: l_invoice_id NUMBER;
346: l_l_hist ap_iaw_pkg.r_line_aprvl_hist;
347: l_tr_reason VARCHAR2(240);
348: l_api_name CONSTANT VARCHAR2(200) := 'Check_Line_Requirements';

Line 704: l_next_approvers ame_util.approversTable2;

700: resultout OUT NOCOPY VARCHAR2) IS
701:
702: l_invoice_id NUMBER;
703: l_complete VARCHAR2(1);
704: l_next_approvers ame_util.approversTable2;
705: l_next_approver ame_util.approverRecord2;
706: l_index ame_util.idList;
707: l_ids ame_util.stringList;
708: l_class ame_util.stringList;

Line 705: l_next_approver ame_util.approverRecord2;

701:
702: l_invoice_id NUMBER;
703: l_complete VARCHAR2(1);
704: l_next_approvers ame_util.approversTable2;
705: l_next_approver ame_util.approverRecord2;
706: l_index ame_util.idList;
707: l_ids ame_util.stringList;
708: l_class ame_util.stringList;
709: l_source ame_util.longStringList;

Line 706: l_index ame_util.idList;

702: l_invoice_id NUMBER;
703: l_complete VARCHAR2(1);
704: l_next_approvers ame_util.approversTable2;
705: l_next_approver ame_util.approverRecord2;
706: l_index ame_util.idList;
707: l_ids ame_util.stringList;
708: l_class ame_util.stringList;
709: l_source ame_util.longStringList;
710: l_line_num NUMBER;

Line 707: l_ids ame_util.stringList;

703: l_complete VARCHAR2(1);
704: l_next_approvers ame_util.approversTable2;
705: l_next_approver ame_util.approverRecord2;
706: l_index ame_util.idList;
707: l_ids ame_util.stringList;
708: l_class ame_util.stringList;
709: l_source ame_util.longStringList;
710: l_line_num NUMBER;
711: l_api_name CONSTANT VARCHAR2(200) := 'Get_Approvers';

Line 708: l_class ame_util.stringList;

704: l_next_approvers ame_util.approversTable2;
705: l_next_approver ame_util.approverRecord2;
706: l_index ame_util.idList;
707: l_ids ame_util.stringList;
708: l_class ame_util.stringList;
709: l_source ame_util.longStringList;
710: l_line_num NUMBER;
711: l_api_name CONSTANT VARCHAR2(200) := 'Get_Approvers';
712: l_iteration NUMBER;

Line 709: l_source ame_util.longStringList;

705: l_next_approver ame_util.approverRecord2;
706: l_index ame_util.idList;
707: l_ids ame_util.stringList;
708: l_class ame_util.stringList;
709: l_source ame_util.longStringList;
710: l_line_num NUMBER;
711: l_api_name CONSTANT VARCHAR2(200) := 'Get_Approvers';
712: l_iteration NUMBER;
713: l_debug_info VARCHAR2(2000);

Line 755: flagApproversAsNotifiedIn => ame_util.booleanTrue,

751: --get the next layer (stage) of approvers
752: AME_API2.getNextApprovers1(applicationIdIn => 200,
753: transactionTypeIn => 'APINV',
754: transactionIdIn => to_char(l_invoice_id),
755: flagApproversAsNotifiedIn => ame_util.booleanTrue,
756: approvalProcessCompleteYNOut => l_complete,
757: nextApproversOut => l_next_approvers,
758: itemIndexesOut => l_index,
759: itemIdsOut => l_ids,

Line 770: IF l_complete = ame_util.booleanFalse THEN

766: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
768: l_api_name,l_debug_info);
769: END IF;
770: IF l_complete = ame_util.booleanFalse THEN
771: -- Loop through approvers' table returned by AME
772: l_debug_info := l_api_name || ': more approvers';
773: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
774: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

Line 823: ame_util.lineItemItemClassName THEN

819: --Depending on the type of item class, we need to set
820: --some variables
821: --amy need correction once project/dist seeded
822: IF l_class(l_rec) =
823: ame_util.lineItemItemClassName THEN
824: l_line_num := l_ids(l_rec);
825: ELSIF l_class(l_rec) = 'project code' THEN
826:
827: SELECT Invoice_Line_Number

Line 832: ame_util.costCenterItemClassName THEN

828: INTO l_line_num
829: FROM AP_INVOICE_DISTRIBUTIONS_ALL
830: WHERE project_id =l_ids(l_rec);
831: ELSIF l_class(l_rec) =
832: ame_util.costCenterItemClassName THEN
833:
834: SELECT Invoice_Line_Number
835: INTO l_line_num
836: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 840: ame_util.lineItemItemClassName

836: FROM AP_INVOICE_DISTRIBUTIONS_ALL
837: WHERE project_id =l_ids(l_rec);
838: --distributions
839: ELSIF l_class(l_rec) <>
840: ame_util.lineItemItemClassName
841: AND l_class(l_rec) <>
842: ame_util.headerItemClassName THEN
843:
844: SELECT Invoice_Line_Number

Line 842: ame_util.headerItemClassName THEN

838: --distributions
839: ELSIF l_class(l_rec) <>
840: ame_util.lineItemItemClassName
841: AND l_class(l_rec) <>
842: ame_util.headerItemClassName THEN
843:
844: SELECT Invoice_Line_Number
845: INTO l_line_num
846: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 944: ame_util.lineItemItemClassName THEN

940: END IF;
941: --Depending on the type of item class, we need to set
942: --some variables:
943: IF l_next_approver.item_class =
944: ame_util.lineItemItemClassName THEN
945: l_line_num := l_next_approver.item_id;
946: ELSIF l_next_approver.item_class = 'project code' THEN
947:
948: SELECT Invoice_Line_Number

Line 953: ame_util.costCenterItemClassName THEN

949: INTO l_line_num
950: FROM AP_INVOICE_DISTRIBUTIONS_ALL
951: WHERE project_id = l_next_approver.item_id;
952: ELSIF l_next_approver.item_class =
953: ame_util.costCenterItemClassName THEN
954:
955: SELECT Invoice_Line_Number
956: INTO l_line_num
957: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 961: ame_util.lineItemItemClassName

957: FROM AP_INVOICE_DISTRIBUTIONS_ALL
958: WHERE project_id = l_next_approver.item_id;
959: --distributions
960: ELSIF l_next_approver.item_class <>
961: ame_util.lineItemItemClassName
962: AND l_next_approver.item_class <>
963: ame_util.headerItemClassName THEN
964:
965: SELECT Invoice_Line_Number

Line 963: ame_util.headerItemClassName THEN

959: --distributions
960: ELSIF l_next_approver.item_class <>
961: ame_util.lineItemItemClassName
962: AND l_next_approver.item_class <>
963: ame_util.headerItemClassName THEN
964:
965: SELECT Invoice_Line_Number
966: INTO l_line_num
967: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 1070: l_next_approvers ame_util.approversTable2;

1066: p_calling_sequence IN VARCHAR2) IS
1067:
1068: l_invoice_id NUMBER;
1069: l_complete VARCHAR2(1);
1070: l_next_approvers ame_util.approversTable2;
1071: l_next_approver ame_util.approverRecord2;
1072: l_index ame_util.idList;
1073: l_ids ame_util.stringList;
1074: l_class ame_util.stringList;

Line 1071: l_next_approver ame_util.approverRecord2;

1067:
1068: l_invoice_id NUMBER;
1069: l_complete VARCHAR2(1);
1070: l_next_approvers ame_util.approversTable2;
1071: l_next_approver ame_util.approverRecord2;
1072: l_index ame_util.idList;
1073: l_ids ame_util.stringList;
1074: l_class ame_util.stringList;
1075: l_source ame_util.longStringList;

Line 1072: l_index ame_util.idList;

1068: l_invoice_id NUMBER;
1069: l_complete VARCHAR2(1);
1070: l_next_approvers ame_util.approversTable2;
1071: l_next_approver ame_util.approverRecord2;
1072: l_index ame_util.idList;
1073: l_ids ame_util.stringList;
1074: l_class ame_util.stringList;
1075: l_source ame_util.longStringList;
1076: l_line_num NUMBER;

Line 1073: l_ids ame_util.stringList;

1069: l_complete VARCHAR2(1);
1070: l_next_approvers ame_util.approversTable2;
1071: l_next_approver ame_util.approverRecord2;
1072: l_index ame_util.idList;
1073: l_ids ame_util.stringList;
1074: l_class ame_util.stringList;
1075: l_source ame_util.longStringList;
1076: l_line_num NUMBER;
1077: l_api_name CONSTANT VARCHAR2(200) := 'Get_All_Approvers';

Line 1074: l_class ame_util.stringList;

1070: l_next_approvers ame_util.approversTable2;
1071: l_next_approver ame_util.approverRecord2;
1072: l_index ame_util.idList;
1073: l_ids ame_util.stringList;
1074: l_class ame_util.stringList;
1075: l_source ame_util.longStringList;
1076: l_line_num NUMBER;
1077: l_api_name CONSTANT VARCHAR2(200) := 'Get_All_Approvers';
1078: l_iteration NUMBER;

Line 1075: l_source ame_util.longStringList;

1071: l_next_approver ame_util.approverRecord2;
1072: l_index ame_util.idList;
1073: l_ids ame_util.stringList;
1074: l_class ame_util.stringList;
1075: l_source ame_util.longStringList;
1076: l_line_num NUMBER;
1077: l_api_name CONSTANT VARCHAR2(200) := 'Get_All_Approvers';
1078: l_iteration NUMBER;
1079: l_debug_info VARCHAR2(2000);

Line 1117: IF l_complete = ame_util.booleanFalse THEN

1113: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1114: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1115: l_api_name,l_debug_info);
1116: END IF;
1117: IF l_complete = ame_util.booleanFalse THEN
1118: --Loop through approvers' table returned by AME
1119: l_debug_info := 'more approvers';
1120: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1121: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

Line 1166: ame_util.lineItemItemClassName THEN

1162: --Depending on the type of item class, we need to set
1163: --some variables
1164: --amy need correction once project/dist seeded
1165: IF l_class(l_rec) =
1166: ame_util.lineItemItemClassName THEN
1167: l_line_num := l_ids(l_rec);
1168: ELSIF l_class(l_rec) = 'project code' THEN
1169:
1170: SELECT Invoice_Line_Number

Line 1175: ame_util.costCenterItemClassName THEN

1171: INTO l_line_num
1172: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1173: WHERE project_id =l_ids(l_rec);
1174: ELSIF l_class(l_rec) =
1175: ame_util.costCenterItemClassName THEN
1176:
1177: SELECT Invoice_Line_Number
1178: INTO l_line_num
1179: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 1183: ame_util.lineItemItemClassName

1179: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1180: WHERE project_id =l_ids(l_rec);
1181: --distributions
1182: ELSIF l_class(l_rec) <>
1183: ame_util.lineItemItemClassName
1184: AND l_class(l_rec) <>
1185: ame_util.headerItemClassName THEN
1186:
1187: SELECT Invoice_Line_Number

Line 1185: ame_util.headerItemClassName THEN

1181: --distributions
1182: ELSIF l_class(l_rec) <>
1183: ame_util.lineItemItemClassName
1184: AND l_class(l_rec) <>
1185: ame_util.headerItemClassName THEN
1186:
1187: SELECT Invoice_Line_Number
1188: INTO l_line_num
1189: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 1242: ame_util.lineItemItemClassName THEN

1238: END IF;
1239: --Depending on the type of item class, we need to set
1240: --some variables:
1241: IF l_next_approver.item_class =
1242: ame_util.lineItemItemClassName THEN
1243: l_line_num := l_next_approver.item_id;
1244: ELSIF l_next_approver.item_class = 'project code' THEN
1245:
1246: SELECT Invoice_Line_Number

Line 1251: ame_util.costCenterItemClassName THEN

1247: INTO l_line_num
1248: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1249: WHERE project_id = l_next_approver.item_id;
1250: ELSIF l_next_approver.item_class =
1251: ame_util.costCenterItemClassName THEN
1252:
1253: SELECT Invoice_Line_Number
1254: INTO l_line_num
1255: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 1259: ame_util.lineItemItemClassName

1255: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1256: WHERE project_id = l_next_approver.item_id;
1257: --distributions
1258: ELSIF l_next_approver.item_class <>
1259: ame_util.lineItemItemClassName
1260: AND l_next_approver.item_class <>
1261: ame_util.headerItemClassName THEN
1262:
1263: SELECT Invoice_Line_Number

Line 1261: ame_util.headerItemClassName THEN

1257: --distributions
1258: ELSIF l_next_approver.item_class <>
1259: ame_util.lineItemItemClassName
1260: AND l_next_approver.item_class <>
1261: ame_util.headerItemClassName THEN
1262:
1263: SELECT Invoice_Line_Number
1264: INTO l_line_num
1265: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 1385: l_esc_approver AME_UTIL.approverRecord2;

1381: actid IN NUMBER,
1382: funcmode IN VARCHAR2,
1383: resultout OUT NOCOPY VARCHAR2 ) IS
1384:
1385: l_esc_approver AME_UTIL.approverRecord2;
1386: l_name VARCHAR2(30);
1387: l_esc_approver_name VARCHAR2(150);
1388: l_esc_approver_id NUMBER(15);
1389: l_approver_id NUMBER(15);

Line 1450: l_esc_approver.api_insertion := ame_util.apiInsertion;

1446: l_esc_role,
1447: l_esc_role_display);
1448:
1449: l_esc_approver.name := l_esc_role;
1450: l_esc_approver.api_insertion := ame_util.apiInsertion;
1451: l_esc_approver.authority := ame_util.authorityApprover;
1452: l_esc_approver.approval_status := ame_util.forwardStatus;
1453:
1454: --update AME

Line 1451: l_esc_approver.authority := ame_util.authorityApprover;

1447: l_esc_role_display);
1448:
1449: l_esc_approver.name := l_esc_role;
1450: l_esc_approver.api_insertion := ame_util.apiInsertion;
1451: l_esc_approver.authority := ame_util.authorityApprover;
1452: l_esc_approver.approval_status := ame_util.forwardStatus;
1453:
1454: --update AME
1455: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

Line 1452: l_esc_approver.approval_status := ame_util.forwardStatus;

1448:
1449: l_esc_approver.name := l_esc_role;
1450: l_esc_approver.api_insertion := ame_util.apiInsertion;
1451: l_esc_approver.authority := ame_util.authorityApprover;
1452: l_esc_approver.approval_status := ame_util.forwardStatus;
1453:
1454: --update AME
1455: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
1456: transactionTypeIn => 'APINV',

Line 1458: approvalStatusIn => AME_UTIL.noResponseStatus,

1454: --update AME
1455: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
1456: transactionTypeIn => 'APINV',
1457: transactionIdIn => to_char(l_invoice_id),
1458: approvalStatusIn => AME_UTIL.noResponseStatus,
1459: approverNameIn => l_role,
1460: itemClassIn => ame_util.headerItemClassName,
1461: itemIdIn => to_char(l_invoice_id),
1462: forwardeeIn => l_esc_approver);

Line 1460: itemClassIn => ame_util.headerItemClassName,

1456: transactionTypeIn => 'APINV',
1457: transactionIdIn => to_char(l_invoice_id),
1458: approvalStatusIn => AME_UTIL.noResponseStatus,
1459: approverNameIn => l_role,
1460: itemClassIn => ame_util.headerItemClassName,
1461: itemIdIn => to_char(l_invoice_id),
1462: forwardeeIn => l_esc_approver);
1463:
1464: --Set WF attributes

Line 1516: l_esc_approver AME_UTIL.approverRecord2;

1512: SELECT Item_Class, Item_Id
1513: FROM AP_APINV_APPROVERS
1514: WHERE Notification_Key = itemkey;
1515:
1516: l_esc_approver AME_UTIL.approverRecord2;
1517: l_name VARCHAR2(30);
1518: l_esc_approver_name VARCHAR2(150);
1519: l_esc_approver_id NUMBER(15);
1520: l_approver_id NUMBER(15);

Line 1581: l_esc_approver.api_insertion := ame_util.apiInsertion;

1577: l_esc_role,
1578: l_esc_role_display);
1579:
1580: l_esc_approver.name := l_esc_role;
1581: l_esc_approver.api_insertion := ame_util.apiInsertion;
1582: l_esc_approver.authority := ame_util.authorityApprover;
1583: l_esc_approver.approval_status := ame_util.forwardStatus;
1584:
1585: OPEN Items_Cur(itemkey);

Line 1582: l_esc_approver.authority := ame_util.authorityApprover;

1578: l_esc_role_display);
1579:
1580: l_esc_approver.name := l_esc_role;
1581: l_esc_approver.api_insertion := ame_util.apiInsertion;
1582: l_esc_approver.authority := ame_util.authorityApprover;
1583: l_esc_approver.approval_status := ame_util.forwardStatus;
1584:
1585: OPEN Items_Cur(itemkey);
1586: LOOP

Line 1583: l_esc_approver.approval_status := ame_util.forwardStatus;

1579:
1580: l_esc_approver.name := l_esc_role;
1581: l_esc_approver.api_insertion := ame_util.apiInsertion;
1582: l_esc_approver.authority := ame_util.authorityApprover;
1583: l_esc_approver.approval_status := ame_util.forwardStatus;
1584:
1585: OPEN Items_Cur(itemkey);
1586: LOOP
1587:

Line 1595: approvalStatusIn => AME_UTIL.noResponseStatus,

1591: --update AME
1592: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
1593: transactionTypeIn => 'APINV',
1594: transactionIdIn => to_char(l_invoice_id),
1595: approvalStatusIn => AME_UTIL.noResponseStatus,
1596: approverNameIn => l_role,
1597: itemClassIn => l_item_class,
1598: itemIdIn => l_item_id,
1599: forwardeeIn => l_esc_approver);

Line 1765: approvalStatusIn => AME_UTIL.approvedStatus,

1761: --update AME with response
1762: IF l_result = 'APPROVED' THEN
1763: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
1764: transactionIdIn => to_char(l_invoice_id),
1765: approvalStatusIn => AME_UTIL.approvedStatus,
1766: approverNameIn => l_name,
1767: transactionTypeIn => 'APINV',
1768: itemClassIn => l_item_class,
1769: itemIdIn => l_item_id);

Line 1773: approvalStatusIn => AME_UTIL.rejectStatus,

1769: itemIdIn => l_item_id);
1770: ELSE
1771: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
1772: transactionIdIn => to_char(l_invoice_id),
1773: approvalStatusIn => AME_UTIL.rejectStatus,
1774: approverNameIn => l_name,
1775: transactionTypeIn => 'APINV',
1776: itemClassIn => l_item_class,
1777: itemIdIn => l_item_id);

Line 1859: approvalStatusIn => AME_UTIL.approvedStatus,

1855: --update AME with response
1856: IF l_result = 'WFAPPROVED' THEN
1857: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
1858: transactionIdIn => to_char(p_invoice_id),
1859: approvalStatusIn => AME_UTIL.approvedStatus,
1860: approverNameIn => l_name,
1861: transactionTypeIn => 'APINV',
1862: itemClassIn => l_item_class,
1863: itemIdIn => l_item_id);

Line 1867: approvalStatusIn => AME_UTIL.rejectStatus,

1863: itemIdIn => l_item_id);
1864: ELSE
1865: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
1866: transactionIdIn => to_char(p_invoice_id),
1867: approvalStatusIn => AME_UTIL.rejectStatus,
1868: approverNameIn => l_name,
1869: transactionTypeIn => 'APINV',
1870: itemClassIn => l_item_class,
1871: itemIdIn => l_item_id);

Line 3081: approvalStatusIn => AME_UTIL.nullStatus,

3077:
3078:
3079: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
3080: transactionIdIn => to_char(l_invoice_id),
3081: approvalStatusIn => AME_UTIL.nullStatus,
3082: approverNameIn => l_name,
3083: transactionTypeIn => 'APINV',
3084: itemClassIn => l_item_class,
3085: itemIdIn => l_item_id);

Line 3118: approvalStatusIn => AME_UTIL.nullStatus,

3114:
3115:
3116: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
3117: transactionIdIn => to_char(l_invoice_id),
3118: approvalStatusIn => AME_UTIL.nullStatus,
3119: approverNameIn => l_name,
3120: transactionTypeIn => 'APINV',
3121: itemClassIn => l_item_class,
3122: itemIdIn => l_item_id);