39: /* obtain currency info to adjust precision */
40: x_precision NUMBER := 2;
41: x_ext_precision NUMBER := 5;
42: x_min_unit NUMBER := NULL;
43: x_uom_convert VARCHAR2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
44: x_po_uom VARCHAR2(25):=NULL;
45: x_conversion_rate NUMBER := 1;
46: x_gl_date_option VARCHAR2(25);
47: l_uom_conversion_rate MTL_UOM_CONVERSIONS.conversion_rate%TYPE := 1;
141: END IF;
142:
143: l_progress:='030';
144:
145: fnd_profile.get('PO_AUTOCREATE_DATE',x_gl_date_option);
146:
147: l_progress := '040';
148: SELECT order_type_lookup_code
149: INTO x_order_type_lookup_code
207: x_accrued_flag := 'N';
208: END IF;
209:
210: --Bug13553227
211: l_validate_gl_period := nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),'Y');
212: IF g_debug_stmt THEN
213: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
214: p_message => 'l_validate_gl_period: '||l_validate_gl_period);
215: END IF;
938: );
939: END IF;
940:
941: --Bug13553227
942: l_validate_gl_period := nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),'Y');
943: IF (PO_LOG.d_stmt) THEN
944: PO_LOG.stmt(d_module, d_progress, 'l_validate_gl_period', l_validate_gl_period);
945: END IF;
946:
952: IF (p_lines.requisition_line_id_tbl(i) IS NOT NULL ) THEN
953: -- if backing req exists, use req distributions as base for creating
954: -- po distributions.
955: d_progress := 30;
956: FND_PROFILE.GET('PO_AUTOCREATE_DATE', l_gl_date_option);
957:
958:
959:
960: IF ((PO_AUTOCREATE_PARAMS.g_sys.po_encumbrance_flag = 'Y')