APPS.OKC_XPRT_CUSTOM_PACKAGE dependencies on DBMS_OUTPUT

Line 220: dbms_output.put_line('l_price_update_tolerance IS '||l_price_update_tolerance);

216:
217:
218: OPEN l_price_update_csr;
219: FETCH l_price_update_csr INTO l_price_update_tolerance;
220: dbms_output.put_line('l_price_update_tolerance IS '||l_price_update_tolerance);
221: l_price_update_tolerance := l_price_update_tolerance+10;
222: CLOSE l_price_update_csr;
223:
224: IF ( P_VARIABLE_CODE = 'PO$PRICE_TOLERANCE1' OR P_VARIABLE_CODE = 'PO$PRICE_TOLERANCE' ) AND P_DOC_TYPE = 'PA_BLANKET' THEN

Line 352: dbms_output.put_line('start of proc ');

348:
349:
350: x_return_status := G_RET_STS_SUCCESS;
351:
352: dbms_output.put_line('start of proc ');
353: OPEN l_tmp_instance_csr;
354: FETCH l_tmp_instance_csr INTO l_tmp_instance_id;
355: CLOSE l_tmp_instance_csr;
356: dbms_output.put_line('l_tmp_instance_id IS '||l_tmp_instance_id);

Line 356: dbms_output.put_line('l_tmp_instance_id IS '||l_tmp_instance_id);

352: dbms_output.put_line('start of proc ');
353: OPEN l_tmp_instance_csr;
354: FETCH l_tmp_instance_csr INTO l_tmp_instance_id;
355: CLOSE l_tmp_instance_csr;
356: dbms_output.put_line('l_tmp_instance_id IS '||l_tmp_instance_id);
357:
358: OPEN l_sup_value_csr(l_tmp_instance_id,'Benefit');
359: FETCH l_sup_value_csr INTO l_tmp_value;
360: CLOSE l_sup_value_csr;

Line 361: dbms_output.put_line('l_tmp_value IS '||l_tmp_value);

357:
358: OPEN l_sup_value_csr(l_tmp_instance_id,'Benefit');
359: FETCH l_sup_value_csr INTO l_tmp_value;
360: CLOSE l_sup_value_csr;
361: dbms_output.put_line('l_tmp_value IS '||l_tmp_value);
362:
363: OPEN l_sup_value_csr(l_tmp_instance_id,'Name of VAD');
364: FETCH l_sup_value_csr INTO l_tmp1_value;
365: CLOSE l_sup_value_csr;

Line 366: dbms_output.put_line('l_tmp1_value IS '||l_tmp1_value);

362:
363: OPEN l_sup_value_csr(l_tmp_instance_id,'Name of VAD');
364: FETCH l_sup_value_csr INTO l_tmp1_value;
365: CLOSE l_sup_value_csr;
366: dbms_output.put_line('l_tmp1_value IS '||l_tmp1_value);
367:
368: --getting lov value
369: OPEN l_sup_lov_value_csr(l_tmp_instance_id,'Industry-Type');
370: FETCH l_sup_lov_value_csr INTO l_tmp2_value;

Line 372: dbms_output.put_line('l_tmp2_value IS '||l_tmp2_value);

368: --getting lov value
369: OPEN l_sup_lov_value_csr(l_tmp_instance_id,'Industry-Type');
370: FETCH l_sup_lov_value_csr INTO l_tmp2_value;
371: CLOSE l_sup_lov_value_csr;
372: dbms_output.put_line('l_tmp2_value IS '||l_tmp2_value);
373:
374:
375: IF P_VARIABLE_CODE = 'QUOTE$SUP_VAD' THEN
376: X_VARIABLE_VALUE_ID := l_tmp_value;