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.POR_AMENDMENT_PKG dependencies on WF_ENGINE

Line 5048: if (funcmode <> wf_engine.eng_run) then

5044:
5045:
5046: -- Do nothing in cancel or timeout mode
5047: --
5048: if (funcmode <> wf_engine.eng_run) then
5049:
5050: resultout := wf_engine.eng_null;
5051: return;
5052:

Line 5050: resultout := wf_engine.eng_null;

5046: -- Do nothing in cancel or timeout mode
5047: --
5048: if (funcmode <> wf_engine.eng_run) then
5049:
5050: resultout := wf_engine.eng_null;
5051: return;
5052:
5053: end if;
5054:

Line 5055: l_from_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

5051: return;
5052:
5053: end if;
5054:
5055: l_from_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5056: itemkey => itemkey,
5057: aname => 'DOCUMENT_ID');
5058:
5059: x_progress := 'POR_AMENDMENT_PKG.CREATE_BASE_VERSION: 02 - l_from_req_header_id= ' || l_from_req_header_id;

Line 5101: if (funcmode <> wf_engine.eng_run) then

5097:
5098:
5099: -- Do nothing in cancel or timeout mode
5100: --
5101: if (funcmode <> wf_engine.eng_run) then
5102:
5103: resultout := wf_engine.eng_null;
5104: return;
5105:

Line 5103: resultout := wf_engine.eng_null;

5099: -- Do nothing in cancel or timeout mode
5100: --
5101: if (funcmode <> wf_engine.eng_run) then
5102:
5103: resultout := wf_engine.eng_null;
5104: return;
5105:
5106: end if;
5107:

Line 5108: l_conformed_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

5104: return;
5105:
5106: end if;
5107:
5108: l_conformed_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5109: itemkey => itemkey,
5110: aname => 'CONFORMED_HEADER_ID');
5111:
5112: l_revision_num := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 5112: l_revision_num := wf_engine.GetItemAttrNumber (itemtype => itemtype,

5108: l_conformed_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5109: itemkey => itemkey,
5110: aname => 'CONFORMED_HEADER_ID');
5111:
5112: l_revision_num := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5113: itemkey => itemkey,
5114: aname => 'REVISION_NUM');
5115:
5116:

Line 5147: if (funcmode <> wf_engine.eng_run) then

5143: END IF;
5144:
5145: -- Do nothing in cancel or timeout mode
5146: --
5147: if (funcmode <> wf_engine.eng_run) then
5148:
5149: resultout := wf_engine.eng_null;
5150: return;
5151:

Line 5149: resultout := wf_engine.eng_null;

5145: -- Do nothing in cancel or timeout mode
5146: --
5147: if (funcmode <> wf_engine.eng_run) then
5148:
5149: resultout := wf_engine.eng_null;
5150: return;
5151:
5152: end if;
5153:

Line 5154: l_requisition_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

5150: return;
5151:
5152: end if;
5153:
5154: l_requisition_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5155: itemkey => itemkey,
5156: aname => 'DOCUMENT_ID');
5157:
5158: carry_auto_aceept_and_reject(l_requisition_header_id);

Line 5188: if (funcmode <> wf_engine.eng_run) then

5184:
5185:
5186: -- Do nothing in cancel or timeout mode
5187: --
5188: if (funcmode <> wf_engine.eng_run) then
5189:
5190: resultout := wf_engine.eng_null;
5191: return;
5192:

Line 5190: resultout := wf_engine.eng_null;

5186: -- Do nothing in cancel or timeout mode
5187: --
5188: if (funcmode <> wf_engine.eng_run) then
5189:
5190: resultout := wf_engine.eng_null;
5191: return;
5192:
5193: end if;
5194:

Line 5195: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

5191: return;
5192:
5193: end if;
5194:
5195: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5196: itemkey => itemkey,
5197: aname => 'DOCUMENT_ID');
5198:
5199: l_current_buyer_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 5199: l_current_buyer_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

