688: where entity_id = V_entity_id
689: AND rollup_ind = 1;
690: begin
691: FOR L_RECORD IN CUR_REC LOOP
692: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
693: gmd_debug.put_line('item_um'||l_record.detail_uom);
694: gmd_debug.put_line('item_qty'||l_record.qty);
695: gmd_debug.put_line('line_id'||l_record.line_id);
696: gmd_debug.put_line('entity'||l_record.entity_id);
689: AND rollup_ind = 1;
690: begin
691: FOR L_RECORD IN CUR_REC LOOP
692: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
693: gmd_debug.put_line('item_um'||l_record.detail_uom);
694: gmd_debug.put_line('item_qty'||l_record.qty);
695: gmd_debug.put_line('line_id'||l_record.line_id);
696: gmd_debug.put_line('entity'||l_record.entity_id);
697: gmd_debug.put_line('qtymass'||l_record.qty_mass);
690: begin
691: FOR L_RECORD IN CUR_REC LOOP
692: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
693: gmd_debug.put_line('item_um'||l_record.detail_uom);
694: gmd_debug.put_line('item_qty'||l_record.qty);
695: gmd_debug.put_line('line_id'||l_record.line_id);
696: gmd_debug.put_line('entity'||l_record.entity_id);
697: gmd_debug.put_line('qtymass'||l_record.qty_mass);
698: gmd_debug.put_line('massuom'||l_record.mass_uom);
691: FOR L_RECORD IN CUR_REC LOOP
692: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
693: gmd_debug.put_line('item_um'||l_record.detail_uom);
694: gmd_debug.put_line('item_qty'||l_record.qty);
695: gmd_debug.put_line('line_id'||l_record.line_id);
696: gmd_debug.put_line('entity'||l_record.entity_id);
697: gmd_debug.put_line('qtymass'||l_record.qty_mass);
698: gmd_debug.put_line('massuom'||l_record.mass_uom);
699: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
692: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
693: gmd_debug.put_line('item_um'||l_record.detail_uom);
694: gmd_debug.put_line('item_qty'||l_record.qty);
695: gmd_debug.put_line('line_id'||l_record.line_id);
696: gmd_debug.put_line('entity'||l_record.entity_id);
697: gmd_debug.put_line('qtymass'||l_record.qty_mass);
698: gmd_debug.put_line('massuom'||l_record.mass_uom);
699: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
700: gmd_debug.put_line('voluom'||l_record.vol_uom);
693: gmd_debug.put_line('item_um'||l_record.detail_uom);
694: gmd_debug.put_line('item_qty'||l_record.qty);
695: gmd_debug.put_line('line_id'||l_record.line_id);
696: gmd_debug.put_line('entity'||l_record.entity_id);
697: gmd_debug.put_line('qtymass'||l_record.qty_mass);
698: gmd_debug.put_line('massuom'||l_record.mass_uom);
699: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
700: gmd_debug.put_line('voluom'||l_record.vol_uom);
701: gmd_debug.put_line('rollupind'||l_record.rollup_ind);
694: gmd_debug.put_line('item_qty'||l_record.qty);
695: gmd_debug.put_line('line_id'||l_record.line_id);
696: gmd_debug.put_line('entity'||l_record.entity_id);
697: gmd_debug.put_line('qtymass'||l_record.qty_mass);
698: gmd_debug.put_line('massuom'||l_record.mass_uom);
699: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
700: gmd_debug.put_line('voluom'||l_record.vol_uom);
701: gmd_debug.put_line('rollupind'||l_record.rollup_ind);
702: END LOOP;
695: gmd_debug.put_line('line_id'||l_record.line_id);
696: gmd_debug.put_line('entity'||l_record.entity_id);
697: gmd_debug.put_line('qtymass'||l_record.qty_mass);
698: gmd_debug.put_line('massuom'||l_record.mass_uom);
699: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
700: gmd_debug.put_line('voluom'||l_record.vol_uom);
701: gmd_debug.put_line('rollupind'||l_record.rollup_ind);
702: END LOOP;
703: end temp_dump;
696: gmd_debug.put_line('entity'||l_record.entity_id);
697: gmd_debug.put_line('qtymass'||l_record.qty_mass);
698: gmd_debug.put_line('massuom'||l_record.mass_uom);
699: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
700: gmd_debug.put_line('voluom'||l_record.vol_uom);
701: gmd_debug.put_line('rollupind'||l_record.rollup_ind);
702: END LOOP;
703: end temp_dump;
704:
697: gmd_debug.put_line('qtymass'||l_record.qty_mass);
698: gmd_debug.put_line('massuom'||l_record.mass_uom);
699: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
700: gmd_debug.put_line('voluom'||l_record.vol_uom);
701: gmd_debug.put_line('rollupind'||l_record.rollup_ind);
702: END LOOP;
703: end temp_dump;
704:
705: procedure temp_param (V_entity_id IN NUMBER,V_line_id IN NUMBER) IS
710: AND a.line_id= b.line_id
711: and (v_line_id is null or a.line_id = v_line_id);
712: begin
713: FOR L_REC IN CUR_REC1 LOOP
714: gmd_debug.put_line('item qty lotno lineid techparmname value');
715: gmd_debug.put_line(l_rec.concatenated_segments|| '-' ||l_rec.qty|| '-' ||l_rec.lot_number|| '-' ||l_rec.line_id|| '-' ||l_rec.tech_parm_name|| '-' ||l_rec.value);
716: END LOOP;
717: end temp_param;
718:
711: and (v_line_id is null or a.line_id = v_line_id);
712: begin
713: FOR L_REC IN CUR_REC1 LOOP
714: gmd_debug.put_line('item qty lotno lineid techparmname value');
715: gmd_debug.put_line(l_rec.concatenated_segments|| '-' ||l_rec.qty|| '-' ||l_rec.lot_number|| '-' ||l_rec.line_id|| '-' ||l_rec.tech_parm_name|| '-' ||l_rec.value);
716: END LOOP;
717: end temp_param;
718:
719: