DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_LINE_UTIL

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

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

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

1425: IF l_debug_level > 0 THEN
1426: oe_debug_pub.add( 'FETCHED LINE ACK ID: ' || L_LINE_ACK_ID ) ;
1427: END IF;
1428:
1429: l_line_rec := oe_line_util.query_row ( p_line_id => l_line_ack_id);
1430: END IF; -- end bug 3363327
1431:
1432: l_ind_cntr := l_ind_cntr + 1;
1433: l_line_tbl(l_ind_cntr) := l_line_rec;

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

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

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

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