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_WORKFLOW_PKG dependencies on AME_UTIL

Line 172: l_next_approver ame_util.approverRecord;

168: funcmode IN VARCHAR2,
169: resultout OUT NOCOPY VARCHAR2 ) IS
170: l_invoice_id NUMBER;
171: l_hold_id NUMBER;
172: l_next_approver ame_util.approverRecord;
173: l_api_name CONSTANT VARCHAR2(200) := 'Get_Approver';
174: l_debug_info VARCHAR2(2000);
175: l_org_id NUMBER;
176: l_role VARCHAR2(50);

Line 229: IF l_next_approver.approval_status = ame_util.exceptionStatus THEN

225: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
226: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
227: l_api_name,l_debug_info);
228: END IF;
229: IF l_next_approver.approval_status = ame_util.exceptionStatus THEN
230: l_debug_info := 'Error in AME_API.getNextApprover call';
231: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
233: l_api_name,l_debug_info);

Line 451: approvalStatusIn => AME_UTIL.approvedStatus,

447: l_api_name,l_debug_info);
448: END IF;
449: AME_API.updateApprovalStatus2(applicationIdIn => 200,
450: transactionIdIn => to_char(l_hold_id),
451: approvalStatusIn => AME_UTIL.approvedStatus,
452: approverPersonIdIn => l_approver_id,
453: approverUserIdIn => NULL,
454: transactionTypeIn => 'APHLD');
455:

Line 551: approvalStatusIn => AME_UTIL.approvedStatus,

547: l_api_name,l_debug_info);
548: END IF;
549: AME_API.updateApprovalStatus2(applicationIdIn => 200,
550: transactionIdIn => to_char(l_hold_id),
551: approvalStatusIn => AME_UTIL.approvedStatus,
552: approverPersonIdIn => l_approver_id,
553: approverUserIdIn => NULL,
554: transactionTypeIn => 'APHLD');
555:

Line 648: approvalStatusIn => AME_UTIL.approvedStatus,

644: l_api_name,l_debug_info);
645: END IF;
646: AME_API.updateApprovalStatus2(applicationIdIn => 200,
647: transactionIdIn => to_char(l_hold_id),
648: approvalStatusIn => AME_UTIL.approvedStatus,
649: approverPersonIdIn => l_approver_id,
650: approverUserIdIn => NULL,
651: transactionTypeIn => 'APHLD');
652:

Line 747: approvalStatusIn => AME_UTIL.approvedStatus,

743: l_api_name,l_debug_info);
744: END IF;
745: AME_API.updateApprovalStatus2(applicationIdIn => 200,
746: transactionIdIn => to_char(l_hold_id),
747: approvalStatusIn => AME_UTIL.approvedStatus,
748: approverPersonIdIn => l_approver_id,
749: approverUserIdIn => NULL,
750: transactionTypeIn => 'APHLD');
751:

Line 911: approvalStatusIn => AME_UTIL.approvedStatus,

907: l_api_name,l_debug_info);
908: END IF;
909: AME_API.updateApprovalStatus2(applicationIdIn => 200,
910: transactionIdIn => to_char(l_hold_id),
911: approvalStatusIn => AME_UTIL.approvedStatus,
912: approverPersonIdIn => l_internal_approver_id,
913: approverUserIdIn => NULL,
914: transactionTypeIn => 'APHLD');
915:

Line 1099: approvalStatusIn => AME_UTIL.rejectStatus,

1095: l_api_name,l_debug_info);
1096: END IF;
1097: AME_API.updateApprovalStatus2(applicationIdIn => 200,
1098: transactionIdIn => to_char(l_hold_id),
1099: approvalStatusIn => AME_UTIL.rejectStatus,
1100: approverPersonIdIn => l_internal_approver_id,
1101: approverUserIdIn => NULL,
1102: transactionTypeIn => 'APHLD');
1103:

Line 1226: approvalStatusIn => AME_UTIL.approvedStatus,

1222: END IF;
1223:
1224: AME_API.updateApprovalStatus2(applicationIdIn => 200,
1225: transactionIdIn => to_char(l_hold_id),
1226: approvalStatusIn => AME_UTIL.approvedStatus,
1227: approverPersonIdIn => l_approver_id,
1228: approverUserIdIn => NULL,
1229: transactionTypeIn => 'APHLD');
1230:

Line 1272: l_result ame_util.stringlist;

1268: actid IN NUMBER,
1269: funcmode IN VARCHAR2,
1270: resultout OUT NOCOPY VARCHAR2) IS
1271:
1272: l_result ame_util.stringlist;
1273: l_reason ame_util.stringlist;
1274: l_invoice_id NUMBER;
1275: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
1276: l_tr_reason VARCHAR2(240);

Line 1273: l_reason ame_util.stringlist;

1269: funcmode IN VARCHAR2,
1270: resultout OUT NOCOPY VARCHAR2) IS
1271:
1272: l_result ame_util.stringlist;
1273: l_reason ame_util.stringlist;
1274: l_invoice_id NUMBER;
1275: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
1276: l_tr_reason VARCHAR2(240);
1277: l_api_name CONSTANT VARCHAR2(200) := 'Check_Header_Requirements';

Line 1531: l_result ame_util.stringlist;

1527: WHERE po_header_id is not null
1528: AND invoice_id = l_invoice_id
1529: AND wfapproval_status = 'INITIATED';
1530:
1531: l_result ame_util.stringlist;
1532: l_reason ame_util.stringlist;
1533: l_invoice_id NUMBER;
1534: l_l_hist AP_INV_APRVL_HIST%ROWTYPE;
1535: l_tr_reason VARCHAR2(240);

Line 1532: l_reason ame_util.stringlist;

1528: AND invoice_id = l_invoice_id
1529: AND wfapproval_status = 'INITIATED';
1530:
1531: l_result ame_util.stringlist;
1532: l_reason ame_util.stringlist;
1533: l_invoice_id NUMBER;
1534: l_l_hist AP_INV_APRVL_HIST%ROWTYPE;
1535: l_tr_reason VARCHAR2(240);
1536: l_api_name CONSTANT VARCHAR2(200) := 'Check_Line_Requirements';

Line 1754: l_next_approvers ame_util.approversTable2;

1750: resultout OUT NOCOPY VARCHAR2 ) IS
1751:
1752: l_invoice_id NUMBER;
1753: l_complete VARCHAR2(1);
1754: l_next_approvers ame_util.approversTable2;
1755: l_next_approver ame_util.approverRecord2;
1756: l_index ame_util.idList;
1757: l_ids ame_util.stringList;
1758: l_class ame_util.stringList;

Line 1755: l_next_approver ame_util.approverRecord2;

1751:
1752: l_invoice_id NUMBER;
1753: l_complete VARCHAR2(1);
1754: l_next_approvers ame_util.approversTable2;
1755: l_next_approver ame_util.approverRecord2;
1756: l_index ame_util.idList;
1757: l_ids ame_util.stringList;
1758: l_class ame_util.stringList;
1759: l_source ame_util.longStringList;

Line 1756: l_index ame_util.idList;

1752: l_invoice_id NUMBER;
1753: l_complete VARCHAR2(1);
1754: l_next_approvers ame_util.approversTable2;
1755: l_next_approver ame_util.approverRecord2;
1756: l_index ame_util.idList;
1757: l_ids ame_util.stringList;
1758: l_class ame_util.stringList;
1759: l_source ame_util.longStringList;
1760: l_line_num NUMBER;

Line 1757: l_ids ame_util.stringList;

1753: l_complete VARCHAR2(1);
1754: l_next_approvers ame_util.approversTable2;
1755: l_next_approver ame_util.approverRecord2;
1756: l_index ame_util.idList;
1757: l_ids ame_util.stringList;
1758: l_class ame_util.stringList;
1759: l_source ame_util.longStringList;
1760: l_line_num NUMBER;
1761: l_api_name CONSTANT VARCHAR2(200) := 'Get_Approvers';

Line 1758: l_class ame_util.stringList;

1754: l_next_approvers ame_util.approversTable2;
1755: l_next_approver ame_util.approverRecord2;
1756: l_index ame_util.idList;
1757: l_ids ame_util.stringList;
1758: l_class ame_util.stringList;
1759: l_source ame_util.longStringList;
1760: l_line_num NUMBER;
1761: l_api_name CONSTANT VARCHAR2(200) := 'Get_Approvers';
1762: l_iteration NUMBER;

Line 1759: l_source ame_util.longStringList;

1755: l_next_approver ame_util.approverRecord2;
1756: l_index ame_util.idList;
1757: l_ids ame_util.stringList;
1758: l_class ame_util.stringList;
1759: l_source ame_util.longStringList;
1760: l_line_num NUMBER;
1761: l_api_name CONSTANT VARCHAR2(200) := 'Get_Approvers';
1762: l_iteration NUMBER;
1763: l_debug_info VARCHAR2(2000);

Line 1810: flagApproversAsNotifiedIn => ame_util.booleanFalse,

1806: AME_API2.getNextApprovers1
1807: (applicationIdIn => 200,
1808: transactionTypeIn => 'APINV',
1809: transactionIdIn => to_char(l_invoice_id),
1810: flagApproversAsNotifiedIn => ame_util.booleanFalse,
1811: approvalProcessCompleteYNOut => l_complete,
1812: nextApproversOut => l_next_approvers,
1813: itemIndexesOut => l_index,
1814: itemIdsOut => l_ids,

Line 1826: IF l_complete = ame_util.booleanFalse THEN

1822: G_MODULE_NAME||l_api_name,
1823: l_debug_info);
1824: END IF;
1825:
1826: IF l_complete = ame_util.booleanFalse THEN
1827: -- Loop through approvers' table returned by AME
1828: l_debug_info := l_api_name || ': more approvers';
1829: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1830: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 1847: ame_util.headerItemClassName

1843: --
1844: FOR l_table IN 1..l_next_approvers.count LOOP
1845: l_next_approver := l_next_approvers(l_table);
1846: IF nvl(l_next_approver.item_class,'line item') <>
1847: ame_util.headerItemClassName
1848: THEN
1849: l_debug_info := l_api_name || ': item_id = '|| l_next_approver.item_id;
1850: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1851: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 1885: IF l_class(l_rec) = ame_util.lineItemItemClassName THEN

1881: l_debug_info);
1882: END IF;
1883: --Depending on the type of item class, we need to set
1884: --some variables. Need correction once project/dist seeded
1885: IF l_class(l_rec) = ame_util.lineItemItemClassName THEN
1886: l_line_num := l_ids(l_rec);
1887: ELSIF l_class(l_rec) = 'project code' THEN
1888: -- Manoj:
1889: -- Need to have an array of lines

Line 1896: ELSIF l_class(l_rec) = ame_util.costCenterItemClassName THEN

1892: INTO l_line_num
1893: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1894: WHERE project_id =l_ids(l_rec);*/
1895: null;
1896: ELSIF l_class(l_rec) = ame_util.costCenterItemClassName THEN
1897: -- Manoj:
1898: -- Need to have an array of lines
1899: --
1900: /*SELECT Invoice_Line_Number

Line 1906: ame_util.lineItemItemClassName

1902: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1903: WHERE project_id =l_ids(l_rec);*/
1904: null;
1905: ELSIF l_class(l_rec) <>
1906: ame_util.lineItemItemClassName
1907: AND l_class(l_rec) <>
1908: ame_util.headerItemClassName THEN
1909: SELECT Invoice_Line_Number
1910: INTO l_line_num

Line 1908: ame_util.headerItemClassName THEN

1904: null;
1905: ELSIF l_class(l_rec) <>
1906: ame_util.lineItemItemClassName
1907: AND l_class(l_rec) <>
1908: ame_util.headerItemClassName THEN
1909: SELECT Invoice_Line_Number
1910: INTO l_line_num
1911: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1912: WHERE invoice_distribution_id = l_ids(l_rec);

Line 1916: -- ame_util.headerItemClassName THEN

1912: WHERE invoice_distribution_id = l_ids(l_rec);
1913: END IF; --l_class
1914: /**************/
1915: --IF l_class(l_rec) <>
1916: -- ame_util.headerItemClassName THEN
1917: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
1918: transactionIdIn => to_char(l_invoice_id),
1919: approvalStatusIn => AME_UTIL.notifiedStatus,
1920: approverNameIn => l_next_approver.NAME,

Line 1919: approvalStatusIn => AME_UTIL.notifiedStatus,

1915: --IF l_class(l_rec) <>
1916: -- ame_util.headerItemClassName THEN
1917: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
1918: transactionIdIn => to_char(l_invoice_id),
1919: approvalStatusIn => AME_UTIL.notifiedStatus,
1920: approverNameIn => l_next_approver.NAME,
1921: transactionTypeIn => 'APINV',
1922: itemClassIn => l_class(l_rec),
1923: itemIdIn => l_ids(l_rec));

Line 2054: ame_util.lineItemItemClassName THEN

2050: --Depending on the type of item class, we need to set
2051: --some variables:
2052: --
2053: IF l_next_approver.item_class =
2054: ame_util.lineItemItemClassName THEN
2055: l_line_num := l_next_approver.item_id;
2056: ELSIF l_next_approver.item_class = 'project code' THEN
2057: -- Manoj:
2058: -- Need to have an array of lines

Line 2066: ame_util.costCenterItemClassName THEN

2062: FROM AP_INVOICE_DISTRIBUTIONS_ALL
2063: WHERE project_id = l_next_approver.item_id;*/
2064: null;
2065: ELSIF l_next_approver.item_class =
2066: ame_util.costCenterItemClassName THEN
2067: -- Manoj:
2068: -- Need to have an array of lines
2069: --
2070: /*SELECT Invoice_Line_Number

Line 2076: ame_util.lineItemItemClassName

2072: FROM AP_INVOICE_DISTRIBUTIONS_ALL
2073: WHERE project_id = l_next_approver.item_id;*/
2074: null;
2075: ELSIF l_next_approver.item_class <>
2076: ame_util.lineItemItemClassName
2077: AND l_next_approver.item_class <>
2078: ame_util.headerItemClassName THEN
2079: SELECT Invoice_Line_Number
2080: INTO l_line_num

Line 2078: ame_util.headerItemClassName THEN

2074: null;
2075: ELSIF l_next_approver.item_class <>
2076: ame_util.lineItemItemClassName
2077: AND l_next_approver.item_class <>
2078: ame_util.headerItemClassName THEN
2079: SELECT Invoice_Line_Number
2080: INTO l_line_num
2081: FROM AP_INVOICE_DISTRIBUTIONS_ALL
2082: WHERE invoice_distribution_id = l_next_approver.item_id;

Line 2087: --ame_util.headerItemClassName THEN

2083: END IF; --l_class
2084:
2085: /********/
2086: --IF l_next_approver.item_class <>
2087: --ame_util.headerItemClassName THEN
2088: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
2089: transactionIdIn => to_char(l_invoice_id),
2090: approvalStatusIn => AME_UTIL.notifiedStatus,
2091: approverNameIn => l_next_approver.NAME,

Line 2090: approvalStatusIn => AME_UTIL.notifiedStatus,

2086: --IF l_next_approver.item_class <>
2087: --ame_util.headerItemClassName THEN
2088: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
2089: transactionIdIn => to_char(l_invoice_id),
2090: approvalStatusIn => AME_UTIL.notifiedStatus,
2091: approverNameIn => l_next_approver.NAME,
2092: transactionTypeIn => 'APINV',
2093: itemClassIn => l_next_approver.item_class,
2094: itemIdIn => l_next_approver.item_id);

Line 2206: -- 'line item') <> ame_util.headerItemClassName

2202: l_debug_info);
2203: END IF;
2204: END IF; --more than one item_id per approver
2205: END IF; -- end if for IF nvl(l_next_approver.item_class,
2206: -- 'line item') <> ame_util.headerItemClassName
2207: END LOOP; --nextApprovers table
2208: END IF; --complete
2209: resultout := wf_engine.eng_completed;
2210: EXCEPTION

Line 2943: approvalStatusIn => AME_UTIL.rejectStatus,

2939: l_api_name,l_debug_info);
2940: END IF;
2941: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
2942: transactionIdIn => to_char(l_invoice_id),
2943: approvalStatusIn => AME_UTIL.rejectStatus,
2944: approverNameIn => l_role,
2945: transactionTypeIn => 'APINV',
2946: itemClassIn => ame_util.headerItemClassName,
2947: itemIdIn => to_char(l_invoice_id));

Line 2946: itemClassIn => ame_util.headerItemClassName,

2942: transactionIdIn => to_char(l_invoice_id),
2943: approvalStatusIn => AME_UTIL.rejectStatus,
2944: approverNameIn => l_role,
2945: transactionTypeIn => 'APINV',
2946: itemClassIn => ame_util.headerItemClassName,
2947: itemIdIn => to_char(l_invoice_id));
2948:
2949: fnd_client_info.set_org_context(l_org_id);
2950:

Line 3117: approvalStatusIn => AME_UTIL.approvedStatus,

3113: l_api_name,l_debug_info);
3114: END IF;
3115: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
3116: transactionIdIn => to_char(l_invoice_id),
3117: approvalStatusIn => AME_UTIL.approvedStatus,
3118: approverNameIn => l_role,
3119: transactionTypeIn => 'APINV',
3120: itemClassIn => ame_util.headerItemClassName,
3121: itemIdIn => to_char(l_invoice_id));

Line 3120: itemClassIn => ame_util.headerItemClassName,

3116: transactionIdIn => to_char(l_invoice_id),
3117: approvalStatusIn => AME_UTIL.approvedStatus,
3118: approverNameIn => l_role,
3119: transactionTypeIn => 'APINV',
3120: itemClassIn => ame_util.headerItemClassName,
3121: itemIdIn => to_char(l_invoice_id));
3122:
3123: fnd_client_info.set_org_context(l_org_id);
3124:

Line 3341: approvalStatusIn => AME_UTIL.rejectStatus,

3337:
3338: --update AME with response
3339: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
3340: transactionIdIn => to_char(l_invoice_id),
3341: approvalStatusIn => AME_UTIL.rejectStatus,
3342: approverNameIn => l_name,
3343: transactionTypeIn => 'APINV',
3344: itemClassIn => l_item_class,
3345: itemIdIn => l_item_id);

Line 3586: approvalStatusIn => AME_UTIL.approvedStatus,

3582:
3583: --update AME with response
3584: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
3585: transactionIdIn => to_char(l_invoice_id),
3586: approvalStatusIn => AME_UTIL.approvedStatus,
3587: approverNameIn => l_name,
3588: transactionTypeIn => 'APINV',
3589: itemClassIn => l_item_class,
3590: itemIdIn => l_item_id);

Line 3848: approvalStatusIn => AME_UTIL.approvedStatus,

3844: --update AME with response
3845: /*
3846: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
3847: transactionIdIn => to_char(l_invoice_id),
3848: approvalStatusIn => AME_UTIL.approvedStatus,
3849: approverNameIn => l_role_name,
3850: transactionTypeIn => 'APINV',
3851: itemClassIn => ame_util.headerItemClassName,
3852: itemIdIn => to_char(l_invoice_id));

Line 3851: itemClassIn => ame_util.headerItemClassName,

3847: transactionIdIn => to_char(l_invoice_id),
3848: approvalStatusIn => AME_UTIL.approvedStatus,
3849: approverNameIn => l_role_name,
3850: transactionTypeIn => 'APINV',
3851: itemClassIn => ame_util.headerItemClassName,
3852: itemIdIn => to_char(l_invoice_id));
3853: */
3854: l_hist_rec.AMOUNT_APPROVED := null;
3855:

Line 4217: approvalStatusIn => AME_UTIL.rejectStatus,

4213: /* Not needed since we are completing the parent activity
4214: --update AME with response
4215: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
4216: transactionIdIn => to_char(l_invoice_id),
4217: approvalStatusIn => AME_UTIL.rejectStatus,
4218: approverNameIn => l_role_name,
4219: transactionTypeIn => 'APINV',
4220: itemClassIn => ame_util.headerItemClassName,
4221: itemIdIn => to_char(l_invoice_id));

Line 4220: itemClassIn => ame_util.headerItemClassName,

4216: transactionIdIn => to_char(l_invoice_id),
4217: approvalStatusIn => AME_UTIL.rejectStatus,
4218: approverNameIn => l_role_name,
4219: transactionTypeIn => 'APINV',
4220: itemClassIn => ame_util.headerItemClassName,
4221: itemIdIn => to_char(l_invoice_id));
4222: */
4223: l_debug_info := 'Before calling insert_history_table for Line'
4224: || l_line_number;

Line 4669: l_admin_approver AME_UTIL.approverRecord;

4665: itemkey IN VARCHAR2,
4666: actid IN NUMBER,
4667: funcmode IN VARCHAR2,
4668: resultout OUT NOCOPY VARCHAR2 ) IS
4669: l_admin_approver AME_UTIL.approverRecord;
4670: l_ret_approver VARCHAR2(50);
4671: l_name VARCHAR2(30);
4672: l_display_name VARCHAR2(150);
4673: l_debug_info VARCHAR2(50);

Line 4684: l_next_approvers ame_util.approversTable2;

4680: l_count NUMBER(9);
4681: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
4682: l_notf_iteration NUMBER;
4683: l_complete VARCHAR2(1);
4684: l_next_approvers ame_util.approversTable2;
4685: l_next_approver ame_util.approverRecord2;
4686: l_index ame_util.idList;
4687: l_ids ame_util.stringList;
4688: l_class ame_util.stringList;

Line 4685: l_next_approver ame_util.approverRecord2;

4681: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
4682: l_notf_iteration NUMBER;
4683: l_complete VARCHAR2(1);
4684: l_next_approvers ame_util.approversTable2;
4685: l_next_approver ame_util.approverRecord2;
4686: l_index ame_util.idList;
4687: l_ids ame_util.stringList;
4688: l_class ame_util.stringList;
4689: l_source ame_util.longStringList;

Line 4686: l_index ame_util.idList;

4682: l_notf_iteration NUMBER;
4683: l_complete VARCHAR2(1);
4684: l_next_approvers ame_util.approversTable2;
4685: l_next_approver ame_util.approverRecord2;
4686: l_index ame_util.idList;
4687: l_ids ame_util.stringList;
4688: l_class ame_util.stringList;
4689: l_source ame_util.longStringList;
4690: l_ampersand varchar2(1);

Line 4687: l_ids ame_util.stringList;

4683: l_complete VARCHAR2(1);
4684: l_next_approvers ame_util.approversTable2;
4685: l_next_approver ame_util.approverRecord2;
4686: l_index ame_util.idList;
4687: l_ids ame_util.stringList;
4688: l_class ame_util.stringList;
4689: l_source ame_util.longStringList;
4690: l_ampersand varchar2(1);
4691: Cursor C_invoice (p_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS

Line 4688: l_class ame_util.stringList;

4684: l_next_approvers ame_util.approversTable2;
4685: l_next_approver ame_util.approverRecord2;
4686: l_index ame_util.idList;
4687: l_ids ame_util.stringList;
4688: l_class ame_util.stringList;
4689: l_source ame_util.longStringList;
4690: l_ampersand varchar2(1);
4691: Cursor C_invoice (p_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS
4692: SELECT invoice_type_lookup_code

Line 4689: l_source ame_util.longStringList;

4685: l_next_approver ame_util.approverRecord2;
4686: l_index ame_util.idList;
4687: l_ids ame_util.stringList;
4688: l_class ame_util.stringList;
4689: l_source ame_util.longStringList;
4690: l_ampersand varchar2(1);
4691: Cursor C_invoice (p_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS
4692: SELECT invoice_type_lookup_code
4693: ,gl_date

Line 4745: flagApproversAsNotifiedIn => ame_util.booleanFalse,

4741: */
4742: AME_API2.getNextApprovers1(applicationIdIn => 200,
4743: transactionTypeIn => 'APINV',
4744: transactionIdIn => substr(itemkey, 1, instr(itemkey,'_')-1),
4745: flagApproversAsNotifiedIn => ame_util.booleanFalse,
4746: approvalProcessCompleteYNOut => l_complete,
4747: nextApproversOut => l_next_approvers,
4748: itemIndexesOut => l_index,
4749: itemIdsOut => l_ids,

Line 4767: --IF l_complete = ame_util.booleanTrue THEN /no approver on the list/

4763: --Now set the environment
4764: MO_GLOBAL.INIT ('SQLAP');
4765: MO_GLOBAL.set_policy_context('S',l_org_id);
4766:
4767: --IF l_complete = ame_util.booleanTrue THEN /*no approver on the list*/
4768: IF l_next_approvers.count < 1 THEN
4769: resultout := wf_engine.eng_completed||':'||'FINISH';
4770:
4771: --check for prior approvers

Line 4951: l_esc_approver AME_UTIL.approverRecord2;

4947: itemkey IN VARCHAR2,
4948: actid IN NUMBER,
4949: funcmode IN VARCHAR2,
4950: resultout OUT NOCOPY VARCHAR2 ) IS
4951: l_esc_approver AME_UTIL.approverRecord2;
4952: l_name VARCHAR2(30);
4953: l_esc_approver_name VARCHAR2(150);
4954: l_esc_approver_id NUMBER(15);
4955: l_approver_id NUMBER(15);

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

5048: l_esc_role,
5049: l_esc_role_display);
5050: -- bug#6837841 Changes End
5051: l_esc_approver.name := l_esc_role;
5052: l_esc_approver.api_insertion := ame_util.apiInsertion;
5053: l_esc_approver.authority := ame_util.authorityApprover;
5054: l_esc_approver.approval_status := ame_util.forwardStatus;
5055:
5056: --update AME

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

5049: l_esc_role_display);
5050: -- bug#6837841 Changes End
5051: l_esc_approver.name := l_esc_role;
5052: l_esc_approver.api_insertion := ame_util.apiInsertion;
5053: l_esc_approver.authority := ame_util.authorityApprover;
5054: l_esc_approver.approval_status := ame_util.forwardStatus;
5055:
5056: --update AME
5057: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

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

5050: -- bug#6837841 Changes End
5051: l_esc_approver.name := l_esc_role;
5052: l_esc_approver.api_insertion := ame_util.apiInsertion;
5053: l_esc_approver.authority := ame_util.authorityApprover;
5054: l_esc_approver.approval_status := ame_util.forwardStatus;
5055:
5056: --update AME
5057: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
5058: transactionTypeIn => 'APINV',

Line 5060: approvalStatusIn => AME_UTIL.noResponseStatus,

5056: --update AME
5057: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
5058: transactionTypeIn => 'APINV',
5059: transactionIdIn => to_char(l_invoice_id),
5060: approvalStatusIn => AME_UTIL.noResponseStatus,
5061: approverNameIn => l_role,
5062: itemClassIn => ame_util.headerItemClassName,
5063: itemIdIn => to_char(l_invoice_id),
5064: forwardeeIn => l_esc_approver);

Line 5062: itemClassIn => ame_util.headerItemClassName,

5058: transactionTypeIn => 'APINV',
5059: transactionIdIn => to_char(l_invoice_id),
5060: approvalStatusIn => AME_UTIL.noResponseStatus,
5061: approverNameIn => l_role,
5062: itemClassIn => ame_util.headerItemClassName,
5063: itemIdIn => to_char(l_invoice_id),
5064: forwardeeIn => l_esc_approver);
5065: --Set WF attributes
5066: WF_ENGINE.SetItemAttrText(itemtype,

Line 5129: l_esc_approver AME_UTIL.approverRecord2;

5125: WHERE invap.Notification_Key = itemkey
5126: AND al.line_number = invap.line_number
5127: AND al.invoice_id = invap.invoice_id;
5128:
5129: l_esc_approver AME_UTIL.approverRecord2;
5130: l_name VARCHAR2(30);
5131: l_esc_approver_name VARCHAR2(150);
5132: l_esc_approver_id NUMBER(15);
5133: l_approver_id NUMBER(15);

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

5216: l_esc_role,
5217: l_esc_role_display);
5218:
5219: l_esc_approver.name := l_esc_role;
5220: l_esc_approver.api_insertion := ame_util.apiInsertion;
5221: l_esc_approver.authority := ame_util.authorityApprover;
5222: l_esc_approver.approval_status := ame_util.forwardStatus;
5223:
5224: l_hist_rec.HISTORY_TYPE := 'LINESAPPROVAL';

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

5217: l_esc_role_display);
5218:
5219: l_esc_approver.name := l_esc_role;
5220: l_esc_approver.api_insertion := ame_util.apiInsertion;
5221: l_esc_approver.authority := ame_util.authorityApprover;
5222: l_esc_approver.approval_status := ame_util.forwardStatus;
5223:
5224: l_hist_rec.HISTORY_TYPE := 'LINESAPPROVAL';
5225: l_hist_rec.INVOICE_ID := l_invoice_id;

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

5218:
5219: l_esc_approver.name := l_esc_role;
5220: l_esc_approver.api_insertion := ame_util.apiInsertion;
5221: l_esc_approver.authority := ame_util.authorityApprover;
5222: l_esc_approver.approval_status := ame_util.forwardStatus;
5223:
5224: l_hist_rec.HISTORY_TYPE := 'LINESAPPROVAL';
5225: l_hist_rec.INVOICE_ID := l_invoice_id;
5226: l_hist_rec.ITERATION := l_iteration;

