4703: IF p_hold_source_rec.line_id is not NULL THEN
4704: IF l_debug_level > 0 THEN
4705: oe_debug_pub.add(' p_hold_source_rec.line_id : ' || p_hold_source_rec.line_id );
4706: END IF;
4707: oe_line_util.query_row(
4708: p_line_id => p_hold_source_rec.line_id
4709: ,x_line_rec => l_line_rec
4710: );
4711: END IF;
4725: oe_header_util.query_row ( p_header_id => p_hold_source_rec.header_id,
4726: x_header_rec => l_header_rec);
4727: END IF;
4728: IF p_hold_source_rec.line_id is not NULL THEN
4729: oe_line_util.query_row(
4730: p_line_id => p_hold_source_rec.line_id
4731: ,x_line_rec => l_line_rec
4732: );
4733: END IF;
6025: l_prev_org_id := p_sel_rec_tbl(j).org_id;
6026: END IF;
6027:
6028: l_line_id := p_sel_rec_tbl(j).id1;
6029: OE_LINE_UTIL.Query_Row
6030: ( p_line_id => l_line_id,
6031: x_line_rec => l_line_rec
6032: );
6033:
6511: END IF;
6512:
6513:
6514: L_line_id := p_sel_rec_tbl(j).id1;
6515: OE_LINE_UTIL.Query_Row
6516: ( p_line_id => l_line_id,
6517: x_line_rec => l_line_rec
6518: );
6519: OE_DEBUG_PUB.Add('header_id: '||l_line_rec.header_id);
7267: l_prev_org_id := p_sel_rec_tbl(j).org_id;
7268: END IF;
7269:
7270: L_line_id := p_sel_rec_tbl(j).id1;
7271: OE_LINE_UTIL.Query_Row
7272: ( p_line_id => l_line_id,
7273: x_line_rec => l_line_rec
7274: );
7275: OE_DEBUG_PUB.Add('header_id: '||l_line_rec.header_id);
13436: IF p_hold_source_rec.line_id is not NULL THEN
13437: IF l_debug_level > 0 THEN
13438: oe_debug_pub.add(' p_hold_source_rec.line_id : ' || p_hold_source_rec.line_id );
13439: END IF;
13440: oe_line_util.query_row(
13441: p_line_id => p_hold_source_rec.line_id
13442: ,x_line_rec => l_line_rec
13443: );
13444: END IF;
13459: oe_header_util.query_row ( p_header_id => p_hold_source_rec.header_id,
13460: x_header_rec => l_header_rec);
13461: END IF;
13462: IF p_hold_source_rec.line_id is not NULL THEN
13463: oe_line_util.query_row(
13464: p_line_id => p_hold_source_rec.line_id
13465: ,x_line_rec => l_line_rec
13466: );
13467: END IF;