DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_LINE_UTIL

Line 1381: oe_line_util.query_rows ( p_header_id => l_header_id,

1377: oe_debug_pub.add( P_START_FROM_FLOW || ' FLOW , WITH LINE_ID => ' || P_LINE_ID ) ;
1378: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;
1379: END IF;
1380: l_line_id := p_line_id;
1381: oe_line_util.query_rows ( p_header_id => l_header_id,
1382: p_line_id => l_line_id,
1383: x_line_tbl => l_line_tbl);
1384:
1385: -- checking for 'CLOSED' or 'CANCELLED' line status for 3a6

Line 1434: l_line_rec := oe_line_util.query_row ( p_line_id => l_line_ack_id);

1430: IF l_debug_level > 0 THEN
1431: oe_debug_pub.add( 'FETCHED LINE ACK ID: ' || L_LINE_ACK_ID ) ;
1432: END IF;
1433:
1434: l_line_rec := oe_line_util.query_row ( p_line_id => l_line_ack_id);
1435: END IF; -- end bug 3363327
1436:
1437: l_ind_cntr := l_ind_cntr + 1;
1438: l_line_tbl(l_ind_cntr) := l_line_rec;

Line 1476: oe_line_util.query_row ( p_line_id => l_line_ack_id);

1472: oe_debug_pub.add( 'G_WFI_PROC FLOW , L_LINE_ACK_ID => ' || L_LINE_ACK_ID ) ;
1473: oe_debug_pub.add( 'RETRIEVED LINE LAST_ACK_CODE: ' || L_LINE_LAST_ACK_CODE ) ;
1474: END IF;
1475: l_line_rec :=
1476: oe_line_util.query_row ( p_line_id => l_line_ack_id);
1477: l_line_rec.last_ack_code := l_line_last_ack_code;
1478: End If;
1479: Exit When sso_line_ack_cur%notfound;
1480: l_ind_cntr := l_ind_cntr + 1;

Line 1494: oe_line_util.query_row ( p_line_id => l_line_ack_id);

1490: IF l_debug_level > 0 THEN
1491: oe_debug_pub.add( 'G_WFI_PROC FLOW , L_LINE_ACK_ID => ' || L_LINE_ACK_ID ) ;
1492: END IF;
1493: l_line_rec :=
1494: oe_line_util.query_row ( p_line_id => l_line_ack_id);
1495: End If;
1496: Exit When line_ack_cur%notfound;
1497: l_ind_cntr := l_ind_cntr + 1;
1498: l_line_tbl(l_ind_cntr) := l_line_rec;