[Home] [Help]
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ICX.PLSQL.POR_AMENDMENT_PKG';
14:
15: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
16:
17: TYPE g_line_id_map IS TABLE OF NUMBER INDEX BY VARCHAR2(20);
18:
19: /* Forward Declartion */
5772: x_kanban_card_id number:='';
5773: x_accrued_flag varchar2(1);
5774: x_po_uom varchar2(25):=null;
5775: x_req_uom varchar2(25):=null;
5776: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
5777: x_conversion_rate number := 1;
5778: x_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
5779:
5780:
5868: WHERE line_location_id = x_line_location_id;
5869:
5870:
5871: l_progress:='020';
5872: fnd_profile.get('PO_AUTOCREATE_DATE',x_gl_date_option);
5873:
5874: /* Bug 482648 ecso 4/30/97
5875: * Move quantity conversion from setup_interface_tables
5876: * to create_distribution for consistency
7602: l_employee_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'APPROVER_EMPID');
7603: l_document_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_ID');
7604: l_document_type := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_TYPE');
7605: l_document_subtype := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_SUBTYPE');
7606: fnd_profile.Get('PO_REQAPPR_OVERRIDE_FUNDS',l_override_funds);
7607: l_clm_funds_Override := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'CLM_FUNDS_OVERRIDE');
7608:
7609:
7610:
8145: AND AMENDMENT_TYPE = 'CANCELLED'
8146: AND AMENDMENT_STATUS = 'N';
8147:
8148: BEGIN
8149: fnd_profile.get('PO_GL_DATE',l_use_gl_date);
8150:
8151: SELECT AMENDMENT_REASON, PREPARER_ID, ORG_ID
8152: INTO x_amendment_reason, x_preparer_id, x_org_id
8153: FROM PO_REQUISITION_HEADERS_ALL