1018: l_value NUMBER;
1019: l_print_value VARCHAR2(40);
1020:
1021: BEGIN
1022: gmd_debug.log_initialize('LCF');
1023: --Load formulation specification details
1024: OPEN Cur_get_formulation;
1025: FETCH Cur_get_formulation INTO l_formulation;
1026: CLOSE Cur_get_formulation;
1275: l_value := ROUND(l_lt_matrix(i)(j),5);
1276: l_print_value := RPAD(TO_CHAR(l_value, '9990.99999'), 10);
1277: l_print_line := l_print_line||l_print_value||' ';
1278: END LOOP;
1279: gmd_debug.put_line(l_print_line);
1280: END LOOP; */
1281:
1282: --After builiding the matrix call the lcf engine routine.
1283: gmd_lcf_engine.evaluate (P_spec_id => V_formulation_spec_id,
1329: select *
1330: from gmd_lcf_details_gtmp;
1331: BEGIN
1332: FOR L_RECORD IN CUR_REC LOOP
1333: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1330: from gmd_lcf_details_gtmp;
1331: BEGIN
1332: FOR L_RECORD IN CUR_REC LOOP
1333: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1331: BEGIN
1332: FOR L_RECORD IN CUR_REC LOOP
1333: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1332: FOR L_RECORD IN CUR_REC LOOP
1333: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1333: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
1343: gmd_debug.put_line('voluom'||l_record.vol_uom);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
1343: gmd_debug.put_line('voluom'||l_record.vol_uom);
1344: END LOOP;
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
1343: gmd_debug.put_line('voluom'||l_record.vol_uom);
1344: END LOOP;
1345: END temp_dump;
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
1343: gmd_debug.put_line('voluom'||l_record.vol_uom);
1344: END LOOP;
1345: END temp_dump;
1346:
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
1343: gmd_debug.put_line('voluom'||l_record.vol_uom);
1344: END LOOP;
1345: END temp_dump;
1346:
1347: procedure temp_param IS
1350: from gmd_lcf_tech_data_gtmp a, gmd_lcf_details_gtmp b
1351: where a.line_id= b.line_id;
1352: begin
1353: FOR L_REC IN CUR_REC1 LOOP
1354: gmd_debug.put_line('item lineid techparmname value');
1355: gmd_debug.put_line(l_rec.concatenated_segments|| '-' ||l_rec.line_id|| '-' ||l_rec.tech_parm_name|| '-' ||l_rec.value);
1356: END LOOP;
1357: end temp_param;
1358:
1351: where a.line_id= b.line_id;
1352: begin
1353: FOR L_REC IN CUR_REC1 LOOP
1354: gmd_debug.put_line('item lineid techparmname value');
1355: gmd_debug.put_line(l_rec.concatenated_segments|| '-' ||l_rec.line_id|| '-' ||l_rec.tech_parm_name|| '-' ||l_rec.value);
1356: END LOOP;
1357: end temp_param;
1358:
1359: procedure temp_category IS
1361: select *
1362: from gmd_lcf_category_dtl_gtmp;
1363: begin
1364: FOR L_REC IN CUR_REC1 LOOP
1365: gmd_debug.put_line('category lineid value_ind');
1366: gmd_debug.put_line(l_rec.category_id|| '-' ||l_rec.line_id|| '-' ||l_rec.value_ind);
1367: END LOOP;
1368: end temp_category;
1369:
1362: from gmd_lcf_category_dtl_gtmp;
1363: begin
1364: FOR L_REC IN CUR_REC1 LOOP
1365: gmd_debug.put_line('category lineid value_ind');
1366: gmd_debug.put_line(l_rec.category_id|| '-' ||l_rec.line_id|| '-' ||l_rec.value_ind);
1367: END LOOP;
1368: end temp_category;
1369:
1370: