34: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_REQCHANGEREQUESTNOTIF_PVT';
35: G_FILE_NAME CONSTANT VARCHAR2(30) := 'POXVRCNB.pls';
36:
37: -- Read the profile option that enables/disables the debug log
38: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
39: g_module_prefix CONSTANT VARCHAR2(50) := 'po.plsql.' || g_pkg_name || '.';
40:
41: Procedure get_additional_details(p_req_header_id in number,
42: p_document out NOCOPY varchar2);
292:
293:
294: NL VARCHAR2(1) := fnd_global.newline;
295:
296: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
297:
298:
299: BEGIN
300:
467:
468:
469: NL VARCHAR2(1) := fnd_global.newline;
470:
471: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
472:
473: cursor l_get_wf_keys_csr is
474: select wf_item_type, wf_item_key
475: from po_change_requests
648: l_old_line_amount number;
649: l_request_status po_change_requests.request_status%type;
650:
651: display_txn_curr VARCHAR2(30);
652: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
653:
654:
655: CURSOR line_csr(v_document_id NUMBER) IS
656: SELECT rql.requisition_line_id,
731: aname => 'ORG_ID');
732:
733: SetDocMgrContext(l_item_type, l_item_key);
734:
735: display_txn_curr := FND_PROFILE.value('POR_DEFAULT_DISP_TRANS_CURRENCY');
736:
737:
738: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
739:
773: l_document := l_document || NL || NL || ''|| NL || NL || '
';
774:
775: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS'));
776:
777: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
778:
779: select count(1)
780: into l_num_lines
781: from po_requisition_lines
1159: l_old_line_amount number;
1160: l_request_status po_change_requests.request_status%type;
1161:
1162: display_txn_curr VARCHAR2(30);
1163: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
1164:
1165:
1166: CURSOR line_csr(v_document_id NUMBER) IS
1167: SELECT rql.requisition_line_id,
1243: aname => 'ORG_ID');
1244:
1245: SetDocMgrContext(l_item_type, l_item_key);
1246:
1247: display_txn_curr := FND_PROFILE.value('POR_DEFAULT_DISP_TRANS_CURRENCY');
1248:
1249: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
1250:
1251: l_currency_code := PO_CORE_S2.get_base_currency;
1284: l_document := l_document || NL || NL || ''|| NL || NL || '
';
1285:
1286: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS'));
1287:
1288: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
1289:
1290: select count(1)
1291: into l_num_lines
1292: from po_requisition_lines
1934: l_document VARCHAR2(32000) := '';
1935:
1936: NL VARCHAR2(1) := fnd_global.newline;
1937:
1938: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
1939:
1940: l_note po_action_history.note%TYPE;
1941: l_old_req_amount VARCHAR2(40);
1942: l_old_tax_amount VARCHAR2(40);
2119:
2120: l_document varchar2(1000) := '';
2121:
2122: NL VARCHAR2(1) := fnd_global.newline;
2123: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2124:
2125: begin
2126:
2127: l_document := '