5195: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5196: itemkey => itemkey,
5197: aname => 'DOCUMENT_ID');
5198:
5199: l_current_buyer_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5200: itemkey => itemkey,
5201: aname => 'CURRENT_BUYER_ID');
5202:
5203: x_progress := 'POR_AMENDMENT_PKG.MORE_BUYER_TO_NOTIFY: 02 : l_document_id :'||l_document_id||' : l_current_buyer_id : '||l_current_buyer_id;

Line 5227: wf_engine.SetItemAttrText ( itemtype => itemtype,

5223: AND awdrefs.agent_id > Nvl(l_current_buyer_id,0);
5224:
5225:
5226: IF l_buyer_id IS NOT NULL THEN
5227: wf_engine.SetItemAttrText ( itemtype => itemtype,
5228: itemkey => itemkey,
5229: aname => 'CURRENT_BUYER_ID',
5230: avalue => l_buyer_id);
5231:

Line 5234: wf_engine.SetItemAttrText ( itemtype => itemtype,

5230: avalue => l_buyer_id);
5231:
5232: PO_REQAPPROVAL_INIT1.get_user_name(l_buyer_id, l_buyer_name, l_buyer_display_name);
5233:
5234: wf_engine.SetItemAttrText ( itemtype => itemtype,
5235: itemkey => itemkey,
5236: aname => 'CURRENT_BUYER_NAME',
5237: avalue => l_buyer_name);
5238:

Line 5242: wf_engine.SetItemAttrText ( itemtype => itemtype,

5238:
5239: resultout:='COMPLETE:'||'Y';
5240: RETURN;
5241: ELSE
5242: wf_engine.SetItemAttrText ( itemtype => itemtype,
5243: itemkey => itemkey,
5244: aname => 'CURRENT_BUYER_ID',
5245: avalue => l_buyer_id);
5246: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 5246: wf_engine.SetItemAttrText ( itemtype => itemtype,

5242: wf_engine.SetItemAttrText ( itemtype => itemtype,
5243: itemkey => itemkey,
5244: aname => 'CURRENT_BUYER_ID',
5245: avalue => l_buyer_id);
5246: wf_engine.SetItemAttrText ( itemtype => itemtype,
5247: itemkey => itemkey,
5248: aname => 'CURRENT_BUYER_NAME',
5249: avalue => null);
5250:

Line 5289: if (funcmode <> wf_engine.eng_run) then

5285:
5286:
5287: -- Do nothing in cancel or timeout mode
5288: --
5289: if (funcmode <> wf_engine.eng_run) then
5290:
5291: resultout := wf_engine.eng_null;
5292: return;
5293:

Line 5291: resultout := wf_engine.eng_null;

5287: -- Do nothing in cancel or timeout mode
5288: --
5289: if (funcmode <> wf_engine.eng_run) then
5290:
5291: resultout := wf_engine.eng_null;
5292: return;
5293:
5294: end if;
5295:

Line 5296: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

5292: return;
5293:
5294: end if;
5295:
5296: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5297: itemkey => itemkey,
5298: aname => 'DOCUMENT_ID');
5299:
5300: l_current_sourcing_owner_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 5300: l_current_sourcing_owner_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

5296: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5297: itemkey => itemkey,
5298: aname => 'DOCUMENT_ID');
5299:
5300: l_current_sourcing_owner_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5301: itemkey => itemkey,
5302: aname => 'CURRENT_SOURCING_OWNER_ID');
5303:
5304:

Line 5318: wf_engine.SetItemAttrText ( itemtype => itemtype,

5314: AND prl.AMENDMENT_STATUS IN ('N','P')
5315: AND pah.trading_partner_contact_id > Nvl(l_current_sourcing_owner_id,0);
5316:
5317: IF l_sourcing_owner_id IS NOT NULL THEN
5318: wf_engine.SetItemAttrText ( itemtype => itemtype,
5319: itemkey => itemkey,
5320: aname => 'CURRENT_SOURCING_OWNER_ID',
5321: avalue => l_sourcing_owner_id);
5322:

Line 5330: wf_engine.SetItemAttrText ( itemtype => itemtype,

5326: WHERE person_party_id = l_sourcing_owner_id
5327: AND nvl(end_date, sysdate+1) > sysdate
5328: AND rownum=1;
5329:
5330: wf_engine.SetItemAttrText ( itemtype => itemtype,
5331: itemkey => itemkey,
5332: aname => 'CURRENT_SOURCING_OWNER_NAME',
5333: avalue => l_ourcing_owner_name);
5334:

Line 5338: wf_engine.SetItemAttrText ( itemtype => itemtype,

5334:
5335: resultout:='COMPLETE:'||'Y';
5336: RETURN;
5337: ELSE
5338: wf_engine.SetItemAttrText ( itemtype => itemtype,
5339: itemkey => itemkey,
5340: aname => 'CURRENT_SOURCING_OWNER_ID',
5341: avalue => l_sourcing_owner_id);
5342: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 5342: wf_engine.SetItemAttrText ( itemtype => itemtype,

5338: wf_engine.SetItemAttrText ( itemtype => itemtype,
5339: itemkey => itemkey,
5340: aname => 'CURRENT_SOURCING_OWNER_ID',
5341: avalue => l_sourcing_owner_id);
5342: wf_engine.SetItemAttrText ( itemtype => itemtype,
5343: itemkey => itemkey,
5344: aname => 'CURRENT_SOURCING_OWNER_NAME',
5345: avalue => null);
5346:

Line 5415: if (funcmode <> wf_engine.eng_run) then

5411:
5412:
5413: -- Do nothing in cancel or timeout mode
5414: --
5415: if (funcmode <> wf_engine.eng_run) then
5416:
5417: resultout := wf_engine.eng_null;
5418: return;
5419:

Line 5417: resultout := wf_engine.eng_null;

5413: -- Do nothing in cancel or timeout mode
5414: --
5415: if (funcmode <> wf_engine.eng_run) then
5416:
5417: resultout := wf_engine.eng_null;
5418: return;
5419:
5420: end if;
5421:

Line 5422: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

5418: return;
5419:
5420: end if;
5421:
5422: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5423: itemkey => itemkey,
5424: aname => 'DOCUMENT_ID');
5425:
5426: l_currency_code := PO_CORE_S2.get_base_currency;

Line 5429: wf_engine.SetItemAttrText ( itemtype => itemtype,

5425:
5426: l_currency_code := PO_CORE_S2.get_base_currency;
5427: fnd_currency.get_info(l_currency_code, l_precision, l_ext_precision, l_min_acct_unit);
5428:
5429: wf_engine.SetItemAttrText ( itemtype => itemtype,
5430: itemkey => itemkey,
5431: aname => 'FUNCTIONAL_CURRENCY',
5432: avalue => l_currency_code);
5433:

Line 5447: wf_engine.SetItemAttrText ( itemtype => itemtype,

5443: CLOSE req_tax_csr;
5444:
5445: l_tax_amount_disp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK( l_currency_code, g_currency_format_mask))||' '||l_currency_code;
5446:
5447: wf_engine.SetItemAttrText ( itemtype => itemtype,
5448: itemkey => itemkey,
5449: aname => 'NEW_TAX_AMOUNT_CURRENCY_DSP',
5450: avalue => l_tax_amount_disp);
5451:

Line 5455: wf_engine.SetItemAttrText ( itemtype => itemtype,

5451:
5452: l_total_amount := l_req_amount + l_tax_amount;
5453: l_total_amount_disp := TO_CHAR(l_total_amount, FND_CURRENCY.GET_FORMAT_MASK( l_currency_code, g_currency_format_mask))||' '||l_currency_code;
5454:
5455: wf_engine.SetItemAttrText ( itemtype => itemtype,
5456: itemkey => itemkey,
5457: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP',
5458: avalue => l_total_amount_disp);
5459:

Line 5463: l_conformed_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

5459:
5460:
5461:
5462:
5463: l_conformed_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5464: itemkey => itemkey,
5465: aname => 'CONFORMED_HEADER_ID');
5466:
5467: l_revision_num := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 5467: l_revision_num := wf_engine.GetItemAttrNumber (itemtype => itemtype,

5463: l_conformed_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5464: itemkey => itemkey,
5465: aname => 'CONFORMED_HEADER_ID');
5466:
5467: l_revision_num := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5468: itemkey => itemkey,
5469: aname => 'REVISION_NUM');
5470:
5471: SELECT requisition_header_id

Line 5489: wf_engine.SetItemAttrText ( itemtype => itemtype,

5485: CLOSE req_tax_csr;
5486:
5487: l_tax_amount_disp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK( l_currency_code, g_currency_format_mask))||' '||l_currency_code;
5488:
5489: wf_engine.SetItemAttrText ( itemtype => itemtype,
5490: itemkey => itemkey,
5491: aname => 'OLD_TAX_AMOUNT_CURRENCY_DSP',
5492: avalue => l_tax_amount_disp);
5493:

Line 5497: wf_engine.SetItemAttrText ( itemtype => itemtype,

5493:
5494: l_total_amount := l_req_amount + l_tax_amount;
5495: l_total_amount_disp := TO_CHAR(l_total_amount, FND_CURRENCY.GET_FORMAT_MASK( l_currency_code, g_currency_format_mask))||' '||l_currency_code;
5496:
5497: wf_engine.SetItemAttrText ( itemtype => itemtype,
5498: itemkey => itemkey,
5499: aname => 'OLD_REQ_AMOUNT_CURRENCY_DSP',
5500: avalue => l_total_amount_disp);
5501:

Line 5592: if (funcmode <> wf_engine.eng_run) then

5588: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5589: END IF;
5590:
5591: -- Do nothing in cancel or timeout mode
5592: if (funcmode <> wf_engine.eng_run) then
5593: resultout := wf_engine.eng_null;
5594: return;
5595: end if;
5596:

Line 5593: resultout := wf_engine.eng_null;

5589: END IF;
5590:
5591: -- Do nothing in cancel or timeout mode
5592: if (funcmode <> wf_engine.eng_run) then
5593: resultout := wf_engine.eng_null;
5594: return;
5595: end if;
5596:
5597: l_conformed_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 5597: l_conformed_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

5593: resultout := wf_engine.eng_null;
5594: return;
5595: end if;
5596:
5597: l_conformed_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5598: itemkey => itemkey,
5599: aname => 'CONFORMED_HEADER_ID');
5600:
5601: --Since this is an amendment flow, so we have to create/modify the

Line 7372: if (funcmode <> wf_engine.eng_run) then

7368: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
7369: END IF;
7370:
7371: -- Do nothing in cancel or timeout mode
7372: if (funcmode <> wf_engine.eng_run) then
7373: resultout := wf_engine.eng_null;
7374: return;
7375: end if;
7376:

Line 7373: resultout := wf_engine.eng_null;

7369: END IF;
7370:
7371: -- Do nothing in cancel or timeout mode
7372: if (funcmode <> wf_engine.eng_run) then
7373: resultout := wf_engine.eng_null;
7374: return;
7375: end if;
7376:
7377: l_amendment_approval := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 7377: l_amendment_approval := wf_engine.GetItemAttrText (itemtype => itemtype,

7373: resultout := wf_engine.eng_null;
7374: return;
7375: end if;
7376:
7377: l_amendment_approval := wf_engine.GetItemAttrText (itemtype => itemtype,
7378: itemkey => itemkey,
7379: aname => 'IS_AMENDMENT_APPROVAL');
7380:
7381: x_progress := 'POR_AMENDMENT_PKG.set_amendment_related_attrib: 02';

Line 7396: l_conformed_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

7392: RETURN;
7393: END IF;
7394:
7395:
7396: l_conformed_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7397: itemkey => itemkey,
7398: aname => 'CONFORMED_HEADER_ID');
7399:
7400: l_revision_num := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 7400: l_revision_num := wf_engine.GetItemAttrNumber (itemtype => itemtype,

7396: l_conformed_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7397: itemkey => itemkey,
7398: aname => 'CONFORMED_HEADER_ID');
7399:
7400: l_revision_num := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7401: itemkey => itemkey,
7402: aname => 'REVISION_NUM');
7403:
7404: --Since this is an amendment flow, so we have to create/modify the

Line 7537: if (funcmode <> wf_engine.eng_run) then

7533: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
7534: END IF;
7535: -- Do nothing in cancel or timeout mode
7536: --
7537: if (funcmode <> wf_engine.eng_run) then
7538: resultout := wf_engine.eng_null;
7539: return;
7540: end if;
7541:

Line 7538: resultout := wf_engine.eng_null;

7534: END IF;
7535: -- Do nothing in cancel or timeout mode
7536: --
7537: if (funcmode <> wf_engine.eng_run) then
7538: resultout := wf_engine.eng_null;
7539: return;
7540: end if;
7541:
7542: x_progress := 'POR_AMENDMENT_PKG.SET_CLM_FUNDS_OVERRIDE: Setting Funds Override as Y : 02';

Line 7547: wf_engine.SetitemattrText( itemtype => itemtype,

7543: IF (g_po_wf_debug = 'Y') THEN
7544: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
7545: END IF;
7546: -- Bug 9667861.
7547: wf_engine.SetitemattrText( itemtype => itemtype,
7548: itemkey => itemkey,
7549: aname => 'CLM_FUNDS_OVERRIDE',
7550: avalue => 'Y');
7551:

Line 7594: IF (funcmode <> wf_engine.eng_run) THEN

7590: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,x_progress);
7591: END IF;
7592: -- Do nothing in cancel or timeout mode
7593: --
7594: IF (funcmode <> wf_engine.eng_run) THEN
7595: resultout := wf_engine.eng_null;
7596: RETURN;
7597: END IF;
7598: l_req_encumbrance_on := po_core_s.Is_encumbrance_on(p_doc_type => 'REQUISITION',p_org_id => NULL);

Line 7595: resultout := wf_engine.eng_null;

7591: END IF;
7592: -- Do nothing in cancel or timeout mode
7593: --
7594: IF (funcmode <> wf_engine.eng_run) THEN
7595: resultout := wf_engine.eng_null;
7596: RETURN;
7597: END IF;
7598: l_req_encumbrance_on := po_core_s.Is_encumbrance_on(p_doc_type => 'REQUISITION',p_org_id => NULL);
7599: l_conformed_header_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'CONFORMED_HEADER_ID');

Line 7617: wf_engine.SetitemattrText(itemtype => itemtype,itemkey => itemkey,aname => 'CLM_FUNDS_OVERRIDE', avalue => 'N');

7613: END IF;
7614: IF (l_clm_funds_Override IS NOT NULL
7615: AND l_clm_funds_Override <> 'N') THEN
7616: l_override_funds := l_clm_funds_Override;
7617: wf_engine.SetitemattrText(itemtype => itemtype,itemkey => itemkey,aname => 'CLM_FUNDS_OVERRIDE', avalue => 'N');
7618: END IF;
7619: IF (g_po_wf_debug = 'Y') THEN
7620: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'is Amenement Approval '||l_amendment_approval);
7621: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'Conformed Header Id '||l_conformed_header_id);

Line 8090: if (funcmode <> wf_engine.eng_run) then

8086:
8087:
8088: -- Do nothing in cancel or timeout mode
8089: --
8090: if (funcmode <> wf_engine.eng_run) then
8091:
8092: resultout := wf_engine.eng_null;
8093: return;
8094:

Line 8092: resultout := wf_engine.eng_null;

8088: -- Do nothing in cancel or timeout mode
8089: --
8090: if (funcmode <> wf_engine.eng_run) then
8091:
8092: resultout := wf_engine.eng_null;
8093: return;
8094:
8095: end if;
8096:

Line 8097: l_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

8093: return;
8094:
8095: end if;
8096:
8097: l_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
8098: itemkey => itemkey,
8099: aname => 'DOCUMENT_ID');
8100: l_conf_hdr_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
8101: itemkey => itemkey,

Line 8100: l_conf_hdr_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

8096:
8097: l_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
8098: itemkey => itemkey,
8099: aname => 'DOCUMENT_ID');
8100: l_conf_hdr_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
8101: itemkey => itemkey,
8102: aname => 'CONFORMED_HEADER_ID');
8103:
8104: --update the approval status of the main requisition with the