APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_ORDER_LINES_ALL

Line 1361: -- OE_ORDER_LINES_ALL table

1357: End;
1358: -- End Header query}
1359:
1360: --{Call Query Row procedure to get the Line Data from Base
1361: -- OE_ORDER_LINES_ALL table
1362:
1363: IF l_debug_level > 0 THEN
1364: oe_debug_pub.add( 'ORDER_SOURCE_ID' || L_HEADER_REC.ORDER_SOURCE_ID ) ;
1365: oe_debug_pub.add( 'P_START_FROM_FLOW' || P_START_FROM_FLOW ) ;

Line 1446: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;

1442: Exception
1443: When Others Then
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --FND_API.G_RET_STS_SUCCESS;
1445: IF l_debug_level > 0 THEN
1446: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1447: END IF;
1448: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1449: fnd_message.set_token ('TABLE', 'oe_order_lines');
1450: oe_msg_pub.add;

Line 1508: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;

1504: Exception
1505: When Others Then
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;--FND_API.G_RET_STS_SUCCESS;
1507: IF l_debug_level > 0 THEN
1508: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1509: END IF;
1510: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1511: fnd_message.set_token ('TABLE', 'oe_order_lines');
1512: oe_msg_pub.add;

Line 4061: SELECT 'X' INTO temp FROM oe_order_lines_all WHERE line_id=p_line_id;

4057: IS
4058: PRAGMA AUTONOMOUS_TRANSACTION;
4059: temp VARCHAR2(1);
4060: BEGIN
4061: SELECT 'X' INTO temp FROM oe_order_lines_all WHERE line_id=p_line_id;
4062: x_exists_flag :='Y';
4063: COMMIT;
4064: EXCEPTION
4065: WHEN OTHERS THEN