Line 5252: approvalStatusIn => AME_UTIL.noResponseStatus,

5248: --update AME
5249: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
5250: transactionTypeIn => 'APINV',
5251: transactionIdIn => to_char(l_invoice_id),
5252: approvalStatusIn => AME_UTIL.noResponseStatus,
5253: approverNameIn => l_role,
5254: itemClassIn => l_item_class,
5255: itemIdIn => l_item_id,
5256: forwardeeIn => l_esc_approver);

Line 5922: approvalStatusIn => AME_UTIL.nullStatus,

5918:
5919:
5920: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
5921: transactionIdIn => to_char(l_invoice_id),
5922: approvalStatusIn => AME_UTIL.nullStatus,
5923: approverNameIn => l_name,
5924: transactionTypeIn => 'APINV',
5925: itemClassIn => l_item_class,
5926: itemIdIn => l_item_id);

Line 5959: approvalStatusIn => AME_UTIL.nullStatus,

5955:
5956:
5957: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
5958: transactionIdIn => to_char(l_invoice_id),
5959: approvalStatusIn => AME_UTIL.nullStatus,
5960: approverNameIn => l_name,
5961: transactionTypeIn => 'APINV',
5962: itemClassIn => l_item_class,
5963: itemIdIn => l_item_id);

Line 6158: approvalStatusIn => AME_UTIL.approvedStatus,

6154: --update AME with response
6155: IF l_response IN ('APPROVED','ACCEPT') THEN
6156: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
6157: transactionIdIn => to_char(l_invoice_id),
6158: approvalStatusIn => AME_UTIL.approvedStatus,
6159: approverNameIn => l_name,
6160: transactionTypeIn => 'APINV',
6161: itemClassIn => l_item_class,
6162: itemIdIn => l_item_id);

Line 6166: approvalStatusIn => AME_UTIL.rejectStatus,

6162: itemIdIn => l_item_id);
6163: ELSIF l_response = 'REJECTED' THEN
6164: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
6165: transactionIdIn => to_char(l_invoice_id),
6166: approvalStatusIn => AME_UTIL.rejectStatus,
6167: approverNameIn => l_name,
6168: transactionTypeIn => 'APINV',
6169: itemClassIn => l_item_class,
6170: itemIdIn => l_item_id);

Line 6751: l_next_approvers ame_util.approversTable2;

6747: p_calling_sequence IN VARCHAR2) IS
6748:
6749: l_invoice_id NUMBER;
6750: l_complete VARCHAR2(1);
6751: l_next_approvers ame_util.approversTable2;
6752: l_next_approver ame_util.approverRecord2;
6753: l_index ame_util.idList;
6754: l_ids ame_util.stringList;
6755: l_class ame_util.stringList;

Line 6752: l_next_approver ame_util.approverRecord2;

6748:
6749: l_invoice_id NUMBER;
6750: l_complete VARCHAR2(1);
6751: l_next_approvers ame_util.approversTable2;
6752: l_next_approver ame_util.approverRecord2;
6753: l_index ame_util.idList;
6754: l_ids ame_util.stringList;
6755: l_class ame_util.stringList;
6756: l_source ame_util.longStringList;

Line 6753: l_index ame_util.idList;

6749: l_invoice_id NUMBER;
6750: l_complete VARCHAR2(1);
6751: l_next_approvers ame_util.approversTable2;
6752: l_next_approver ame_util.approverRecord2;
6753: l_index ame_util.idList;
6754: l_ids ame_util.stringList;
6755: l_class ame_util.stringList;
6756: l_source ame_util.longStringList;
6757: l_line_num NUMBER;

Line 6754: l_ids ame_util.stringList;

6750: l_complete VARCHAR2(1);
6751: l_next_approvers ame_util.approversTable2;
6752: l_next_approver ame_util.approverRecord2;
6753: l_index ame_util.idList;
6754: l_ids ame_util.stringList;
6755: l_class ame_util.stringList;
6756: l_source ame_util.longStringList;
6757: l_line_num NUMBER;
6758: l_api_name CONSTANT VARCHAR2(200) := 'Get_All_Approvers';

Line 6755: l_class ame_util.stringList;

6751: l_next_approvers ame_util.approversTable2;
6752: l_next_approver ame_util.approverRecord2;
6753: l_index ame_util.idList;
6754: l_ids ame_util.stringList;
6755: l_class ame_util.stringList;
6756: l_source ame_util.longStringList;
6757: l_line_num NUMBER;
6758: l_api_name CONSTANT VARCHAR2(200) := 'Get_All_Approvers';
6759: l_iteration NUMBER;

Line 6756: l_source ame_util.longStringList;

6752: l_next_approver ame_util.approverRecord2;
6753: l_index ame_util.idList;
6754: l_ids ame_util.stringList;
6755: l_class ame_util.stringList;
6756: l_source ame_util.longStringList;
6757: l_line_num NUMBER;
6758: l_api_name CONSTANT VARCHAR2(200) := 'Get_All_Approvers';
6759: l_iteration NUMBER;
6760: l_debug_info VARCHAR2(2000);

Line 6824: IF l_complete = ame_util.booleanFalse THEN

6820: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6821: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6822: l_api_name,l_debug_info);
6823: END IF;
6824: IF l_complete = ame_util.booleanFalse THEN
6825: --Loop through approvers' table returned by AME
6826: l_debug_info := 'more approvers';
6827: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6828: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

Line 6873: ame_util.lineItemItemClassName THEN

6869: --Depending on the type of item class, we need to set
6870: --some variables
6871: --amy need correction once project/dist seeded
6872: IF l_class(l_rec) =
6873: ame_util.lineItemItemClassName THEN
6874: l_line_num := l_ids(l_rec);
6875: ELSIF l_class(l_rec) = 'project code' THEN
6876:
6877: SELECT Invoice_Line_Number

Line 6882: ame_util.costCenterItemClassName THEN

6878: INTO l_line_num
6879: FROM AP_INVOICE_DISTRIBUTIONS_ALL
6880: WHERE project_id =l_ids(l_rec);
6881: ELSIF l_class(l_rec) =
6882: ame_util.costCenterItemClassName THEN
6883:
6884: SELECT Invoice_Line_Number
6885: INTO l_line_num
6886: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 6890: ame_util.lineItemItemClassName

6886: FROM AP_INVOICE_DISTRIBUTIONS_ALL
6887: WHERE project_id =l_ids(l_rec);
6888: --distributions
6889: ELSIF l_class(l_rec) <>
6890: ame_util.lineItemItemClassName
6891: AND l_class(l_rec) <>
6892: ame_util.headerItemClassName THEN
6893:
6894: SELECT Invoice_Line_Number

Line 6892: ame_util.headerItemClassName THEN

6888: --distributions
6889: ELSIF l_class(l_rec) <>
6890: ame_util.lineItemItemClassName
6891: AND l_class(l_rec) <>
6892: ame_util.headerItemClassName THEN
6893:
6894: SELECT Invoice_Line_Number
6895: INTO l_line_num
6896: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 6953: ame_util.lineItemItemClassName THEN

6949: END IF;
6950: --Depending on the type of item class, we need to set
6951: --some variables:
6952: IF l_next_approver.item_class =
6953: ame_util.lineItemItemClassName THEN
6954: l_line_num := l_next_approver.item_id;
6955: ELSIF l_next_approver.item_class = 'project code' THEN
6956:
6957: SELECT Invoice_Line_Number

Line 6962: ame_util.costCenterItemClassName THEN

6958: INTO l_line_num
6959: FROM AP_INVOICE_DISTRIBUTIONS_ALL
6960: WHERE project_id = l_next_approver.item_id;
6961: ELSIF l_next_approver.item_class =
6962: ame_util.costCenterItemClassName THEN
6963:
6964: SELECT Invoice_Line_Number
6965: INTO l_line_num
6966: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 6970: ame_util.lineItemItemClassName

6966: FROM AP_INVOICE_DISTRIBUTIONS_ALL
6967: WHERE project_id = l_next_approver.item_id;
6968: --distributions
6969: ELSIF l_next_approver.item_class <>
6970: ame_util.lineItemItemClassName
6971: AND l_next_approver.item_class <>
6972: ame_util.headerItemClassName THEN
6973:
6974: SELECT Invoice_Line_Number

Line 6972: ame_util.headerItemClassName THEN

6968: --distributions
6969: ELSIF l_next_approver.item_class <>
6970: ame_util.lineItemItemClassName
6971: AND l_next_approver.item_class <>
6972: ame_util.headerItemClassName THEN
6973:
6974: SELECT Invoice_Line_Number
6975: INTO l_line_num
6976: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 7534: l_esc_approver AME_UTIL.approverRecord;

7530: l_org_id NUMBER(15);
7531: l_name VARCHAR2(30);
7532: l_display_name VARCHAR2(150);
7533: l_forward_to_user_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
7534: l_esc_approver AME_UTIL.approverRecord;
7535: l_rec_role VARCHAR2(50);
7536: l_comments VARCHAR2(240);
7537: l_hist_id NUMBER(15);
7538: l_amount ap_invoices_all.invoice_amount%TYPE;

Line 7897: l_esc_approver AME_UTIL.approverRecord;

7893: l_org_id NUMBER(15);
7894: l_name VARCHAR2(30);
7895: l_display_name VARCHAR2(150);
7896: l_forward_to_user_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
7897: l_esc_approver AME_UTIL.approverRecord;
7898: l_rec_role VARCHAR2(50);
7899: l_comments VARCHAR2(240);
7900: l_hist_id NUMBER(15);
7901: l_amount ap_invoices_all.invoice_amount%TYPE;